Advanced Excel Macros & VBA Programming
Designed for advanced users of Excel who want to take their skills even further, this class goes deep into the programming side of Excel. The class Starts with recording basic and advanced macros, then gets into handwritten VBA code to make Excel do exactly what you want.
It's a great hands-on learning experience that allows any advanced user to acces Excel's powerful programming. This is a two-day class.
TOPIC 1 – Making A Macro Do Simple Tasks
- Creating a Simple Macro
- Changing Multiple Properties at Once
- Manipulating Recorded Properties
- Recording Methods in a Macro
- Trusting Macro-Enabled Workbooks
TOPIC 2 – Making A Macro Do Complex Tasks
- Opening the Report File
- Filling In Missing Labels
- Adding a Column of Dates
- Appending to the Database
- Deleting a Worksheet
TOPIC 3 – Exploring Workbooks And Worksheets
- Working with Objects
- Understanding Workbooks
- Understanding Worksheets
TOPIC 4 – Exploring Range Objects
- Referring to a Range
- Enhancing Recorded Selections
- Entering Values and Formulas into a Range
- Formatting a Range
TOPIC 5 – Exploring Data Objects
- Working with Excel Tables
- Working with PivotTable Reports
TOPIC 6 – Exploring Graphical Objects
- Working with Graphical Objects
- Working with Chart Objects
TOPIC 7 – Controlling Visual Basic
- Using Conditionals
- Creating Loops
- Managing Large Loops
TOPIC 8 – Extending Excel and Visual Basic
- Creating Custom Functions
- Handling Errors
TOPIC 9 – Launching Macros With Events
- Creating Custom Command Buttons
- Handling Worksheet and Workbook Events
TOPIC 10 – Using Dialog Box Controls On A Worksheet
- Using a Loan Payment Calculator
- Creating an Error-Resistant Loan Payment Calculator
- Retrieving a Value From a List
- Protecting the Worksheet
TOPIC 11 – Creating A Custom Form
- Creating a Form's User Interface
- Preparing a Form's Functionality
- Implementing a Form
