Get Qualified with Advanced Skills in Microsoft Excel!

Study an industry accredited qualification from only $25 a week – Interest FREE!

Advanced Certificate in Microsoft Excel

Go beyond the basics and become an expert!

Master Microsoft Excel with our online training course developed by a Microsoft expert. Go beyond the basics and learn the advanced features and functions of Microsoft Excel including manipulating data, advanced chart features, macros and protecting your spreadsheet.

Get Qualified & Earn more. Download a FREE info pack now:

Key Benefits

  • Learn advanced Microsoft Excel Skills and gain an accredited certificate
  • Developed by a highly qualified Microsoft Excel expert
  • Learning online allows you to study anytime, at home or the office
  • Receive tutor support via email or by calling our toll free number

Advanced MS Excel Module

1. Advanced Functions

  • Absolute referencing
  • Range names
  • Using the IF function
  • Using the VLookup function
  • Nesting functions

2. Advanced Chart Features

  • Formatting chart objects
  • Trendlines
  • Creating pivot charts
  • Manipulating pivot charts

3. Securing Spreadsheets

  • Protecting your worksheet
  • Protecting your workbook, including using passwords

4. Using Excel Macros

  • Creating macros with the macro recorder
  • Running a macro

5. Excel Data Tools

  • Removing duplicates
  • Text to columns
  • Goal seek
  • Scenario manager

You will learn how to

  • Apply advanced functions to access multiple sheets and manipulate data
  • Apply advanced chart features to visually represent your data
  • Protect your spreadsheet from accidental or intentional harm
  • Automate activities within your spreadsheet using macros
  • Gain a deeper understanding of your data using the data tools

Course Summary

Investment: $295 + GST or from only $25 per week on a payment plan

Assessments: Case studies, quizzes, written assessments and practical exercises

Duration: 8-10 hours

Accredited by ICOES

ICOES, the International Council for Online Educational Standards guarantees you a high standard of content with measurable outcomes from a reputable training organisation. ICOES is the accrediting body that establishes, monitors and continually develops the educational standards of online teaching institutions.

What our students say

★★★★★ “Course content and progression were very clear, and I did not have any need to contact the tutor for assistance. Overall great course – thanks.” – Alice Young

 

★★★★★ “This was recommended by my manager who is the Fixed Accountant and I work under her, she thought a basis in accounting would be useful as we touch multiply parts of the business included Balance Sheet and P&L. The course was very well structured and easy to follow what was required” – Stefanie Downes

Download a FREE course guide!

Dream it. Believe it. Do it.

The Career Academy will give you industry-relevant skills & the support to get on the path to make your dreams happen. Take the next step today!