Excel Intermediate Skill Set
Increase your knowledge, upgrade your employability.
Build on your basic understanding of Microsoft Excel with this short course and become more confident with this versatile and useful program.
Overview
Campus Geraldton
When Semester 1, 2025
Study Mode On campus
Advance your current skills in Microsoft Excel.
This short course is aimed at those that have the existing knowledge and skills to create, edit, print and chart simple worksheets including understanding ranges and the copying process. The topics covered in this short course include:
- use the fill operations available to fill a data series,
- use a range of formula techniques,
- use a range of logical functions,
- apply a range of number formatting techniques to data,
- apply conditional formatting in a worksheet,
- apply borders to cells and ranges,
- work with various elements of a worksheet,
- use a range of find and replace techniques,
- sort data in a list in a worksheet, and
- filter data in a table.
This skill set covers unit BSBTEC302 Design and Produce Spreadsheets, which is a Core unit in FNS40222 Certificate IV in Accounting and Bookkeeping.
Select your preferred campus and apply
Semester 1, 2025
Details
Course fees
(Tuition fee* $97.50 + Resource fee $10.37 )
(Tuition fee* $29.10 + Resource fee $10.37 )
Units and fees
To attain this skill set, you are required to successfully complete all one (1) units of competence listed below.
Core
| National ID Unit title | General fee | Concession | Resource fee |
|---|---|---|---|
| BSBTEC302 Design and produce spreadsheets | $97.50 | $29.10 | $10.37 |
Please note: Course information and fees are subject to change without notice.
- Fees may differ between campus locations due to the difference between elective units in the course study plan or a need to adapt courses to meet local industry needs.
- Fees may also differ for individuals depending on units of study selected, prior qualifications and recognition of prior learning (RPL).
- Fees are payable at the time of enrolment.
- Total fees quoted include tuition fees and resource fees only. You may also be required to purchase text books, uniforms or other personal equipment that are not included in this fee estimate.
- For Lower Fees, Local Skills (half-price) courses please refer to additional eligibility information above.
- Concession rates: If eligible, proof of concession must be presented.
- Concessions and the secondary school age fee cap do not apply to commercial courses (short courses), or Foundation Programs (i.e ESL and General Education).
- Secondary school aged persons (in 2025, students born on or after 1 July 2007 who are at least 15 years old in 2025) undertaking training that is not part of a VET Delivered to Secondary Schools program, the maximum course (tuition) fee chargeable is $420. Additional resource fees and discretionary fees may apply.
- VET Student Loans for eligible courses and fee caps may be subject to changes implemented by the Australian Government.
More information: Visit our fees and payment options page or call us on 1800 672 700