Microsoft Excel 2003 Introduction

Target Audience

This course is for delegates who desire to gain the skills necessary to create, edit, format, and print basic Excel 2003 workbooks.

Prerequisites

Delegates must have a working knowledge of a Microsoft Windows operating system and have keyboard and mouse skills.

Introduction to Microsoft Excel 2003

• What Is Excel?

• Excel File Types

• Excel Environment

• Toolbars

• Office Help

Workbooks and Worksheets In Excel 2003

• Creating And Opening Workbooks

• Working With Workbooks

• Working With Worksheets

• Working With Cells

• Navigating Within A Worksheet

• Navigating The Workbook

Spreadsheet Data In Excel 2003

• Entering Data

• Using Time Saving Features

• Checking The Spelling

Formatting and Customising Data In Excel 2003

• Selecting Items In Excel

• Formatting Text

• Formatting Numbers

• Manipulating Data

• Formatting Columns And Rows

• Formatting With Colours And Patterns

• Adding And Editing Borders

• Using Autoformat

Editing Spreadsheets In Excel 2003

• Cutting, Copying, And Pasting

• Inserting And Deleting

• Using Find And Replace

• Using Undo And Redo

Formulas and Functions In Excel 2003

• Entering Formulas

• Entering Functions

• Using Named Cells And Ranges In Formulas

Printing In Excel 2003

• Using Page Setup

• Printing a Spreadsheet

Drawing And Picture Objects In Excel 2003

• Drawing Toolbar

• Working With Autoshapes

• Creating Text Boxes

• Adding Pictures

• Layering Objects

• Grouping And Ungrouping Objects