This 1-day instructor-led course enables participants to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft® Office application suite. VBA can be used to perform tasks that would be difficult or impossible to do using only worksheet functions, and can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give students a good foundation for understanding, creating and using VBA in your own Excel workbooks and will learn how to use the macro recorder effectively, as well as how to write VBA code from scratch. Participants will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. Note: To ensure your success in this course participants should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells and creating pivot tables and charts. For deeper content, also review Programming and Data Wrangling with VBA and Excel (EXVBA3).
Target Audience
This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain and understand.
What You'll Learn
- Identify general components of VBA and their appropriate use in solving business solutions
- Record VBA macros to automate repetitive tasks
- Write VBA code to create VBA subroutines and functions
- Use various programming elements to solve problems through code, including variables, objects, conditional statements and loops
- Eliminate, avoid, or handle errors in VBA code and optimize its performance
- Course Number EXVBA1
- Course Length 1 day
- Course Fee $595.00
- Delivery Format vILT (Instructor Led; Virtual LIVE Online; Remote Training)
- Course Topic Business Intelligence
- Vendor Microsoft
- Technology Excel
Need a different date? This course is also offered on these dates
| Date | Course ID | Course Name | Duration | Delivery Format | Registration | |
|---|---|---|---|---|---|---|
| 04/25/2025 | EXVBA1 | VBA with Microsoft Excel | 1 day | vILT | Register |
Register for course: EXVBA1
"*" indicates required fields