Microsoft Excel VBA Advanced
Course
In Birmingham, London-City and Reading
Description
-
Type
Course
-
Location
This intensive, hands-on one-day course has been designed to build on the foundation created in the VBA Introduction course, to increase their capability to automate and enhance their Excel spreadsheets by the use of advanced tools and concepts. This course covers 2007, 2010, 2013 and 2016 versions TARGET AUDIENCE This is a course which naturally follows on from the Introduction course. Delegates must either have attended the Introduction course or be fully conversant with all its subject matter. Maximum class size for Microsoft Excel courses is 6 delegates, which ensures that attendees get adequate time for personal attention from the instructor. ABOUT MICROSOFT VBA VBA stands for Visual Basic for Applications and is a programming language developed by Microsoft. Although VBA is derived from the programming language Visual Basic, it is normally used within a host application (e.g. Excel, Access, etc.) not as a standalone language
Facilities
Location
Start date
Start date
Start date
Start date
Reviews
Subjects
- MS Excel
- Microsoft excel training
- Programming
- Visual Basic
- Microsoft Excel
- Visual Basic training
- Excel
Course programme
MODULE 1: Advanced Procedures
Learning outcomes:
Explore the more advanced options of sub and function procedures to create more flexible programs
Topics covered:
- Calling Procedures
- Passing Values to Procedures
MODULE 2: Advanced Variables
Learning outcomes:
Introduce advanced variable types to store data arrays and simplify the control of objects
Topics covered:
- Understanding Variable Scope
- Understanding Object Variables
- Creating Array Variables
- Creating Dynamic Array Variables
MODULE 3: Interacting with Office Applications
Learning outcomes:
Gain an introduction into the use of VBA to control other office applications to create letters and presentations
Topics covered:
- Setting References to other Applications
- Setting References using Late Binding
- Create a PowerPoint Presentation
- Create a Letter in Word
MODULE 4: Debugging and Error Traps
Learning outcomes:
Using VBA's debugging tools to find and correct errors in code, react to un-foreseen problems
Topics covered:
- Review of Error Types
- Debugging tools
- Setting Error Traps
MODULE 5: Creating Custom User Forms
Learning outcomes:
Use the VBA editor to create custom forms and controls, to gather and validate information from the user
Topics covered:
- Creating a Custom Form
- Adding Form Controls
- Creating Event Procedures
MODULE 6: Workbook and Worksheet Events
Learning outcomes:
Explore the use of Workbook and Worksheet events to react to the users actions and help control your application
Topics covered:
- Create Workbook Events
- Create WorkSheet Events
Microsoft Excel VBA Advanced