, ,
Home | Courses | Microsoft Excel Advanced

Microsoft Excel Advanced

State ID: G004P

Learn the more advanced features of Microsoft Excel including analytical tools, pivot tables, Solver, outlining and summarising plus 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 including the ability to copy within Excel, create charts and create basic formulas.

Participants will:

  • use a range of formula techniques,
  • protect data in worksheets and workbooks,
  • use an advanced filter to analyse data in a list,
  • use a variety of data validation techniques,
  • apply conditional formatting to ranges in a worksheet,
  • use goal seeking to determine the values required to read a desired result,
  • create, use and modify data tables,
  • create and work with scenarios and Scenario Manager,
  • understand and create simple PivotTables,
  • construct and operate PivotTables using some of the more advanced techniques,
  • use data linking to create more efficient workbooks, and
  • use the Data Consolidation feature to combine data from several workbooks into one.

Upon completion of the course you will receive a Certificate of Participation.

Please refer to the Student Fact Pack for additional College and support information.

Important information

How to apply

Important information

Duration 

TBA

Day & Time

TBA

Other Information 

Kalgoorlie Campus
Tracy Hicks
(08) 9088 6830
info@crtafe.wa.edu.au

For more information about this course and to enrol contact: 1800 672 700 or 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
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 www.tafeinternational.wa.edu.au 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 2, 2019

Kalgoorlie Campus - Microsoft Excel Advanced - 12 to 13 December

Details

Units

Overview
Duration 2 day/s
When Semester 2, 2019
Where Kalgoorlie Campus
How Face to face (class room)
Apply now
Ready to apply for this course? Check out the apply and enrol page for more information.
Kalgoorlie Campus - Microsoft Excel Advanced - 14 to 15 August

Details

Units

Overview
Duration 2 day/s
When Semester 2, 2019
Where Kalgoorlie Campus
How Face to face (class room)
Apply now
Ready to apply for this course? Check out the apply and enrol page for more information.
Kalgoorlie Campus - Microsoft Excel Advanced - 4 to 5 November

Details

Units

Overview
Duration 2 day/s
When Semester 2, 2019
Where Kalgoorlie Campus
How Face to face (class room)
Apply now
Ready to apply for this course? Check out the apply and enrol page for more information.
Kalgoorlie Campus - Microsoft Excel Advanced - 9 to 10 September

Details

Units

Overview
Duration 2 day/s
When Semester 2, 2019
Where Kalgoorlie Campus
How Face to face (class room)
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 12, 2019