1)Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets
2) Saving Excel File as PDF, CSV and Older versions
3) Using Excel Shortcuts with Full List of Shortcuts
4)Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
Using Paste Special Options
5)Formatting Cells, Rows, Columns and Sheets
6)Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
7)Page Layout and Printer Properties
8)Inserting Pictures and other objects in Worksheets
9)Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, etc
10)Logical Function
11)Database Functions
12) Math and Trigonometry Functions
13) Statistical Functions
14) Text Functions
15) Using Conditional Formatting
16)Sorting Data A-Z and Z-A
17)Using Filters to Sort Data,Advance Filtering Options
18)Creating Pivot Tables
19) Using Pivot Table Options
20)Data validation
21)Consolidation
22)Groups
23)Subtotal
24) What is Excel Macro ? How to Record / Run Excel Macro ?