Excel VBA Training

Live Online & Classroom Enterprise Certification Training

Master the skills to create your own macros, so that you can bring your Excel skills to the next level, and put yourself ahead of the competition.

Looking for a private batch ?

REQUEST A CALLBACK

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Excel VBA Training about?

At the end of the training, you'll learn:

Enhance your current Excel files & automate your work with VBA
Master Excel VBA
Directly apply the Excel VBA example files included to your own work
Create simple solutions to complex problems by levering Excel functionality with Macro
Formulas & Excel core functionality can't do everything. Use VBA when you reach a limitation

What are the objectives of Excel VBA Training ?

It's a programming language that enables you to control just about everything in Excel. You'll learn how to create Macros that can be run from things like a button on a spreadsheet, the Excel Ribbon - in fact, lots of places. Learning Excel VBA will enable you to do a lot more with the software than you can via the normal spreadsheet view.

Who is Excel VBA Training for?

Business Professionals who'd like to simplify & automate work flow.
Data analysts.
You currently use Excel and like to improve your skills.

What are the prerequisites for Excel VBA Training?

Foundational Knowledge on Microsoft Excel or only know what is Microsoft Excel.

Available Training Modes

Live Online Training

18 Hours

Classroom Training

3 Days

Course Outline Expand All

Expand All

Recorded Macros

Understanding Excel Macros

Setting Macro Security

Saving a Document as Macro Enabled

Recording a Simple Macro

Running a Recorded Macro

Relative Cell References

Running Macro with Relative References

Viewing a Macro

Editing a Macro

Assigning a Macro to the Toolbar

Running a Macro from the Toolbar

Assigning a Keyboard Shortcut to a Macro

Deleting a Macro

Copying a Macro

Recorder Workshop

Preparing Data for an Application

Recording a Summation Macro

Recording Consolidations

Recording Divisional Macros

Testing Macros

Creating Objects to Run Macros

Assigning a Macro to an Object

Understanding VBA

Programming in Microsoft Excel

VBA Terminology

Understanding Objects

Viewing the Excel 2010 Object Model

Using the Immediate Window

Working with Object Collections

Setting Property Values

Working with Worksheets

Using the Object Browser

Programming with the Object Browser

The Best VBA Help Available

The VBA Editor

The VBA Editor Screen

Opening and Closing the Editor

Using the Project Explorer

Working with the Properties Window

Using the Work Area

Viewing Other Panes

Working with Toolbars

Working with a Code Module

Running code from the Editor

Setting Breakpoints in the Editor

Stepping Through Code

Procedures

Understanding Procedures

Where Procedures Live

Creating a New Sub Routine

Making Sense of IntelliSense

Using the Edit Toolbar

Commenting statements

Indenting Code

Bookmarking in Procedures

Using Variables

Understanding Variables

Creating and Using Variables

Implicit and Explicit Declarations

The Scope of Variables

Procedure Level Scoping

Module Level Scoping

Passing Variables by Reference

Passing Variables by Value

Data Types

Declaring Data types

Functions In VBA

Understanding Functions

Creating VBA Functions

Using a VBA Function in a Worksheet

Setting Function Data Types

Using Multiple Arguments

Modifying a VBA Function

Creating a Function Library

Referencing a Function Library

Importing a VBA Module

Using a Function In VBA Code

Using Excel Objects

The Application Object

The Workbook Objects

Program Testing with The Editor

Using Workbook Objects

The Worksheets Object

Using the Worksheets Object

The Range Object

Using Range Objects

Using Objects in a Procedure

Programming Techniques

The MsgBox Function

Using MsgBox

InputBox Techniques

Using the InputBox Function

Using the InputBox Method

The IF Statement

Using IF for Single Conditions

Using IF for multiple Conditions

The Select Case Statement

Using The Select Case Statement

For Loops

Looping With specified Iterations

The Do...Loop Statement

Looping With Unknown Iterations

Creating Custom Forms

About Custom Forms

Creating a Custom Form

Adding Text Boxes to a Form

Changing Text Box Control Properties

Adding Label Controls to a Form

Adding a Combo Box Control

Adding Option Buttons

Adding Command Buttons

Running a Custom Form

Automatic Startup

Programming Automatic Procedures

Running Automatic Procedures

Automatically Starting a Workbook

Error Handling

Error types

The On Error statement

Creating a Simple Error Handler

Using the Resume Statement

Using Decision Structures in Error Handlers

Using the Err object

Error Handling in Event Procedures

Defining Custom Errors

Working with Arrays

Declaring array

Array indexing (0/1)

Assigning & accessing elements

Redimensioning array

Array operations (search/sort etc)

Multi dimensional array

Charts and VBA

Understanding Chart Object Model

Working with the different parts of the chart

Creating a simple chart using VBA

Creating a dynamic chart

Specifying the source data, chart type, series, legend, title & chart axis

PivotTable and VBA

Working with PivotTable object

Understanding PivotCache

Pivotfield object

Orienting the fields

Creating a pivot chart

Events

What are Event Procedures?

On Open event

Before Close event

On Activate event

On Deactivate event

On Key event

On Time event

Addins

What is an Addin?

Creating an Addin

Using an Addin

Security

Protect/lock code for view/edit

Digital Signatures

Who is the instructor for this training?

The trainer for this Excel VBA Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree