This publication has been mapped to the BSBITU314 - Design And Produce Spreadsheets competency. It applies to individuals employed in a range of environments who tend to be personally responsible for designing and working with spreadsheets under minimal supervision.

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

• understand some of the key underlying concepts of spreadsheets
• understand points to consider to avoid problems in your worksheets
• 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
• make changes to data in a workbook
• understand and use formula cell referencing
• use font formatting techniques
• understand and use the number formatting features in Excel
• apply conditional formatting to ranges in a worksheet
• work with elements that make up the structure of a worksheet
• align the contents of cells in a number of ways
• save workbooks in a variety of formats
• print your workbook data
• apply a variety of page setup techniques
• create and work with headers and footers
• create effective charts in Microsoft Excel
• use a range of elements and features to enhance charts
• obtain help for Excel whenever you need it