Excel A to Z
Main learning pathTen progressive courses — from complete beginner to confident intermediate. Interface, formulas, lookups, dates, text, charts. Everything, in order.
Start here. Understand the Excel interface, customize your view, and master the fundamentals of data entry.
Make your spreadsheets readable and professional. Master text, number, cell formatting, and conditional formatting basics.
Transform raw data into structured tables. Master sorting, filtering, and interactive slicers to manage data efficiently.
Your first formulas. Learn syntax, references, and the essential math functions (SUM, AVERAGE, COUNT) that power everything else.
Make your spreadsheets think. Build IF/IFS logic, combine with AND/OR, and gracefully handle errors.
Connect data across tables. Master VLOOKUP, XLOOKUP, and INDEX+MATCH to retrieve any value from any list.
Master dates and times in Excel. Calculate delays, deadlines, durations, and build smart schedules.
Clean and analyze textual data. Extract, search, and tidy text with LEFT, RIGHT, MID, LEN, FIND, CLEAN, and TRIM.
Practical math and statistics: rounding, conditional totals, median, and random numbers — for scores, prices, and quick analysis.
Turn numbers into stories. Create clear, professional charts — bars, combo charts, sparklines — and build a simple dashboard.