Improve your workflow and learn how to automate tasks in this hands-on VBA training. Learn by working through real-world applications of macros and Excel programming.
Increase your daily productivity by learning VBA (Visual Basic for Applications). Create custom buttons and automate repetitive tasks. Learn how to write code to develop new macros and update existing macros to improve their functionality. Master the VBA programming language to accelerate your workflow and reduce your daily workload by several hours.
In this practical, instructor-led VBA training workshop, you will work on real-world applications of Macros and Excel programming with hands-on exercises. In addition to extensive teaching experience, our instructors provide VBA consulting work and use examples and best practices from real projects in the class.
Prerequisite:
Prior VBA programming knowledge is not required, but knowledge equivalent to our Intermediate Excel course is recommended, including VLOOKUP, Pivot Tables, and IF statements.
Curriculum
- Excel VBA and Macros Level I
- Excel VBA and Macros Level II
What You’ll Learn at a Glance
- Record and edit macros
- Write custom VBA code in the VBA editor
- Implement security measures to preserve code
- Prevent crashes and rectify errors with code troubleshooting techniques
The Excel Programming with VBA course concentrates on practical automation of tedious Excel tasks and reports. This VBA class is perfect for professionals who work in Excel regularly and need to automate repetitive functions.
Throughout the course, you'll learn
- Security
- Recording macros
- Reading and analyzing code
- Programming basic macros
- Create more complex macros
- Variables
- Looping statements
- Logic statements
- User Forms
- Error Trapping
- Troubleshooting
Learn more about Excel Programming with VBA at NYIM Training.