Microsoft Office – VBA Advanced
In this course you will learn the skills to enable you to use the Visual Basic for Applications (VBA) programming language to simplify or automate activities and tasks using the Microsoft Office 2007 – 2019 applications. The course covers examples in Excel 2007 – 2019, Access 2007 – 2019, Word 2007 – 2019 and PowerPoint 2007 – 2019.
Please Note: Microsoft Excel 2016 is used as the primary application during the course for demonstration purposes.
Delegates looking to gain enhanced skills to apply VBA to develop macros to work with Office applications. You will work with the application object models, manipulate data across applications and manage files and folders using VBA.
Have attended the QA course Introduction to VBA in Office 2007 - 2019 or have equivalent knowledge i.e.
Able to write macros which include variable declarations with appropriate scope, intrinsic functions, decision making structures and repeating code actions
Have a working knowledge of Excel 2007 - 2019, Access 2007 - 2019, Word 2007 - 2019 and PowerPoint 2007 - 2019
Understand how to create Charts, PivotTables and apply filters and sorting to data sets
Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.
|Microsoft Office – VBA Advanced Key Facts
|Course Duration (days)
|Course Price (ex VAT)