Home > Training > Microsoft Office 2003

Excel 2003 Introduction

Duration
2 days (1 day if fast track)

Course Objectives
This course is designed to provide delegates with a solid foundation in using Excel 2003 to produce professionally presented spreadsheets, containing formulae to link information. It is a hands-on course containing varied and relevant exercises for delegates to practise and reinforce the techniques learnt.

Outline
Excel Basics
The Excel environment
Entering text, numbers and dates
The formula bar
AutoComplete
Moving around a worksheet
Saving, opening and closing workbooks
The formatting toolbar
Selecting cells, rows and columns
Adjusting the column width
Adding and deleting rows and columns
Copying, moving and erasing cells
Using AutoFormat
Undoing mistakes

Formulae
Cell referencing and ranges
Writing formulae
Order of operations used by Excel
Copying formulae

Fast Data Entry Techniques
Filling adjacent cells using the fill handle
Incrementing a series of numbers and dates
Creating a custom AutoFill list

Functions
The Sum function
Using the AutoSum button
Other commonly used functions

Formatting Data
Font formatting
Cell alignment
Borders, patterns and colours
Number formatting
Using styles

Printing
The Print dialog box
Inserting and removing page breaks
Setting margins
Inserting headers and footers
Setting print titles

Advanced Formulae
Relative cell references
Absolute cell references
Automatic and manual recalculation

Working in Workbooks
Multiple sheets
Naming worksheets
Creating formulae across worksheets
Multiple windows
Splitting windows
Freezing panes

Charts
Creating charts
- pie charts, bar charts, 3D charts etc
Moving, resizing and deleting charts
Modifying charts
- chart AutoFormat
- changing colours and fonts
- adding labels and titles

Introduction to Excel Databases
Creating an Excel database (list)
Using data forms
Adding, editing and deleting records
Finding records
Sorting lists
Filtering information

Assumed Knowledge
Delegates attending this course should have familiarity with PCs and experience of using Windows. It is also beneficial, but not essential, to have used Word 2003.

Course Times
10:00am to 5:00pm

Comprehensive course manual included.
Refreshments and lunch are provided on all courses at the Information Horizons Training Centre.

Back to the top