How much does VBA with Microsoft Excel cost?

$655 per seat. That covers courseware and lab access. Exam vouchers are quoted separately. Volume pricing is available for teams, and a private cohort is usually cheaper per seat past about four people.

How long is VBA with Microsoft Excel?

1 day of instructor-led training, delivered live online. Classes run during business hours in the timezone shown on each date.

When is the next VBA with Microsoft Excel class?

The next scheduled date is Oct 21-22. There is 1 upcoming date in total, 1 of which is guaranteed to run regardless of enrollment.

Is VBA with Microsoft Excel delivered online?

Yes. It runs live online with an instructor, not as a recording, so you can ask questions as you go. It can also be delivered privately at your site.

Can a government agency buy VBA with Microsoft Excel?

Yes. Purchase orders and government purchase cards are both accepted at checkout, and quotes can be formatted for a solicitation response. Terms are net 30 on invoiced orders.

What happens if I need to cancel VBA with Microsoft Excel?

Course fees are fully refundable with written notice at least ten business days before the class. Inside that window the fee is forfeited, though one free retake is available within six months of the class date.

VBA with Microsoft Excel | 1-day class

Upcoming dates

All times shown in the class's own timezone. 1 of 1 are guaranteed to run, meaning they go ahead regardless of enrollment.

Dates	Starts	Where	Status	Seat	Book
Oct 21-22	9:00 AM to 5:00 PM EDT	Live virtual	GUARANTEED	$655

About this class

We have 1 scheduled date of VBA with Microsoft Excel, starting Oct 21-22. It is guaranteed to run regardless of enrollment. Seats are $655 each over 1 day, courseware included. Book online with a card, or send a purchase order and we will invoice on net 30 terms.

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA’s capabilities and to optimize and debug your code.

What you'll be able to do

Identify general components of VBA and their appropriate use in solving business solutions.
Record VBA macros to automate repetitive tasks.
Write VBA code to create VBA subroutines and functions.
Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops.
Eliminate, avoid, or handle errors in VBA code, and optimize its performance.

Course outline

1. Using VBA to Solve Business Problems

Use Macros to Automate Tasks in Excel
Identify Components of Macro-Enabled Workbooks
Configure the Excel VBA Environment

2. Recording a Macro

Use the Macro Recorder to Create a VBA Macro
Record a Macro with Relative Addressing
Delete Macros and Modules
Identify Strategies for Using the Macro Recorder

3. Writing VBA Code Directly

Write VBA Code
Discover Objects You Can Use
Create a Custom Function

4. Solving Problems through Code

Make Decisions in Code
Work with Variables
Perform Repetitive Tasks

5. Improving Your VBA Code

Debug VBA Errors
Deal with Errors
Improve Macro Performance

6. Controlling How and When Macros Run

Prompt the User for Information
Configure Macros to Run Automatically

Before you attend

To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3.

Who this is for

This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.