Learn Excel by doing real work.
Build reliable spreadsheet skills with formulas, lookups, cleanup and reconciliation patterns.
From fundamentals to useful work.
Short explanations, runnable examples, quick checks and a hands-on practice set.
Excel Formula Basics
Understand formulas, cell references and calculation order.
SUM, AVERAGE, MIN & MAX
Calculate totals and basic descriptive statistics.
IF
Return one result when a condition is true and another when it is false.
COUNTIF & COUNTIFS
Count rows that meet one or several conditions.
SUMIF & SUMIFS
Sum values only for rows that meet criteria.
XLOOKUP
Find a key in one range and return a related value from another range.
INDEX + MATCH
Build a flexible lookup using a position finder and a return range.
Text Cleaning Functions
Clean and reshape messy text with TRIM, LEFT, RIGHT, MID and LEN.
Date Functions
Extract and work with year, month and day values.
Find Duplicates
Detect repeated IDs and understand when duplicates are valid or problematic.
Compare Two Lists
Check whether values from one list exist in another list.
Pivot Table Thinking
Understand how rows, columns, values and filters turn detail data into a summary.