Study Method Online
Institution The Career Academy
Recognition ICOES
Start Date Enrol anytime

Course overview

A logical step after completing an Intermediate Certificate in Microsoft Excel, this advanced Microsoft Excel course includes learning across text and CSV files, saving imported files, and discovering how to export data from Excel. This a great step for those students wanting to pursue a career in accounting, bookkeeping, or business administration. Microsoft Excel online certification prepares you across pivot tables and charts, advances your learning around cross-referencing, and you will discover things like how to complete horizontal lookups using VLOOKUP. Enrol now and make career advancement your new goal.


<p>ICOES (The International Council for Online Educational Standards) logo.</p>

Accredited by The International Council for Online Educational Standards

Study method

  • Online Online info icon
    Online delivery - online course content with the exception of assessments and work placement
  • Blended Blended info icon
    Blended delivery - both online course content and partial face to face requirements
  • In-class In-class info icon
    In class delivery - predominately face to face course content conducted at a specific location
  • Virtual Virtual info icon
    Virtual Delivery - Live and interactive classroom-style learning conducted completely online

Duration study load

  • 30 hours
  • 6 months access

Course features

  • Learn how to manage and present data in meaningful reports using imports, VLOOKUP and pivot tables
  • Upskill and gain an Advanced Certificate in Microsoft Excel to add to your CV
  • Received unlimited tutor support throughout your studies
  • Become confident and savvy with Excel, learning essential skills
  • This practical course guides you through the fundamental skills required to create, modify, format and print Excel files
  • Flexible online study – work at your own pace, in your own time


  • Multiple choice
  • Short answer
  • Practical assessments


  • The lady I spoke with was very friendly, explained things well and put my mind at ease.
    Tegan Walder
  • Effective communication. Good relationship in sharing fast information to tutors and student support regarding assessment submission and log-on issues.
    Helena Westerlund


100% Online and 24/7 Access

  • Get instant access within 1 business day and start when you’re ready
  • Receive unlimited tutor support via phone and email from experienced professionals

Career Benefits

  • Learn to complete vertical lookups
  • Know how to format and insert tables
  • Discover how to analyse data utilising a Total Row
  • Gain knowledge around Table Filtering & Slicers
  • Find out how to use the Error Indicator to convert cell formats
  • Get a certificate that indicates your advanced knowledge of MS Excel
  • Prove your worth to prospective employers


Core Modules
Importing and Saving Plain Text Files
Lookup and Cross-Reference
Preparing Data for Reporting
Using Tables
Pivot Tables
Pivot Charts

Want more information about the subjects for this course?

Payment options

Interest-free payment plans available from $25/week.

Find out more about the payment options for this course

About The Career Academy

The Career Academy is New Zealand's leading provider of online courses. Their education driven team of developers and tutors are located in Parnell, Auckland. They are committed to providing exceptional online courses and personal tutor support. The Career Academy offers a range of specialist courses to improve job performance. Their focus is on mentoring, inspiring and supporting people through training so their career or business can reap the rewards. The Career Academy’s course delivery is flexible, so their students can study with minimal disruption to their daily life. They offer flexible payment plans so anyone wanting to learn has the opportunity no matter their circumstances.

Want to know more about this course?
Complete the form and learn about:

  • Pricing and payment options
  • Start dates
  • Subjects
  • Study method
  • How to get help and contact information
  • Everything you need to know before enrolling!

Receive a consultation from a course expert

See student testimonials below

"I found the website easy to use and the contact I received after my enquiry was good. Not too pushy but there if I needed them." - Dimity G.
"All details and info was there and my query was answered quickly." - Soula M.
"Gave me everything I needed and someone called me, pretty much straight away." - Marlon T.

Want to know more about this course?

Get your free course guide now! Complete this easy form and you'll receive a course guide and consultation from The Career Academy

By submitting this enquiry I accept the "Privacy Policy" and "Terms of Use"

This provider is not currently accepting enquiries on this site from .

Would you like to view our range of Administration courses?


You are currently visiting our New Zealand website

Would you like to visit our Australian website instead?