Find your new direction

  • 1300 76 2221
  • Australian owned and operated since 2008

Microsoft Office Excel 2016


Course Outline and Topics

Course Overview

Microsoft Office Excel 2016 is an online professional development program that will provide you with the skills and knowledge required to develop spreadsheets using Microsoft Office Excel 2016. In this online excel course you will learn how to create simple and complex spreadsheets, produce charts, use chart design tools and work with formulae.

Businesses need to operate at the cutting edge of technology to remain competitive. It’s just as important for employees to be knowledgeable in the software that enhances business success.

If you want a career in business, you’ll want to be proficient in the Microsoft Office Excel 2016. This software is used by almost every company world-wide. The skills you acquire are transferrable, enhance your ability to communicate and collaborate effectively, increase your productivity and simplify business tasks.

Course Structure

Unit 1 - Create and use spreadsheets using Excel 2016

  • Select and prepare resources
  • Adjust workspace
  • Work place health and safety
  • Determine spreadsheet requirements
  • Reporting hazards
  • Organisational requirements
  • Recycle, reuse, reduce
  • Create simple spreadsheets
  • Excel screen
  • Consistency of design
  • Formatting text
  • Inserting or deleting rows
  • Inserting or deleting columns
  • Creating formulae
  • AutoSum
  • Using functions
  • Producing simple charts
  • Chart styles and types
  • Chart design tools
  • Protecting a worksheet

Unit 2 - Develop and use complex spreadsheets Using Excel 2016

  • Select and prepare resources
  • Adjust workspace
  • Work place health and safety
  • Analyse task
  • Determine spreadsheet requirements
  • Spreadsheet terminology
  • Plan spreadsheet
  • Clarify tasks, input, design and layout
  • Data entry, storage, output
  • Reporting and presentation requirements
  • Organisational strategies
  • Energy and resource conservation techniques
  • Using Excel 2016
  • Linking spreadsheets
  • Quick Access Toolbar
  • Formulae and functions
  • Cell formatting
  • Test formulae to confirm output
  • Automate spreadsheet operations
  • Increase spreadsheet efficiency
  • Creating macros
  • Using templates
  • Checking spreadsheet ability
  • Data validation
  • Importing and exporting data
  • Online user manuals
  • File storage
  • Data in graphic form
  • Chart types
  • Manipulating spreadsheet data
  • Graphs with labels


Written assignments and exercises, including short-answer questions, reports/essays and projects. There are no examinations or due dates for assessment.

Payment Information

Certificate Course



  • Professional development that is widely recognised and respected;
  • Improve your employment opportunities;
  • Study online, anywhere via our elearning system;
  • High-quality professional development programs written by industry experts;
  • No entry requirements;
  • All course materials provided online – no textbooks to buy;
  • Unlimited tutor support;
  • Easy to understand course content;
  • 12 months’ access. Free extensions may be available upon application.
  • Certificate of Attainment/Completion issued for your CV (hard copy provided); and
  • Course may be tax deductible; see your tax advisor.
  • Includes 12 months access
  • Full up-front payment only