Microsoft Excel 2003 Introduction

Course Overview

Microsoft Excel 2003 Introduction aims to develop skills using Excel 2003 to produce and edit spreadsheet documents to an introductory level.

Audience

This course is intended for those who are required to use Excel 2003 as their spreadsheeting application.

Delivery

CD-ROM   $110 for one level, $269 for all three levels of Excel training.

Please note:  Postal delivery takes 2-3 weeks

Related Courses

• AX3509 - Microsoft Excel (Introduction - Intermediate - Advanced)
• AX3443 - Microsoft Excel (Introduction)
• AX3445 - Microsoft Excel (Intermediate)
• AX3447 - Microsoft Excel (Advanced)

Total Learning Time

1 Day

Objectives

Getting Started

• Starting Excel 2000
• Accessing Menus
• Personalised Menus
• Toolbars
• Working with Dialog Boxes
• Creating a Workbook
• Entering Information in a Worksheet
• Saving your Workbook
• Creating a Workbook Based on a Template
• Opening Multiple Workbooks
• Quick File Switching
• Workbook Properties
• Creating a Favourites List
• Finding and Deleting a Workbook
• Backward File Compatibility

View Options

• Using Different View Modes
• Arranging Workbook Windows
• Customising View Options

Creating Simple Formulas

• Mathematical Operators
• Creating a Formula
• Typing Vs Pointing
• Using the Autosum Button
• Copying Formulas
• Using Autofill to Copy Formulas
• Absolute Cell References

Working With Functions

• Date and Time
• Using the Now Functions
• Using the Today Function
• Using the Paste Function
• Statistical Functions
• The Average Function
• The Max Function
• The Min Function
• The Count Function

Formatting Cells

• Selecting Rows and Columns
• Inserting and Deleting rows and

Columns

• Row Heights and Column Widths
• Hiding and Unhiding Rows and Columns
• Formatting Cells and Numbers
• Aligning Cell Contents
• Formatting Fonts
• Applying borders to Cells
• See-Through View

Formatting the Worksheet

• Autoformatting a Worksheet
• Conditional Formatting
• Deleting Conditional Formatting

Spell Checking the Worksheet

• Using the Spell Checker
• Using Autocorrect
• Adding an Entry into Autocorrect
• Deleting Autocorrect Entries

Page Setup and Printing

• Page Set-Up in Microsoft Excel 2000
• Setting Margins
• Headers and Footers
• Working With Charts
• Creating A Chart Using The Chart Wizard
• Resizing and Moving a Chart
• Changing the Chart Data
• Formatting a Chart
• Adding Extra Data
• Rotating a 3-D Chart
• Printing a Chart
• Chreating Charts with Non-Contiguous Data
• Deleting a Chart

Customising the Toolbar

• Customising Toolbars
• Displaying and Creating Toolbars
• Changing a Button’s Appearence
• Deleting a Toolbar
• Personalised Menus and Toolbar Options

Using Help

• The Office Assistant
• Accessing The Help Contents And Index