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.

Pre-Requisites

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.

Outcomes

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)

95%
of respondents recommend this course to a friend.


Reviewd by 22 participants
« previous12345next »

Good

Rating


Comment:
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

Rating


Comment:
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.

Rating


Comment:
Very good course

I recommend this course.

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




Nice course - learned a lot.

Rating


Comment:
Nice course - learned a lot.

I recommend this course.

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




Informative and useful

Rating


Comment:
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