This unit describes the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents.  It applies to individuals employed in a range of work environments who require skills in creation of 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.

Unit details

Study level:
Vocational and further education (TAFE)
Unit code:


Assessment tasks will be designed to reinforce and extend knowledge and skill competence within set and controlled parameters in accordance with each unit's learning outcomes and performance criteria requirements, including the setting of work based practical application tasks designed to provide evidence of competence outcomes, within periodic and scheduled timelines. Students will be expected to demonstrate the following required skills: - follow organisational and safe work practices; - adhere to organisational requirements; - adhere to identified or task requirements when producing documents; - resolve issues by referring to user documentation and online help; - use appropriate data storage options; - evaluate tasks to improve efficiency; - apply knowledge of functions and features of contemporary computer applications, and; - communicate with relevant personnel. Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.Students will also be expected to demonstrate the following knowledge: - explain advanced functions of spreadsheet software applications; - describe impact of formatting and design on presentation and readability of data, and; - explain organisational requirements for ergonomics, work periods and breaks, and conservation techniques.

Where to next?

As part of a course

This unit is studied as part of the following courses. Refer to the course page for information on how to apply for the course.

VU takes care to ensure the accuracy of this unit information, but reserves the right to change or withdraw courses offered at any time. Please check that unit information is current with the Student Contact Centre.