Intermediate Excel Skill Set
Complete the Intermediate Excel skill set
This unit describes the skills and knowledge required to develop spreadsheets through the use of both cloud-based and non-cloud based spreadsheet applications.

Overview
Campus Esperance | Katanning
When All year round
Study Mode On Campus
This unit describes the skills and knowledge required to develop spreadsheets through the use of both cloud-based and non-cloud based spreadsheet applications.
It 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.
What will you learn in this course?
- Follow correct ergonomic, conservation requirements and relevant organisational and statutory requirements
- Design spreadsheets that address a range of data and organisational requirements
- documents that align to document purpose and appropriate to target audience
- use software functions, graphics and support materials to create spreadsheets that adhere to organisational requirements relating to style and presentation
- Key elements of formatting of spreadsheets appropriate to workplace documents, including the ability to calculate:
- sum totals
- averages
- counts of values
- formulas and functions
- create and modify intermediate-level charts that analyse the dataset.
- You would like to boost productivity by using excel to organise, analyse and visualise data.
- You would like to improve decision making through insights from excel charts and tables.
Then this is the course for you.
To make an informed choice about the suitability of this course, please consider the essential skills and knowledge below. You must:
- Demonstrate your ability to communicate with others.
- Show your ability to work independently.
- Demonstrate your ability to meet deadlines.
- Show attention to detail.
- Have a problem-solving mindset.
- Show basic maths and digital literacy.
This course aims to provide you with an opportunity to build on your basic excel skills and knowledge. You will develop spreadsheets through cloud-based and non-cloud-based spreadsheet applications of formats, formulas, functions and charts for data analysis.
Time Commitment – You will need to allocate appropriate time to complete this course. This includes attending classes on-site and/or online as outlined in the study mode; and undertake independent study outside of class hours, including private study, assessment preparation, research and complete assessment requirements.
Below are some of the important personal skills you will be required to develop and demonstrate during training. These skills are highly valued by industry:
- Respectful Communication - Interact with people from different backgrounds, share ideas effectively and build trust.
- Teamwork – Collaborate with others, show them respect, and be open to feedback.
- Problem Solving - There is always a solution. How do you respond to a challenge? If you spot a problem, we encourage you to ask questions, clarify as needed, and respond appropriately within your training.
- Initiative - Stay motivated, take proactive steps, and seek help when necessary.
- Planning - Manage time well. Knowing how to prioritise and completing your tasks efficiently are crucial for your success.
- Self-Management - Reflect on your performance. Reflection is a powerful tool for growth and success as a student at South Regional TAFE. Being a professional in the workplace can mean learning when to accept responsibility for your failures as often as your successes. This is how we learn!
- Learning – Recognise what your strengths already are. Then embrace all the new knowledge and experience from your South Regional TAFE journey to grow as a student. Some of the skills you will learn include:
- Follow correct ergonomic, conservation, organisational and statutory requirements
- Design spreadsheets that address a range of data and organisational requirements
- Format spreadsheets - calculate sum totals, averages and counts of value
- Use formulas and functions - addition, subtraction, division, multiplication and brackets
- Create and modify intermediate-level charts that analyse the dataset
- Technology - Adapt to new tools, access digital resources, and integrate technology into your learning.
Important information
Select your preferred campus and apply
All year round, 2025
Details
Units
Core
National ID | Unit title |
---|---|
BSBTEC302 | Design and produce spreadsheets |
Details
Units
Core
National ID | Unit title |
---|---|
BSBTEC302 | Design and produce spreadsheets |