Excel Syllabus

Understanding Excel Dashboard

2. Customizing & Protecting
3. Viewing & Cell reference
4. Name Range
5. Date and time
6. Function and Superpower
7. Tables & What If
8. Cell formatting & Review
9. Conditional formatting
10. Data Analysing & Pivot Table
11. Data Sort & Filter
12. Editing & Outline
13. Text, Logical, Information Function
14. Macros
15. Problem Solving
16. Graph & Chart & Sparklines
17. Page Setup & Printing
18. VLookup & HLookup
19. Practical Projects

1. Understanding Spreadsheet
2. Understanding Excel Dashboard
3. Customizing & Protecting
4. Viewing & Cell reference
5. Name Range
6. Date and time
7. Function and Superpower
8. Tables & What If
9. Cell formatting & Review
10. Conditional formatting
11. Data Analysing & Pivot Table
12. Data Sort & Filter
13. Editing & Outline
14. Text, Logical, Information Function
15. Macros
16. Problem Solving
17. Graph & Chart & Sparklines
18. Page Setup & Printing
19. VLOOKUP & HLOOKUP
20. Efficiency and Risk
21. Array Formula
22. Form Control
23. Practical Interactivity with VBA
24. Visual Basic & Macros
25. Advance Accounting Projects
26. Practical Projects