Excel 2003

Introduction (E355)

an eWord company

 

Microsoft Office courses are conducted using 2003, however these courses are suitable for users of versions 97, 2000 and XP/2002.

 

 

General Course Information

In this 2 day program, you will gain the knowledge and skills to allow you, by means of realistic business scenarios, to create workbooks incorporating formulas, functions and graphs..

 

They will also learn how format your workbooks for professional presentation and easy-to-follow printouts.

 

You will learn to

Ø  Fully utilise the interface

Ø  Navigate efficiently

Ø  Format and edit cells

Ø  Format number displays

Ø  Write formulas

Ø  Use Excel’s built-in Functions

Ø  Create and format graphs

Ø  Configure page layout and printing options

 

What skills you need

The ability to work in the Windows environment and use a mouse.

 

Electus training

Electus is a South Australian company with 20 years of experience in training.  Trainers and facilitators at Electus are chosen for their expertise, practical and broad experience in their field and a relaxed and friendly manner.

 

Training includes

Each participant receives a training reference manual/workbook and supplementary training materials. 

Refreshments and lunch are provided.

 

 

Duration

2 days

9:00am-4:15pm

 

 

Who needs to come

Anyone who would like to learn how to create worksheets to tabulate & graph numeric data and automate calculations.

 

Nationally Recognised Qualification

You can choose to have this course assessed towards a unit of competency for a nationally recognised qualification.

 

Regular venue

37 Angas Street

Adelaide SA

(near Victoria Square)

 

 

How to book

Contact Electus by
phone: (08) 8221 5517
fax: (08) 8221 5518
email: mail@electus.com.au

 

 

Course dates

Visit www.electus.com.au for the latest course schedule or ring us on (08) 8221 5517.

 

 

 

 

 

Electus – Now offering 44 nationally recognised qualifications                                                          37 Angas Street, Adelaide SA 5000

                                                                                                                                                                                        Telephone: 08 8221 5517

                                                                                                                                                                                          Facsimile: 08 8221 5518

                                                                                                                                                                                 Email: mail@electus.com.au

                                                                                                                                                                                              www.electus.com.au

 

Excel 2003 Introduction

 

 

 

Course Content

Exploring Excel

·         Using the Interface

·         Working with worksheets

·         Displaying/Hiding toolbars

·         Changing menu and toolbar options

·         Using the Task Pane

Using Basic Workbook Skills

·         Selecting cells

·         Entering text and numbers

·         Entering formulas

·         Editing columns & rows

·         Using the AutoSum function

·         Saving a workbook

·         Opening existing workbooks

·         Using data entry shortcuts

·         Editing cell entries

·         Deleting/clearing cell entries

Navigating the Workbook

·         Selecting cells and ranges

·         Using the GoTo command

·         Using multiple worksheets

·         Navigating between worksheets

Basic Formatting

·         Formatting cell text

·         Changing font attributes

·         Wrapping Text

·         Changing text alignment

·         Using the Borders button

·         Drawing cell borders

·         Renaming/colouring worksheet tabs

Creating Simple Formulas

·         Entering formulas

·         Using Functions

·         Using the AutoSum List

·         Entering basic Functions

·         Modifying formulas

·         Checking Errors

·         Using Autocalculate

·         Creating an absolute reference

 

Smart Data Entry

·         Using Ranges

·         Entering values into a range

·         Using the AutoFill feature

·         Undo/Redo

·         Using drag-and-drop editing

·         Copying/moving data

·         Using the Paste Options data

·         Freezing panes

·         Spell checking

·         Finding & replacing data

Formatting Numbers

·         Applying Currency and Percent formats

·         Changing decimal places

·         Using the comma style

·         Date and Time formats

Building Worksheets

·         Inserting columns & rows

·         Deleting columns & rows

·         Adjusting columns automatically

·         Inserting worksheets

·         Moving worksheets

·         Deleting worksheets

Using Page Setup

·         Setting Margin & Centering

·         Changing the page orientation

·         Changing print gridlines

·         Repeating row and column labels

·         Adding Headers & Footers

·         Using Page Break preview

·         Removing page breaks

Printing

·         Setting/removing a print area

·         Previewing a worksheet

·         Printing options

Working with Comments

·         Creating & viewing comments

·         Using the reviewing toolbar

·         Printing comments

Using other Functions

·         Using Date Functions

·         Using Logical Functions

·         Using Statistical Functions

·         Using Maths Functions

More Formatting

·         Using Colour fills

·         Merging & Centering

·         Splitting cells

·         Copying formatting

·         Changing vertical alignment

·         Using AutoFormatting

·         Extending list formats

Using Drawing Objects

·         Drawing Enclosed Objects

·         Drawing Lines

·         Selecting & Moving objects

·         Adding text to an object

·         Applying formatting

·         Inserting graphics

Creating Charts

·         Instant Charts

·         Using the Chart Wizard

·         Moving/Resizing Charts

·         Editing chart elements

·         Changing the data source

·         Changing the chart location

·         Printing the chart

Managing Files

·         Changing workbook properties

·         Using the Search task panes

·         Selecting File Views

·         Sorting Excel files

·         Using the Document Recovery Pane

Using the Help System

·         Using the Help Task Pane

·         Using Type a Question for help

·         Using the Office Assistant

 

 

Electus – Now offering 44 nationally recognised qualifications                                                          37 Angas Street, Adelaide SA 5000

                                                                                                                                                                                        Telephone: 08 8221 5517

                                                                                                                                                                                          Facsimile: 08 8221 5518

                                                                                                                                                                                 Email: mail@electus.com.au

                                                                                                                                                                                              www.electus.com.au