Get Qualified with an Advanced Certificate in Microsoft Excel!

CITN1003 – Advanced Certificate in Microsoft Excel

Go beyond the basics and become Microsoft Excel 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

Course Summary

Investment: $295 + GST or from only $25 per week on an interest free payment plan

 

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

 

Duration: 8-10 hours

 

Access Time: You will have access to this course for up to 6 months until you complete.

 

Course Level: 4

 

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

What our students say

★★★★★ “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

Endorsed by AAPNZ

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!