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