Microsoft Office – VBA Essentials
This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, basic VBA programming, event handling, control structures, and debugging tools.
The course is suitable for users of Office 2007, 2010, 2013, 2016 and 2019 (365) due to the minimal differences between versions. Note that this course will normally be delivered on PCs with Office 2016 installed.
Course Prerequisites
-
Navigate, edit and manage Excel workbooks
-
Format worksheets and workbooks
-
Understand the difference between absolute and relative references
-
Understand the basics of Excel formulas and functions, e.g. Sum, text functions
-
Understand the concepts of a Macro and its capabilities
Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.
Microsoft Office – VBA Essentials Key Facts |
Course Duration (days) |
2.00
|
Course Price (ex VAT) |
£1165.00
|
Course Vendor |
Microsoft
|
Recent Comments