APEX Shield Col CW_tag.png

Spreadsheets for Business



Course Information

Short course


What it is about

  • This course is about using spreadsheet software and advanced spreadsheet techniques to improve productivity at work

Who is it for

  • People who want to learn skills in creating complex spreadsheets using advanced formulas and functions to manage and analyse data

Study load

  • Study at your own pace
  • You can take as long as you need
  • Recommended study load: 30 hours 
  • Slowly: 12 weeks (2.5 hours per week)
  • Steadily: 4 weeks (7.5 hours per week)
  • Quickly: 2 weeks (15 hours per week)

Mode of learning

  • Distance learning
  • All course materials are provided online
  • You can purchase printed materials

Learning tools

  • An activity-based approach to learning, accompanied by step-by-step Show & Tell videos with practice files

Personal trainer

  • Your own personal trainer
  • Your choice of Telephone/Email/Video Conference support
  • Weekends and outside hours

What you will learn

  • Work Health and Safety (WHS)
  • Energy and resource conservation
  • Identify your task requirements and plan your spreadsheet
  • Introduction to spreadsheets
  • Workbooks, cells, and formulas
  • Formatting data
  • Tables and charts
  • Protect, print and save spreadsheets
  • Analyze and chart data
  • Sorting and filtering data
  • PivotTables
  • Advanced formulae and functions
  • Link spreadsheet data
  • Test your formulas
  • Use spreadsheets to automate tasks
  • Import and export data
  • Collaborate with others

Course topics

  1. Prepare and plan spreadsheet development
  2. Spreadsheet fundamentals
  3. Advanced spreadsheet techniques

You will need

  • A desire to excel 
  • Basic English language, literacy and numeracy skills
  • Basic computer, internet and email knowledge
  • A personal computer (Windows 7 or later)
  • Internet access
  • Microsoft Excel (2007 or later)

Your investment

Please see the APEX Schedule of Fees.


APEX Professional Excellence Certificate

Enrol Now.PNG

APEX Enrolment Form


Study anytime, anywhere...

© 2015 Academy of Professional Excellence Pty Ltd (APEX). All rights reserved