MS Excel Intermediate
The MS Excel Intermediate one-day short course provides the skills and knowledge to be able to use and operate the software effectively.

Overview
Campus Karratha | Newman | Pundulmurra (South Hedland)
When Semester 1, 2025 | Semester 2, 2025
Study Mode On Campus
You will learn a range of techniques to work with worksheets and at the completion of this course you should be able to:
- apply a variety of page setup techniques
- apply borders to cells and ranges in a worksheet
- understand and use formula cell referencing
- use common worksheet functions and create more complex formulas and functions
- create and use defined names in a workbook
- apply a range of number formatting techniques to worksheet cells
- apply conditional formatting to ranges in a worksheet
- use goal seeking to determine the values required to reach a desired result
- use a range of elements and features to enhance charts
- select and change the format of objects in a chart
- sort data in a list in a worksheet
- use the fill operations available to fill a data series
- filter data in a table
- understand points to consider to avoid problems in your worksheets
Improve your job prospects by completing the MS Excel Intermediate course today!
*Please note; Short Courses are non-accredited and result in a Certificate of Participation. A non-accredited training course does not count-towards a recognised qualification, but is specially designed to provide hands-on training in a new skill you can use in your personal or professional life, and is a great way to refresh your knowledge or give you a taste of a different industry.
Important information
Select your preferred campus and apply
Semester 1, 2025
Details
Course fees
Our estimated fees are based on:
- Full time study in 2025.
- All units required to gain this qualification. If you're a student that has successfully completed a lower-level qualification that is a prerequisite for this course, you'll only pay for the units that you need to enrol in to complete this course.
- For more information regarding eligibility and fees, please visit the DTWD website.
These fees are estimates only and depend on your eligibility for government funding, concession rates, the units you have already completed or seek to be recognised under Recognition of Prior Learning (RPL). Additional resource, material and/or equipment costs may apply. Visit our Fees and Charges page for more information, including on consumer rights.
Units
National ID | Unit title |
---|---|
K2049 | MS Excel Intermediate |
Details
Course fees
Our estimated fees are based on:
- Full time study in 2025.
- All units required to gain this qualification. If you're a student that has successfully completed a lower-level qualification that is a prerequisite for this course, you'll only pay for the units that you need to enrol in to complete this course.
- For more information regarding eligibility and fees, please visit the DTWD website.
These fees are estimates only and depend on your eligibility for government funding, concession rates, the units you have already completed or seek to be recognised under Recognition of Prior Learning (RPL). Additional resource, material and/or equipment costs may apply. Visit our Fees and Charges page for more information, including on consumer rights.
Units
National ID | Unit title |
---|---|
K2049 | MS Excel Intermediate |
Details
Course fees
Our estimated fees are based on:
- Full time study in 2025.
- All units required to gain this qualification. If you're a student that has successfully completed a lower-level qualification that is a prerequisite for this course, you'll only pay for the units that you need to enrol in to complete this course.
- For more information regarding eligibility and fees, please visit the DTWD website.
These fees are estimates only and depend on your eligibility for government funding, concession rates, the units you have already completed or seek to be recognised under Recognition of Prior Learning (RPL). Additional resource, material and/or equipment costs may apply. Visit our Fees and Charges page for more information, including on consumer rights.
Units
National ID | Unit title |
---|---|
K2049 | MS Excel Intermediate |
Semester 2, 2025
Details
Course fees
Our estimated fees are based on:
- Full time study in 2025.
- All units required to gain this qualification. If you're a student that has successfully completed a lower-level qualification that is a prerequisite for this course, you'll only pay for the units that you need to enrol in to complete this course.
- For more information regarding eligibility and fees, please visit the DTWD website.
These fees are estimates only and depend on your eligibility for government funding, concession rates, the units you have already completed or seek to be recognised under Recognition of Prior Learning (RPL). Additional resource, material and/or equipment costs may apply. Visit our Fees and Charges page for more information, including on consumer rights.
Units
National ID | Unit title |
---|---|
K2049 | MS Excel Intermediate |
Details
Course fees
Our estimated fees are based on:
- Full time study in 2025.
- All units required to gain this qualification. If you're a student that has successfully completed a lower-level qualification that is a prerequisite for this course, you'll only pay for the units that you need to enrol in to complete this course.
- For more information regarding eligibility and fees, please visit the DTWD website.
These fees are estimates only and depend on your eligibility for government funding, concession rates, the units you have already completed or seek to be recognised under Recognition of Prior Learning (RPL). Additional resource, material and/or equipment costs may apply. Visit our Fees and Charges page for more information, including on consumer rights.
Units
National ID | Unit title |
---|---|
K2049 | MS Excel Intermediate |
Details
Course fees
Our estimated fees are based on:
- Full time study in 2025.
- All units required to gain this qualification. If you're a student that has successfully completed a lower-level qualification that is a prerequisite for this course, you'll only pay for the units that you need to enrol in to complete this course.
- For more information regarding eligibility and fees, please visit the DTWD website.
These fees are estimates only and depend on your eligibility for government funding, concession rates, the units you have already completed or seek to be recognised under Recognition of Prior Learning (RPL). Additional resource, material and/or equipment costs may apply. Visit our Fees and Charges page for more information, including on consumer rights.
Units
National ID | Unit title |
---|---|
K2049 | MS Excel Intermediate |
Details
Course fees
Our estimated fees are based on:
- Full time study in 2025.
- All units required to gain this qualification. If you're a student that has successfully completed a lower-level qualification that is a prerequisite for this course, you'll only pay for the units that you need to enrol in to complete this course.
- For more information regarding eligibility and fees, please visit the DTWD website.
These fees are estimates only and depend on your eligibility for government funding, concession rates, the units you have already completed or seek to be recognised under Recognition of Prior Learning (RPL). Additional resource, material and/or equipment costs may apply. Visit our Fees and Charges page for more information, including on consumer rights.
Units
National ID | Unit title |
---|---|
K2049 | MS Excel Intermediate |
Details
Course fees
Our estimated fees are based on:
- Full time study in 2025.
- All units required to gain this qualification. If you're a student that has successfully completed a lower-level qualification that is a prerequisite for this course, you'll only pay for the units that you need to enrol in to complete this course.
- For more information regarding eligibility and fees, please visit the DTWD website.
These fees are estimates only and depend on your eligibility for government funding, concession rates, the units you have already completed or seek to be recognised under Recognition of Prior Learning (RPL). Additional resource, material and/or equipment costs may apply. Visit our Fees and Charges page for more information, including on consumer rights.
Units
National ID | Unit title |
---|---|
K2049 | MS Excel Intermediate |