Completed
Start
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