Excel 2007 Foundation

Core Topics

A First Look at Excel

• Starting Excel

• Entering numbers and text

• Worksheets and Workbooks

• Creating and opening a workbook

• Saving and closing workbooks

Help

• Getting help

• Printing a Help topic

Entering & Editing Data

• Entering & editing data

• Undo & redo

• Selecting a cell or range

• Moving, copying and posting cell contents

• Autofill

• Inserting & deleting rows & columns

• Modifying column widths & row heights

• Sorting a cell range

• Using Find & replace

Manipulating Worksheets

• Switching between worksheets

• Inserting, renaming & deleting worksheets

• Moving or copying a worksheet

• Moving or copying worksheets between workbooks

• Freezing row and column titles

Formatting

• Text & number formatting

• Creating borders & shading

• Alignment and centring

• Format painter

Formulae & Functions

• Creating formulae

• Operators

• Formula error messages

• Relative & absolute cell referencing

• Common functions

• What are 'IF functions'?

• Using the IF function

Using Charts

• Inserting charts & chart types

• Editing & deleting charts

• Formatting charts

• Copying and moving charts between workbooks

Customizing Excel

• Modifying basic options

• Minimising the Ribbon

• AutoCorrect options

Print Set-up & Printing

• Page layout options

• Headers and Footers

• Printing titles on every page when printing

• Printing the Excel row and column headings

• Previewing a worksheet

• Printing options

Follow up Courses

Excel 2007 Intermediate

Excel 2007 Advanced