Whether you keep the team spreadsheets or inherited a mess, this helps. Macros, conditional formatting, linked sheets, faster functions. For reporting work, this has you covered.
Recording macros and time saving functions. The repetitive jobs stop eating your afternoon.
Why formulas break, how to link sheets, how to cross reference cleanly.
Sit the Microsoft Excel Intermediate test. Then you have proof, not a claim on a CV.
Every office runs on spreadsheets, and few people know them well. The work is easy to picture. A monthly report, a budget to track, a tangled table.
The regular reports, out on time and right.
The person the team brings broken files to.
Pulling the numbers together each month.
Watching spend against plan, line by line.
Keeping records clean and cross referenced.
Roles where these skills are useful, not promised outcomes. Every role is different, and some need more study or experience.
What stage two adds once you know the basics.
It assumes the basics. The time goes into large tables, macros and multiple sheets.
The Excel Intermediate test gives you something concrete to show an employer.
Amore C, Dessa M, Dana L and Rita T all have bios.
Certificate of Achievement · The Career Academy
From the college, once the eight topics are done.
Sit it to show where your Excel sits.
Something you can share on your SEEK profile.
Enquire and an advisor sends the guide and the topics.
Start any day. Pay weekly, or upfront in one go.
Short topics you can do between other jobs.
Prove the level, then put it on your CV.
Yes, the basics. Stage two builds on what you can already do.
From $29 a week on a flexible plan, or pay upfront. Enquire to confirm current pricing.
About 30 hours across eight topics, with 6 months of access.
No. It covers recording macros, which is the point and click way in.
A test you sit to show your level. It gives you proof of learning for an employer.
No exams. The Intermediate test is the one check, and it is practical.
It comes from an ICOES accredited centre. The centre holds Official Accreditation with the CPD Standards Office. That is accreditation for professional development. It is not NZQA accredited, so it is not a national qualification. Those are different things. Employers mostly want to see the spreadsheet work.
There is a 10-Day Money Back Guarantee from the day you enrol.
This course comes from The Career Academy, an online college in Christchurch.
The college has run over 15 years. It helps more than 25,000 students a year. Tutors are named on the page with their fields listed. Support runs unlimited by phone and email in business hours.
Picture the month end when the report builds itself, you leave on time, and someone else is still copying rows across by hand.