Excel 2019 Advanced Tutorial

Excel 2019 Advanced Tutorial

Learnit Training via YouTube Direct link

Macros – Recording & Running the Header Macro

22 of 25

22 of 25

Macros – Recording & Running the Header Macro

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel 2019 Advanced Tutorial

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

  1. 1 Start
  2. 2 Creating & Applying Named Ranges
  3. 3 Navigating with Named Ranges
  4. 4 IF Functions Part 1
  5. 5 IF Functions Part 2
  6. 6 Introduction to Nesting Functions
  7. 7 The Round Function
  8. 8 Formula Auditing Tools
  9. 9 Introduction to VLOOKUP
  10. 10 VLOOKUP
  11. 11 IFERROR
  12. 12 Database Functions – SUMIF & AVERAGEIF
  13. 13 Database Functions – SUMIFS
  14. 14 Text Functions
  15. 15 Consolidate by Position
  16. 16 Consolidate by Category
  17. 17 Goal Seek
  18. 18 Introduction to Data Tables
  19. 19 Data Tables
  20. 20 Scenario Manager
  21. 21 Macros – Adding the Developer Tab
  22. 22 Macros – Recording & Running the Header Macro
  23. 23 Macros – Visual Basic Editor & Form Control
  24. 24 Macros – Adding Macros to the Ribbon
  25. 25 Macros – Exercise

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.