INTRO TO 80:20 EXCEL AND FINDING THE RIGHT INFORMATION
The 80:20 principle & the paradox of choice
Introduction to Excel for professionals
Performance of Excel
Long boring lists
Long boring lists: Monthly Data
Small, Mid and Large Data sets
Locking down cells
Finding Information: VLOOKUP
Finding Information: INDEX & MATCH
OPTIONAL: Excel Tables & Slicers
ADVANCED LOOKUPS & LOGIC TO CREATE POWERFUL SOLUTIONS
Finding Information: Limit formulas
Getting Advanced with Lookups
Finding Information: putting it all together
Rule building with IF
More advanced logic building
DEALING WITH NON-NUMERICAL DATA
Working with Text
Text Functions: PROPER, TRIM & CLEAN
Text Functions: LEN & SEARCH
Text Functions: LEFT, MID, RIGHT
Flash Fill
Text functions: Advanced Text analysis by building formulas
Text functions: Creating email addresses to build distribution lists
Creating character and word count limits
MASTERING THE ART OF SUMMARISING YOUR WORK
Introduction to summarising
Counting
Summing
Analysis walkthrough with summing and counting
Everything you need to know about Pivot Tables in under 15 minutes
Advanced list analysis: understanding Array formulas
OPTIONAL: Introduction to Array Formulas
OPTIONAL: Array Formulas for Multiple Criteria
OPTIONAL: Array Formulas for Multiple Occurrences
Advanced Modelling with Array formula lookups
Dashboard and reporting practice for professionals
Advanced Conditional formatting: Using formulas
Advanced Conditional formatting: Beyond Highlighting
DEEPER INTO BUILDING WORLD CLASS REPORTS AND SOLUTIONS
Resource Analysis: Good practice for managing data
Dynamic Charts
Charting Actual vs Forecast
Segmenting for deeper MI
Meaningful Resource Analysis