Overview and objectives

Excel 2000 is the most popular version of the spreadsheet from Microsoft, designed specifically for the networked office environment. This course is designed to give users an understanding of some of the more advanced features and functions within Excel and the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in using advanced features of Excel 2000 to manage, automate and customize workbooks. This Excel 2000 course also instructs users in Year 2000 best practice.

Who should attend?

Users with a basic understanding of Excel 2000 who want to consolidate and expand on their knowledge of the basic features in a short space of time.

Course prerequisites

A good working knowledge of Excel, plus Windows 95/98/NT/2000 is assumed, gained from the workplace or by prior attendance on an "Excel 2000 Intermediate" course.

• Custom formatting

• Working with named ranges

• Importing and exporting data

• Templates and Add-Ins

• Working with multiple workbooks

• Printing workbooks and reports

• Lookup and reference functions

• Working with Toolbars

• Using Macros

• Creating map charts