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