Completed
INDEX & MATCH Part 1
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Power User Beginner Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 VLOOKUP
- 3 Range Lookup
- 4 Autofilling Lookup
- 5 Defining Names
- 6 Using Named Ranges to Retrieve Data
- 7 INDEX
- 8 MATCH
- 9 INDEX & MATCH Part 1
- 10 INDEX & MATCH Part 2
- 11 INDEX & MATCH Part 3
- 12 Introduction to Array Formula
- 13 Array Formula
- 14 Array Function
- 15 Dynamic Named Ranges Offset
- 16 OFFSET Function
- 17 Name Manager
- 18 Basic Conditional Formatting
- 19 Building New Rules and Troubleshooting
- 20 Expanding Conditional Formatting Fields
- 21 Text Search Conditional Formatting
- 22 Data Validating Conditional Formatting
