Excel Intermediate Workshop
Build on your basic understanding of Microsoft Excel
You will learn to create more effective and productive workbooks and maximise the use and efficiency of Microsoft Excel.
Overview
When Semester 2, 2024
How Online
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.
Whether you are a small company or a large organisation, if you have staff who wish to further develop their leadership skills, email Paccs@nmtafe.wa.edu.au to see about group training we may be able to deliver.
- 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
Select your preferred campus and apply
No study options available at this time
This course is currently undergoing delivery planning, and no future intakes are scheduled at this stage. Please check back later for updates. In the meantime, you may wish to explore related courses using the search and filter tools.
Get help
This form is only for course enquiries. If you would like to apply, please refer to the SELECT YOUR PREFERRED CAMPUS AND APPLY section above.