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.

warning-standard-solid This course has a 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.

What You'll Learn

  • 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