Excel VBA Level 2

Overview: 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

  • Create, delete, copy and move worksheets
  • Create, open and closr 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

  • 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