Completed
SUMIFS
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Power User Tutorial - Advanced Functions, Pivot Tables, and Macros
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 IF Function Basics
- 4 IF Functions with Calculations
- 5 Nesting AND with IF
- 6 Naming Ranges and COUNTIF
- 7 SUMIF and AVERAGEIF
- 8 SUMIFS
- 9 XLOOKUP
- 10 Populating Forms with XLOOKUP
- 11 Displaying Pivot Table Fields with COUNT Function
- 12 Calculated Fields
- 13 Slicers
- 14 Using the Timeline
- 15 Inserting Report Filter Pages
- 16 Flash Fill for Text Functions
- 17 Introduction to Advanced Conditional Formatting and Macros
- 18 Array Formula Basics
- 19 Looking Up Multiple Values with XLOOKUP
- 20 Array Functions
- 21 Advanced Conditional Formatting
- 22 Combo Charts
- 23 Developer Tab
- 24 Macro Basics
- 25 Relative Reference Macros
- 26 VBA Basics
- 27 Cleaning Up Macros
- 28 Conclusion
