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) Best Practices for Working with Data in Excel (SIMPLE PRINCIPLES TO FOLLOW) Add Lookups both VERTICALLY AND HORIZONTALLY (Index Match Match) Index Match Match Walkthrough How to Problem Solve in Excel (DATA MANIPULATION BASICS & WIDE vs. LONG STRUCTURES) SUMIFS & COUNTIFS Basics SUMIFS Excel Walkthrough Why you should be using NAMED RANGES How to use INDIRECTs and WHY THEY WILL SAVE YOU HOURS IN EXCEL! COUNTIFS Excel Walkthrough (UNDERSTAND NUMBER OF ORDERS / CUSTOMERS) Customer Analysis Walkthrough Nested IF Statements & WHY YOU SHOULD NOT USE THEM! Continuous Bucketing with VLOOKUP Manipulate Numbers in Excel (CUSTOM NUMBER FORMATS!) Checking your Analysis (Walkthrough) Checking your Analysis (Key Principles) How to Write Custom Number Formats Own your Workstream (BUILD A STATUS TRACKER & SIMPLE TABLE FORMAT) Zebra Shaded Table in Excel (UPDATED WITH CONDITIONAL FORMATTING) Excel's Most Powerful Tool (PASTE SPECIAL) How to Print Excel Documents or PDF How to Freeze Panes in Excel Basics of Sensitivity Analysis (DATA TABLES IN EXCEL) Fastest Way to Create Output Tables in Excel (MULTI-CRITERIA SUMIFS & INDIRECTS)
