ShareShare on FacebookShare on LinkedIn

Excel Training Sydney and Australia

Microsoft Excel Training Courses Sydney, Specialists in Excel Onsite Training
Get a Quote
excel training sydney

Excel Training Sydney Onsite

Trainers Direct specialises in short Excel training courses tailored to your needs. We are the specialists in delivering Excel onsite training at your workplace in a flexible format for individuals and teams.

We Provide:-

Hands on customised Excel Training courses for professionals in Sydney and Australia

Tailored training and a free training needs analysis

Flexible content enabling you to train different people on several topics over the course of a day

A cost effective solution for small and large groups

All Microsoft Office software versions and Excel training levels are available for PC and Mac users including 2003, 200720102013 and 2016. We also offer Excel training in Melbourne.

Classroom Courses

Browse all Classroom Course Dates

Group Training

Book an onsite group course at your office or at one of our training rooms

One on One Course

Learn more about one on one training

View our Prices page or Get a Quote

Level 1 - Introduction

Excel Intro Training Sydney

Our Excel short courses are delivered by Microsoft Certified Excel Experts.  This introductory level course is aimed at users who may be self taught with a basic knowledge of spreadsheets. Users with limited Excel skills who have little or no experience of Excel formulae and functions should attend this course prior to enrolling on the intermediate level.  Customers may request an intermediate level Excel course which can be customised to include a revision section covering formulae and functions.


Design your own spreadsheets

Professionally format spreadsheets using colours, borders, alignment, text wrap and orientation tools

Understand formulae and functions

Use relative and absolute references in formulae

Define page set up and print options

Repeat print titles and freeze panes

Understand page breaks

Understand when and when not to use brackets in a formula

Looking to cover If functions, linking and charts? Our Intermediate Excel Training Course may be more appropriate for you.

Level 2 - Intermediate

Intermediate Excel Training Sydney


Users attending the intermediate Excel course should have a good working knowledge of how to set up an Excel spreadsheet using formatting and basic formulas.   Users should be able to add, subtract, multiply and divide as well as being able to access page setup options and AutoSum.


Refresh on formulas, functions, tips and shortcuts

Logical functions: The If Function, Sum If, Count If

Conditional formatting

Protection and security

Linking spreadsheets

Grouping and updating sheets simultaneously

3d formulae

Freeze panes, Sort, Filter and Automatically Subtotal

Pivot table reports

Named ranges and Tables

Charts including Spark Lines

Looking to cover Lookup functions and macros? Our Advanced Excel Training Course may be more appropriate for you.

Level 3 - Advanced

Excel Advanced Training in Sydney

Users attending the Excel advanced training course should be conversant with all topics at both intro and intermediate level.


Nested Formulas

If, and, or

Error trapping functions

Lookup functions

Cleaning Data

Text functions (Concatenate, Proper, Upper, Lower, Right, Len, Left etc)

Consolidation, outlining and working with large sheets

Text to columns

Removing duplicates


Macros and customising

We also offer Excel VBA training for expert level Excel users and tailored Microsoft Excel macros training. We also offer Excel tuition on a one on one basis. Get in touch for the best advanced Excel Training in Sydney.

Microsoft Excel Refresher Course Level 1

Excel Training Sydney – Microsoft Excel Refresher Course Level 2

This course can be run on site over a day or users can attend a public course.

Prerequisites – Users must be familiar with the basics of Excel including data entry, column widths, row heights, inserting and deleting rows and columns, editing, basic formatting and printing.



Refresher on creating formulas using add, subtract, multiply, divide when to use brackets

Sum, Average, Min, Max, Today, Now and Count functions

Formatting and Printing Tips and Shortcuts

Conditional formatting

Protection and security

Linking spreadsheets and calculating across multiple sheets

Grouping and updating sheets simultaneously

Freeze panes, sort and filter

Automatically subtotal

Remove duplicates from a list


Excel Training Sydney, onsite and classroom courses for professionals

Microsoft Excel Refresher Course Level 2

Excel Training Sydney – Microsoft Excel Refresher Course Level 2

This course can be run on site over a day or users can attend a public course.

Prerequisites – Users must be familiar with the topics on our Level 1 Refresher Course


Using named range to make formula construction seamless

Creating drop down lists

Analysing data using Pivot Table Reports

Nested Formulas

Advanced functions including If, and, or, Vlookup, Match, Iferror

Lookup functions inc Vlookup and Match

Manipulating text using functions

Managing large data sets

Using Macros to automate repetitive tasks

Excel Training Sydney, onsite and classroom courses for professionals


Users who require a blend of topics from different levels may choose to combine topics to create a tailor made Excel course or a Boot Camp. Ask about our free training needs analysis for a truly relevant and hands on learning experience. We offer Excel tuition in Sydney and Melbourne and across most Australian states.  All training courses are flexible and timings can be changed to suit any busy staff schedule.

Excel Versions

We offer Excel Short Courses in the following versions:-


Excel 2007 Training 
2010 Training 
2013 Training
2016 Training

Excel Training Sydney, onsite and classroom courses for professionals

Microsoft Office short courses are available on site throughout NSW including Sydney CBD, Parramatta, Wetherill Park, Mascot, Hills District, North Sydney, Chatswood, St Leonards, Smithfield, Ryde, Pennant Hills, Sutherland Shire, Norwest, Macquarie Business Park, Bondi, Horsnby, Arndell Park, St Marys, Penrith, Fairfield and Northern Beaches. Check out our public course dates and competitive prices.

We cover all Microsoft applications including Excel, Word, PowerPoint, Access, OneNote, Publisher, Outlook, MS Project, Office 365


Useful Course Information

  • Our trainers contract for some of the largest providers in Sydney guaranteeing quality delivery at affordable prices
  • Training courses can be delivered on site at your offices or at one of our training venues in Sydney CBD or Northern Beaches
  • Full day courses run from 09:30 – 16:00 with a 45 minute lunch break but we also offer short courses too
  • Soft copy training manuals are included
  • Our trainers can use your examples
  • We offer classroom based training with small class sizes
  • Course outlines can be tailored to suit your needs
  • We are so certain you will be happy with our training that we offer a money back guarantee if you are not satisfied
  • All of our trainers are certified with many years of corporate training experience
  • Our pricing is competitive because our overheads are low
  • We offer free laptop hire to all Microsoft courses in Sydney
  • A free training needs analysis is included in our service
  • We offer lifetime membership of our online user support group for all IT courses

Another Satisfied Client

“I found our half day intermediate excel course to be very informative and easy to follow. I was surprised at how much I didn’t know and how easy it was to pick up through some quick and clever little exercises. At quite a few stages I looked around to see senior management gasping with surprise at Anita’s “4 simple clicks method” for simple solutions to major problems saving hours and hours of unnecessary work. Thanks for the training Anita. I learnt heaps in those 4 hours”.

Excel Training Review

by Kings Transport


Trainers Direct 5/49 Frenchs Forest Road East Frenchs Forest NSW 2086
Tel: 02 9454 7702

ShareShare on FacebookShare on LinkedIn

LAST MINUTE DEAL Excel Intermediate Boot Camp

27th March Parramatta

ONLY $250 + GST

Excel Intermediate Parramatta NORMAL PRICE $400 + GST, Learn how to be more efficient with countless tips, tricks and shortcuts from our MS Certified Trainers, 5* Reviews, Don't Miss Out, Small Class Size only 6 per session, Book Today!


You have Successfully Subscribed!