SUM Functions
SUM Function, SUMIF Function, SUMIFS Function
COUNT Functions
COUNT Function, COUNTIF Function, COUNTIFS Function
Logical Functions
True and False, And/Or Functions, IF Function
Lookup Functions
VLOOKUP Function, HLOOKUP Function
Text Search Functions
LEN, LEFT, RIGHT, MID Functions, FIND Function
Intro to Shortcuts
Copy, Paste, Cut, Undo, Text Formatting Shortcuts, Number Formatting Shortcuts
Cell Selection Shortcuts
Cell Selection, Larger Selections, Rows and Columns
Text Manipulation Functions
CONCAT Function, JOIN Function, UPPER, LOWER, PROPER Functions, SUBSTITUTE Function
Date Functions
TODAY Function, NOW Function
Index Match Lookup
INDEX Function, MATCH Function, INDEX/MATCH
Statistical Functions
AVERAGE Function, MIN, MAX, LARGE, SMALL Functions, FLOOR & CEILING Functions
Tables
Filters, Pivot Tables 1, Pivot Tables 2
