Excel Part 4

Excel Part 4 - Macros
Course Code: AD308 or AD313

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
Course participants will learn how to:

Record, edit and run personal and workbook macros

Use absolute and relative references

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

Insert a macro module into a workbook

Use a conditional statement and a control loop in a macro

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

Work with dialog sheets and boxes

Create macro menus

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

Inserting a Macro Module

Displaying a Data Prompt

Using a Conditional Statement

Using a Control Loop in a Macro

Placing Controls on a Worksheet

Placing a Drop-Down List and Check Box

Linking a Control

Placing Controls in a Dialog Box

Inserting a Dialog Sheet

Creating a Custom Dialog Box

Writing a Macro to Display a Custom Dialog Box

Creating a Macro Toolbar (97 only)

Creating a New Toolbar

Adding a Button to a Toolbar

Assigning a Macro to a Toolbar Button

Creating Custom Macro Menus

Creating a Workbook Macro Menu

Creating a Personal Macro Menu

Using the Visual Basic Help System

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

Dates and times
Courses are available either in the morning or the evening. Contact the relevant training centre for further details and enrolment information.

Š Copyright The Fourth R^Ž

[Back to MS Office Training Courses]