Excel VBA 24-Hour Trainer (2015)

Excel VBA 24-Hour Trainer (2015)

Part I: Understanding the BASICs

Lesson 1: Introducing VBA

Lesson 2: Getting Started with Macros

Lesson 3: Introducing the Visual Basic Editor

Lesson 4: Working in the VBE

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 8: Working with Ranges

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 17: Programming Charts

Lesson 18: Programming PivotTables and PivotCharts

Lesson 19: User-Defined Functions

Lesson 20: Debugging Your Code

Part IV: Advanced Programming Techniques

Lesson 21: Creating UserForms

Lesson 22: UserForm Controls and Their Functions

Lesson 23: Advanced UserForms

Lesson 24: Class Modules

Lesson 25: Add-Ins

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