Advanced Excel & Data Analysis

Master formulas, PivotTables, data cleaning and business reporting dashboards.

Intermediate6 weeksSelf-paced
$85 USD
Apply for admission →

Already have an account? Log in to enrol

  • • 6 weeks (4 hours/week)
  • • 90-day access after enrolment
  • • 0 lessons in 0 modules
  • • Pass mark: 55%

About this course

Practical spreadsheet skills for finance, administration and operations roles.

What you will learn

  • ✓Use XLOOKUP, INDEX/MATCH and IF formulas
  • ✓Build interactive PivotTables and charts
  • ✓Clean and validate business datasets

Curriculum

0 modules · 0 lessons
Preview lessons are free: Lessons marked Preview are visible before enrolment. Full notes, quizzes and assessments unlock after enrolment.

Curriculum modules are being prepared by the academic team.

Requirements & practical activities

  • • Familiarity with basic spreadsheets

Practical activities

  • • Build a monthly sales summary dashboard

Assessment

  • • Weekly quizzes (20%)
  • • Practical assignments (50%)
  • • Final examination (30%)
  • • Pass mark: 55%

Related courses