Home > Training > Microsoft Office 2002 (XP)

Excel 2002 (XP) Introduction

Duration
2 days

Course Objectives
This course is designed to provide delegates with a solid foundation in using Excel 2002 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 and row height
Adding and deleting rows and columns
Copying, moving and erasing cells
Using AutoFormat
Undoing mistakes
Getting help in Excel

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 functions: Average, Count, Min, Max

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

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

Advanced formulae
Error values
Relative and absolute cell references
Automatic and manual recalculation
The IF function
Checking your work

Modifying basic settings
Default folder and user name
Default column width

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

Charts
Creating charts
Pie charts, bar charts, 3-D charts
Moving, resizing and deleting charts
Modifying charts
Chart AutoFormat
Changing colours and fonts
Adding labels and titles

Sorting data
Sorting on a single column
Sorting on more than one column

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 2002.

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