HOW TO LEARN EXCEL
Excel is a most powerful spreadsheet and data analysis application
These days, every job requires advance Excel skills. An organization wants these 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 formulas of excel.
BASICS OF EXCEL :-
What is a workbook
what is a sheet
what is a cell
what is cell address
Create a new blank workbook
Explore the Excel interface
Move within worksheet cells
Select and format data
Copy and paste formatting and data
Insert and resize columns
Save a workbook in a new folder
How to cut,copy & paste commands works
How to find the specific name/text
How to protect file or sheet: Encrypt an Excel file with a password so that it requires a password to open it.
How to hide or unhide columns/rows
Keyboard Shortcuts: Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed.
shortcut commands of excel like ( ctrl +c, ctrl+v, ctrl+x, ctrl+z, ctrl+y, ctrl+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
4- How to apply conditional formatting
5- How to use filters
6- How to use VLOOKUP function
7- How to use multiple IF statement
8-How to use AND