Skip to main content
Menu Menu

MS Excel Intermediate

MS Excel Intermediate

State ID K2049P

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

Image
Workplace skills

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

Duration 1 Day
When 16 May, 2025
Where Karratha
How On Campus

Course fees

$353.00

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

Duration 1 Day
When 8 May, 2025
Where Newman
How On Campus

Course fees

$353.00

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

Duration 1 Day
When 13 June, 2025
Where Pundulmurra (South Hedland)
How On Campus

Course fees

$353.00

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

Duration 1 Day
When 15 August, 2025
Where Karratha
How On Campus

Course fees

$353.00

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

Duration 1 Day
When 31 October, 2025
Where Karratha
How On Campus

Course fees

$353.00

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

Duration 1 Day
When 23 October, 2025
Where Newman
How On Campus

Course fees

$353.00

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

Duration 1 Day
When 29 August, 2025
Where Pundulmurra (South Hedland)
How On Campus

Course fees

$353.00

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

Duration 1 Day
When 21 November, 2025
Where Pundulmurra (South Hedland)
How On Campus

Course fees

$353.00

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

Not sure? Ask us

Course enquiry form