Home > Courses > Administration > Short > Intermediate Certificate in Microsoft Excel

Intermediate Certificate in Microsoft Excel

Study Method Online
Institution The Career Academy
Start Date Enrol anytime
The Career Academy

Course overview

You know the basics; now it’s time to move forward

Gain an intermediate level of knowledge and a strong understanding of how to organise and analyse data in Excel. Work through preparation, sorting, subtotals, filtering, and discover how to troubleshoot potential issues. This practical course is perfect for those in accounting, bookkeeping, and administration roles who want to level up. Cover conditional formatting, learn how to attend to multiple worksheets simultaneously, understand key features of MS 365 and complete a Microsoft Excel Intermediate test to show employers you know your stuff. Enrol now to widen your world.

Study method

  • Online Online info icon
    Online delivery - online course content with the exception of assessments and work placement
  • Blended Blended info icon
    Blended delivery - both online course content and partial face to face requirements
  • In-class In-class info icon
    In class delivery - predominately face to face course content conducted at a specific location
  • Virtual Virtual info icon
    Virtual Delivery - Live and interactive classroom-style learning conducted completely online

Duration study load

  • 30 hours
  • 6 months access
  • Complete 1 module per week

Course features

  • Discover how to write macros that automate repetitive tasks
  • Learn to apply conditional formatting to documents
  • Understand how to update & cross reference on multiple worksheets
  • Explore efficient data linking between worksheets
  • Gain proficiency with time-saving functions
  • Complete a Microsoft Excel Intermediate test to prove proficiency
  • Approach employers with proof of learnin

Assessment

  • Multiple choice
  • Short answer
  • Practical assessments

Testimonials

  • It is always a pleasure dealing with the helpful staff at Career Academy. I have just signed up for another 2 courses.
    Rachel
  • This is an awesome Academy that I'm currently studying in. It's been a while since I've had to do any academic study due to life. Before starting here, I was so anxious that I might get judged or will get no assistance whatsoever. Since my first assignment, I've been calling and chatting with the support group and seriously, they are hands down (the best), very supportive, helpful, and understanding.
    Monika Fihaki

Delivery

100% Online and 24/7 Access

  • Get instant access within 1 business day and start when you’re ready
  • Receive unlimited tutor support via phone and email from experienced professionals

Subjects

Core Modules
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

Want more information about the subjects for this course?

Payment options

Interest-free payment plans available from $25/week.

Find out more about the payment options for this course

About The Career Academy

The Career Academy is New Zealand's leading provider of online courses. Their education driven team of developers and tutors are located in Parnell, Auckland. They are committed to providing exceptional online courses and personal tutor support. The Career Academy offers a range of specialist courses to improve job performance. Their focus is on mentoring, inspiring and supporting people through training so their career or business can reap the rewards. The Career Academy’s course delivery is flexible, so their students can study with minimal disruption to their daily life. They offer flexible payment plans so anyone wanting to learn has the opportunity no matter their circumstances.

Want to know more about this course?
Complete the form and learn about:

  • Pricing and payment options
  • Start dates
  • Subjects
  • Study method
  • How to get help and contact information
  • Everything you need to know before enrolling!

Receive a consultation from a course expert

See student testimonials below

"I found the website easy to use and the contact I received after my enquiry was good. Not too pushy but there if I needed them." - Dimity G.
"All details and info was there and my query was answered quickly." - Soula M.
"Gave me everything I needed and someone called me, pretty much straight away." - Marlon T.

Want to know more about this course?

Get your free course guide now! Complete this easy form and you'll receive a course guide and consultation from The Career Academy

By submitting this enquiry I accept the "Privacy Policy" and "Terms of Use"

This provider is not currently accepting enquiries on this site from .

Would you like to view our range of Administration courses?

Yes

You are currently visiting our New Zealand website Training.co.nz

Would you like to visit our Australian website instead?

Visit Training.com.au