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 Broome | Derby | Karratha

When Semester 2, 2026

Study Mode On Campus

Duration 1 Day

You will learn a range of techniques for working with worksheets. By the end of this course, you will be able to apply page setup options to improve the presentation of worksheets and use borders, number formatting, and conditional formatting to enhance data visibility. You will develop skills in creating and using formulas, functions, and cell references, as well as working with defined names within a workbook.

The course will also teach you how to create and customise charts, including formatting chart elements and objects to effectively present information. In addition, you will learn how to sort, filter, and manage data, use fill operations to create data series, and apply goal-seeking tools to identify values needed to achieve specific outcomes. You will also gain an understanding of common worksheet issues and best practices to help ensure accuracy and efficiency in your spreadsheets.

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.
  • Worksheet formatting and presentation
  • Page setup and print preparation
  • Formula and function creation
  • Cell referencing techniques
  • Number and conditional formatting
  • Workbook management
  • Chart creation and customisation
  • Data sorting and filtering
  • Data series and fill operations
  • Goal-seeking and problem-solving
  • Spreadsheet accuracy and troubleshooting
  • Data analysis and reporting
  • Microsoft Excel intermediate skills

This course might be suited to you if you are looking to:

  • Improve your spreadsheet skills for work, study, or personal use
  • Learn how to create formulas and functions to save time and reduce errors
  • Develop skills in analysing and managing data more efficiently
  • Create professional-looking charts and reports
  • Gain confidence working with larger and more complex spreadsheets
  • Learn techniques to organise, sort, and filter data effectively
  • Improve accuracy when working with calculations and business information
  • Enhance your problem-solving and decision-making skills using data
  • Build valuable digital skills that are highly sought after by employers
  • Increase your productivity and efficiency in the workplace
  • Gain practical skills that can be applied across a wide range of industries

Important information

Select your preferred campus and apply

Semester 2, 2026

Details

Duration 1 Day
When 19 November, 2026
Where Broome
How On Campus

Course fees

$377.00

Our estimated fees are based on:

  • Full time study in 2026.
  • 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 26 November, 2026
Where Derby
How On Campus

Course fees

$377.00

Our estimated fees are based on:

  • Full time study in 2026.
  • 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 10 December, 2026
Where Karratha
How On Campus

Course fees

$377.00

Our estimated fees are based on:

  • Full time study in 2026.
  • 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