COVID-19 updates
, , ,
Home | Courses | Advanced Microsoft Excel

Advanced Microsoft Excel

State ID: S0105P

Supercharge your Microsoft Excel ability and expand your knowledge in creating more productive workbooks. 

In this one-day course we cover formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking. 

Gain these skills:

  • use the fill operations available to fill a data series 
  • use a range of techniques to work with worksheets  
  • apply a variety of page setup techniques  
  • apply borders to cells and ranges in a worksheet  
  • use common worksheet functions  
  • create more complex formulas and functions 
  • create and use defined names in a workbook 
  • apply a range of numbers formatting techniques to worksheet cells 
  • apply conditional formatting to ranges in a worksheet 
  • use goal seeking to determine the values required to read a desired result 
  • understand and use Excel’s Quick Analysis tools 
  • create and work with tables 
  • use a range of elements and features to enhance charts 
  • select and change the format of objects in a chart 

 

It is expected before you start that you can use Excel to create, edit, print and chart simple worksheets, you can understand ranges and copying and have knowledge of simple formulas such as SUM, AVERAGE, MAX and MIN. 

 
 

Delivery location, important dates and study options

This course may be offered with a blended, flexible delivery model to enable social distancing measures to be undertaken during the COVID-19 pandemic. This approach may include a mix of online and classroom based delivery, as well as practical and work experience placements. Lecturers will provide any specific instructions if your training delivery style needs to change.

Semester 2

Rockingham - Part Time-Classroom-Short Course-21/7-11/12

Overview

Units

Overview
Where Rockingham
How Part Time
Fee
Non concession:
$200.00
Enquire now
Short courses and skill set courses run subject to demand. Use the course enquiry form at the end of this page to enquire now.

Course enquiry

Are you ready to study a full time or part time full qualification?

Stop. Use the Apply Now instructions in your favourite study option listed under 'Delivery location, important dates and study options'. HINT: Click on the name of the study mode to see 'Apply now'.

Are you ready to apply for a Skills Ready Skill Set?

Stop. Use the Apply Now instructions in your favourite study option listed under 'Delivery location, important dates and study options'. HINT: Click on the name of the study mode to see 'Apply now'.

Are you ready to apply for a short course/ skills set?

Use this form to get started.

Do you have a question and need assistance before you make your decision to apply?

Use this form to get started.

For short courses and skill sets, your enquiry using this form can be the start of your application, or you can ask for more information if you don't feel ready.
Page last updated August 07, 2020