This intermediate-level Microsoft Excel course is designed for those who already know the basics and want to advance their skills in organising, analysing, and presenting data. It covers conditional formatting,…
This intermediate-level Microsoft Excel course is designed for those who already know the basics and want to advance their skills in organising, analysing, and presenting data. It covers conditional formatting,…
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.
Working with large tables of data
When Formulas Don't Calculate as Expected
Using Multiple Worksheets
Time Saving Functions
Conditional Formatting
Introduction to Recording Macros
Protecting Microsoft 365 Functions
Writing macros that automate repetitive tasks
Applying conditional formatting to documents
Updating and cross-referencing on multiple worksheets
Efficient data linking between worksheets
Completing a Microsoft Excel Intermediate test to prove proficiency
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.
Upon successfully completing the course, students receive a Certificate of Achievement from The Career Academy, accredited by ICOES and the CPD Standards Office.
Students have unlimited access to tutor support via phone and email during business hours, with expert tutors available to answer questions and provide guidance throughout the course.
The course is fully online with 24/7 access, allowing students to study at their own pace and at times that suit them, with 6 months of course access.
Upon enrolment, students gain instant access to the Career Centre, including latest job opportunities, CV templates, a free personalised CV review, job tips, and interview preparation resources.
Optional upgrade providing expert career coaching, a personalised career plan, LinkedIn profile review, and proven strategies for job and career success.
Students receive a free virtual Student ID card giving access to over 150,000 discounts in New Zealand and around the world, including food, entertainment, and travel.
Enrolled students get free access to over 50 titles in the CCH eBook Library to enhance their learning and knowledge.
Upon completion, students can verify their qualification via SEEK Pass and share it on SEEK to stand out to employers as a qualified, job-ready candidate.
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 intermediate-level Microsoft Excel course is designed for those who already know the basics and want to advance their skills in organising, analysing, and presenting data. It covers conditional formatting, multiple worksheets, time-saving functions, macros, and Microsoft 365 features, concluding with a Microsoft Excel Intermediate test. Ideal for professionals in accounting, bookkeeping, and administration roles looking to level up their career prospects.
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