Microsoft® Excel Macros and VBA Level 1
Open Enrollment Course Dates:
Course Length: 1 day
Prerequisites/Advanced Preparation: Excel Intermediate or equivalent knowledge
Course Level: Advanced
Course Fee: $395
Course Hours: 8:30 a.m. – 4:15 p.m.
Target Student: Simplify your work in the Excel environment by automating many of the repetitive tasks that are part of the spreadsheet development. In this course, you will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel.
This course is designed to acquaint the user with macro creation by introducing them to the macro recorder. There will be a preliminary groundwork set for proper macro blueprinting in the development process. The users will also be introduced to the Visual Basic editor window where the basic fundamentals of the programming language will be discussed. Upon nesting macro code together they will generate stored macros and discover how to run them in other files. This will evolve into a distinction made between macros and VBA programming where the users will create various Visual Basic procedures. They will explore such facets of programming as variable and constant declaration, branching commands, looping, and error trapping.
Highlights:recording and executing macros; viewing procedure code; nesting macros; fundamentals of VB language; variable and constant declaration; variable scope and lifetime; DO UNTIL looping; conditional branching commands; error trapping routines.