fbpx Microsoft Excel Advanced | Central Regional Tafe

Microsoft Excel Advanced

Share this course on your social media page

Learn the more advanced features of Microsoft Excel.

Students will build upon their previously learnt skills in Excel and be introduced to more complex features including analytical tools, pivot tables, Solver, outlining, summarising and key automation features such as Macros. 

Topics covered include: 

  • use a range of formula techniques,
  • protect data in worksheets and workbooks,
  • use an advanced filter to analyse data in a list,
  • use a variety of data validation techniques,
  • apply conditional formatting to ranges in a worksheet,
  • use goal seeking to determine the values required to read a desired result,
  • create, use and modify data tables,
  • create and work with scenarios and Scenario Manager,
  • understand and create simple PivotTables,
  • construct and operate PivotTables using some of the more advanced techniques,
  • use data linking to create more efficient workbooks, and
  • use the Data Consolidation feature to combine data from several workbooks into one.

Certification

Upon successful completion students will be issued with a Certificate of Participation.

Contact Details 

For more information about this course and to enrol, contact Tracy Hicks, Commercial Training Coordinator - Kalgoorlie Campus:

1800 672 700
info@crtafe.wa.edu.au

Locations and study options

Click on your preferred location below to get started with your application or enrolment.

Semester 1, 2021

Details
Duration 2 Days
When Semester 1, 2021
Where Kalgoorlie
How On Campus
Details
Duration 2 Days
When Semester 1, 2021
Where Kalgoorlie
How On Campus

Semester 2, 2021

Details
Duration 2 Days
When Semester 2, 2021
Where Kalgoorlie
How On Campus
Details
Duration 2 Days
When Semester 2, 2021
Where Kalgoorlie
How On Campus
Details
Duration 2 Days
When Semester 2, 2021
Where Kalgoorlie
How On Campus

Get help

Please note This form is only for course enquiries. If you would like to apply, please refer to the 'How to apply' tab above.

Enquire now. Complete the form below and our team will be in touch to progress your application for this course.

(if applicable)
Preferred contact method
Preferred delivery mode
Have you studied with us before?