Odyssey Training header goes here

Microsoft Excel 2003 Introduction

Upcoming Course Dates
Microsoft Excel 2003 Introduction

Melbourne
07 Jun 2012 $395
04 Jul 2012 $395
Show more Melbourne courses
02 Aug 2012 $395
06 Sep 2012 $395
03 Oct 2012 $395
07 Nov 2012 $395
04 Dec 2012 $395
08 Jan 2013 $395
06 Feb 2013 $395
Show less courses
Sydney
07 Jun 2012 $395
04 Jul 2012 $395
Show more Sydney courses
02 Aug 2012 $395
06 Sep 2012 $395
03 Oct 2012 $395
07 Nov 2012 $395
04 Dec 2012 $395
10 Jan 2013 $395
06 Feb 2013 $395
Show less courses
Brisbane
06 Jun 2012 $365
20 Jun 2012 $365
Show more Brisbane courses
02 Jul 2012 $365
16 Jul 2012 $365
01 Aug 2012 $365
24 Aug 2012 $365
03 Sep 2012 $365
20 Sep 2012 $365
02 Oct 2012 $365
16 Oct 2012 $365
07 Nov 2012 $365
19 Nov 2012 $365
05 Dec 2012 $365
16 Jan 2013 $365
04 Feb 2013 $365
20 Feb 2013 $365
Show less courses
  • Duration
    1 Day (9:00 am – 4:00 pm)
  • Downloads
    Practice Files  
  • Meals Provided
    Lunch and refresments
  • Print-Friendly
    Print this page
  • Delivery Methods
    Public, In-house, Closed Group
  • Skills Assessment
    Take the test

Expected Outcomes

  • Create, modify and format a spreadsheet
  • Use basic formulas and functions
  • Create a calculation across multiple worksheets
  • Sort a list
  • Create a chart
  • Print a spreadsheet using Headers and Footers and Page Breaks

Prerequisites

Participants will need to be familiar with Microsoft Windows and basic Windows techniques such as opening, closing and saving files.

Who Should Attend this Course

This course has been developed for people who want to acquire basic skills to produce spreadsheets. Including working with data and performing basic calculations.

Topics Covered [Click to Show All]

The Excel Screen
Moving around a Sheet
Displaying other Areas
Mouse Movements
Viewing other Sheets

Selecting Cells
Inserting Text and Numbers
Typing the Text
Adjusting Column Widths
Typing Numbers

Saving a Workbook
The My Places Bar
File Properties

Alignment and Indenting
Indenting
Centre Aligning
Merging and Centring

Calculations
BEMDAS Rule
AutoSum
Filling the Formula
Basic Formulas
AutoCalculate
Cell Editing

Multiple Worksheets
Copying Sheet Contents
Data Entry Ranges
Calculating across Worksheets
Copying Formulas

Functions
Function Syntax
The AVERAGE Function
The MAX Function
The MIN Function

Working with Worksheets
Renaming Sheets
Inserting a Sheet
Deleting Sheets

Formatting
Fonts and Font Sizes
Number Formatting
Formatting a Group of Sheets
Borders
The Format Painter
Cell Shading
Font Colour
Inserting Images
Proofing
Checking Spelling
AutoCorrect
Find and Replace
Comments

Sorting

Charts

Column Chart
Pie Chart

Print Preview
Page Break Preview
Adjusting the Page Breaks
Previewing the Workbook
Zoom
Margins and Column Widths
Column Widths in Print
Preview

Page Setup
Orientation
Scaling
Margin Settings
Headers and Footers
Built-In Headers and Footers
Custom Headers and Footers
Sheet Options

Page Breaks and Print
Areas
Inserting a Page Break
Setting a Print Area

Printing