1 - Introduction to Macros
Recording MacrosAbsolute and RelativeHow to Run a Macro
2 - Basics of Code Writing
The VBA Environment (the “VBE” window) Essential Tips, Tricks, ShortcutsUnderstanding VBA and Best Practice
3 - Crucial VBA Objects and Structures
Variables and Data TypesConditionals (If, Select Case)Loops (For, Do)
4 - Interaction
Interact with Data, Sheets, the Excel Application Interact with User (Message Box, Input Box)
5 - Errors
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.