Excel VBA Level 2

Excel VBA Level 2

Visual Basic for Application (VBA) is a programming language designed for automating task in Microsoft Office. This one-day training session focuses on the VBA as it applies to Microsoft Excel – specifically with the programming aspects of worksheets, workbooks, and SQL datasets and with the programming aspects of charts, pivot tables, and data tables. The use of VBA in Microsoft Excel will improve the user experience and productivity with the application.

Excel VBA Programming demonstrates how Excel users can customize and supercharge Excel apps using the powerful capabilities of Visual Basic. To be successful in this course, you should have proficient knowledge of Microsoft Excel.

In this course participants will learn:
     How to programmatically manipulate worksheets and workbooks
     How to consolidate and split-up worksheets and workbooks
     How to query data from an SQL database using a simple select and stored procedure
     How to programmatically create the major objects in Excel – specifically charts, Pivot Tables, and Data Lists

Course Outline

Day 1: Worksheets, Workbooks, and SQL Data Sets


At the end of this day, students will have learned how to:

     Create, delete, copy, and move worksheets
     Create, open, and close workbooks
     Consolidate and split-up data using worksheets and workbooks
     Create a connection to an SQL database
     Query data with basic SQL syntax
     Query data with store procedures

Day 2: Charts, Pivot Tables, and Data Tables


At the end of this day, students will have learned how to:

     Create charts with a chart sheet template
     Create charts programmatically
     Leverage simple coding tricks to improve pivot table use
     Create and manipulate Pivot Tables programmatically
     Create and manipulate data tables programmatically

Length of Class: 
Two Days
Instructor-led or Online: 
Instructor-Led