CodeMIRAI
0 XP

Excel for everyone

Learn Excel the useful way: cell references, the formulas people actually use, lookups, PivotTables and charts, with worked examples for every function.

  • 3 modules
  • 15 lessons
  • 0 runnable examples
  • Beginner to intermediate
01

Getting started

Cells, references and your first formulas.

  1. Introduction to Excel
  2. Your first formulas
  3. Relative and absolute references
  4. Number formatting
02

Essential functions

The functions you will use every day.

  1. SUM, AVERAGE, MIN and MAX
  2. COUNT, COUNTA and COUNTIF
  3. IF and logical tests
  4. SUMIF and SUMIFS
  5. Text functions
  6. Date functions
03

Lookups and analysis

Finding and summarising data.

  1. VLOOKUP
  2. XLOOKUP
  3. INDEX and MATCH
  4. PivotTables
  5. Charts