Excel Macros VBA Series

Acknowledgement of Completion
Online
Completion Requirement: 3 courses
Puzzle pieces with words "Analyze" "Measure "Control" and "Define"
Overview

Throughout the three levels of the Macros VBA workshop series, students focus on the use of Excel's Macro Recorder to generate VBA code. Learn macro (VBA*) code generation techniques that require little or no subsequent modification. By the third Excel Macros VBA workshop you will be able to accomplish some introductory programming exercises. Self-paced online training makes learning flexible and students can take their time to work through the material.

This series of workshops is not for Excel Beginners. Those wanting to take this training need to possess Intermediate to Advanced Excel skills.

This means students should have the following minimum excel skills:

  • They need to have created their own worksheet solutions.
  • They should have experience using a variety of Excel Features and Functions in doing so.
  • They recognize their need to automate repetitive Excel processing projects, in order to save time and eliminate human errors

PLEASE NOTE: While no prior Macro or VBA experience is needed, students need to be prepared to deal with technical matters that typical Excel users do not usually encounter, which includes the examination and modification of VBA Code generated by Excel's Macro Recorder.

To register for this training see the “Program of Studies” section and start with the first of the 3 courses and work your way through the 2nd and then the 3rd course. This training needs to be taken in sequence.

  • Ontario Secondary School Diploma (OSSD) or equivalent (Mohawk Academic Upgrading, GED) OR 19 years of age or older.

You do not need to apply to begin this program. Start by ensuring you meet the admission requirements listed above and then register for the courses listed in the Program of Studies when they are offered.  Some courses have prerequisites, so please check the Program of Studies for details. Find out how to register for a course.

Course Number Course Name Course Hours Description
INFO10246 Excel VBA1 Macros 9 Part 1/3 of Excel VBA series. Learn Excel features that increase the speed and accuracy of data input. Learn to use the Macro Recorder to create "unbreakable" Macro code that navigates a workbook and input data into cells. Use the VB* Editor to examine and modify generated VBA* code. In this first workshop you'll learn to create a Database Update application. Create an input form with buttons and user messages to control the input to and update of a sheet database. This training is for Intermediate to Advanced Excel Users who want to automate repetitive Excel processing projects. After registering you will receive additional information on how to log in. Prior to starting this course please be sure to complete the Special Excel Setup described at http://exceltrainers.com/beforevba1online/ri/
INFO10247 Excel VBA2 Macros 9 Part 2/3 of Excel VBA series. Learn how to automate Data Consolidation of files that have a "standardized (uniform) structure and content", as well as files that do not. Learn to Automate: PivotTable analysis, Data Filters, Sorts and Subtotals, as well as the Creation of Charts. Create macros for these features, and learn to dynamically recognize the database row growth and column structure changes. Also, learn to accept user inputs that control what a macro will do. And learn to "trap run-time errors" caused by unexpected user inputs. Students need to take Excel VBA1 Macros prior to starting this course, as VBA2 training builds upon concepts and skills learned in said course. Please be sure to complete the Special Excel Setup described at http://exceltrainers.com/beforevba2online/
INFO10248 Excel VBA3 Macros 9 Part 3/3 of Excel VBA series. Learn or experience a refresher in Best Practices for the creation of Worksheet Formulas, and the use of Worksheet Functions. Learn the similarities and differences between Worksheet and VBA Functions. Learn the differences between VBA Function and VBA Sub (Macro) Procedures, including their Creation, Purpose and Execution. Learn VBA code constructs that can handle multiple conditions with procedures. Examine functions from various Function Categories and learn to create User Defined Functions (UDFs) that simplify their use. Obtain a reference to VBA code Statements and Functions. Prior to starting this course you may want to access additional information described at http://exceltrainers.com/beforevba3online/
INFO10249 Excel VBA Macros Series 27 For a detailed description of this bundled series, please see what's posted for course codes INFO10246, INFO10247 and INFO10248.

Courses

Online

By taking all three courses within a single semester, over a period of three months, you can save on the overall cost of enrollment.

Questions about CE at Mohawk College? Please see our FAQ.