Excel 2019 Power User Tutorial

Excel 2019 Power User Tutorial

Learnit Training via YouTube Direct link

Index and Match Array Function

12 of 18

12 of 18

Index and Match Array Function

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