Photo: Carlos Muza / Unsplash
Spreadsheets & data — from Zero to Expert

Microsoft Excel

Master Excel from the basics to advanced features: formulas, conditional formatting, pivot tables, Power Query, Power Pivot/DAX, VBA, dashboards and certification.

7progressive levels
35detailed sections
100%free resources
ENEnglish edition

🇫🇷 Version française 🇪🇸 Versión española 🌐 العربية

How to follow this guide

Guide resources

0

Level 0 — Getting started & environment

Understand Excel, install it and discover workbooks, sheets and cells.

  1. What is Excel & overview
  2. Install, license & Excel free online
  3. Interface: ribbon, workbooks, sheets & cells
  4. Enter, select & save
Start level 0 →
2

Level 2 — Intermediate: functions, lookup & filters

Automate calculations with logical and lookup functions, filter and structure.

  1. Logical functions: IF, AND, OR, IFS
  2. Lookup: VLOOKUP, XLOOKUP, INDEX/MATCH
  3. Text & date/time functions
  4. Conditional formatting
  5. Sort, filters & structured tables
Start level 2 →
3

Level 3 — Advanced: pivot tables & charts

Summarise and visualise: pivot tables, charts, slicers and data validation.

  1. Pivot tables
  2. Charts & pivot charts
  3. Slicers, timelines & simple dashboards
  4. Data validation & drop-down lists
  5. Conditional calculation: SUMIF(S), COUNTIF(S)
Start level 3 →
5

Level 5 — Specialisations & certification

Dashboards, analysis, collaboration and certification prep.

  1. Professional dashboards & KPIs
  2. What-if analysis: Goal Seek & Solver
  3. Collaboration, protection & sharing
  4. Prepare the MOS Excel certification
Start level 5 →
6

Level 6 — In practice

Case studies, error playbook, toolbox and field feedback.

  1. Case studies
  2. Recurring problems (playbook)
  3. Best practices & pitfalls
  4. Toolbox
  5. Field feedback
  6. Going further
Start level 6 →