Completed
Start
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Excel 2021 Power User Full Course
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Excel Power User Introduction
- 3 DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH
- 4 Excel XLOOKUP Two-Way Search
- 5 Text Functions
- 6 Advanced Pivot Tables
- 7 INDEX MATCH Array Function
- 8 Advanced Conditional Formats
- 9 Excel Charts
- 10 Introduction to Macros
- 11 Macro Examples
- 12 Excel Power User Conclusion
- 13 Pivot Tables Introduction
- 14 Organizing Data in Tables
- 15 More Data Organization Techniques
- 16 Data Mining
- 17 Custom Sort Command and Functions
- 18 Merge Data Using XLOOKUP
- 19 Pivot Tables - Setup
- 20 Pivot Tables - Building Reports
- 21 Pivot Tables - Formats, Drilldowns, and Refreshing
- 22 Pivot Tables - Designing for Reports and Charts
- 23 Pivot Tables - Cal Fields, Items, and Grouping
- 24 Power Pivot - Turning It On
- 25 Power Pivot - Adding Data and Establishing Relationships
- 26 Power Pivot - RELATED Function and Pivot Tables
- 27 Pivot Tables Conclusion
- 28 Intro to Data Analysis Introduction
- 29 Working with Tables
- 30 Conditional Formats
- 31 Using the IF FUNCTION
- 32 Database Functions
- 33 Unique, Sort, and Filter Functions
- 34 Charts and Sparklines
- 35 Working with Pivot Tables
- 36 Intro to Data Analysis Conclusion
- 37 XLOOKUP Introduction
- 38 VLOOKUP Refresher
- 39 XLOOKUP Basics
- 40 INDEX and MATCH
- 41 XLOOKUP - Approx Match Results
- 42 XLOOKUP - Returning Multiple Values
- 43 XLOOKUP - Two Way Search
- 44 XLOOKUP Conclusion
