Excel 2003

Intermediate  (E356)

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 learn advanced editing and formatting and expand your working knowledge of formulas and graphs.  You will also explore the powerful database tools within Excel.

 

You will learn to

Ø  How to automate data entry

Ø  Use a wider range of functions and formulas including conditional statements

Ø  Set up complex formatting

Ø  Customise number, date and time formats

Ø  Creating and edit custom charts

Ø  Add drawing objects and diagrams

Ø  Create and query a database

Ø  Work in multiple worksheets

 

What skills you need

You should already have some experience in using Excel functions and formulas writing as well as cell formatting, number formatting and creating simple graphs.

 

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 expand their knowledge of spreadsheet automation including more formulas, functions, charts and databases.

 

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 Intermediate

 

 

 

Course Content

Creating Web (HTML) files

·         Saving a worksheet as a Web page

·         Creating a hyperlink

·         Editing a hyperlink

·         Previewing a Web page

·         Using Publishing options

·         Opening an HTML file

Using Multiple Workbooks

·         Copying Data between workbooks

·         Comparing workbooks side by side

·         Saving a Workspace

·         Linking Workbooks

Working with Columns & Rows

·         Selecting Columns & Rows

·         Hiding/Unhiding Columns & Rows

More Formulas & Functions

·         Using Function arguments

·         Using Financial functions

·         More Logical functions

·         Using Lookup Functions

·         Using Maths Functions

·         Using Nested Functions

·         Limiting the Precision of numbers

Managing Worksheets

·         Copying & moving worksheets

·         Using Grouped worksheets

·         Creating 3D formulas

·         Using 3D ranges in functions

Using Worksheet Protection

·         Unlocking cells

·         Protecting a worksheet

·         Unprotecting a worksheet

·         Managing allow-editing ranges

·         Hiding a worksheet

·         Protecting workbook windows

·         Assigning a password

Working with Data Series

·         Creating a Linear Series

·         Creating a Data Series

·         Using a stop value

·         Creating a Growth Trend series

·         Creating Custom Lists

Using Paste Special

·         Copying values between worksheets

·         Copying formulas between worksheets

Using Page Setup

·         Customising Headers & Footers

·         Repeating row and columns labels

·         Scaling a worksheet

Using Range Names

·         Using range names in formulas

·         Creating range names

·         Applying range names

·         Deleting range names

Working with Labels in Formulas

·         Using labels to define a range

·         Using multiple stacked labels

·         Using labels to refer to cells

Using Conditional and Custom Number Formats

·         Applying conditional formats

·         Creating custom formats

Drawing Objects & Diagrams

·         Drawing enclosed objects & lines

·         Editing objects

·         Adding text to objects

·         Selecting & resizing objects

·         Applying colours

Advanced Chart Editing

·         Formatting Gridlines

·         Formatting an Axis

·         Formatting the Data Series

·         Charting non-adjacent ranges

·         Adding data – different worksheets

·         Using a secondary axis

·         Adding trendlines

·         Adding data tables

·         Creating chart templates

·         Applying chart templates

Working with Databases

·         Creating a database

·         Modifying a database

·         Sorting records

·         Using Data Validation

·         Using Validation lists

·         Creating a custom error message

·         Creating subtotals in a list

·         Removing subtotals in a list

Exporting and Importing Data

·         Exporting data to other applications

·         Importing data

·         Changing external data range properties

·         Removing the query definition

·         Importing dynamic data from the Web

·         Copying a table from a Web page

Using AutoFilter

·         Enabling AutoFilter

·         Filtering a list

·         Clearing AutoFilter criteria

·         Creating a custom AutoFilter

·         Disabling AutoFilter

 

 

 

 

 

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