Skip to main content
Menu Menu

Intermediate Excel Skill Set

Intermediate Excel Skill Set

State ID MAC42
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.

Image
computer

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

When All year round, 2025
Where Esperance
How Classroom

Units

Core

National ID Unit title
BSBTEC302 Design and produce spreadsheets

Details

When All year round, 2025
Where Katanning
How Intermediate Excel Skill Set

Units

Core

National ID Unit title
BSBTEC302 Design and produce spreadsheets

Get help

Course enquiry form