Excel Advanced

Excel Advanced

Qualification Description.
BSBTEC402 - Design and Produce Complex Spreadsheets

Are you using Excel to its fullest potential? You will be amazed at the maximum functionality of Microsoft Excel. Upon completion of this course, you will be able to prepare and plan spreadsheets, develop linked spreadsheet solutions, automate and standardize spreadsheet operations, represent numerical data graphically, and store spreadsheets, among other skills.

Upon completion, a Statement of Attainment will be issued for BSBTEC402 Design and produce complex spreadsheets from the BSB40120 Certificate IV in Business. This competency can also be credited towards the BSB40120 Certificate IV in Business or FNS41820 Certificate IV in Financial Services.

Course Fee

Fee for service: $575.00

Prerequisites

Whilst there are no prerequisites for this course, it is expected that participants have adequate language, literacy, numeracy, and computer skills to complete assessments using a computer in the classroom. Knowledge of intermediate Excel is preferred.

Unit of Competency

BSBTEC402 - Design and produce complex spreadsheets

Delivery Strategies

Classes are delivered face-to-face in a classroom environment by a qualified and industry-experienced trainer. Learning strategies include role play, demonstrations, lectures, and classroom activities. All participants will be supported by our skilled team throughout their learning journey. The course consists of 3 sessions (one day per week) with an additional 4 hours of home study per week.

Assessment Strategies

Assessment for this course includes both summative and formative methods through written questions, answers, observations, and practical demonstrations of knowledge and skills.

Resource Requirements

Learner manuals will be provided. This course requires the use of a computer and internet, either in the classroom or at the student's home or workplace, to research relevant legislation, industry standards, and develop workplace documents.

Need Further Information?

For more information, please contact our office on 02 9687 2072 or send an email to This email address is being protected from spambots. You need JavaScript enabled to view it..

  • Design and produce complex spreadsheets (BSBTEC402)
Course fee: $575.00
Nationally Recognised Training
Nationaly Recognised Training
What is a USI?

The Unique Student Identifier or USI is a reference number that creates a secure online record of your recognised training and qualifications gained in Australia, even from different training organisations. You can read more about a USI here.

Recognition of Prior Learning

We understand that you may already have many skills and areas of expertise that you have obtained in different ways and these are recognised through our Recognition of Prior Learning (RPL) process.

Term Dates
Start Date End Date
Monday,02 February 2026 Sunday,12 April 2026
Monday,27 April 2026 Sunday,05 July 2026
Monday,20 July 2026 Sunday,27 September 2026
Monday,12 October 2026 Sunday,20 December 2026

Contact us

Parramatta Community College

Search

Offline

Sorry, we’re not online at the moment. Please fill in the form below and we’ll get back to you.

Please fill the required field.