Excel Practice

Excel functions

75 functions have a lesson that makes you type them. Every row links to the practice rather than to an explanation, because reading about VLOOKUP is not the part people find hard.

Every function with a lesson, the module it sits in, and the lessons that teach it
Function Practise it in
AND AND, OR and NOT
AVERAGE AVERAGE MEDIAN and MODE FILTER Project: A Grade Book
AVERAGEIF AVERAGEIF Project: A Grade Book
AVERAGEIFS AVERAGEIFS
CONCAT Joining Text: & and CONCAT Building and Cleaning: Putting It Together
COUNT COUNT and COUNTA AVERAGE
COUNTA COUNT and COUNTA UNIQUE Dynamic Arrays: Putting It Together
COUNTBLANK COUNT and COUNTA
COUNTIF COUNTIF A Frequency Table: UNIQUE with COUNTIF What a Pivot Table Does Project: A Grade Book Project: Budget Against Actual Project: A Stock Reorder List
COUNTIFS COUNTIFS A Lookup on Two Criteria Grouping by Month: EOMONTH and SUMIFS Project: A Sales Report Project: A Stock Reorder List
DATE DATE: Building One from Pieces
DATEDIF DATEDIF: The Undocumented One Dates and Time: Putting It Together Ages and Years of Service
DAY YEAR, MONTH and DAY
DAYS Days Left and Deadlines
EOMONTH WEEKDAY and EOMONTH Grouping by Month: EOMONTH and SUMIFS
FILTER FILTER A Frequency Table: UNIQUE with COUNTIF Dynamic Arrays: Putting It Together
FIND FIND: Locating a Character LEFT with FIND: Splitting a Name Extracting Text: Putting It Together
HLOOKUP HLOOKUP
IF IF AND, OR and NOT Nested IF, and When to Stop Putting It Together ISNUMBER, ISTEXT, ISBLANK and ISERROR Guarding a Division: IF or IFERROR? Errors: Putting It Together Days Left and Deadlines Project: Budget Against Actual Project: A Stock Reorder List
IFERROR IFERROR AVERAGEIFS
IFNA XMATCH: Position, Then Value IFNA and the Not-Found Value Why VLOOKUP Returns #N/A Errors: Putting It Together TEXTBEFORE
IFS IFS and SWITCH
INDEX INDEX INDEX and MATCH Together XMATCH: Position, Then Value Two-Way Lookup: INDEX with Two MATCHes SORT SEQUENCE A Frequency Table: UNIQUE with COUNTIF Dynamic Arrays: Putting It Together Project: A Sales Report
ISBLANK ISNUMBER, ISTEXT, ISBLANK and ISERROR Errors: Putting It Together
ISNUMBER ISNUMBER, ISTEXT, ISBLANK and ISERROR FIND: Locating a Character Extracting Text: Putting It Together TEXT and VALUE: Converting Between the Two
ISTEXT ISNUMBER, ISTEXT, ISBLANK and ISERROR
LARGE LARGE and SMALL
LEFT LEFT and RIGHT: Taking from the Ends LEFT with FIND: Splitting a Name Splitting a Full Name
LEN LEN: Counting Characters Extracting Text: Putting It Together TRIM: The Invisible Problem Building and Cleaning: Putting It Together
LOWER UPPER, LOWER and PROPER
MATCH MATCH INDEX and MATCH Together Two-Way Lookup: INDEX with Two MATCHes Project: A Sales Report
MAX MAX and MIN A Frequency Table: UNIQUE with COUNTIF Project: A Sales Report Project: A Timesheet
MAXIFS MAXIFS and MINIFS Project: A Stock Reorder List
MEDIAN MEDIAN and MODE
MID MID: Taking from the Middle LEFT with FIND: Splitting a Name Extracting Text: Putting It Together
MIN MAX and MIN
MINIFS MAXIFS and MINIFS
MODE MEDIAN and MODE
MONTH YEAR, MONTH and DAY
NETWORKDAYS Working Days: NETWORKDAYS and WORKDAY Project: A Timesheet
NOT AND, OR and NOT
OR AND, OR and NOT
PROPER UPPER, LOWER and PROPER Building and Cleaning: Putting It Together
REPLACE REPLACE: By Position, Not by Content
ROUND ROUND, ROUNDUP and ROUNDDOWN Percentages: Share, Change and Discount Project: An Invoice Project: A Grade Book
ROUNDDOWN ROUND, ROUNDUP and ROUNDDOWN
ROUNDUP ROUND, ROUNDUP and ROUNDDOWN
ROWS FILTER
SEQUENCE SEQUENCE
SMALL LARGE and SMALL
SORT SORT A Frequency Table: UNIQUE with COUNTIF Dynamic Arrays: Putting It Together
SUBSTITUTE SUBSTITUTE: Replacing Text Building and Cleaning: Putting It Together REPLACE: By Position, Not by Content Splitting Text: Putting It Together
SUBTOTAL SUBTOTAL: One Function, Nine Aggregates
SUM The SUM Function Fill Down and Fill Right Relative References Absolute References and the Dollar Sign Filling Down and Filling Right Copying Formulas: What Travels and What Does Not References: Putting It Together AVERAGE Running Totals Putting It Together IFERROR Errors: Putting It Together Date Arithmetic: Subtracting Dates FILTER SEQUENCE Dynamic Arrays: Putting It Together SUMPRODUCT: Weighted Totals and Conditions What a Pivot Table Does A Pivot Table with Rows and Columns Reading and Checking a Pivot Table Project: An Invoice Project: Budget Against Actual Project: A Timesheet
SUMIF SUMIF SUMIFS, and the Argument Order That Flips Putting It Together A Frequency Table: UNIQUE with COUNTIF What a Pivot Table Does Project: A Timesheet
SUMIFS SUMIFS, and the Argument Order That Flips A Lookup on Two Criteria Choosing a Lookup: Putting It Together Grouping by Month: EOMONTH and SUMIFS A Pivot Table with Rows and Columns Project: A Sales Report
SUMPRODUCT SUMPRODUCT: Weighted Totals and Conditions
SWITCH IFS and SWITCH
TEXT TEXT and VALUE: Converting Between the Two Building and Cleaning: Putting It Together How Excel Stores Dates Grouping by Month: EOMONTH and SUMIFS
TEXTAFTER TEXTAFTER Splitting a Full Name Splitting Text: Putting It Together
TEXTBEFORE TEXTBEFORE Splitting a Full Name Splitting Text: Putting It Together
TEXTJOIN TEXTJOIN: A Separator and a Range
TODAY TODAY and NOW Dates and Time: Putting It Together
TRIM Why VLOOKUP Returns #N/A TRIM: The Invisible Problem Building and Cleaning: Putting It Together
UNIQUE UNIQUE Dynamic Arrays: Putting It Together
UPPER UPPER, LOWER and PROPER
VALUE Why VLOOKUP Returns #N/A TEXT and VALUE: Converting Between the Two Building and Cleaning: Putting It Together
VLOOKUP Nested IF, and When to Stop Putting It Together VLOOKUP Approximate Match: Bands and Brackets Choosing a Lookup: Putting It Together IFNA and the Not-Found Value Why VLOOKUP Returns #N/A Errors: Putting It Together TRIM: The Invisible Problem Project: A Grade Book
WEEKDAY WEEKDAY and EOMONTH
WORKDAY Working Days: NETWORKDAYS and WORKDAY
XLOOKUP XLOOKUP Approximate Match: Bands and Brackets XLOOKUP: Looking Left, Not Found and Next Larger A Lookup on Two Criteria Choosing a Lookup: Putting It Together IFNA and the Not-Found Value Project: A Stock Reorder List
XMATCH XMATCH: Position, Then Value
YEAR YEAR, MONTH and DAY

Mentioned, not yet practised

These come up in a lesson's explanation — usually as the alternative to the function being taught — but nothing here makes you type one yet.