Skip to main content
Menu Menu

Excel Intermediate Workshop

Excel Intermediate Workshop

State ID SC-PMT-V2387

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.

Image
Decorative image - Accounting

Overview

Campus Perth

When Semester 2, 2024

Study Mode On campus | 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.

  • 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

Important information

Select your preferred campus and apply

Semester 2, 2024

Details

When Semester 2, 2024
Where Perth
How Online

Units

Core

National ID Unit title
V2387 Excel Intermediate Workshop

Details

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

Units

Core

National ID Unit title
V2387 Excel Intermediate Workshop

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.

Course enquiry form