Microsoft Excel VBA Training Course

Microsoft Excel VBA Training Course for Beginners

Call Now

Enroll Now

Email Us

Microsoft Excel VBA Training Course for Beginners Summary

 

Join us for a 16 hours Instructor-led Microsoft Excel VBA training course to be taught over 4 weeks, 8 sessions, 2 sessions per week, 2 hours per session.

  • All Published Ticket Prices are in US Dollars
  • The course will be taught in English language

Microsoft Excel VBA Training Course for Beginners Schedule

 

Please choose from one of the dates in the table below to begin your enrollment :

Dates Weekly Schedule (US Pacific Time)* Price Add to Cart
Dec 6 to Dec 29 Mon/Wed 5:30 PM - 7:30 PM each day $394.00 Add to cart
Dec 7 to Dec 30 Tue/Thu 7:30 AM - 9:30 AM each day $394.00 Add to cart
Jan 8 to Jan 30 Sat/Sun 7:30 AM - 9:30 AM each day $394.00 Add to cart
Jan 10 to Feb 2 Mon/Wed 5:30 PM - 7:30 PM each day $394.00 Add to cart
Jan 11 to Feb 3 Tue/Thu 7:30 AM - 9:30 AM each day $394.00 Add to cart
Feb 5 to Feb 27 Sat/Sun 7:30 AM - 9:30 AM each day $394.00 Add to cart
Feb 7 to Mar 2 Mon/Wed 5:30 PM - 7:30 PM each day $394.00 Add to cart
Feb 8 to Mar 3 Tue/Thu 7:30 AM - 9:30 AM each day $394.00 Add to cart
Mar 14 to Apr 6 Mon/Wed 6:30 PM - 8:30 PM each day $394.00 Add to cart
Mar 15 to Apr 7 Tue/Thu 8:30 AM - 10:30 AM each day $394.00 Add to cart
Mar 19 to Apr 10 Wed/Sun 8:30 AM - 10:30 AM each day $394.00 Add to cart
*click on date/time hyperlink to add your location and find local date/time for first session
Dates and Weekly Schedule (US Pacific Time)* Price
Dec 6 to Dec 29
Mon/Wed 5:30 PM - 7:30 PM each day
$394.00
Enroll
Dec 7 to Dec 30
Tue/Thu 7:30 AM - 9:30 AM each day
$394.00
Enroll
Jan 8 to Jan 30
Sat/Sun 7:30 AM - 9:30 AM each day
$394.00
Enroll
Jan 10 to Feb 2
Mon/Wed 5:30 PM - 7:30 PM each day
$394.00
Enroll
Jan 11 to Feb 3
Tue/Thu 7:30 AM - 9:30 AM each day
$394.00
Enroll
Feb 5 to Feb 27
Sat/Sun 7:30 AM - 9:30 AM each day
$394.00
Enroll
Feb 7 to Mar 2
Mon/Wed 5:30 PM - 7:30 PM each day
$394.00
Enroll
Feb 8 to Mar 3
Tue/Thu 7:30 AM - 9:30 AM each day
$394.00
Enroll
Mar 14 to Apr 6
Mon/Wed 6:30 PM - 8:30 PM each day
$394.00
Enroll
Mar 15 to Apr 7
Tue/Thu 8:30 AM - 10:30 AM each day
$394.00
Enroll
Mar 19 to Apr 10
Wed/Sun 8:30 AM - 10:30 AM each day
$394.00
Enroll
*click on date/time hyperlink to add your location and find local date/time for first session

Features and Benefits

 
  • 4 Weeks, 8 sessions, 16 hours of total Instructor-led and guided training
  • 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.

Prerequisites

 
  • Familiarity with HTML and JavaScript

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

4. Working with Objects

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

5. Understanding Collections

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

6. Working with Variables

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

7. 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

8. Creating Functions

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

9. 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

9. Working with Forms and Controls (Continued)

  • Work with the Combo Box Control
  • Work with the Frame Control
  • Work with the Option Button Controls

10. Adding Functionality to Forms

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

11. Using Pivot Tables

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

12. Controlling Forms

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

13. Understanding Debugging

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

Refund Policy

 
  • 100% refund can be applied if request is initiated 24 hours before the 1st course session.
  • If a class is rescheduled/cancelled by the organizer, registered students will be offered a credit towards any future course or a 100% refund