in
f
Sign Up for eNews
- First Name
- Last Name
- Email Address
- Nearest Training Location
- Interested In: Microsoft Office Professional Development Adobe Scheduled Courses In-house/Customised Training

Items 0

Total $0.00

Select Courses

Odyssey Training is a national provider of professional, computer and management training and consultancy.

Microsoft Excel 2003 Intermediate

Upcoming Course Dates
Microsoft Excel 2003 Intermediate

Next Level Course

Microsoft Excel 2003 Advanced

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

Understand and use statistical, financial and date functions
Understand and utilise range names in formulas
Organise a database list by sorting, filtering and subtotalling
Use outlining to create easy to read database reports
Create, modify and format charts

Prerequisites

Participants will need to have attended or be familiar with the topics covered in the Microsoft Excel Introduction course.

Who Should Attend this Course

This course has been developed for people wanting to utilise Microsoft Excel to perform complex calculations, represent data as a chart and manipulate database lists.

Topics Covered [Click to Show All]

Absolute Cell Referencing

Functions
Function Syntax
The MAX Function
The MIN Function
The COUNT Function
The IF Function
Financial Functions
Date Functions – Today, Now, Month

Range Names
Defining Range Names
Names in Formulas
Navigating with Names
Using Named Constants
Documenting Range Names

Conditional Formatting
Conditional Formatting from cell value
Conditional Formatting from a formula

AutoFill
Filling Dates
Filling Text
Custom Lists

Database Lists
Extended Formatting and Formulas
Adding Records
Sorting Data
Filtering Records
Advanced Filter
Subtotals
Outline Symbols
Using Other Subtotal Functions
Using Page Breaks
Removing Subtotals

Outlining
Hiding Detail
Showing Detail
Grouping Rows

Charts
The Chart Wizard
The Chart Toolbar
Changing the Chart Type
The Legend
Gridlines
Removing an Axis

Formatting Charts
Deleting a Data Table
Printing Charts
Separate Chart Sheets
Coloured Sheet Tabs
Chart Titles
Formatting Chart Titles
Printing Separate Chart Sheets

Computer Training

Microsoft Office 2010

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2010	Microsoft Access 2010 Introduction	Microsoft Access 2010 Intermediate	Microsoft Access 2010 Advanced	VBA for Microsoft Access 2010
Microsoft Excel 2010	Microsoft Excel 2010 Introduction	Microsoft Excel 2010 Intermediate	Microsoft Excel 2010 Advanced	VBA for Microsoft Excel 2010
Office 2010 New Features	Microsoft Office 2010 New Features
Microsoft Outlook 2010	Microsoft Outlook 2010 Introduction		Microsoft Outlook 2010 Advanced
Microsoft Powerpoint 2010	Microsoft PowerPoint 2010 Introduction		Microsoft PowerPoint 2010 Advanced
Microsoft Project 2010	Microsoft Project 2010 Introduction		Microsoft Project 2010 Advanced
Microsoft Visio Professional 2010	Microsoft Visio 2010 Professional Introduction		Microsoft Visio 2010 Professional Advanced
Microsoft Word 2010	Microsoft Word 2010 Introduction	Microsoft Word 2010 Intermediate	Microsoft Word 2010 Advanced	VBA for Microsoft Word 2010
Introduction to Computers	Introduction to Computers

Microsoft Office 2007

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2007	Microsoft Access 2007 Introduction	Microsoft Access 2007 Intermediate	Microsoft Access 2007 Advanced	VBA for Microsoft Access 2007
Microsoft Excel 2007	Microsoft Excel 2007 Introduction	Microsoft Excel 2007 Intermediate	Microsoft Excel 2007 Advanced	VBA for Microsoft Excel 2007
Office 2007 New Features	Microsoft Office 2007 New Features
Microsoft Outlook 2007	Microsoft Outlook 2007 Introduction		Microsoft Outlook 2007 Advanced
Microsoft Powerpoint 2007	Microsoft PowerPoint 2007 Introduction		Microsoft PowerPoint 2007 Advanced
Microsoft Project 2007	Microsoft Project 2007 Introduction		Microsoft Project 2007 Advanced
Microsoft Visio Professional 2007	Microsoft Visio 2007 Introduction		Microsoft Visio 2007 Professional Advanced
Microsoft Word 2007	Microsoft Word 2007 Introduction	Microsoft Word 2007 Intermediate	Microsoft Word 2007 Advanced	VBA for Microsoft Word 2007

Microsoft Office 2003

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2003	Microsoft Access 2003 Introduction	Microsoft Access 2003 Intermediate	Microsoft Access 2003 Advanced	VBA for Microsoft Access 2003
Microsoft Excel 2003	Microsoft Excel 2003 Introduction	Microsoft Excel 2003 Intermediate	Microsoft Excel 2003 Advanced	VBA for Microsoft Excel 2003
Microsoft Outlook 2003	Microsoft Outlook 2003 Introduction		Microsoft Outlook 2003 Advanced
Microsoft Powerpoint 2003	Microsoft PowerPoint 2003 Introduction		Microsoft PowerPoint 2003 Advanced
Microsoft Project 2003	Microsoft Project 2003 Introduction		Microsoft Project 2003 Advanced
Microsoft Visio Professional 2003	Microsoft Visio 2003 Introduction		Microsoft Visio 2003 Advanced
Microsoft Word 2003	Microsoft Word 2003 Introduction	Microsoft Word 2003 Intermediate	Microsoft Word 2003 Advanced	VBA for Microsoft Word 2003

Microsoft Sharepoint 2010

Adobe Publishing and Web

	Introduction	Advanced
Adobe Acrobat 9.0	Adobe Acrobat 9.0 Introduction	Adobe Acrobat 9.0 Advanced
Adobe Acrobat X	Adobe Acrobat X Introduction	Adobe Acrobat X Advanced
Adobe Captivate 5	Adobe Captivate Introduction
Adobe Dreamweaver CS4	Adobe Dreamweaver CS4 Introduction
Adobe Dreamweaver CS5	Adobe Dreamweaver CS5 Introduction
Adobe Illustrator CS4	Adobe Illustrator CS4 Introduction
Adobe Illustrator CS5	Adobe Illustrator CS5 Introduction
Adobe InDesign CS4	Adobe InDesign CS4 Introduction	Adobe InDesign CS4 Advanced
Adobe InDesign CS5	Adobe InDesign CS5 Introduction	Adobe InDesign CS5 Advanced
Adobe Photoshop CS4	Adobe Photoshop CS4 Introduction	Adobe Photoshop CS4 Advanced
Adobe Photoshop CS5	Adobe Photoshop CS5 Introduction	Adobe Photoshop CS5 Advanced

"Excellent presenter, well delivered, extremely relevant." Nina - Department of Education & Training

Copyright
Privacy
Collection Statement

Microsoft Certified Silver Learning Partner 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.

Training Schedules

Partnering with employers across Australia. Training your people, bringing out their best!

Experience that speaks for itself.

Build your team, your way!

We are an Australian training company, developing Australia’s professionals.

Microsoft Excel 2003 Intermediate

Upcoming Course Dates Microsoft Excel 2003 Intermediate

Melbourne

Sydney

Brisbane

Next Level Course

Related Courses

Duration

Downloads

Meals Provided

Print-Friendly

Delivery Methods

Skills Assessment

Expected Outcomes

Prerequisites

Who Should Attend this Course

Topics Covered [Click to Show All]

Training Courses

Upcoming Course Dates
Microsoft Excel 2003 Intermediate