Intermediate Excel

Take your Excel skills to the next level with this Intermediate Excel short course. Designed for those who already understand the basics, this course will help you work more confidently and efficiently with data.

You’ll learn how to use more advanced formulas and functions, manage and analyse data sets, and create more dynamic and professional spreadsheets. Whether you're using Excel at work, in your business, or for study, these skills will help you get more done, more accurately.

This course is ideal if you want to understand the basics of Microsoft Excel and need to extend your knowledge and application. Topics covered include:

• Development of formulas
• Macros
• Go to Special
• Pivot tables
• Named Ranges
• Drop-down lists
• Conditional formatting
• Excel tables for data analysis
• Using Sparklines
• Text to column

• provide photo ID to the trainer on the first day of the course
• bring a pen and paper

This short course does not include accredited units and training.

Here's an outline of fees and costs associated with your course.

Booking your short course is easy and starts online. Once you've completed your online booking, you can choose from the following convenient payment options:

• Online: pay securely via our online payment portal.
• Over the phone: we will call you to take EFTPOS payment over the phone using your credit or debit card.
• In person: visit your nearest campus to pay by card.
• Authority to Invoice: if you nominate a third party (such as your employer) to cover your course cost, we will email you an Authority to Invoice form.

There are 4 simple steps when booking for a short course with us. 

1. Book – Book online and complete your enrolment details at swtafe.edu.au 
2. Verify – You will be asked to verify your identity online as part of the booking process.
3. Pay – Pay online, in person, over the phone, or request an invoice for third-party payment.
4. Attend – Once confirmed, we’ll email all the course details and any pre-reading required.

If need any assistance with completing your booking, contact our team via the live chat below, call 1300 648 911 or visit your nearest campus.

Not sure which course is right for you? South West TAFE will help you find your way.

Our Careers Coaches at the Skills and Jobs Centre is here to support you. Whether you’re exploring career options, transitioning from school to the workforce or looking to study after school we’re here to help you.

As a SWTAFE student, you can access a variety of support services that will enhance your study experience and help you complete your studies successfully. For more information about any of these services, visit our student page.