Excel - Level 2
1 Day - 4 hours
 
Pre-requisites - Excel Level 1
What you'll learn
VLOOKUP functions
HLOOKUP & LOOKUP Functions
IF Statement & Nested IF Statements
Sort & Filter Columns
Create Tables 
Use Slicers
Create Pivot Tables
Formatting Pivot Table
Pivot Table Group - Sort
Pivot Chart
Conditional Formatting
Find & Replace 
Find Blanks & Duplicates
Formula Trace Precedents & Dependents
Excel Level 3 warmup