Learning Outcomes
By the end of this course students will be able to:

Produce and store a Worksheet
Access and Retrieve data for editing
Edit simple data to a required format and layout
Produce and format a Chart
Incorporate simple built-in functions
Organise and maintain data
Develop a template

Method
This course is provided as hands on and includes and extensive workshop manual and data disk for use during the course.

Getting started with Excel 2000

The Excel Screen
Using the Worksheet
Moving around the Worksheet
Selecting Cells and Ranges
Closing your Worksheet

Exiting Excel 2000

Additional saving and closing options

Summing Figures

Checking your Worksheet spelling
Printing your data

Using Autofill

Additional Autofill series
Creating custom lists for Autofill

Adjusting, Moving & Copying

Adjusting the Worksheet structure
Sizing columns, cells and rows
Inserting columns, cells and rows

Constructing Formulae

Absolute and Relative Cell References
Linking Formulae

Formatting

Formatting your Worksheets
Additional Formatting options

Viewing your Worksheet

Zooming and Screen Modes
Print Preview Modes
Inserting, Removing Page Breaks

Charting and Graphs

Charting your data
Modifying Charts
Chart Options

Printing your Workbook

Setting Page options & Page Breaks
Printing your Workbook
Printing Charts

Customising Excel 2000

Altering Excel's Default Options

Help - The Office Assistant

Using Help in Excel 2000
The Office Assistant
Customising the Assistant

Using Large Worksheets

Viewing large worksheets effectively
Printing Large worksheets effectively

Working with Multiple Worksheets

Customising your Worksheet
Grouping
Entering data in Group mode

Using Functions

Excel and commonly used functions
Using the PMT Function
Using the IF Function

Auditing your Worksheets

Tracing Precedents and Dependents
Tracking down errors
Validating your data

Building Templates

Creating a Template
Using Templates
Inserting Template sheets in a workbook

Data Lists

Maintaining, sorting and filtering lists
Sub-Totaling Lists
Creating custom filters
Advanced Filtering

Customising Toolbars

Adding and Removing buttons
Resetting Built-in Toolbars
Creating and Deleting Custom Toolbars
Customising existing buttons

Productivity Tools

Copying more than just text
AutoCorrect and AutoComplete
Using Comments
Searching for and replacing data

Using Security in Excel

Cell Protection
Protecting the sheet or workbook