Onsite Excel Training Sydney

Excel Training Conveniently Delivered at Your Offices
Enquire Now

Onsite Excel Training delivered by Microsoft Certified Instructors at your offices in Sydney and across Australia. We can tailor a training programme to meet your business needs.  Book a full day course, a half day course or two half day workshops on the same day, it’s really that flexible.


Why Trainers Direct?

  Practical and relevant hands on workshops tailored to your business needs using your own examples

  Cost effective training providing value for money for small to large groups

  $1250 + GST per day for up to 8 delegates

  No hidden extras

  5* online reviews


 

What’s Included?

  Free training needs analysis

  customised training programme

  Soft copy course notes

  Lifetime memberships of our user support group

  Free laptop hire

 


 

onsite excel training sydney
Level 1 - Introduction

Excel Beginners 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.

COURSE OUTLINE 1 DAY

Design your own spreadsheets

Professionally format spreadsheets

Understand formulae and functions

Use relative and absolute references in formulae

Define page set up and print options

Learn about brackets and errors in formulae

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

COURSE OUTLINE 1 DAY

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.

OUTLINE

The If Function

Conditional formatting

Protection and security

Linking spreadsheets

Grouping and updating sheets simultaneously

3d formulae

Freeze panes, sort, filter and subtotal

Pivot table reports

Named ranges

Charts

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

Level 3 - Advanced

Advanced Excel Training in Sydney

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

ADVANCED EXCEL COURSE CONTENT 1 DAY

Nested Formulas

If, and, or

Error trapping functions

Lookup functions

Text functions

Consolidation, outlining and working with large sheets

Text to columns

Removing duplicates

Automation

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.

Bespoke
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.
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.

COURSE OUTLINE 1 DAY

OUTLINE

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

Charting

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

COURSE OUTLINE 1 DAY

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

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

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