Get good at Excel by actually using it.
Short, hands-on lessons in a live spreadsheet. Type a formula, get instant feedback, and build skills that stick, from your first =SUM to XLOOKUP and dynamic arrays.
Browse the course · Function reference · Playground · Keyboard shortcuts
Tracks
- Spreadsheet Basics: Cells, formulas, ranges and the references that make spreadsheets tick.
- Logic & Decisions: Teach your formulas to decide: comparisons, IF, IFS, AND/OR/NOT and friendly error handling.
- Conditional Math: Count, sum and average only the rows that match your conditions.
- Lookups: Pull matching data from other tables with VLOOKUP, INDEX/MATCH and XLOOKUP.
- Working with Text: Join, split, clean and reformat text without retyping a thing.
- Dates, Rounding & Money: Date arithmetic, working days, rounding rules and the maths behind loans and savings.
- Time & Schedules: Times as fractions of a day, timesheets and overnight shifts, overtime pay and date-based reports.
- Statistics & Ranking: Rank results, pick out the top and bottom, and describe what is typical and how spread out your numbers are.
- Clean & Check Data: Spot problems, flag duplicates, decode codes and repair messy imported values.
- Money & Finance: How long debts take to clear, what loans really charge, where each payment goes, and which investment is worth more.
- Modern Excel: Dynamic arrays that spill: one formula, a whole list of answers. UNIQUE, SORT, FILTER and friends.
- Keyboard Shortcuts: Fly around a spreadsheet, edit and format it without touching the mouse.
- Challenges: Real-world projects that combine everything you have learned, with less hand-holding.