Excel: VBA (2 Days)
- This event has passed.
In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of the spreadsheet development. In this course, you will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel.
Who is this course for?
Advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).
Pre-requisites
Knowledge of Microsoft Office Excel, including how to create, edit, format, and print worksheets that contain charts, and sorted and filtered data. To ensure your success, we recommend the following courses, or equivalent knowledge in Microsoft Office Excel Basic, Microsoft Office Excel Intermediate and Microsoft Office Excel Advanced.
Objectives
Upon successful completion of this course, students will be able to:
- Create, edit, and debug a macro.
- Understand programming basics.
- Create an interactive worksheet.
- Work with multiple worksheets.
Course contents
Unit 1: Visual Basic Editor
- Topic A: Visual Basic for Applications
- Topic B: Object programming
- Topic C: The Object Browser
Unit 2: Programming basics
- Topic A: Data basics
- Topic B: Scope of variables
- Topic C: Scope of procedures
Unit 3: Control structures
- Topic A: Decision structures
- Topic B: Loop structures
Unit 4: Custom dialog boxes
- Topic A: User forms
- Topic B: Events
Unit 5: Debugging and error handling
- Topic A: Errors
- Topic B: Debugging
- Topic C: Error handling