Design and produce spreadsheets

Buy now


This unit describes the skills and knowledge required to develop spreadsheets through the use of spreadsheet applications.

The unit applies to individuals employed in a range of environments who tend to be personally responsible for designing and working with spreadsheets under minimal supervision. These individuals are generally required to have intermediate knowledge and understanding of a number of spreadsheet applications.

No licensing, legislative or certification requirements apply to this unit at the time of publication.

Unit Sector

Digital Competence – Technology Use

Foundation Skills

This section describes those language, literacy, numeracy and employment skills that are essential to performance but not explicit in the performance criteria.




  • Recognises and interprets numerical and textual information to determine organisational and task requirements


  • Inputs numerical and key reporting information when creating and finalising spreadsheets
  • Uses format, layout, style guides and standard naming conventions to organise data according to purpose and audience


  • Uses mathematical equations to create simple formulae and validate numerical data


  • Collaborates with others to achieve joint outcomes

Unit Mapping Information

Supersedes and is equivalent to BSBITU314 Design and produce spreadsheets.

Supersedes but is not equivalent to BSBITU311 Use simple relational databases.

Assessment Conditions

Skills in this unit must be demonstrated in a workplace or simulated environment where the conditions are typical of those in a working environment in this industry.

This includes access to:

  • industry software/applications for producing spreadsheets
  • digital device user information
  • relevant legislation and codes of practice
  • relevant organisational policies and procedures
  • workplace documentation and resources, including style guide.

Assessors of this unit must satisfy the requirements for assessors in applicable vocational education and training legislation, frameworks and/or standards.

Design and produce spreadsheets

$15.40$33.00 inc. GST

Black WhiteLearning Guide
$19.80 inc. GST
Black WhiteTrainer Guide
$19.80 inc. GST
ColourLearning Guide
$33.00 inc. GST
ColourTrainer Guide
$33.00 inc. GST
ElearningLearning Guide
$15.40 inc. GST
SKU: N/A Category:


Customisation request?

Email us

You will need to access our free online Learning Management System (LMS) to use eLearning units.