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.


Course Content 

The below nationally recognised units of competency is included in this course:

BSBITU314       Produce spreadsheets

BSBITU402       Develop and use complex spreadsheets



Upon successful completion students will be issued with a Statement of Attainment.


Enrolment & Enquiries

For more information about this course and to enrol:

Contact: Michelle Harvey | Lecturer – Geraldton Campus

9956 6122 | 1800 672 700


Enquiry Form: Complete the course enquiry form below.


To find out more about studying with us please also refer to our Course Guide and Student Information Pack.

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 completing the form below, calling our student services team on 1800 672 700 or visiting your local campus.


Delivery location, important dates and study options

Training at CRTAFE will be offered with a blended, flexible delivery model to enable social distancing measures during the COVID-19 pandemic. This approach may include a combination of online and classroom based delivery, as well as practical and work experience placements. While the mode of delivery may vary, the content and key learning outcomes of the course will remain the same. Lecturers will provide specific instructions to their student groups on how training will be undertaken and the support available to them.

Semester 2, 2020

Geraldton Campus - Intermediate and Advanced Excel Skill Set - 27 October to 4 November



Duration 2 week/s
When Semester 2, 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 November 26, 2020