Develop And Use Complex Spreadsheets - Microsoft Excel 2013


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
  • work with logical function in Excel
  • use maths functions
  • use a variety of Financial functions
  • use a variety of financial functions
  • 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
  • understand and create simple PivotTables
  • create and edit a PivotChart
  • use and format a range of elements and features to enhance charts
  • 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

  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