Excel 2021 Power User Tutorial

Excel 2021 Power User Tutorial

Learnit Training via YouTube Direct link

DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH

2 of 11

2 of 11

DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel 2021 Power User Tutorial

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

  1. 1 Start
  2. 2 DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH
  3. 3 Excel XLOOKUP Two-Way Search
  4. 4 Text Functions
  5. 5 Advanced Pivot Tables
  6. 6 INDEX MATCH Array Function
  7. 7 Advanced Conditional Formats
  8. 8 Excel Charts
  9. 9 Introduction to Macros
  10. 10 Macro Examples
  11. 11 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.