Excel Training Melbourne

Cost Effective Onsite Training at your Offices

If you have at least 2 people to train, onsite training is guaranteed to save time and $$$ compared to a classroom course.

Book Today
excel courses melbourne

Why it’s more Cost Effective to Invest in Onsite Group Training

Why pay per delegate for classroom training if you need to train a small group?
Classroom courses are priced per head whereas onsite courses are priced per day
Classroom courses are based around a generic course outline whereas onsite courses can be tailored to your needs

If you’re looking for flexible training where you choose the subjects then contact us today
Prices start at just $1195 per day for 6 delegates

All trainers are Microsoft Certified Professionals.

All software versions covered including 2003, 2007, 2010, 2013 and 2016.

Another Satisfied Client

Thank you very much for coming down from Sydney to do this session. It was fantastic and you are a great educator. Staff got so much out of it and we should all be so much more efficient now.

K Bailey

St Vincents Hospital, Melbourne

Onsite or Public Course?

  1. Cost effective onsite courses for groups
  2. One on one for the
    same price as a public course Learn More…

What's Included?

  1. Tailored PDF course notes
  2. Membership of our support group
  3. Complimentary training needs analysis
  4. Laptop hire available

Top 3 Reasons to Choose Us

  1. 5 Star Google Reviews
  2. Microsoft Certified Instructors
  3. 20 year’s global experience
Level 1 - Introduction

excel courses melbourneExcel Courses Melbourne – Intro Level

Our beginner Excel courses are delivered by certified Excel Experts.  This foundation 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 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

Excel Courses Melbourne – Intermediate Level

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

Excel Courses Melbourne – Advanced Level

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

COURSE OUTLINE 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

Excel for Business Refresher Level 1

Excel Training Melbourne – Refresher Level 1

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 ONSITE

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 for Business Refresher - Level 2

Excel Training Melbourne – Refresher Level 2

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

COURSE OUTLINE 1 DAY ONSITE

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

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 can run any Excel course 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 the following Excel Training Course versions:-

Excel 2007 Training 
2010 Training 
2013 Training
 
2016 Training

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

FIND US

Trainers Direct 2/49 Frenchs Forest Road East Frenchs Forest NSW 2086
Email: trainers@trainers-direct.com.au
Tel: 02 9454 7702
Sitemap