Excel - Level 3 (Advanced Data Analysis with Microsoft Excel)

Course Description

This course aims to increase your productivity by providing the skills and knowledge to use Microsoft Excel 2003 effectively.


This course is designed for current Microsoft Excel users who can build basic workbooks. It is assumed that the user will know how to create and save a workbook, create formulas and use functions.


At the completion of this course, participants will be able to:

  • protect data
  • use Lookup functions
  • nest functions to create complex formulas
  • use advanced filters
  • use data validation techniques
  • use goal seeking
  • create, use and modify data tables
  • use the Scenario Manager
  • create, modify and work with PivotTables
  • group cells and use outlines
  • use linking
  • share workbooks with other users
  • combine data using consolidation
  • publish workbooks for the web
  • create macros

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Good Stuff (Rating based on 22 reviews)

of respondents recommend this course to a friend.

Reviewd by 22 participants
« previous12345next »



It was pretty good course

I recommend this course.

by from Department of Defence
Date: 2013-06-13 14:06:47

Picked up a few tips, thanks


The course was good, just a little to basic for me.

I recommend this course.

by Me
Date: 2013-06-13 14:04:51

Nice course - learned a lot.


Very good course

I recommend this course.

by Ranjan - Defence
Date: 2013-06-13 14:04:19

Nice course - learned a lot.


Nice course - learned a lot.

I recommend this course.

by George
Date: 2013-06-13 14:00:38

Informative and useful


Instructor was very knowledgeable in Excel and was able to answer all questions asked

I recommend this course.

by Dash
Date: 2013-06-13 13:59:51

Course Info

Next Step

Enquire Now
Tell a Friend
Email Course Outline

Course files