Design And Produce Spreadsheets - Microsoft Excel 2016

B&W printed

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

  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