Build expert-level Excel skills with an ICOES-accredited, CPD-endorsed certificate. Study online at your own pace in around 30 hours.
Build expert-level Excel skills with an ICOES-accredited, CPD-endorsed certificate. Study online at your own pace in around 30 hours.
Practical, job-relevant skills for these roles. As a professional development course, it builds capability in this field rather than guaranteeing a specific role or salary.
Indicative market figures from publicly available New Zealand data (Stats NZ · careers.govt.nz). Possible career directions only; no specific job, salary or outcome is guaranteed. Where you go depends on your experience, the employer and your location.
Importing and Saving Plain Text Files
Lookup and Cross-Reference (HLOOKUP, VLOOKUP)
Preparing Data for Reporting
Introduction to Dynamic Tables
Pivot Tables
Pivot Charts
How to complete vertical lookups
How to format and insert tables
How to analyse data utilising a Total Row
Table Filtering & Slicers
Using the Error Indicator to convert cell formats
Exporting data from Excel
What you’ll typically need to get started.
Requirements can vary by intake and pathway, so submit an enquiry to confirm what applies to you.
Courses are accredited by ICOES and the CPD Standards Office. The Career Academy is also a member of the International Approval & Recognition Council.
Unlimited access to tutor support via phone and email during business hours. Tutors are industry experts passionate about student success.
24/7 course access allowing students to study at their own pace from anywhere.
Instant access to the Career Centre upon enrolment, including latest job opportunities, CV templates, free personalised CV review, job tips, interview preparation, and personalised career planning.
Receive a Virtual Student ID Card providing access to over 150,000 discounts on food, entertainment, travel and more in New Zealand and around the world.
Get access to over 50 titles to enhance learning and knowledge.
Verify your qualification from The Career Academy with SEEK Pass upon completion to stand out to employers on SEEK as a qualified, job-ready candidate.
Structured courses guide students from beginner to advanced levels, progressing through Basic, Intermediate, and Advanced Excel certifications.
ICOES
CPD
The Career Academy offers an online Career Centre providing career coaching, CV reviews, interview preparation, job search resources, and LinkedIn profile reviews. Students have access to a Career Success Hub, Business Hub, and Self Service Resource Hub. The centre includes one-to-one coaching from dedicated career support staff and is available to all students during and after their studies.
A few simple steps from enquiry to your first day.
“Hiromi found the perfect work-life balance after enrolling in The Career Academy's Certificate in Bookkeeping. As a busy mum, the flexibility of online study allowed her to pursue her dream career while caring for her family. Upon completing her course, she secured a role with The Back Office Company and began her journey in a new profession.”
“Cameron Young transformed his passion for dogs into a successful mobile dog grooming service. Cameron's journey started with The Career Academy's Diploma in Dog Grooming, which equipped him with the skills and confidence to launch his business.”
This course covers advanced Microsoft Excel techniques for professionals who want to move beyond spreadsheet basics. Students learn data modelling, complex formulas, automation, dashboard development, and business intelligence tools. It suits anyone in business, finance, operations, or administration who works with data regularly.
Delivered by The Career Academy NZ, the course is completed entirely online with 6 months of access and around 30 hours of study. Students set their own schedule and can study from anywhere, at any time. Tutor support from industry experts is available by phone and email during business hours.
On completion, students receive an ICOES-accredited certificate endorsed by the CPD Standards Office, along with a SEEK Pass verified credential to share with employers. The course includes access to the CCH eBook library (over 50 titles) and the Career Centre, with CV templates, interview preparation, and personalised career planning tools.
Enquire about this course and a course advisor from The Career Academy NZ will be in touch with pricing and next steps.
Helping students across New Zealand find the right course since 2013 · 1M+ enquiries
Disclaimer: Course information on this page is sourced from the education provider and was last verified on the date shown below. Details including pricing, availability, entry requirements and course content may change without notice. Get Course is a directory service that connects students with course providers; we do not deliver courses directly. Contact the provider for the most current information before enrolling.
Last updated: July 2026