Microsoft Excel 2000 - Day 4 (Macros)

---

The purpose of the intermediate course is to familiarise users with further features and functions of this package.  This will be done by using a series of hands-on exercises.  It is assumed that the delegates have attended the Day 1, 2 and 3  courses, or, have knowledge to the Day 3 course level.

Level of the course: Fourth
Duration:1 day
Hours: 9.30am-4.30pm

A Certificate will be issued to each delegate and will contribute to units of the appropriate NVQ.

Macros Starting the recorder
Recording a macro
Examining the procedure
Running the procedure
Attaching procedures to buttons, menus and objects
Getting data with data entry box
Displaying a message
Extended macro exercise
Using relative addressing in macros
Multiple worksheets
Renaming worksheets
Selecting multiple worksheets
Linking worksheets
Linking workbooks
Conditional Formatting
Conditional sum
Customising the environment
Setting worksheet defaults
Removing gridlines
Displaying formulas
Controlling how excel starts
Change the default font
Change number of sheets
Creating custom toolbars
To add a button to the standard toolbar
To change the width of a pull-down list
Creating your own toolbar
To delete a toolbar

As with all our training courses, Harlow ITeC will willingly tailor this course to provide added emphasis to your particular needs.

Issue 6/9/01
Course Code Excel2000D4