Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Essential VBA Training for Excel - Automate Repetitive Tasks
Introduction
Introduction to the VBA Course (5:02)
Course Exercise and Solution Files
The Environment
Getting Started (6:22)
The VBA Editor (8:59)
First Coding Manipulations (7:39)
VBA as a Language
VBA Syntax, Keywords, and Comments (8:06)
Objects and VBA's Intellitext (6:04)
Variables and Method Calling Rules (8:29)
How to Define and Manage Variables (9:21)
Constant Variable Types and Variables through Intellitext (3:37)
Introducing Macros
Subroutines (4:50)
Logical Constructs: The Boolean Type (5:55)
Logical Constructs: If and Switch Statements (4:59)
Methods for Communicating to the User (8:43)
Looping: The For and Do While Loops (6:40)
Looping: Collections and the For Each Loop (4:33)
Introducing Functions
Functions (4:25)
Returning Values from Functions (4:43)
Sending Values to Functions (7:04)
Determining Limitations (5:04)
The Worksheet Function Object (9:23)
Completing Exercise 5 (7:50)
The Range Object (8:32)
Writing an Array Formula (5:21)
Common Keys to VBA
The Application Object (10:01)
The Workbook and Worksheet Objects (12:00)
Using Errors to Guide You (12:03)
The Name and Names Objects (6:25)
The PivotTable Object (6:58)
The Chart and ChartObject Objects (9:11)
The PageSetup Object and Print Ranges (12:04)
One Approach To Completing Exercise 8 (11:53)
Conclusion
Concluding Remarks (5:07)
Course Quiz and Certificate of Completion
The VBA Editor
Complete and Continue