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

Produce and store a worksheet incorporating simple formulae with both absolute and relative cell references.
Access and retrieve data for editing
Edit simple text to a required format and layout
Produce and format a chart from given data

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

Getting Started
Starting Excel
Entering and editing data
Saving and closing the workbook
Opening and existing workbook
Creating a new workbook
Working with multiple workbooks
Building series using AutoFill
Summing data using AutoSum
Spell checking and printing your data
Finding Files
Storing files in the Favourites folder

Formatting Your Worksheet

Sizing, inserting and deleting cells, rows and columns
Moving and copying data
Constructing formulae
Using absolute references
Using links
Basic formatting of your workbook
Additional formatting including customised number formats and conditional formats

Charting and Layout

Viewing your worksheet
Charting your data
Preparing your workbook to print
Printing your workbook with charts
Exiting Excel 97
Customising Excel's default settings

Appendix

Additional opening/saving features
Workbook properties
Creating custom lists for AutoFill
Customising the toolbars
Learning as you work using Help and the Office Assistant