Excel 2019 Expert Tutorial

Excel 2019 Expert Tutorial

Learnit Training via YouTube Direct link

Macros – Recording & Running the Header Macro

23 of 26

23 of 26

Macros – Recording & Running the Header Macro

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel 2019 Expert Tutorial

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

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