-
Courses
-
Industries
- Aerospace, Maritime and Logistics
- Agriculture, Animals, Science and the Environment
- Automotive
- Building and Construction
- Business and Finance
- Creative Industries
- Education and Community Services
- Engineering and Mining
- English, Languages and Foundation Studies
- Health, Beauty and Fitness
- Hospitality, Tourism and Events
- Information Technology, Library and Digital
SEARCH COURSES
I don't actually know what I want to study. Show me everything. -
Industries
- Future students
- Current students
- Short courses
-
Employers
-
Industry solutions for:
- Aerospace, Maritime and Logistics
- Agriculture, Animals, Science and the Environment
- Automotive
- Building and Construction
- Business and Finance
- Creative Industries
- Education and Community Services
- Engineering and Mining
- English, Languages and Foundation Studies
- Health, Beauty and Fitness
- Hospitality, Tourism and Events
- Information Technology, Library and Digital
-
Industry solutions for:
- Campuses
, 
, 
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 www.tafeinternational.wa.edu.au 
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 - Term 1Overview
Fees and charges
Overview
| 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.
Overview
Fees and charges
Overview
| 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
Page last updated February 12, 2020