Operate Spreadsheet Applications - Microsoft Excel 2016

B&W printed

The skills and knowledge acquired in ICTICT105 Operate Spreadsheet Applications are sufficient to be able to use spreadsheet applications, including creating spreadsheets, formatting data, incorporating charts and objects, and printing spreadsheets. It applies to individuals who perform a range of routine tasks in the workplace under direct supervision or with limited responsibility.

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

  • create new workbooks in Microsoft Excel
  • understand, create and work with formulas and functions
  • work with workbooks created in Microsoft Excel
  • copy and paste data in Excel
  • save workbooks in a variety of formats
  • use font formatting techniques
  • align the contents of cells in a number of ways
  • create and work with headers and footers
  • insert pictures or create charts in a workbook
  • print data from workbooks
  • customise Microsoft Excel workbooks
  • apply a variety of page setup techniques
  • modify Excel options

  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