Course Content Full Excel Course Skip to Videos All | Excel (1/3) - Foundations & Basics | Excel (2/3) - Data Manipulation & Formulas | Excel (3/3) - File Completion & Ad Hoc | Excel Basics (EXCEL 101) Logic in Excel (IF STATEMENTS EXPLAINED) Add Lookups in Excel (INDEX MATCH EXPLAINED) Lookups Excel Walkthrough (INDEX MATCH LIVE EXAMPLES) How to use Pivot Tables? (PIVOT TABLE BASICS) Pivot Tables Excel Walkthrough (HOW TO USE PIVOT TABLES) Basics of Data Investigation (USE PIVOT TABLES TO UNDERSTAND YOUR DATASET) You are spending TOO MUCH TIME FORMATTING! (WHAT YOU SHOULD CHANGE AND WHY) Logical Foundation of an Excel Model (FLOW MAY SURPRISE YOU) How to Format Output Tables in Excel (SIMPLE FORMATTING APPROACH) Excel Model Formatting Logic (BONUS TIPS INCLUDED)
