Learn VLOOKUP, Pivot Tables, XLOOKUP, IF, SUMIF, INDEX MATCH, and more!
Number Formatting Shortcuts
Cell Selection Shortcuts
COUNT Function
True & False
IF Function
SUM Function
Arrow Keys
Wildcard Characters
SUMIF Function
SUMIFS Function
SUM Functions Skill Summary
SUMIF Practice
SUMIFS Practice
COUNTIF Function
COUNTIFS Function
COUNT Practice
COUNT Skill Summary
AND, OR, XOR Functions
IS Functions
IFS Function
SWITCH Function
Larger Cell Selections
Row and Column Selections
Number Formatting Shortcuts
Cell Selection Shortcuts
COUNT Function
True & False
IF Function
SUM Function
Arrow Keys
Wildcard Characters
SUMIF Function
SUMIFS Function
SUM Functions Skill Summary
SUMIF Practice
SUMIFS Practice
COUNTIF Function
COUNTIFS Function
COUNT Practice
COUNT Skill Summary
AND, OR, XOR Functions
IS Functions
IFS Function
SWITCH Function
Larger Cell Selections
Row and Column Selections
Cell Selection Shortcuts 2
Larger Cell Selections 2
Cell Selection Skill Summary
VLOOKUP Function
VLOOKUP Function 2
VLOOKUP Practice
HLOOKUP Function
HLOOKUP Function 2
XLOOKUP Function
XLOOKUP Function 2
MATCH Function
INDEX Function
INDEX MATCH Lookup
INDEX MATCH Practice
Index Match Skill Summary
LEN, LEFT, and RIGHT Functions
MID Function
LEN, LEFT, RIGHT, MID Practice
FIND Function
SEARCH Function
Intro to Shortcuts
Text Formatting Shortcuts
Cut, Copy, Paste
Cell Selection Shortcuts 2
Larger Cell Selections 2
Cell Selection Skill Summary
VLOOKUP Function
VLOOKUP Function 2
VLOOKUP Practice
HLOOKUP Function
HLOOKUP Function 2
XLOOKUP Function
XLOOKUP Function 2
MATCH Function
INDEX Function
INDEX MATCH Lookup
INDEX MATCH Practice
Index Match Skill Summary
LEN, LEFT, and RIGHT Functions
MID Function
LEN, LEFT, RIGHT, MID Practice
FIND Function
SEARCH Function
Intro to Shortcuts
Text Formatting Shortcuts
Cut, Copy, Paste
Data Shortcuts
AVERAGE Function
MIN, MAX, LARGE, SMALL Functions
MIN, MAX, LARGE, SMALL Practice
FLOOR & CEILING Functions
DATE Function
TODAY Function
DATEDIF Function
DAYS Function
DATE Functions Skill Summary
CONCAT Function
TEXTJOIN Function
UPPER, LOWER, and PROPER Functions
SUBSTITUTE Function
Pivot Tables 1
Pivot Tables 2
Table Filters
Tables Skill Summary
ODD and EVEN Functions
Worksheets
Conditional Formatting
MEDIAN Function
MODE Function
Data Shortcuts
AVERAGE Function
MIN, MAX, LARGE, SMALL Functions
MIN, MAX, LARGE, SMALL Practice
FLOOR & CEILING Functions
DATE Function
TODAY Function
DATEDIF Function
DAYS Function
DATE Functions Skill Summary
CONCAT Function
TEXTJOIN Function
UPPER, LOWER, and PROPER Functions
SUBSTITUTE Function
Pivot Tables 1
Pivot Tables 2
Table Filters
Tables Skill Summary
ODD and EVEN Functions
Worksheets
Conditional Formatting
MEDIAN Function
MODE Function