Intermediate Excel

Intermediate Excel

Assessments are made against units of competency.

This course has no current classes. Please join the waiting list. Click here

Intermediate Excel – Sydney Course

Do you need to take your Microsoft Office Excel skills to the next level? This Intermediate Excel course is ideal if you have already completed an Introduction to Microsoft Office Excel course or have previous experience with spreadsheets but wish to take your skills to the next level.
Whether it be for personal or work use, our Intermediate Excel course will enable you to further improve your understanding of Microsoft Office Excel to enhance your productivity.

In this course you will learn how to design professional spreadsheets that suit a specific purpose, audience and informational requirements. You will understand how to analyse and present data with maximum effectiveness, and enhance readability and appearance. You will learn how to use software functions and create formulae and charts to display and analyse data in a professional and efficient manner.
This Intermediate MS Excel course is aligned with a unit of competency found in BSB30415 Certificate III in Business Administration.

Macquarie Community College also operates from a range of venues across North and Western Sydney. We have campuses in Carlingford, Eastwood, Chatswood, Blacktown, Richmond and many more.

Course Outline

In this course you will learn how to:

  • format and edit different spreadsheets for style and useability
  • create functions and formulas
  • create charts for different purposes

Course Outcome

By the end of this course you will be knowledgeable in the intermediate use of Microsoft Excel. You will be able to create, format and edit spreadsheets for a variety of purposes and audiences. You will be able to use tools in Excel to create formulas and charts.
Upon successful completion of this course you will be eligible for a Statement of Attainment in BSB30415 Certificate III in Business Administration.

What to Bring

All course material is provided and inclusive with course fees.
Please bring:

  • notebook
  • pen
  • USB

Prerequisite: Essential

Students will undertake an initial assessment of language, literacy and numeracy skills to ensure that this course is suitable for their ability levels.

Prerequisite: Desirable

You will need to have language, literacy and numeracy skills that allow you to read and interpret information in addition to basic computer literacy.
If you do not have these skills, we recommend that you complete the ICT10115 Certificate I in Information, Digital Media and Technology (Computer Basics), before enrolling in this course.

Fees and Government Subsidy Opportunities

Smart and Skilled is a reform of the NSW Vocational Education and Training (VET) system. It’s helping people in NSW get the skills they need to find a job and advance their careers.

Smart and Skilled provides eligible students with:

  • An entitlement to government-subsidised training up to and including Certificate III.
  • Government funding for higher-level courses (Certificate IV and above) in targeted priority areas.

If you’re a prospective student, please visit: https://www.training.nsw.gov.au/forms_documents/ace/ace_cso_flyer.pdf where you will find everything you need to know about NSW Government subsidies before you enrol.

This training is subsidised by the NSW Government, and as a result your fee is determined through Training Services NSW formal eligibility criteria. This criteria will determine your exact fee. Students who meet additional specified criteria, may be eligible for a concession fee or a fee exemption. In claiming the concession or exemption students will be required to supply the required evidence to support the claim in accord with the requirements of Smart and Skilled eligibility.

Students who are eligible for Recognition of Prior Learning (RPL) and/or credit transfer from previous study will have their fee adjusted to reflect this. The amended fee will be confirmed by Training Services NSW and will be reflected in the adjusted Student Fee Statement.

Payment Plans are available through Macquarie Community College for Smart and Skilled eligible qualifications. 10% deposit is required upon enrolment followed by an interest-free payment plan. Payment methods: EFTPOS, Direct Deposit, Direct Debit, Visa or MasterCard.

Study Load

This course will include both classroom based sessions and home study.

Recognition of Prior Learning

Recognition of prior learning (RPL) is defined in the AQF as follows:

  • Recognition of prior learning is an assessment process that involves assessment of an individual’s relevant prior learning (including formal, informal and non-formal learning) to determine the credit outcomes of an individual application for credit.

This is underpinned by the AQF definition of credit as follows:

  • Credit is the value assigned for the recognition of equivalence in content and learning outcomes between different types of learning and/or qualifications.
  • Credit reduces the amount of learning required to achieve a qualification and may be through credit transfer, articulation, recognition of prior learning or advanced standing.

For further information visit: https://www.aqf.edu.au/sites/aqf/files/rpl-explanation.pdf.

If you would like to apply for RPL, please contact us for an RPL kit.

Career Opportunities

This course will help you create and use Excel spreadsheets that are very common in the modern workplace.

Elective Unit Components (1)

BSBITU304 Produce spreadsheets

For more information, visit https://training.gov.au/Training/Details/BSBITU304

How You Will Be Assessed

Assessment (including recognition of prior learning) must:

  • Meet the requirements of the relevant training package or accredited course, and
  • Be conducted in accordance with the principles of assessment and the rules of evidence, and
  • Meet workplace and, where relevant, regulatory requirements.

For this course assessment will entail the following:

  • written and verbal questioning
  • practical demonstrations

Assessments will be written and practical and may take place in:

  • the classroom environment
  • in the workplace
  • by submission of required documentation depending on your mode of delivery

What Can I Study Next?

At the completion of this course, you can move on to advanced courses in Excel to gain more complex skills. Alternatively, studying other basic and intermediate courses covering computer applications such as Word, Outlook or PowerPoint, will help you gain all-round Microsoft Office skills.
This Intermediate Excel course can be used toward a BSB30415 Certificate III in Business Administration.

Delivery Mode

We offer training in formats that suit you and your workplace in accordance with the training package.
This Intermediate Excel course is available in a variety of learning modes:

  • Classroom based: experienced and engaging trainers will take you through the course material face to face.
  • Distance education: You study at your own pace. We send you learning materials in folders and you can study without the need for a computer or Internet connection.

*Workplace based: Training is tailored to your organisation and delivered in your workplace.

  • Blended: A mix of face to face and online or distance education giving you the benefit of periodic face to face support from a trainer while also having a degree of flexibility.

Logistical Information

Macquarie Community College also operates from a range of venues across North and Western Sydney. We have campuses in Carlingford, Eastwood, Chatswood, Blacktown, Richmond and many more.
Other areas of delivery assessed on request.
Workplace based training delivered in your workplace.