Create And Use Spreadsheets - Microsoft Excel 2016

B&W printed

This publication has been mapped to the BSBITU212 - Create And Use Spreadsheets competency. It is designed for users who are keen to learn how to use a spreadsheet application to create a variety of spreadsheet workbooks. This publication is specifically relevant to individuals who perform a range of routine tasks in the workplace.

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
  • understand and work with ranges in a worksheet
  • understand, create and work with formulas and functions
  • copy and paste data in Excel
  • understand and use formula cell referencing
  • use font formatting techniques
  • understand and use the number formatting features in Excel
  • make changes to data in a workbook
  • align the contents of cells in a number of ways
  • work with elements that make up the structure of a worksheet
  • use a range of find and replace techniques
  • sort data in a list in a worksheet
  • print your workbook data
  • apply a variety of page setup techniques
  • create effective charts in Microsoft Excel
  • create a range of common charts
  • work safely with your computer, consider your impact on the environment and manage files and folders efficiently
  • obtain help for Excel whenever you need it

  View outline

View a detailed outline of the course material. You may need to install Adobe Acrobat Reader to open this file.

View Outline

  Download student files

Download working files to go with this course. Read the installation instructions for opening these files.

Download Files Zip