Free demo · Microsoft Excel · Lesson 1 · Course overview

Learn Microsoft Excel 2024 / Microsoft 365

From your first cell to dashboards: a step-by-step, animated course with worked examples, quizzes and hands-on assignments.

  1. IntroductionThe Excel window, ribbon, cells and ranges, workbooks, saving, everyday shortcuts23 slides
  2. BasicsEditing, formatting, formulas, SUM · AVERAGE · COUNT, charts, printing47 slides
  3. IntermediateIF · IFS, text and dates, SUMIFS, XLOOKUP, FILTER · SORT · UNIQUE, tables61 slides
  4. AdvancedPivotTables, Power Query, what-if, LET · LAMBDA, dashboards, macros, Copilot64 slides
Month | Sales | Target Jan | 40 | 50 Feb | 65 | 50 Mar | 55 | 50 Apr | 90 | 50 [b]Total | [b]=SUM(B2:B5)→250 | [b]200
  1. 1
  2. 2
  3. 3
  4. 4
  5. Enrol

Tip: press → or Space to step through, ← to go back, R to replay.

About this lesson

This free demo previews MAVI Foundation's Microsoft Excel course for Excel 2024 and Microsoft 365. The full course runs over four levels: Introduction (the Excel window, ribbon and workbooks), Basics (editing, formatting, formulas, charts and printing), Intermediate (logical, text, date and lookup functions, dynamic arrays and data tools) and Advanced (PivotTables, Power Query, what-if analysis, LAMBDA, dashboards, macros and Copilot). Every function is explained with a worked example.

Key points

  • Four levels, 195 animated slides
  • Formulas and functions with real examples
  • Assignments with starter workbooks after every level