COVID-19 updates
, ,
Home | Courses | MS Excel Intermediate and Advanced Skill Set

MS Excel Intermediate and Advanced Skill Set

State ID: KAA47

Save time, simplify tasks and dramatically improve your efficiency in using spreadsheets

Add to your existing knowledge gained in the Excel basic course.

The intermediate part of this course will cover:

  • Creating charts
  • Statistical functions
  • Lookup formulas
  • Using multiple workbooks
  • and much more

You will then learn the more advanced features of Microsoft Excel including:

  • analytical tools
  • pivot tables
  • solver
  • outlining and
  • summarising as well as some key automation features such as Macros.

This course assumes a good general understanding of the software and experience in the construction and modification of workbooks. Students should be able to copy within Excel, create charts and create basic formulas.

This is a nationally accredited unit of competency and upon successful completion you will receive a Statement of Attainment

Please also refer to the Student Information Pack for additional College support information

How to apply

How to apply
On Campus (Full-Time or Part-Time)
 Visit our Apply and Enrol page to find out how to apply for full-time, part-time or online courses.  
Flexible and Other Study Types 
We take applications for many of our flexible courses all year round.  Visit the Apply and Enrol page and use our Applicant Portal to lodge your application anytime. 
Apprenticeships and Traineeships 
For apprenticeships and traineeships, you must be employed in a training contract by an appropriate organisation to study. Find out more here.
International Students 
International students please visit Opens in a new window 
Short Courses and Skill Sets

Enrol in a short course or skill set by:

Calling your local campus on 1800 672 700 or completing the short course enquiry form at the bottom of your selected course page.


Delivery location, important dates and study options

Semester 1, 2020

Geraldton Campus - Intermediate and Advanced Excel Skill Set - 27 May to 17 June


Fees and charges

Duration 4 week/s
When Semester 1, 2020
Where Geraldton Campus
How Face to face (class room)
Face to face (subject to quota)
Skill set
Apply now
Ready to apply for this course? Check out the apply and enrol page for more information.

Course enquiry

Please note: This form is only for course enquiries. If you would like to apply or require further application information, please visit our Apply and Enrol page.

Page last updated February 12, 2020