Printing the course overview will compile the details for all availabilities into a single PDF file without the units attached. If you want to print the units out for one or multiple availabilities then select the checkboxes below.
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.
Study options and next steps
Click on your preferred option below to get started with your application.
Semester 2, 2023
Perth - On Campus - TAFE+
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.