Sample Training for
"Excel with Macros & VBA"

IMPORTANT: To work through the training exercises that follow, please be aware of these technical requirements.

The Icons shown below are used to access each of the identified learning resources for this training.
Training Exercise Workbook
Excel Exercise Files

Start / Continue Training Videos
Extra Bonus Materials

These icons appear for the Sample Training below; and also appear in the Full Workshop Training.

"Excel with Macros & VBA"
Level 1 - Sample Training


For Level 1 Training Videos click/tap the video images below.

Level 1 Sample Training Videos: While these preliminary training videos do not get into Macros or VBA, the "data input" features covered in them are important to what is done at the end of this first workshop, when a Data Input Form is created, using Fills and Data Validation. Then macros are created to access the data input to the form, for use in updating an Excel Database sheet. 

Level 1 - Video 0

Level 1 - Video 0

Level 1 - Video 1

Level 1 - Video 1

Level 1 - Video 2

Level 1 - Video 2

Level 1 - List of Training Videos

Level 1 - Video List

These Sample Videos show the training style and type of content that can be expected through this entire workshop.

Based on this, together with the Sample Workbook material, plus all the other information available on this website, it is hoped that this degree of information will help you to feel confident to:

- Either choose to enroll by completing this Enrolment Request Form.

- Or, if you need more information, send your questions by completing this Information Request Form.

"Excel with Macros & VBA"
Level 2 - Sample Training


For Level 2 Training Videos click/tap the video images below.

Level 2 Sample Training Videos: The first sample video gives an overview of the training content for this workshop. The second video teaches how to maintain the stability of "permanent links" between files, so that changes can be made to a target file without disrupting the link to a cell within that file. The third video overviews a 7-part teaching on the consolidation of "standardized files". 

Note: Training Videos are branded with an "Excel Trainers" logo — the domain where the Learning Management System is accessed.

Level 1 - Video 0

Level 2 - Video 0

Level 1 - Video 1

Level 2 - Video 1

Level 1 - Video 2

Level 2 - Video 2

Level 1 - List of Training Videos

Level 2 - Video List

These Sample Videos show the training style and type of content that can be expected through this entire workshop.

Based on this, together with the Sample Workbook material, plus all the other information available on this website, it is hoped that this degree of information will help you to feel confident to:

- Either choose to enroll by completing this Enrolment Request Form.

- Or, if you need more information, send your questions by completing this Information Request Form.

"Excel with Macros & VBA"
Level 3 - Sample Training


For Level 1 Training Videos click/tap the video images below.

Level 3 Sample Training Videos: For many, these preliminary videos will be a "refresher" on the proper use of Cell References for the creation of formulas and use of worksheet functions. Even so, to ensure that everyone taking this training is "on the same page", these preliminary training videos are essential to the training that follows. The entire focus of what follows is the creation of Custom or User Defined Functions (UDFs) that, from a worksheet perspective, require appropriate use of Cell References. 

Note: Training Videos are branded with an "Excel Trainers" logo — the domain where the Learning Management System is accessed.

Level 1 - Video 0

Level 3 - Video 0

Level 1 - Video 1

Level 3 - Video 1

Level 1 - Video 2

Level 3 - Video 2

Level 1 - List of Training Videos

Level 3 - Video List

These Sample Videos show the training style and type of content that can be expected through this entire workshop.

Based on this, together with the Sample Workbook material, plus all the other information available on this website, it is hoped that this degree of information will help you to feel confident to:

- Either choose to enroll by completing this Enrolment Request Form.

- Or, if you need more information, send your questions by completing this Information Request Form.

Or, I have a Question!
Call 905-848-5636, or

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