Learnit Training provides this Excel VBA Beginner Tutorial for those looking to boost their Excel skills.
Sure, it’s not Spark or Python, but not everything needs to be.
Exercise files: https://bit.ly/2OGV7eu
Content:
- Introduction 0:03
- What is VBA? 1:44
- Object Oriented Programming Languages 5:59
- Turning on the Developer Tab 10:17
- The Macro Recorder 13:40
- Using Relative References 20:39
- Recording Simple Macros 27:51
- Multi-Step Macro Recording 39:25
- Sort and Filter Macro Recording 45:26
- Protecting and Formatting Sheets with the Macro Recorder 51:35
- VBA Interface Setup 55:09
- Recorder Code vs. Manual Code 1:01:11
- Introduction to Editing Macros 1:12:28
- Debugging Macros 1:16:53
- Grammar in VBA 1:28:00
- Macro Scripting Basics 1:33:04
- Range 1:40:41
- Selection & Color 1:47:14
- Value and Clear 1:52:16
- ActiveSheet, Sheets, and Name 1:54:01
- CurrentRegion 1:56:40
- Practice 1:58:08