Posted in: Syllabus

Excel Syllabus

Advance Excel

Understanding Excel Dashboard

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

Mastering Excel

  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
See also  Advance Microsoft Excel Syllabus
Back to Top