Produce Spreadsheets - Microsoft Excel 2013


This publication has been mapped to the BSBITU304 - 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
  • navigate your way around Microsoft Excel 2013
  • create and work with a new workbook
  • understand, create and work with formulas and functions
  • make changes to data in a workbook
  • 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
  • print your workbook data
  • create effective charts in Microsoft Excel
  • work safely with your computer, consider your impact on the environment and manage files and folders efficiently

  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