Microsoft Excel 2003 Introduction
Upcoming Course Dates
Microsoft Excel 2003 Introduction
Melbourne
Show more Melbourne coursesSydney
Show more Sydney coursesBrisbane
Show more Brisbane coursesNext Level Course
Duration
1 Day (9:00 am – 4:00 pm)Downloads
Practice FilesMeals Provided
Lunch and refresmentsPrint-Friendly
Print this pageDelivery Methods
Public, In-house, Closed GroupSkills 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]
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
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







Odyssey Training is a national Australian provider of professional, technical and management training and consultancy. We run customised training and scheduled training courses in Brisbane, Cairns, Melbourne, Sydney and Townsville. We have been a major outsource partner for local and national projects across the private and public sectors. Quality Assurance System conforming to AS/NZS ISO 9001:2008 (Certification no. 1075). Odyssey Training is also a signatory to the Government’s Information Technology Conditions v5 (GITC v5) – Q-953.