NONAC08036

Microsoft Office Excel: Intermediate

Non-accredited Short Course

Develop intermediate Excel skills with this Microsoft course.

Apply now

STUDY LOCATIONS Greater Brisbane Gold Coast

WAYS TO STUDY On campus

NEXT INTAKE Start date: 04 Dec 2023 Duration: 1 day View all intakes

WHAT YOU'LL PAY

Full Fee

$185

Course overview

If you want to become more efficient and organised at work using Microsoft Excel, at TAFE Queensland we have the course for you! Microsoft Office Excel: Intermediate is designed to assist you in improving your expertise and developing your skills further by mastering the tools and features of Excel.

Gold Coast
Microsoft Excel - 6 hours face to face on campus.

In this session, using the Windows 10 platform, you will learn how to:

work with rows, columns and worksheets
relative, absolute and named references
Excel Math
3D formulas
use the functions: SUM, AVERAGE, and COUNT
formatting

Greater Brisbane
Microsoft Excel - 4 hours. In this session you will:

Learn how to be more productive with data entry using Fill-Handle, Absolute Reference, Transpose data, Flash-Fill, Text-to-Column and adding drop-down data lists.
Learn how to apply key functions like CONCATENATE, SUM, COUNT, SUMIF, TRIM, COUNTIF, MAX, MIN, SUMIFS, NOW, IF, VLOOKUP.
Learn how to better manage spreadsheets using FUNCTION search, automatically updating data/functions/formulas, editing formulas and functions, using CHECKSUM, adding the Developer menu item, linking worksheets and applying Freeze panes,
Learn how to display data and results effectively using Sparklines, Show Formulas, using Rounding functions, advanced conditional formatting, Array Formulas and Protecting cells and sheets.

This short course is non-accredited therefore is not registered with the National Training Register.

Course outcome:

Statement of Participation

Ways to study

Choose your study location

On Campus

You'll learn face to face with a teacher in a classroom or simulated workplace environment. You may access learning materials through our online learning management system Connect. Learn more
View comparison chart

On Campus

You'll learn face to face with a teacher in a classroom or simulated workplace environment. You may access learning materials through our online learning management system Connect. Learn more
View comparison chart

CAMPUS	STUDY MODE	START DATE	DURATION	WORKLOAD	WHAT YOU'LL PAY
South Bank	On Campus	22 Mar 2024	up to 4 hours	Part time Friday	Full fee: $185 More Apply
South Bank On Campus Online Time How much of the course will be delivered online. 0% On Campus Time 100% START DATE The date the course starts. Apply early as intakes fill up quickly. 22 Mar 2024 The date the course starts. Apply early as intakes fill up quickly. DURATION The total length of time it takes to complete the course. up to 4 hours The total length of time it takes to complete the course. Workload The average amount of time students will need to allocate to study each week. Part time Friday The average amount of time students will need to allocate to study each week. WHAT YOU'LL PAY Full fee: $185 Class format Some courses include classes at scheduled times while others can be completed in your own time. Teacher-led, Scheduled Some courses include classes at scheduled times while others can be completed in your own time. VIRTUAL CLASS Scheduled online classes using video conferencing software (such as Zoom). No Scheduled online classes using video conferencing software (such as Zoom). ASSESSMENT The primary location assessments will take place. Some courses also require vocational placement. No assessment The primary location assessments will take place. Some courses also require vocational placement. TEACHER COMMS The different ways you can contact your teacher throughout the course. Phone, Email, Face-to-face, Zoom The different ways you can contact your teacher throughout the course. Less Ask a question Apply
South Bank	On Campus	02 Aug 2024	up to 4 hours	Part time Friday	Full fee: $185 More Apply
South Bank On Campus Online Time How much of the course will be delivered online. 0% On Campus Time 100% START DATE The date the course starts. Apply early as intakes fill up quickly. 02 Aug 2024 The date the course starts. Apply early as intakes fill up quickly. DURATION The total length of time it takes to complete the course. up to 4 hours The total length of time it takes to complete the course. Workload The average amount of time students will need to allocate to study each week. Part time Friday The average amount of time students will need to allocate to study each week. WHAT YOU'LL PAY Full fee: $185 Class format Some courses include classes at scheduled times while others can be completed in your own time. Teacher-led, Scheduled Some courses include classes at scheduled times while others can be completed in your own time. VIRTUAL CLASS Scheduled online classes using video conferencing software (such as Zoom). No Scheduled online classes using video conferencing software (such as Zoom). ASSESSMENT The primary location assessments will take place. Some courses also require vocational placement. No assessment The primary location assessments will take place. Some courses also require vocational placement. TEACHER COMMS The different ways you can contact your teacher throughout the course. Phone, Email, Face-to-face, Zoom The different ways you can contact your teacher throughout the course. Less Ask a question Apply
South Bank	On Campus	18 Oct 2024	up to 4 hours	Part time Friday	Full fee: $185 More Apply
South Bank On Campus Online Time How much of the course will be delivered online. 0% On Campus Time 100% START DATE The date the course starts. Apply early as intakes fill up quickly. 18 Oct 2024 The date the course starts. Apply early as intakes fill up quickly. DURATION The total length of time it takes to complete the course. up to 4 hours The total length of time it takes to complete the course. Workload The average amount of time students will need to allocate to study each week. Part time Friday The average amount of time students will need to allocate to study each week. WHAT YOU'LL PAY Full fee: $185 Class format Some courses include classes at scheduled times while others can be completed in your own time. Teacher-led, Scheduled Some courses include classes at scheduled times while others can be completed in your own time. VIRTUAL CLASS Scheduled online classes using video conferencing software (such as Zoom). No Scheduled online classes using video conferencing software (such as Zoom). ASSESSMENT The primary location assessments will take place. Some courses also require vocational placement. No assessment The primary location assessments will take place. Some courses also require vocational placement. TEACHER COMMS The different ways you can contact your teacher throughout the course. Phone, Email, Face-to-face, Zoom The different ways you can contact your teacher throughout the course. Less Ask a question Apply

CAMPUS	STUDY MODE	START DATE	DURATION	WORKLOAD	WHAT YOU'LL PAY
Southport	On Campus	04 Dec 2023	1 day	Full time 9.00am - 3.30pm Monday	Full fee: $185 More Apply
Southport On Campus Online Time How much of the course will be delivered online. 0% On Campus Time 100% START DATE The date the course starts. Apply early as intakes fill up quickly. 04 Dec 2023 The date the course starts. Apply early as intakes fill up quickly. DURATION The total length of time it takes to complete the course. 1 day The total length of time it takes to complete the course. Workload The average amount of time students will need to allocate to study each week. Full time 9.00am - 3.30pm Monday The average amount of time students will need to allocate to study each week. WHAT YOU'LL PAY Full fee: $185 Class format Some courses include classes at scheduled times while others can be completed in your own time. Teacher-led, Scheduled Some courses include classes at scheduled times while others can be completed in your own time. VIRTUAL CLASS Scheduled online classes using video conferencing software (such as Zoom). No Scheduled online classes using video conferencing software (such as Zoom). ASSESSMENT The primary location assessments will take place. Some courses also require vocational placement. No assessment The primary location assessments will take place. Some courses also require vocational placement. TEACHER COMMS The different ways you can contact your teacher throughout the course. Phone, Email, Face-to-face, Zoom The different ways you can contact your teacher throughout the course. Less Ask a question Apply

Studying on campus is a great way to enjoy the benefits of face-to-face education in a way that is far removed from a typical school. No matter which campus you choose, you know that you will be learning in an adult environment where you will be respected and nurtured. Attend a campus to learn face-to-face with a teacher in one of our learning spaces; such as a classroom, workshop, laboratory or simulated environments, or interact with teachers using real-time video or web conference tools. Learn more

Courses delivered on campus may have a combination of online and classroom based learning. Students are expected to undertake additional personal study to complete the course requirements.

Download Brochure

Microsoft Office Excel: Intermediate (NONAC08036)

Ask a question

Microsoft Office Excel: Intermediate

COURSE CODE: NONAC08036

Payment Options

How can I pay for this course?

No matter what your circumstances, TAFE Queensland has a payment option to suit you. If you are unsure of what’s right for you, get in touch. We’re here to help.

Eligibility calculator

Payment plan

If you have difficulty paying for the full cost of a course upfront, you may be eligible for a payment plan.

Learn more

Upfront payment

This may be the full fee for the course, or the student contribution amount if you are eligible for a subsidy or concession.

Learn more

Important Information

Read this before applying

Entry requirements

There are no formal entry requirements for this course.

Selection criteria

It is highly recommended that you:

know the essentials of Microsoft Excel;
have competent computer literacy skills, including an understanding of personal computers and the Windows operating system, especially working with files and folders;
be able to confidently use a mouse and keyboard.

Resources required

Classroom delivery

Please bring a pen and paper for note taking, and a USB.

Gold Coast

You will need to present your Confirmation of Enrolment to the car park attendant each week to be eligible for discounted parking.

Pathways

University pathways

If you want to go on to further study at university, TAFE Queensland has a pathway option to get you there. In many cases, completing one of our diplomas may give you a full year of credit towards a degree with one of our partner universities.

Learn more about University Pathways

How to apply

Direct application

If you're ready to get started, simply hit the Apply Now button on your preferred course information page and get your application underway online.

Course disclaimer

All information was accurate at time of publication, however TAFE policies, tuition fees and course content is subject to change without notice. Course commencement is dependent on sufficient enrolment numbers. Timetable information is subject to change prior to commencement and/or during the duration of your course.