Completed
Introduction to VLOOKUP
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 2019 Expert Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Creating & Applying Named Ranges
- 4 Navigating with Named Ranges
- 5 IF Functions Part 1
- 6 IF Functions Part 2
- 7 Introduction to Nesting Functions
- 8 The Round Function
- 9 Formula Auditing Tools
- 10 Introduction to VLOOKUP
- 11 VLOOKUP
- 12 IFERROR
- 13 Database Functions – SUMIF & AVERAGEIF
- 14 Database Functions – SUMIFS
- 15 Text Functions
- 16 Consolidate by Position
- 17 Consolidate by Category
- 18 Goal Seek
- 19 Introduction to Data Tables
- 20 Data Tables
- 21 Scenario Manager
- 22 Macros – Adding the Developer Tab
- 23 Macros – Recording & Running the Header Macro
- 24 Macros – Visual Basic Editor & Form Control
- 25 Macros – Adding Macros to the Ribbon
- 26 Macros – Exercise
