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.
Certification
Upon successful completion students will be issued with a Statement of Attainment.
Contact Details
For more information about this course and to enrol, contact Michelle Harvey, Lecturer – Geraldton Campus:
Study options and how to apply
Click on your preferred study option below to get started with your application or enrolment.
Semester 2, 2022
Geraldton - Intermediate and Advanced Excel Skill Set - 9 to 17 August
4 nights (Tuesdays & Wednesdays) | 5:30pm to 8:30pm
| Duration | 2 Weeks | ||||||||||||
| When | Semester 2, 2022 | ||||||||||||
| Where | Geraldton | ||||||||||||
| How | On Campus | ||||||||||||
| Course fee |
|
Please note: Where displayed, fees are only an estimate. 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. 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.
- Proof of concession must be presented to access concession rates if eligible.
- 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 2021, students born on or after 1 July 2003 who are at least 15 years old in 2021) 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