Formulas, data and analysis
From your first SUM to SUMIFS, XLOOKUP, INDEX/MATCH, tables, PivotTables and Power Query. Practice in a working spreadsheet with real formulas, on sales, inventory, payroll and budget data.
35 lessons13 modules about 4 hours Everyone Certificate
35 hands-on lessons
Earn your Microsoft Excel certificate
Finish all 35 lessons, then pass the 20-question final exam (80% to pass). Your certificate has a public link anyone can verify.
Formulas, data entry and quick statistics: the skills every spreadsheet starts with.
SUM, AVERAGE and simple math: make a spreadsheet do the arithmetic for you.
Edit cells, add line breaks, stamp dates and fill data down without retyping.
Multiply, divide, raise to powers and use parentheses so Excel calculates in the order you mean.
Summarize a week of café trading: lowest, highest, how many and the middle value.
Move around quickly, make numbers readable, organize sheets and print cleanly.
Jump to the edges of your data, select whole rows and columns, and reach any cell fast.
Currency, percentages, wrapping and Format Painter, and why formatting never changes the value.
Insert, delete, hide and resize rows and columns, and manage sheet tabs.
Landscape pages, print areas, repeating headers and fitting a report on one page.
Control what happens when formulas are copied: $ signs, mixed references and named ranges.
Rounding, whole-number math, rankings and weighted totals.
Answer questions like “how much did the East sell?” with COUNTIF, SUMIF and their multi-condition cousins.
MAX, COUNTIF, SUMIF and AVERAGEIF, plus sorting and freezing the header row.
Count, total and average sales that meet two or more conditions at once.
Find the largest and smallest matching values, match partial text and drive conditions from a cell.
Make formulas decide with IF, AND, OR and IFS, and deal with errors gracefully.
Bonuses, overtime and budget flags: formulas that choose between two results.
Combine conditions and handle more than two outcomes.
Read Excel's error codes, replace errors with sensible results and trace where formulas get their data.
Pull matching values from another table with VLOOKUP, XLOOKUP and INDEX/MATCH.
Look up prices, stock levels and commission tiers, and avoid the approximate-match trap.
Exact matches by default, lookups in any direction, built-in “not found” values and banded rates.
The classic flexible lookup, two-way lookups across a grid, and picking from a list by number.
Clean up messy imports and split or join text.
Sort, filter, tables, validation, duplicates and conditional formatting.
Multi-level sorts, filters and the traps that scramble a list.
Tables that grow automatically, totals that respect filters and formulas that read like English.
Dropdown lists, duplicates, Text to Columns and Flash Fill.
Colors, data bars and icons that update as the numbers change.
Turn numbers into clear charts and summarize big lists without writing formulas.
Date math, formulas that spill, and data clean-up you can repeat with one click.
How Excel stores dates, simple date math and the key date functions.
One formula that spills a whole list of results in Microsoft 365.
Import, clean and reshape data once, then refresh it every month with a click.
Paste Special, power-user shortcuts and Goal Seek.
Protect formulas, comment and co-author safely.
35 hands-on lessons
Earn your Microsoft Excel certificate
Finish all 35 lessons, then pass the 20-question final exam (80% to pass). Your certificate has a public link anyone can verify.
Formulas, data entry and quick statistics: the skills every spreadsheet starts with.
SUM, AVERAGE and simple math: make a spreadsheet do the arithmetic for you.
Edit cells, add line breaks, stamp dates and fill data down without retyping.
Multiply, divide, raise to powers and use parentheses so Excel calculates in the order you mean.
Summarize a week of café trading: lowest, highest, how many and the middle value.
Move around quickly, make numbers readable, organize sheets and print cleanly.
Jump to the edges of your data, select whole rows and columns, and reach any cell fast.
Currency, percentages, wrapping and Format Painter, and why formatting never changes the value.
Insert, delete, hide and resize rows and columns, and manage sheet tabs.
Landscape pages, print areas, repeating headers and fitting a report on one page.
Control what happens when formulas are copied: $ signs, mixed references and named ranges.
Rounding, whole-number math, rankings and weighted totals.
Answer questions like “how much did the East sell?” with COUNTIF, SUMIF and their multi-condition cousins.
MAX, COUNTIF, SUMIF and AVERAGEIF, plus sorting and freezing the header row.
Count, total and average sales that meet two or more conditions at once.
Find the largest and smallest matching values, match partial text and drive conditions from a cell.
Make formulas decide with IF, AND, OR and IFS, and deal with errors gracefully.
Bonuses, overtime and budget flags: formulas that choose between two results.
Combine conditions and handle more than two outcomes.
Read Excel's error codes, replace errors with sensible results and trace where formulas get their data.
Pull matching values from another table with VLOOKUP, XLOOKUP and INDEX/MATCH.
Look up prices, stock levels and commission tiers, and avoid the approximate-match trap.
Exact matches by default, lookups in any direction, built-in “not found” values and banded rates.
The classic flexible lookup, two-way lookups across a grid, and picking from a list by number.
Clean up messy imports and split or join text.
Sort, filter, tables, validation, duplicates and conditional formatting.
Multi-level sorts, filters and the traps that scramble a list.
Tables that grow automatically, totals that respect filters and formulas that read like English.
Dropdown lists, duplicates, Text to Columns and Flash Fill.
Colors, data bars and icons that update as the numbers change.
Turn numbers into clear charts and summarize big lists without writing formulas.
Date math, formulas that spill, and data clean-up you can repeat with one click.
How Excel stores dates, simple date math and the key date functions.
One formula that spills a whole list of results in Microsoft 365.
Import, clean and reshape data once, then refresh it every month with a click.
Paste Special, power-user shortcuts and Goal Seek.
Protect formulas, comment and co-author safely.
Unlock every lesson, exam and certificate
The Basics module is free. Pro unlocks the intermediate and advanced lessons, from $3.33/month.