Completed
Database Functions – SUMIF & AVERAGEIF
Class Central Classrooms beta
YouTube playlists 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
