Course Prerequisites

• You have attended the QA course Introduction to VBA in Office 2016 – 2019 or have equivalent knowledge
• 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 Microsoft Office applications 2016 – 2019 (Excel, Word, Outlook and PowerPoint)
• Understand how to create Charts and PivotTables and apply filters and sorting to data sets

Target Audience

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.

A dual monitor setup is required when attending this course via the QA Attend from Anywhere delivery method.