Excel 2003

Core Skills

1 Day

Learn How to

Create a basic worksheet by entering text, values, and formulas

Create formulas by using Excel’s built-in functions

Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons

Change the appearance of worksheet data by using a variety of formatting techniques

Prepare a document for printing by using the spell checking feature and a variety of printing options

Produce charts from the data

Pre-Requisites

Delegates should be familiar with working in Windows. No knowledge of Microsoft Excel 2003 is assumed.

Excel Introduction

What is Microsoft Excel?

Starting Excel

The Excel Screen

Excel Menus

Excel Toolbars

Keyboard Shortcuts

Using Help

 

Workbooks and Worksheets

The Structure of Excel Files

Opening an Existing Workbook

Saving a Workbook

Starting a New Workbook

Navigating a Workbook

Managing Worksheets

 

Entering Information

Spreadsheet Information

Formatting Cells for Specific Contents

Entering Labels

Using Numbers as Labels

Using Spellcheck

Using AutoComplete

Entering Numbers

Using Currency

Accountancy

Date and Time

Using Percentages

Using Fractions

Selecting a Range

Using Autofill

 

Entering Formulas

Basic Formulas

Order of Operations (BODMAS)

Basic Mathematical Functions

Using SUM

Using AVERAGE

Using COUNT

Using MAX

Using MIN

Using AutoSum

Referencing Other Cells in Formulas

Formatting Workbooks

Editing Cell Contents

Selecting Cells

Copying Cells

Moving Cells

The Clipboard

Inserting and Deleting Cells, Rows and Columns

Using Undo and Redo

Using Find and Replace

Cell Comments

Formatting Cells

Formatting Values

Advanced Cell Formatting

AutoFormat

Using Format Painter

Row Height and Column Width

 

Charts

Chart Types

Creating a Chart

Formatting and Editing Chart Objects

Changing the Source Data of a Chart

Charging a Charts Type

Annotating Charts

 

Sorting data

Sorting Data

Multilevel Sorting

Filtering a List With AutoFilter

 

Printing a Worksheet

Using Print Preview

Printing a Large WorkSheet

Printing a Chart

Additional Print Options