Excel function guides
How each function actually works, with a worked example — then a direct link to practice it for real in a live spreadsheet.
Conditional Formatting in Excel
How conditional formatting works in Excel, with worked rule examples — then practice by predicting exactly which cells a rule highlights.
COUNTIF and SUMIF in Excel
How COUNTIF and SUMIF count and total cells that meet a condition, with real formula examples — then practice with real spreadsheet exercises.
Pivot Table Exercises & Practice
What a pivot table actually computes, with worked SUMIF/COUNTIF equivalents — then practice filling in real pivot results in a live spreadsheet.
The IF Function in Excel
How Excel's IF function works, with worked examples and common nesting mistakes — then practice writing real IF formulas in a live spreadsheet.
INDEX MATCH in Excel
How INDEX and MATCH combine to look up values more flexibly than VLOOKUP, with a worked example — then practice with real spreadsheet exercises.
The MID Function (and LEFT, RIGHT) in Excel
How MID, LEFT, and RIGHT extract text from a cell, with worked examples — then practice pulling real text apart in a live spreadsheet.
Logical Operators in Excel (AND, OR, NOT)
How AND, OR, and NOT combine conditions in Excel formulas, with worked examples — then practice combining logic in a live spreadsheet.
Excel Practice Exercises
Free, interactive Excel practice exercises in a real spreadsheet — type real formulas, get instant feedback, and work through every function from SUM to pivot tables.
VLOOKUP Practice Exercises
How VLOOKUP looks up values across a table, with a worked example and common pitfalls — then practice with real VLOOKUP exercises in a live spreadsheet.
XLOOKUP Practice Exercises
How XLOOKUP replaces VLOOKUP and INDEX MATCH with one simpler formula, with a worked example — then practice with real XLOOKUP exercises.
Excel Keyboard Shortcut Practice
The Excel selection shortcuts that actually save time at work, with what each one does — then practice them for real in a live spreadsheet grid.
Test Your Excel Skills
A free way to test your Excel skills with real formulas instead of multiple choice — see exactly which functions you know and which need practice.
AVERAGEIF and MEDIAN Practice
How AVERAGEIF conditionally averages a range and when MEDIAN beats AVERAGE, with worked examples — then practice with real exercises.
UNIQUE, SORT & FILTER Array Formula Practice
How UNIQUE, SORT, and FILTER spill results across multiple cells from one formula, with worked examples — then practice with real array formula exercises.