Excel Macros and VBA Level 2 - Data Analysis

Course Code:
APPL78386

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): WKSP78133 Excel Macros and VBA Level 1 - Data Input. Before the start of the course take the video-based training located at http://exceltrainers.com/beforevba2online/
 

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) Jul 9, 2019 - $369.45

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.

Okay