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 2010 Advanced

Upcoming Course Dates
Microsoft Excel 2010 Advanced

Next Level Course

VBA for Microsoft Access 2007

Duration
2 Days (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

Protect a workbook and save with a backup
Understand and use advanced functions
Consolidate data, link and export data
Use What-If Analysis tools such as Goal Seek, Solver and Scenarios
Create and modify PivotTables and PivotCharts
Create and modify Macros

Prerequisites

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

Who Should Attend this Course

This course has been developed for people wanting to use more complex functions within Microsoft Excel and includes tools for analysing, linking and exporting data.

Topics Covered [Click to Show All]

File Protection
Attaching a Password
Modifying a Password

Cell Protection
Protecting Cells

Circular References
Circular Error Messages
The Circular Reference Toolbar

Functions
Function Overview
Math and Trig Functions
Financial Functions
Logical Functions
The AND Function
The OR Function
Nesting Functions
The VLOOKUP Function
The HLOOKUP Function
Concatenating Functions
Index and Match Functions
Using Help for Functions

Goal Seek
Using Goal Seek

Solver
Saving a Scenario
Solver Reports

Scenarios
Adding a Scenario
Showing Scenarios

Linking
Worksheet Linking
Workbook Linking

Data Validation

Data Consolidation

Importing Data
Importing CSV Files
Text Import Wizard

Exporting Data
Choosing a Specific Format
Exporting to Word
Pasting Data with a Link
Copying a Graph with a Link

PivotTable Reports
PivotTable Layout
Rearranging Data
Filtering a Report
Adding Fields
Field Settings
Refreshing Data
Formatting a PivotTable
Showing Detail
Create a Calculated Field
Advanced Data Field Settings

PivotChart Reports
Creating a PivotChart
Creating PivotChart Reports from Scratch
Adding Fields to a PivotChart

Macros
Recording a Macro
Editing a Macro
Relative/Absolute Recording
Stepping through a Macro
Macro Buttons
Customising the Toolbar
Deleting a Macro

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

"The trainer really made this course effective and enjoyable. His extensive knowledge of the subject matter made it easy for him to explain the processes and available tools to us in an easy to understand manner. He also gave excellent examples of when these tools could be utilised." Amy

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 2010 Advanced

Upcoming Course Dates Microsoft Excel 2010 Advanced

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 2010 Advanced