top of page

Online Courses Store

The Microsoft Excel Function, Charts & More Online Course is about preparing and processing data to get information.  This course is about introducing you to a large number of functions in Excel that are commonplace in business and applying them to data to get business insights or results.  Then with those results, we look at protecting and presenting the results using tools such as conditional formatting, and chart dashboards. This course includes best practices and loads of shortcuts and tips to make using Excel actually enjoyable. 


The online course includes videos that you can watch and rewind to learn techniques, step-by-step instructions to follow, and loads of exercises and quizzes to reinforce your learning.  The course comes with a tutor who you can call, email or meet via MS Teams if you need that extra bit of support.


At the completion of the course, you will be issued with a Certificate of Completion.


Register and join us today!


Comprehensive coverage of:

  • statistical functions like COUNTA, and MODE
  • logical functions like IF, AND, OR, NOT, IFS and nested IF functions
  • lookup functions like VLOOKUP, LOOKUP, XLOOKUP, INDEX and MATCH
  • IFS functions including COUNTIFS, SUMIFS and AVERAGEIFS
  • text functions including PROPER, Ampersand and Text to Columns
  • date functions including TODAY, YEAR, MONTH and DAY
  • other functions including CELL and more
  • auditing features in Excel
  • protecting the cells, worksheet, workbook and file
  • conditional formatting
  • charts and dashboards
  • and more


This Online Course is ideal, if you struggle to find time to attend a course, and you want to learn in the privacy of your own home, during the hours that you find the most convenient. Learn at your own speed and in your own time and don't deal with the pressure of trying to learn in a group classroom setting. Your online classroom does not expire, so you can take your time and you have access to your own personal tutor via phone, email or MS Teams.

Microsoft Excel - Functions Charts and More Online Course (Level 2)

Excluding GST
  • A basic understanding of formulas and functions including addition, subtraction, division, multiplication, SUM, AVERAGE, MAX, MIN, and COUNT is required. If you do not have this consider the Level One The Essentials course.

bottom of page