"Excel with Macros & VBA" Workshops

These online workshops are ideally suited to Excel users who do not want to become a VBA Programmer, but want to automate their repetitive Excel projects, by simply adding some additional non-programmer methods to their Excel skillset.


* Levels 1 & 2 are Essential; Level 3 is Recommended.
In addition to this Workshop Information, you can also "Test Drive the Training" (below).
Macros & VBA - Level 1
Data Input & Navigation

This workshop lays foundational skills and concepts for use of Excel's Macro Recorder. You'll learn the Best Practices that I've learned, to generate VBA code that automates your work, that needs very little if any code modification. 

To achieve this goal you'll Learn to:
- Create Data Validation lists that automatically detect new data validation values added to their list.
- Understand Absolute and Relative Cell Addressing, and how to best use which method when generating VBA code.
- Generate "unbreakable" VBA code that continues to execute, without error, should an end user insert rows or columns into its target worksheet. 
- Identify when generated code is "breakable" and needs fixing, and learn to make the needed modifications.
- Create a series of macros with Buttons and Message Boxes, that enable input to and update of an Excel database.

Macros & VBA - Level 2
Data Analysis & Reporting

This workshop builds upon the Best Practice Recording skills learned in Level 1. And you'll also learn to use some VBA code snippets and tools, for the execution of VBA processing that is  otherwise not possible via Macro Recorder generated code, including:
- Loops that can run appropriately modified generated code as many times as needed, for example, based on how many files need to be processed.
- Detection of VBA run-time errors to display user-friendly messages that  keep your macro running smoothly.
- How best to organize placement of files to be opened during a macro, so that your macros continue to run if there is a change in the path to the files.

Through all of this you will automate repetitive tasks used to do Data Analysis and Reporting, including: Consolidations, Filters, PivotTables, Sorts and Subtotals, as well as Charts. 

Macros & VBA - Level 3
Formulas & Functions

If you have worksheets that currently use very complex formulas that are next to impossible to understand and are even more difficult to maintain, then this Level 3 Workshop is for you. 

This training transitions from the use of Excel's Macro Recorder, to 100% VBA coding. But, with the familiarity gained during Levels 1 and 2 code review and modification, students are now typically ready to handle this beginner level of VBA coding and programming.

You'll learn to create Custom Worksheet Functions, also called User Defined Functions (UDFs), to not only replace your very complex formulas, but you'll also learn how to simplify use of complex Built-in Functions. In this process you will see that UDF coding is  much easier to understand, and to maintain than what you're currently needing to do, with your use of very complex worksheet formulas. 

For a Zip file that contains All of the PDFs accessible via the above "Learn More" buttons - Click/tap here.

Frequently Asked Questions

What is a Macro? What is VBA?
watch this video.

Self-Paced Video Training Benefits?
watch this video.

Student Evaluations? Who Should Enroll?
watch this video

How does Non-Programmer Training  work?
watch this video.

How is 100-400% Return On Investment possible?

Want to Test Drive the Training? 

Sample Training includes access to:

- A Sample Workbook for each workshop.
- Exercise Files used in the sample videos.
- 3 of each workshop's 21 training videos.
- A Sample of workshop Bonus Materials. 

Sample Training is for all three workshops:

- Level 1: Data Input & Navigation.
- Level 2: Data Analysis & Reporting.
- Level 3: Formulas & Functions.

For a PDF of this Training SCHEDULE and PRICING - Click/tap here

To Receive Special Tuition Pricing - Sign-up here

Dennis Plum is Your Trainer

Dennis has more than 40 years experience as an IT Professional, having worked as a Systems Analyst and Software Developer, as well as a Microsoft Certified Trainer. His LinkedIn profile can be seen here.  

He now helps Microsoft Excel users automate their repetitive projects, to greatly reduce time taken for this sort of work, while significantly increasing the stability of project outputs, which are otherwise prone to human error, due to the labor intensive nature of repetitive projects. 

Based on typical time savings that can be experienced, through automation of even a single repetitive project, a 100-to-400% Return On Investment in this training is a reasonable expectation.

Dennis started creating Macros in 2000, and in 2007 started to develop this series of three workshops, which he launched in 2008. This self-paced training has been designed for Excel users not wanting to become a VBA programmer.

In 2014, the 3-Day live training series was converted to video, and was initially used within a classroom. Then in 2016 it was moved to an online virtual classroom environment. Each workshop has an Introductory video, followed by 20 training videos, with an overall runtime of about 8 hours each.

To-date more than 3,000 professionals have been helped by this training, with over 94% saying that it has met their expectations and that they would recommend the training to others.

I'm Ready* to ENROLL!

* If you received an email with a Special Enrolment Discount, use the Response Form Link in that Email to receive that Special Pricing. 

Send me Special Tuition Pricing
or I have a Question.

Before the Fall of 2021, this training was offered by organizations like those below (the colleges offered it from 2008 and 2011). But now, this site is the exclusive outlet for this training within Canada. And you the consumer, can now reap the benefits.* 

* To understand how "Direct to Public" sales benefits you the consumer, view this PDF or watch this video.

Also, this Advanced "VBA Pro" Training page describes what is mentioned at the end of this PDF/video.

Copyright © Excel Smart - A "Dennis Plum & Associates" business.