Skip to Main Content

User-Defined Navigation:

Main Navigation:

Excel 2003 Introduction to VBA

Overview

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.

Who Should Attend

Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

At Course Completion

Upon successful completion of this course, students will be able to: - develop macros - format worksheets - create an interactive worksheet - work with multiple worksheets - perform calculations

Course Lessons

1: Developing Macros

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

2: Formatting Worksheets

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

3: Creating an Interactive Worksheet

Determine Dialog Box Type
Capture User Input

4: Working with Multiple Worksheets

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

Contact Us

  • Becky Stines, Director
    931-393-7276
    1-888-822-UTSI ext. 276
     bstines@utsi.edu
  • Betty Bright, Administrative Support
    1-888-822-UTSI ext. 277
    bbright@utsi.edu
  • Continuing Education
    The UT Space Institute
    Mail Stop 15
    411 B. H. Goethert Pkwy
    Tullahoma, Tennessee, 37388-9700
  • Fax (931) 393-7346