4.9 (575 reviews)
Learning to program might seem intimidating, but with some patience and with examples in this course many users find that learning VBA makes their work easier and gives them the ability to do things in Office that they did not think were possible.
By the last day of the course, you will be able to write Excel VBA code that interacts with other Office applications such as Word, Access and Outlook.
Learn how to automate daily routine tasks within Excel
Learn best practices when writing code to streamline your VBA code
Understanding the limitations of the Macro Recorder
Learn how to write custom VBA code to create more robust automation
Learn VBA programming concepts to create dynamic, re-usable code
Learn how to write code for real world VBA projects from beginning to end
Learn to write code to automatically send information from Excel using Outlook
Develop code that writes to or merges with Microsoft Word
Learn how to use VBA to incorporate speech in your applications.
We encourage you to bring a USB to take away completed examples.
This course is structured as one day per week over three weeks to give you plenty of time to consolidate the information between sessions.
This course had been designed for the non-technical user who needs to design & create applications in Excel.
Participants must have a good understanding of Excel spreadsheets in particular working with ranges.
• Experienced Microsoft Certified Instructor with Excel development experience
• Comprehensive Training Manual
• Course exercise files ... with completed code
• Unlimited post-course online support to the level of the course
• Access to VBA Snippets newsletter
Available Excel VBA courses
Excel VBA courses are conducted one day per week over 3 weeks to allow participants to practice the content before continuing. Practice activities will be assigned at the completion of each session.
|Event||Event Date||Location||Individual Price||Register|
|Excel VBA (Mar 14,22 + 30)||14-03-2022||Live Online||$1,435.00|
|Excel VBA (May 23, 31 + Jun 8)||23-05-2022||Live Online||$1,435.00|
|Excel VBA (Aug 23, 31+ Sep 8)||23-08-2022||Live Online||$1,435.00|
|Excel VBA (Nov 21, 29 +Dec 7)||21-11-2022||Live Online||$1,435.00|