Excel Power User Tutorial - Advanced Functions, Pivot Tables, and Macros

Excel Power User Tutorial - Advanced Functions, Pivot Tables, and Macros

Learnit Training via YouTube Direct link

Combo Charts

22 of 28

22 of 28

Combo Charts

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. 1 Start
  2. 2 Introduction
  3. 3 IF Function Basics
  4. 4 IF Functions with Calculations
  5. 5 Nesting AND with IF
  6. 6 Naming Ranges and COUNTIF
  7. 7 SUMIF and AVERAGEIF
  8. 8 SUMIFS
  9. 9 XLOOKUP
  10. 10 Populating Forms with XLOOKUP
  11. 11 Displaying Pivot Table Fields with COUNT Function
  12. 12 Calculated Fields
  13. 13 Slicers
  14. 14 Using the Timeline
  15. 15 Inserting Report Filter Pages
  16. 16 Flash Fill for Text Functions
  17. 17 Introduction to Advanced Conditional Formatting and Macros
  18. 18 Array Formula Basics
  19. 19 Looking Up Multiple Values with XLOOKUP
  20. 20 Array Functions
  21. 21 Advanced Conditional Formatting
  22. 22 Combo Charts
  23. 23 Developer Tab
  24. 24 Macro Basics
  25. 25 Relative Reference Macros
  26. 26 VBA Basics
  27. 27 Cleaning Up Macros
  28. 28 Conclusion

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.