Microsoft Excel 2003
Part
4
Course Code: AD532

This is a specialised course on the use of Macros within Microsoft Excel.  It is for experienced Excel users who want to produce professional spreadsheets using the most advanced features of the program.

Objectives
After completing the course, participants will be able to:

  • Record, edit and run personal and workbook macros

  • Use absolute and relative references in Macros

  • Create a macro toolbar and add a macro button to a worksheet

  • Display Data Prompts

  • Use a conditional statement and a control loop in a macro

  • Place a drop-down list box and a check box on a worksheet

  • Use Visual Basic to Write Macros

What you will learn
Topics covered by this course include:

Creating and Using Personal Macros

  • Recording & Running a Personal Macro

  • Displaying Macro Instructions

  • Editing a Macro

  • Using Absolute & Relative References

Creating and Using Workbook Macros

  • Recording & Running a Workbook Macro

  • Adding a Macro Button to a Worksheet

Using Visual Basic to Write Macros

  • Opening a New Module in the Visual Basic editor

  • Displaying a Data Prompt

  • Using a Conditional Statement

  • Using a Control Loop in a Macro

  • Additional Control Statements

Placing Controls on a Worksheet

  • Placing a Combo Box List and Check Box on a Worksheet / Linking a Control to Data

Creating a Macro Toolbar

  • Creating a New Toolbar

  • Adding a Button to a Toolbar

  • Assigning a Macro to a Toolbar Button

Creating a Macro Menu

  • Creating a New Menu

  • Adding an Item to a Menu / Assigning a Macro to a Menu Item

Using the Visual Basic Help System

  • Displaying Visual Basic Help information

Prerequisites
Course participants should have completed Excel 2003 Part 3 (or equivalent).

Dates and times
Please refer to your Fourth R centre for dates and times.

Copyright The Fourth R

 [Back to MS Office Training Courses]