Develop And Use Complex Spreadsheets - Microsoft Excel 2016

B&W printed

This course has been mapped to the BSBITU402 - Develop And Use Complex Spreadsheets competency. It applies to individuals who require skills to create complex spreadsheets to store and retrieve data. They may work as individuals providing administrative support within an enterprise, or may be independently responsible for designing and working with spreadsheets relevant to their own work roles.

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

  • create more complex formulas and functions
  • use logical functions to test whether a statement is true or false
  • use maths functions to solve complex problems
  • use a variety of statistical functions
  • use a variety of financial functions to perform calculations
  • use the date and time functions to perform calculations
  • use a range of lookup and reference functions
  • use a range of techniques to work with worksheets
  • use data linking to create more efficient workbooks
  • understand and create simple PivotTables
  • construct and operate PivotTables using some of the more advanced techniques
  • create and edit a PivotChart
  • use a range of elements and features to enhance charts
  • select and change the format of objects in a chart
  • apply a variety of page setup techniques
  • import data into Excel and export data from Excel
  • create and use templates in Microsoft Excel
  • create recorded macros in Excel
  • use the macro recorder to create a variety of macros
  • 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

  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