Excel 2019 Power User Tutorial

Excel 2019 Power User Tutorial

Learnit Training via YouTube Direct link

PivotTables - 2019 Features

8 of 19

8 of 19

PivotTables - 2019 Features

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel 2019 Power User Tutorial

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Start
  2. 2 Introduction
  3. 3 Troubleshooting VLOOKUP
  4. 4 Using IFERROR
  5. 5 Replacing VLOOKUP with XLOOKUP
  6. 6 Index Match
  7. 7 Text Functions
  8. 8 PivotTables - 2019 Features
  9. 9 PivotTables - Calculated Field
  10. 10 PivotTables - Calculated Items
  11. 11 PivotTables - Show Values As
  12. 12 Array Formulas and Functions
  13. 13 Index and Match Array Function
  14. 14 Conditional Format New Rule Examples
  15. 15 Combo Charts and Sparklines
  16. 16 Add Developer Recording Macros
  17. 17 Editing, Saving, and Stepping into a Macro
  18. 18 Recording a Format Macro
  19. 19 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.