SP932 - Intermediate Excel VBA

Course Description

Explore Excel VBA in more depth and learn how macros can interact with a wide variety of Excel objects. Understand how macros can be used and learn different trouble-shooting strategies to avoid problems. Master using arrays to manage multiple elements, learn to automate and manage PivotTables, and understand how to interact with Excel charts. Learn to incorporate other Office software such as Word and PowerPoint into your Excel VBA workflow. Discover how to make external connections to data and pull information into an Excel spreadsheet using VBA. Topics include creating a custom user form, handling controls, working with arrays, interacting with pivot tables/charts, using SQL commands in macros, and cleaning up data with VBA.

In this course, you will learn to: 

• Simplifying user input by creating a custom Excel UserForm 

• Understanding how arrays are a powerful tool for managing multiple, related elements and using them in several different ways 

• Automating and managing your PivotTables to help control their behavior and appearance 

• Interacting with Excel Charts through VBA to manage their appearance and connections to the source data for the chart 

• Creating connections to an external database through VBA and using SQL statements to pull data from that database into your Excel workbook using VBA 

• Incorporating Office products, such as Word and PowerPoint, into your Excel VBA workflow to simplify and automate tasks that require more than one application to complete 

• Using VBA macros to solve problems with data usability and understanding some of the potential downsides with these methods 

Applies Towards the Following Certificates

• Excel Certificate : Electives