Skip to main content
Menu Menu

MS Excel Intermediate

Share this course on your social media page

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

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.

Not all units and study modes are offered at all campuses. Please check with your local campus.

Delivery locations and study options

Semester 2

Duration 1 Day
When 9 November, 2023
Where Karratha Campus
How On campus
Duration 1 Day
When 15 November, 2023
Where Newman Campus
How On campus
Duration 1 Day
When 9 November, 2023
Where Pundulmurra Campus
How On campus

Register your interest now