Visual Basic for Applications for Productivity & Finance
Learn to use Visual Basic for Applications (VBA), Excel's programming language to automate tasks with macros.
Course Overview
The Visual Basic for Applications (VBA) for Productivity & Finance course uses Excel's programing language VBA, to solve problems and improve process efficiency with macros. No prior programming experience is required.
Course Objectives
This course will provide a foundation to build basic applications to improve your productivity and automate just about any tasks with Excel macros. Your use of Excel will stretch beyond creating and organizing spreadsheets.
| Duration: | 2.0 day / 14.0 hours |
| Course level: | Intermediate |
| Course type: | Instructor-led, in-person or virtual. |
| Prerequisites: | None |
| Who should attend: | For any Excel user looking to improve their efficiency and automate everyday repetitive tasks. |
| Format: | Interactive lecture, participant discussion and hands-on practical. |
What you will learn:
- The power of VBA programming and how it can be applied to everyday tasks in Excel.
- The basics of the object model and its properties.
- The building blocks of coding: variables, looping, and decision making.
- When and how to use VBA programming with your processes, tasks, and projects.
- How to build and utilize custom Excel functions.
- Debugging tips and ways to avoid some common programming frustrations and missteps.
What you will receive:
- All the worksheets, checklists, and forms in Microsoft® Excel template format.
- Receive detailed feedback on your materials to help improve your output.
Visual Basic for Applications (VBA) for Productivity & Finance
Browse our scheduled offerings or to pre-register your spot in this course.
