Course Outline

MS Excel 2003

This is a typical 1 day course split up into 5-10 minute lessons so you can follow the outline in sequence or jump to the topic you want to learn about. Typically, a course outline will contain on average 35 Bite Size lessons. Remember to practice your new found skills. This will help to reinforce the learning and retain your skills.

Getting Started
Lesson not Started  Identifying the Different Parts of the Screen
Lesson not Started  Creating a new Workbook
Lesson not Started  Understanding Cell References
Lesson not Started  Entering Text & Numbers
Lesson not Started  Saving a Workbook
Lesson not Started  Selecting Ranges
Lesson not Started  Moving Around

Formatting
Lesson not Started  Formatting Cells
Lesson not Started  Inserting Rows
Lesson not Started  Inserting Columns
Lesson not Started  Inserting Worksheets
Lesson not Started  Deleting Worksheets
Lesson not Started  Formatting Numbers
Lesson not Started  Formatting across Worksheets
Lesson not Started  Naming & Renaming Worksheets
Lesson not Started  Deleting Rows
Lesson not Started  Deleting Columns
Lesson not Started  Changing Row Heights
Lesson not Started  Changing Column Widths
Lesson not Started  Merge & Centre
Lesson not Started  Sorting

Basic Functions
Lesson not Started  Order of Calculation
Lesson not Started  Basic Formulae
Lesson not Started  Viewing Formulae
Lesson not Started  Auto Sum
Lesson not Started  Quick Add

Working with Data
Lesson not Started  Printing a Worksheet
Lesson not Started  Using Page Break Preview
Lesson not Started  Clearing & Deleting Cell Contents
Lesson not Started  Auto Fill Feature
Lesson not Started  Inserting Comments
Lesson not Started  Transposing Data
Lesson not Started  Go To
Lesson not Started  Freezing Rows and Columns