Completed
- Two-way Lookups in Excel INDEX, MATCH
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Advanced Excel Formulas - IF, IFS, INDEX, MATCH, SUMPRODUCT, XLOOKUP, OFFSET, CHOOSE
Automatically move to the next video in the Classroom when playback concludes
- 1 - Introduction
- 2 - Logical Functions in Excel IF, IFS, AND, OR
- 3 - Two-way Lookups in Excel INDEX, MATCH
- 4 - Assigning Random Values in Excel CHOOSE, RANDBETWEEN
- 5 - Finding the Most Recent Occurrence INDEX, MATCH, MODE, SUMPRODUCT
- 6 - Looking up Values XLOOKUP
- 7 - Extracting Text Strings LEFT, RIGHT, LEN, FIND
- 8 - Sum and Count with Multiple Criteria SUMIFS, COUNTIFS
- 9 - Dynamic SUM Calculations SUM, OFFSET, MATCH
