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

  • Ergonomic requirements
  • Presentation modes
  • Organisational presentations
  • Presentation requirements
  • Selecting an application to produce a presentation
  • Slides, notes and handout masters
  • Design slides notes and handouts
  • Adding slides and content
  • Outline view
  • Speaker notes
  • Style guide
  • Saving presentations
  • Design and layout
  • Slide design
  • Notes design
  • Designing pages
  • Templates
  • Presentation features
  • Advanced software features
  • Transition
  • Builds
  • Hidden slides
  • Custom presentation
  • Designated timelines
  • Using help
  • Spelling and consistency
  • Presentation materials
  • Hand-outs / speaker notes
  • Electronic documents
  • Storing presentation
  • File formats
  • Optical disks
  • Magnetic media
  • USB devices

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



  • Recognised by employers as professional development;
  • Improve your employment opportunities;
  • Study online, anywhere via our elearning system;
  • Access to high-quality courses written by industry experts;
  • All course materials provided online – no textbooks to buy;
  • Unlimited tutor support;
  • Easy to understand course content;
  • Unlimited enrolment with no expiry;
  • Certificate of Attainment issued for your CV (hard copy provided); and
  • Course may be tax deductible; see your tax advisor.
  • Includes unlimited access
  • Full up-front payment only