Use this roadmap to check what you already know and what comes next. It is in the order that makes learning easiest.
Level 1: Beginner
- Excel screen, ribbon, workbooks, sheets, rows, columns, cells
- Entering data, data types, formatting, shortcuts, Paste Special
- Sort, filter, find and replace, remove duplicates
- SUM, AVERAGE, COUNT, MIN, MAX
- Relative and absolute references
Level 2: Intermediate
- IF, AND, OR, IFERROR, IFS
- SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIFS
- VLOOKUP, HLOOKUP, XLOOKUP, INDEX and MATCH
- Text formulas: LEFT, RIGHT, MID, TRIM, TEXTJOIN
- Date formulas: TODAY, DATEDIF, EOMONTH, NETWORKDAYS
- Pivot tables and basic charts
- Conditional formatting and data validation
Level 3: Professional (MIS and analytics)
- Building daily, weekly and monthly reports
- Data cleaning workflows and report checks
- Advanced pivot tables, slicers and timelines
- Dashboards with KPI cards
- Dynamic array functions: FILTER, SORT, UNIQUE
Level 4: Advanced
- Power Query: import, clean, merge, append, refresh
- Data model, Power Pivot and DAX measures
- Interactive dashboards
- Macros and VBA
Where to practice
Practise each formula in our free online Excel practice and see the full formulas list. For guided lessons with tests and certificates, see the Cellgrids courses.