Advanced Certificate in Microsoft Excel

Computer Science

Gain an industry-recognised Advanced Certificate in Microsoft Excel online. Upskill in accountancy, administration, data analytics, and reporting through advanced Excel learning, with flexible study and tutor support.

NZ$554

inc GST

Enquire about international pricing

The Career Academy

This course starts anytime


Online study

Flexible online learning from anywhere

It will take a total of 6 months

Background blur gradient small

Coming Soon: Nexties Explorer

Our AI-powered Explorer is almost ready. Soon, you’ll be able to build a dynamic profile of your skills, goals, and strengths, and get a curated selection of courses just for you.

More details

Unlock these abilities


Star graphic

Gain advanced Excel skills for the workplace

Learn to manage, analyse, and present data effectively using advanced Excel tools and functions.

Star graphic

Create and use pivot tables and charts

Master the creation, customization, and application of pivot tables and charts for business data analysis.

Star graphic

Automate and streamline reporting

Use advanced Excel features to automate data reporting, improve workflow efficiency, and manage large datasets.

What You're Signing Up For

The Advanced Certificate in Microsoft Excel offers a comprehensive progression from beginner to advanced functions in Excel, designed for business, accountancy, and analytics roles. This 100% online course covers essential topics such as dynamic tables, pivot tables, cross-referencing, reporting automation, and best practices for spreadsheet solutions. Students receive industry-recognised CPD accreditation, an internationally accredited certificate, and access to career coaching and job readiness resources. Flexible study and payment plans are available.

Course Content

  • Importing and saving plain text files
  • Lookup and cross-reference functions
  • Preparing data for reporting
  • Introduction to dynamic tables
  • Pivot tables
  • Pivot charts
  • Formatting
  • Worksheet modification
  • Advanced Excel functions (including VLOOKUP, calculations)
  • Reporting automation
  • Spreadsheet solutions
Industry icon

What sort of industry will this job lead to

  • Business

  • Accounting

  • Administration

  • Data Analytics

  • IT

  • Finance

Employment opportunities icon

Future employment opportunities might be

  • Excel Power User

  • Data Analytics Technician

  • Financial Modelling Specialist

  • Reporting Automation Lead

  • Operations Data Analyst

  • Spreadsheet Solutions Developer

  • Budget & Forecasting Analyst

  • Business Intelligence Operator

  • Process Improvement Analyst

  • Excel Trainer (Industry)

The Career Academy

The Career Academy is here to transform your future. As an internationally recognised online education provider, they partner with industry to deliver courses that are practical, flexible, and designed to get results. With expert tutors, a 4.8/5 star student rating, and graduates in New Zealand, Australia, Ireland and the UK, The Career Academy has already helped over 25,000 learners each year gain the skills, confidence, and qualifications to take their next step. You could be next.