Advanced Certificate in Microsoft Excel

Get advanced Excel skills!

 

Stand out with this Advanced certificate on your CV! Learn advanced Excel skills with this online course that teaches you how to import and present data to create valuable information.

 

✔ Learn how to manage and present data in meaningful reports using imports, VLOOKUP and pivot tables.
✔ Perfect for accounting, bookkeeping finance or business roles
✔ Upskill and gain an Advanced Certificate in Microsoft Excel

on a no deposit interest free payment plan

Key Benefits

  • Get an Advanced Certificate in Microsoft Excel to add to your CV
  • Master using VLOOKUP and XLOOKUP functions to combine and cross-reference data
  • Learn how Tables allow you to reference dynamic ranges – no more having to reset your ranges!
  • Learn how to quickly consolidate and analyse data into meaningful Pivot Table reports
  • Flexible online study – work at your own pace, in your own time.

This course is designed for

This course is suitable for anyone who is already knowledgeable in the topics covered in our Certificate in Microsoft Excel and Intermediate Certificate in Microsoft Excel and is the next step to becoming a proficient user of Excel.

Course Summary

Pre-requisites: Certificate in Microsoft Excel and the Intermediate Certificate in Microsoft Excel OR already have intermediate level Excel knowledge and skills.

 

Delivery: Online with tutor support via phone and email

 

Duration:  Fit study around your schedule, in your own time and expect to take around 30 hours.

 

Access Time: You will have access to this course for up to 6 months until you complete.

 

Course modules

  1. CITG158 – Importing and Saving Plain Text Files
  2. CITG159 – Lookup and Cross-Reference
  3. CITG160 – Preparing Data for Reporting
  4. CITG161 – Using Tables
  5. CITG162 – Pivot Tables
  6. CITG163 – Pivot Charts

Course Pricing: $350 + GST or only $25 per week on an interest free payment plan