Skip to main content
Menu Menu

Excel Intermediate Workshop

Share this course on your social media page

Build on your basic understanding of Microsoft Excel

This one day short course will further develop your existing skills and knowledge to enable you to create more effective and productive workbooks. You will learn to maximise the use and efficiency of Microsoft Excel.

In this course you'll cover:

  • Formulas and function techniques
  • More complex formatting
  • Using complex charting features
  • Working more effectively with efficient worksheets and workbooks

This workshop includes a copy of the workbook Design and Produce Complex Spreadsheets with the application of MS Excel Office 365.

  • Use advanced filtering techniques to get the most out of data
  • Use links to automate data within workbooks and worksheets
  • Learn how to create spreadsheets more efficiently using a range of techniques including using fill and data sorting functions
  • Gain an introduction to logical functions in Excel
  • Use a range of formula techniques
  • Apply a range of formatting techniques to enhance the look of workbooks
  • Apply conditional formatting to ranges in a worksheet
  • Sort and filter data in worksheets
  • Use a range of techniques to enhance charts

This course is designed for participants operating in a business environment who can create, edit, print and chart simple worksheets.

An understanding of ranges and the copying process is important. Keyboard skills and a general understanding of personal computers with the Windows operating system are essential.

2023 course dates

On campus  - delivered as a six hour workshop

Monday 11 September, 9:00am - 4:00pm
Monday 23 October, 9:00am - 4:00pm
Monday 20 November, 9:00am - 4:00pm

Online - delivered 2 evenings per week, 2.5 hours per session

Wednesday 1 November & Thursday 2 November
Wednesday 29 November & Thursday 30 November

$250.00

*Fee disclaimers

The fees quoted are estimates only and are for the entire course for students enrolling on a full-time basis. Please view the full list of Fee disclaimers.

Please note fees listed include all units required to gain this qualification.  If you're a continuing student and have 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.

Enquiries regarding fees can be made by calling us.

T 1300 300 822

Study options and next steps

Click on your preferred option below to get started with your application.

Semester 2, 2023

Details
Duration 1 Day
When Semester 2, 2023
Where Perth
How On campus
Details
When Semester 2, 2023
Where Perth
How On campus

Get help

This form is only for course enquiries. If you would like to apply, please refer to the Study options and next steps section above.