Intermediate Excel for Business Skill Set
Elevate your spreadsheet skills to new heights!
Whether you’re navigating the cloud or utilising traditional spreadsheet software, this course is designed to enhance your abilities in creating and managing sophisticated spreadsheets. With a focus on intermediate concepts across various applications, you’ll emerge with a robust understanding and the capability to streamline data management.
Overview
Campus Albany
When All year round
Study Mode On Campus
Gain the skills and knowledge required to develop spreadsheets through the use of both cloud-based and non-cloud based spreadsheet applications.
This skill set is ideal for 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.
Students in this course will learn:
- Working safely and sustainably
- Designing spreadsheets that address a range of data and organisational requirements.
- Use software functions, graphics and support materials create spreadsheets that adhere to organisations 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 along with formulas and functions with addition, subtraction, division, multiplication and brackets.
- How to create and modify intermediate-level charts for understanding data.
- 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:
- Show your ability to communicate with others.
- Demonstrate your ability to work independently.
- Show your ability to meet deadlines.
- Have good attention to detail.
- Show problem-solving mindset.
- Demonstrate 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.
Select your preferred campus and apply
All year round, 2025
Details
Units
Core
| National ID | Unit title |
|---|---|
| BSBTEC302 | Design and produce spreadsheets |