Module 1: Introduction to Excel
  • Module 1 Overview
1.1 The What, Why, and How of Excel
  • The What, Why, and How of Excel
1.2 Excel Components and User Interface
  • Excel Components and File Extensions
  • Excel's User Interface: The Ribbon
  • Excel's User Interface: Quick Access and Formula Toolbars
  • Excel's User Interface: The Worksheet
1.3 Introduction to Formulas and Functions
  • Introduction to Formulas and Functions
  • Formulas and Functions
  • Order of Operations and Formulas
  • Using Excel's Built in Functions
1.4 Overview of Cell References
  • Understanding Cell References
  • Cell References
Module 2: Process and Transform Data
  • Module 2 Overview
2.1 Performing Data Aggregation
  • Module 2.1 Overview
  • Simple Aggregation Functions
  • Simple Aggregation Functions
  • Single Criteria Conditional Aggregation: Static Criteria
  • Single Criteria Conditional Aggregation: Dynamic Criteria
  • Single Criteria Conditional Aggregation: >, <, and <> Conditions
  • Single Criteria Conditional Aggregation: Combining Aggregations
  • Single Criteria Conditional Aggregation Functions
  • Multiple Criteria Conditional Aggregation
  • Multiple Criteria Conditional Aggregation: AND Testing
  • Multiple Criteria Conditional Aggregation: OR Testing
  • Multiple Criteria Conditional Aggregation: Using Arrays for OR Testing
  • Multiple Criteria Conditional Aggregation: More on OR Testing
  • Multiple Criteria Conditional Aggregation Functions
  • Bonus: Using Array Multiplication to Aggregate Data from Many Columns
  • Database Aggregation Functions: Overview
  • Database Aggregation Functions: Building a Reporting Tool
  • Database Aggregations: Advanced Searches
  • Database Aggregation Functions
  • Performing Data Aggregation: Wrap Up
2.2 Performing Logical Operations
  • Module 2.2 Overview
  • Logical Operators
  • Conditional Functions Overview
  • More on Conditional Functions: The If Function
  • Handling more than two Outcomes: Nesting If Functions
  • Simple Error Handling with the Iferror Function
  • Logical Value Functions: True, False, and Not
  • Logical Operations
  • Performing Logical Operations: Wrap Up
2.3 Mastering Lookups and References
  • Module 2.3 Overview
  • Choose Function: An Overview and Simple Example
  • Choose Function: Making Other Functions Dynamic
  • Choose Function: Transforming Quality Scores and Selecting a Forecast Model
  • Choose Function: Nesting Functions Inside Choose
  • The Choose Function
  • Vlookup and Hlookup: An Overview
  • Vlookup: Key Concepts
  • Vlookup: Adding Meaning to Classifications
  • Vlookup: Making it Unique
  • Vlookup: Understanding Approximate Match
  • Vlookup: A Federal Income Tax Calculator
  • Vlookup: Searching Multiple Tables
  • Hlookup: More of the Same, Kind of
  • The Vlookup and Hlookup Functions
  • Index and Match: An Overview
  • Match: Finding the Position
  • Match: Understanding the Approximate Match
  • Index: A Special Case with 1D Arrays
  • Index: Getting Values from a Table
  • Index: Getting Values from Multiple Tables
  • Index: Returning a Reference Instead of a Value
  • The Index and Match Functions
  • Index and Match: Benefits of Index / Match Lookup
  • Index and Match: Left lookups and Reference Stability
  • Index and Match: Building a Dynamic Order Report
  • Index and Match: Mastering the Approximate Lookup
  • Index and Match: Putting the Approximate Match to Use
  • Index and Match: The Power of Offsetting Lookups
  • Index and Match: Searching Multiple Tables - Revisited
  • Index and Match: Finding the First Occurrence
  • Index and Match: Returning the Entire Row or Column
  • Combining the Index and Match Functions
  • Defined Names: Overview and Simple Example
  • Defined Names: More than Constants - Storing Ranges and Calculations
  • Defined Names
  • Offset: Understanding the Offset Function
  • Offset: Creating a Dynamic Dropdown List
  • Offset: Creating a Dynamic Calculation
  • Offset: Another Dynamic Calculation
  • Offset: Dynamic Charting
  • The Offset Function
  • Row and Column: An Overview
  • Row and Column: Finding the Last Row and Automatic Numbering
  • Rows and Columns: An Overview
  • Rows and Columns: Cleaning Up Bad Data
  • Row, Column, Rows, and Columns
  • Lookups, References, and Arrays: Returning More than the First Occurrence
  • Lookups, References, and Arrays: Managing Schedules - Part 1