Microsoft Excel XP-2003 Level 1

Objectives
On completion of this course delegates will be able to:

Understand the concepts of spreadsheets

Create, edit and format a worksheet

Use formulas for basic calculations

Copy and move data
Preview and print worksheets
Use Page Setup to edit page margins, headers and footers

Apply automatic formatting

Insert columns and rows

Use the help feature
Course Content

Exploring Excel

Starting & Exiting Excel
Working with Excel Windows, Worksheets &
Menu Commands
Displaying & Hiding Toolbars
Using Basic Workbook Skills

Creating & Saving a New Workbook
Selecting Cells, Entering & Editing Data
Opening an Existing Workbook
Using Data Entry Shortcuts
Renaming an Existing Workbook
Working with Ranges

Selecting Adjacent & Non-Adjacent Ranges
Entering Values into a Range
Using the Auto Fill Feature
Creating Simple Formulas

Using Formulas, AutoSum Button
Using the AutoSum List
Entering & Editing Basic Functions
Inserting Functions in Formulas
Using the AutoCalculate Feature
Using Range Borders to Modify Formulas
Copying & Moving Data

Copying/Cutting & Pasting Data
Using the Paste Options Smart Tag
Using the Paste List
Using the Clipboard Task Pane
Creating an Absolute Reference
Using Undo & Redo

Printing & Previewing Worksheets

Using Page Setup
Editing Margins, Orientation, Alignment,
Headers & Footers, Printing Gridlines,
Repeating Row & Columns, Labels Scaling a
Worksheet, Page Break Preview & Setting/
Removing a Print Area
Formatting Numbers & Text

Applying Number Styles & Decimal Places
Character Formatting
Rotating, Wrapping & Shrinking Text in a Cell
Merging Cells & Changing Text Indent
Text Alignment & Borders & Fill
Formatting Cells

Changing Cell Alignment
Creating Cell Borders
Using the Fill Color Button
Using the Format Painter Button
Inserting & Deleting Selected Cells
Working with Columns & Rows

Inserting, Deleting, Adjusting,
Hiding & Unhiding Rows & Columns
Using Automatic Formatting

Using Online Help & the Office Assistant