Excel VBA 24-Hour Trainer (2015)
Part I: Understanding the BASICs
Lesson 2: Getting Started with Macros
Lesson 3: Introducing the Visual Basic Editor
Part II: Diving Deeper into VBA
Lesson 5: Object-Oriented Programming: An Overview
Lesson 6: Variables, Data Types, and Constants
Lesson 7: Understanding Objects and Collections
Lesson 9: Making Decisions with VBA
Part III: Beyond the Macro Recorder: Writing Your Own Code
Lesson 10: Repeating Actions with Loops
Lesson 11: Programming Formulas
Lesson 12: Working with Arrays
Lesson 13: Automating Procedures with Worksheet Events
Lesson 14: Automating Procedures with Workbook Events
Lesson 15: Handling Duplicate Items and Records
Lesson 16: Using Embedded Controls
Lesson 18: Programming PivotTables and PivotCharts
Lesson 19: User-Defined Functions
Lesson 20: Debugging Your Code
Part IV: Advanced Programming Techniques
Lesson 22: UserForm Controls and Their Functions
Lesson 26: Managing External Data
Lesson 27: Data Access with ActiveX Data Objects
Lesson 28: Impressing Your Boss (or at Least Your Friends)
Part V: Interacting with Other Office Applications
Lesson 29: Overview of Office Automation from Excel
Lesson 30: Working with Word from Excel