Microsoft Office Excel 2010 Visual Basic for Applications (VBA)

Course details

In this course, students will learn how to simplify their work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.

What will I learn?

Lesson 1: Some Essential Background

• Excel 2010: Where It Came From
• Excel in a Nutshell.
• Formula Tricks and Techniques.
• Understanding Excel Files

Lesson 2: Excel Application Development

• What Is a Spreadsheet Application?
• Essentials of Spreadsheet Application Development

Lesson 3: Understanding Visual Basic for Applications

• Introducing Visual Basic for Applications
• VBA Programming Fundamentals
• Working with VBA Sub Procedures
• Creating Function Procedures
• VBA Programming Examples and Techniques

Lesson 4: Working with UserForms

• Custom Dialog Box Alternatives
• Introducing UserForms
• UserForm Examples
• Advanced UserForm Techniques

Lesson 5: Advanced Programming Techniques

• Developing Excel Utilities with VBA
• Working with Pivot Tables
• Working with Charts
• Understanding Excel’s Events
• Interacting with Other Applications
• Creating and Using Add-Ins

Lesson 6: Developing Applications

• Working with the Ribbon
• Working with Shortcut Menus
• Providing Help for Your Applications
• Developing User-Oriented Applications

Lesson 7: Other Topics

• Compatibility Issues
• Manipulating Files with VBA
• Manipulating Visual Basic Components
• Understanding Class Modules Working with Colors
• Frequently Asked Questions about Excel Programming

Requirements

Prospective students will require intermediate skills in Microsoft Excel 2010. It is recommended that students complete Excel 2010 Level 3 before sitting for this program.