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 | 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 Continuous Bucketing with VLOOKUP Nested IF Statements & WHY YOU SHOULD NOT USE THEM!
