How to learn excel .Excel is a most use full tool of ms-office.
These days, every job requires advance Excel skills. An organization wants these basic Excel skills –creating tables, format data, manipulate basic essential operations like(sum, subtraction, multiplication, division, average & summaries with filters and formulas, highlight data with conditional formatting, validation, charting , advance formulas and much more another thing which you will learn from here.
HOW TO BECOME AN EXCEL EXPERT
Excel is a huge application in itself with thousand of features and formulas.Formulas is back bone the ms-excel.
To become a good excel operator, very firstly you’ll have to learn about basic commands and basic formulas of excel.
BASICS OF EXCEL :-
What is a workbook
what is a sheet
what is a cell
what is cell address
How to cut,copy & paste commands works
How to find the specific name/text
How to hide or unhide columns/rows
shortcut commands of excel like (crtl+c , ctrl+v , crtl+x , crtl+z , crtl+y , crtl+s etc)
The basic formulas of excel is here :-
1- How to insert or delete a column/row
2- How to add two numbers in excel
3- How to subtraction/division/multiplication in excel
WHAT IS CELL & CELL ADDRESS
A cell is an intersection between a row and a column in a spreadsheet.Each cell in a spreadsheet can contain any value that can be called using a relative cell reference or called upon using a formula.
A “cell reference” means the cell to which another cell refers. For example, if in cell A1 you have =B1. Then A1 refers to B1.
HOW TO CUT, COPY & PASTE IN EXCEL
These are commands which must use in excel. Cut,copy,paste command is so simple.
Control+c = copy
Control+x = cut
Other useful commands in excel