Microsoft Excel 2003 VBA Introduction

1 day

Course Overview

Your Excel skills have helped simplify business tasks like the creation of spreadsheets, graphs, charts, and formulas. You have moved your business or your organization from pencil and paper to the digital age. Now it is time to further simplify your work in the Excel environment by automating many of the repetitive tasks that are inherent to spreadsheet development.

Course Objective

Learn to use VBA to create macros for automating repetitive tasks in Excel 2003. Use Excel to make spreadsheet creation easier.

Target student

This course is for students who wish to learn how to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations.

Prerequisites

The Systematix course Microsoft Office Excel 2003: Level 2 course or equivalent knowledge or experience is recommended. Students should have knowledge of the basics of Excel like how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Course Outline

Developing Macros

  • Create a Macro with the Macro Recorder
  • Edit a Macro
  • Debug a Macro
  • Customize Toolbars, Menus, and Hotkeys

Formatting Worksheets

  • Sort Data
  • Insert Rows and Columns
  • Insert Text
  • Format Text
  • Duplicate Data
  • Generate a Report

Creating an Interactive Worksheet

  • Determine Dialog Box Type
  • Capture User Input

Working with Multiple Worksheets

  • Insert, Copy, and Delete Worksheets
  • Rename Worksheets
  • Modify the Order of Worksheets
  • Print Worksheets

Performing Calculations

  • Create User-defined Functions
  • Automate SUM Functions