Microsoft Excel 2013/2016 – Introductory (Face-to-Face)

This course has been mapped against the learning outcomes and performance criteria for the Unit of Competency BSBITU212 Create and use spreadsheets from the Certificate II in Business.


Area of Learning — Microsoft Excel 2013/2016 – Introductory (Face-to-Face)

About this course

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2013/2016.

Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Successful completion of this course and the required assessments leads to a Statement of Attainment.

Face-to-Face Delivery:

  • Learn from certified trainers with real-world experience. 
  • Participate in interactive learning experiences.
  • Feel supported through your studies with our dedicated Student Support Days to provide one on one guidance.

Rather study online?

Check out our Microsoft Excel 2013/2016 – Introductory Online Course for online delivery.


This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2016. However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.

Learning Outcomes

At the completion of this course you should be able to:

  • navigate your way around Microsoft Excel 2016
  • create and work with a new workbook
  • open and navigate within workbooks and worksheets
  • make changes to data in a workbook
  • understand and work with ranges in a worksheet
  • copy and paste data in Excel
  • use the fill operations available to fill a data series
  • move the contents of cells and ranges within and between workbooks
  • understand, create and work with formulas and functions
  • understand and use formula cell referencing
  • use font formatting techniques
  • align the contents of cells in a number of ways
  • understand and use the number formatting features in Excel
  • format rows and columns in a worksheet
  • work with elements that make up the structure of a worksheet
  • sort data in a list in a worksheet
  • filter data in a table
  • print your workbook data
  • create effective charts in Microsoft Excel
  • obtain help for Excel whenever you need it
  • understand points to consider to avoid problems in your worksheets

Now is the time to get qualified.

Discover our areas of learning.

Forsythes Training is an established, trusted, quality training provider with an extensive list of corporate clients and individuals who have attended our training courses over the last twenty years in a variety of learning areas: