Content of Course

1. Module- 1 Introduction
2. Module- 2 Fill handle, Flash Fill Nos. format
3. Module- 3 Working with multiple sheet, freeze panes, split window
4. Module- 4 Introduction to formulas (Basic & Advanced)
5. Module- 5 Auto Sum Functions
6. Module- 6 Logical Functions 1
7. Module- 7 Logical Functions 2
8. Module- 8 Lookup Functions 1
9. Module- 9 Lookup functions 2
10. Module- 10 Lookup Function 3
11. Module- 11 Lookup functions 4
12. Module- 12 Lookup functions 5
13. Module- 13 Sorting and Filtering 1
14. Module- 14 Sorting and Filtering 2
15. Module- 15 Charts 1 Basic
16. Module- 16 Charts 2 Advance Tree Map, sunburst Map
17. Module- 17 Data Validation, Whole nos., list etc...
18. Module- 18 Conditional formatting, Sales Data Analysis etc..
19. Module- 19 Consolidation on function, SumIf/Ifs, Averageif/Ifs etc...
20. Module- 20 Lookup functions 2
21. Module- 21 Lookup functions 2