Excel Macros and VBA Level 2 - Data Analysis

Course Code:

Learn to automate repetitive use of Intermediate to Advanced Excel Data Analysis tools, including Data Consolidation, Auto and Advanced Filters, PivotTables, Sort and Subtotals, as well as Chart Creation. This training builds upon the Best Practices learned in the Level 1 course and adds to them, with Best Practices for the processing of multiple files, including how to best open files and transfer data between them.

You'll learn to use Special VBA Code Tools, alongside Macro Recorder generated code. These tools handle processing which generated macro code cannot. You'll be able to use these tools for your on-the-job Excel automation projects. Also, learn to turn otherwise problematic run-time errors into "user friendly" messages.

Note: Students will need to have Windows Excel 2007 or higher.

Prerequisite(s): APPL78385 Excel Macros and VBA Level 1 - Data Input. 

View Course Outline

For additional information please click on the “ + ” beside your class selection

Day(s) / Time(s) Campus Start Date Sessions Price Select
- Online (Sheridan) Sep 17, 2019 - $378.58
- Online (Sheridan) Oct 15, 2019 - $378.58
- Online (Sheridan) Nov 12, 2019 - $378.58
- Online (Sheridan) Jan 14, 2020 - $378.58
- Online (Sheridan) Feb 11, 2020 - $378.58
- Online (Sheridan) Mar 10, 2020 - $378.58

Your item has been successfully added to your cart. Proceed to cart or continue shopping.

Your cart will expire 24 hours after creation.

Proceed to Cart

We're sorry, something went wrong. Please try again.