Maybe you get by in Excel, or you are starting from zero and want to do it right. This diploma runs three certificates, from the basics through to advanced, so you finish as the person the reports go to.
Every office has one person the broken formulas go to. Fixing formulas, time savers and Microsoft 365 features make that person you.
Analyst and reporting roles run on lookups, pivot tables and pivot charts. The advanced certificate covers each one, step by step.
You do not need to be confident in Excel before you start. The first certificate builds from entering data and basic formulas, at your own pace, with tutors behind you.
Excel work sits inside almost every office, and the people who can build the reports get handed the good problems. The day is easy to picture: pulling the data in, cleaning it up, building the pivot table, and sending out numbers people trust.
Turning raw data into answers, with lookups and pivot tables as your daily tools.
Supporting analysis work, where preparing data for reporting carries the day.
Helping build the numbers reports, using calculations, formatting and pivot charts.
Keeping the operational reports up to date, accurate and on time.
Supporting the data side, from importing files to keeping tables clean.
Running reports out of business systems and shaping them in Excel.
Making sure the numbers are right, with sorting, filtering and cross checks.
Backing a project team with the spreadsheets, trackers and reports they need.
Helping build and track budgets, with calculations and multiple worksheets in play.
Building the recurring reports that show how the business is tracking.
Roles where these skills are useful, not promised outcomes. Every role is different, and some need more study or experience.
Three certificates and twenty-two topics, from entering data to pivot charts.
Here is what stands out in this course.
Beginner, intermediate and advanced, in one course. You start at entering data and finish at pivot tables and charts.
Preparing data for reporting, lookups, dynamic tables and pivot charts. The exact skills behind the reports a business runs on.
A whole topic on what to do when formulas do not work as expected, plus protecting workbooks and recording macros.
You earn 90 hours of CPD accreditation when you finish, so the study counts on your record.
Certificate of Achievement · The Career Academy
Finish the diploma and the college awards you its Certificate of Achievement.
Earned on completion, so the study counts on your professional record.
Your certificate comes with a SEEK Pass link, so you can share it on SEEK where employers look.
Send an enquiry and a course advisor gets back to you with the course guide and straight answers on whether it fits.
Start anytime. Pay on a flexible weekly plan, or pay upfront in one payment.
Work through the three certificates online at your own pace, with unlimited tutor support by phone and email in business hours.
Complete the course and receive your Certificate of Achievement, with 90 hours of CPD accreditation on completion.
Not at all. The first certificate builds from entering data and basic formulas. You do not need to have used pivot tables before; you learn them step by step.
The plan is $29 a week, with no deposit and no credit check. You can also pay fortnightly, monthly, or upfront in one payment. Enquire for the full options.
Around 90 hours at your own pace, with 6 months of access. There are no set class times, so it fits around work.
One enrolment, one course. It is built as three certificates: Excel basics, then intermediate, then advanced. You work through them in order, at your own pace.
There are none, ever. You are assessed on what you understand, with tutor support behind you.
It is accredited by ICOES and the CPD Standards Office, which is accreditation for professional development. It is not NZQA accredited, so it is not a national qualification. That is a different thing. In office and reporting work, hiring runs on whether you can do the job in front of you.
Yes. There is a 10-day money back guarantee. If it is not right, you get your money back.
This course is delivered by The Career Academy, an online course provider in New Zealand.
The college has been running for over 15 years and works with more than 25,000 students a year. Courses are online and self paced, with unlimited tutor support by phone and email in business hours. Career coaching opens as soon as you enrol, including CV help and a LinkedIn profile review.
Picture the pivot table you built landing in the Monday meeting, and everyone working from your numbers. One enquiry starts it.