This publication has been mapped to the BSBITU202 - 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