Excel 2021 Power User Full Course

Excel 2021 Power User Full Course

Learnit Training via YouTube Direct link

DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH

3 of 44

3 of 44

DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH

Class Central Classrooms beta

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