Loading Events

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
R3,800
2 days
19 October 2017 to 20 October 2017
8:30am - 4:30pm

Book your place

(13 places available)