Skip to main content
Level 2
microsoft office

Advanced Excel

Master VLOOKUP, pivot tables, data validation, and macros to handle complex data analysis and reporting.

Advanced Excel course thumbnail

8 lessons

Video-based curriculum

48 min

Total duration

Level 2

Curriculum placement

Syllabus

  1. 1VLOOKUP and HLOOKUP
  2. 2INDEX and MATCH combinations
  3. 3Pivot tables from scratch
  4. 4Data validation and dropdowns
  5. 5Conditional logic: IF, SUMIFS, COUNTIFS
  6. 6Named ranges and structured references
  7. 7Introduction to macros and VBA
  8. 8Dashboard design in Excel

Ready to start learning?

Sign up for free to access this course and track your progress.

Get Started Free