VIEW UPCOMING MICROSOFT EXCEL VBA IN-PERSON TRAINING CLASSES

VIEW UPCOMING INSTRUCTOR-LED LIVE ONLINE MICROSOFT EXCEL VBA ZOOM CLASSES

16 Hours Microsoft Excel VBA training is a 4 weeks long Instructor-led and guided training with Practical Hands-On Lab exercises to be taught over 16 hours, 2 sessions per week, 2 hours per session.

The medium of instruction is English.
All Published Ticket Prices are in US Dollars.

16 Hours Microsoft Excel VBA Training Course Weekly Schedule

June 8, 2021 - July 1, 2021 US Pacific time
4 Weeks | 2 Hours on Tuesdays, 2 Hours on Thursdays every week US Pacific time
8:30 AM - 10:30 AM US Pacific time each of those days
Please click here to add your city name and check your local date and time for the first session to be held on June 8, 2021 at 8.30 AM US Pacific Time.

Features and Benefits

4 weeks, 8 sessions, 16 hours of total Instructor-led and guided training
Training material, instructor handouts and access to useful resources on the cloud provided
Practical Hands-on Lab exercises provided
Actual code and scripts provided
Real-life Scenarios

What you will learn?

VBA (Visual Basic for Applications) is a programming interface for Excel. With VBA you will be able to automate tasks and even control other Microsoft Office applications such as MS Access and MS PowerPoint.

Who should attend

Students who want to learn how to automate repetitive, manual, redundant tasks,develop self-running, models and spreadsheets. Students should have working knowledge of Excel.

Course Outline

1. Learn about Macros

How to record a Simple Macro
How to record a Macro
How to run a Macro

2. Understanding VB Editor

Use the Menu Bar
Use the Standard Toolbar
Use the Project Explorer
Use the Properties Window
Understand the Code Window
Understand Code Window Options
Edit Code

3. Getting Help

Use .CHM or .HLP Files
Close the Visual Basic Editor

3. Working with Objects

Understand the Object Browser
Understand Objects
Understand the Objects Hierarchy
Reference Objects

4. Understanding Collections

Use the Editing Features
Use the Immediate Window
Use the Auto List
Use Auto Quick Info

5. Working with Variables

Understand Variables
Declare Variables
Understand Data Types
Store Values in Variables
Store Objects in Variables

6. Creating Procedures and Functions

Understanding Procedures
How to use the Macro Recorder to Create Sub Procedures
How to call Procedures from Procedures
How to use Intrinsic Functions
How to use Message Boxes
How to use Input Boxes

7. Creating Functions

Pass Arguments to a Function
Work with Conditional Statements
Understand Conditional Statements
Work with Decision Structures
Work with Loop Structures

8. Working with Forms and Controls

Understand UserForms
Use the Toolbox
Work with UserForm Properties
Events and Methods
Use the Properties Window
Understand Controls
Work with the Label Control
Work with the Text Box Control
Work with the Command Button Control
Work with the Combo Box Control
Work with the Frame Control
Work with the Option Button Controls

9. Adding Functionality to Forms

Work with Control Appearance
Set the Tab Order
Populate a Control
Add Code to Controls
Launch Forms from Procedures

10. Using Pivot Tables

Understand Pivot Tables
Create Pivot Tables
Pivot Table Arguments
Add Fields to Pivot Tables

11. Controlling Forms

Control Pivot Tables from a Form
Control a Form from a Custom Toolbar

12. Understanding Debugging

Understand Errors
Debug Code
Debug Tools
Use the Locals Window
Use the Watch Window
Use Breakpoints

16 Hours Excel VBA Training Course for Beginners in Sherbrooke

Follow this organizer to stay informed on future events

Events you might like

Stakeholder Management 1 Day Training in SherbrookeStakeholder Management 1 Day Training in Sherbrooke

Absence Management 1 Day Training in SherbrookeAbsence Management 1 Day Training in Sherbrooke

Stakeholder Management 1 Day Training in Sherbrooke

Absence Management 1 Day Training in Sherbrooke