top of page

Basic to Advance Excel
(Online Course Syllabus) 

Advance Excel Logo
  1. Tables (Merge & Wrap Text Use of Alignment)

  2. Mathematical Formulas Practice Sheets (Addition, Subtraction, Multiply, Divide, Percentage)

  3. All Home Tab Commands

  4. Count, Counta, Count Blank & Countif formulas Practice Sheet

  5. Chart Practice (Pie, Bar, Lin, etc.)

  6. Text Functions

  7. Date formatting & other Date functions in excel

  8. Sum, Sumif, Sumifs, Sumproduct, Average, Averageif, Averageifs

  9. Pivot Table & Pivot Charts

  10. Absolute Cell Reference Practice Sheet

  11. V lookup & H lookup Function

  12. Search Box Practice Sheet

  13. Use of Paste Special & Transpose Function

  14. What if Analysis (Goal Seek, Data Table & Scenario Manager)

  15. Data Validation

  16. Data Consolidation

  17. Hyperlink Function in Excel

  18. Compare Two Sheets & Organize Sheets

  19. Combine Test & Assignment (Related to all Syllabus)

bottom of page