Onsite Excel Training Melbourne

Excel on the Job Training
Get a Quote

Flexible Excel Training in the Workplace

Trainers Direct offers onsite Excel training courses in Melbourne, designed for businesses who need flexible and cost effective staff training in the workplace.

excel courses melbourne

Combine Topics

Choose from a huge list of subjects combining intro, intermediate and advanced course levels

Flexible Sessions

Break the day into several sessions to cater for different staff members and abilities

Free Advice and Support

Benefit from a free training needs analysis and lifetime membership of our support forum

Live 5* Online Reviews Speak Volumes

google logoTrainers DirectTrainers Direct
4.9 Stars - Based on 66 User Reviews

  • I was lucky enough to have one on one course with Anita today, she was... read more

    Alison M.

    Great course. Very informative and presented in a very comprehensive way. Anita was... read more

    Kellie S.

    Excellent trainer. Very informative and helpful.

    Zac Y.

    Anita is a great teacher. She is thorough, clear and friendly. We will definitely be... read more

    Mark B.
  • Incredible trainer (with a name like Anita how can you go wrong?).
    She was informative, helpful...
    read more

    Anita H.

    Lauren was really professional and engaging through out the 4 day training sessions. She outlined... read more

    Biswa K.

    I have fairly advanced skills in Excel but needed to create a relational database in... read more

    Diane H.

    Great Training! Highly Recommended

    Leo D.
  • I needed some help with administration of Office365 and found Trainers Direct. After a few... read more

    Ross d.

    Excellent, most educational, for a bloke who knew very little about ExcelI learned allot &... read more

    joseph t.

    Extremely well presented course with a great deal of practical, helpful and useful information.

    Ryan K.

    Just Completed the Excel Intermediate Course. Great Course Content. Very Informative & Easy To Follow.... read more

    Sarah J.
  • The beginner-intermediate excel training course was a game changer for me. Prior to attending this... read more

    Cindy D.

    Anita provided a relaxed but focused classroom experience. Feedback from all staff attending was how... read more

    Damian D.

    A very informative session even though brief I learnt some new tricks that will make... read more

    Michelle D.

    Thanks Anita for the Outlook training. An informative session which highlighted some very useful tips... read more

    Mark C.
  • Great friendly learning environment.

    Rob H.

    An excellent session, well explained and very informative.

    Greg W.

    Excellent introduction to Word and Excel. I would highly recommend the course and Anita who... read more

    Fatema S.

    I have learnt so many short cuts which is so handy and saves time. The... read more

    Leanne H.
  • Fabulous training by Anita in Advanced Excel!Great trainer, clear, concise and methodical! Thank you

    Loraine R.

    Anita was very professional she was very helpfully. I am normally very shy but she... read more

    Irshad K.

    excellent,enjoyed,simple and easy to understand recommend Anita @ trainers direct

    Andrew S.

    Thanks Anita for a great couple days of training... and your knowledge of the clavier... read more

    Paul O.
  • I would highly recommend Anita @ Trainers Direct. We opted for a 1 day... read more

    Sonya A.

    I attended the Microsoft Excel and Word intro course in the CBD. I enjoyed the... read more

    Daniela A.

    Great course. Learnt alot of information with Anita. Very Recommended !

    Ashleigh D.

    Anita was an excellent teacher, I felt extremely relaxed & no question was a dumb... read more

    Donna M.
  • I attended an excel course today ran by Anita. I have nothing negative to say... read more

    Laura J.

    Anita was very pleasant, helpful and extremely patient. Her tuition to the class (all varying... read more

    Di H.

    Great course will be able to use things that I learnt to make getting things... read more

    cat f.

    Hands down, best trainer, best technique, best course which evolves in line with the attendees... read more

    Lorraine E.
  • Excellent! Lots covered off and on point. Thanks.

    Hugh L.

    I recently took part in a short lesson learning the basics in excel for work... read more

    Ty A.

    I'd consider myself an Intermediate excel user. I decided to do the Intro course and... read more

    David S.

    Very informative training session and that is the feedback from all who attended. Trained &... read more

    Matthew H.
  • I attended Anita's Basic Excel skills training 3 hour session and I have learned so... read more

    Gabriella M.

    Great course, the new skills I have learn’t will enable me to be a lot... read more

    Richard J.

    The time management course with Lauren was so beneficial, I felt more organised and on... read more

    Mark S.

    A very informative and enjoyable session. The trainer was very tolerant of learner ignorance, and... read more

    James M.

Level 1 - Introduction

Excel Courses Melbourne – 1 Day Intro Level

Trainers Direct 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

Course Overview

This course is ideal for beginners who want to learn how to produce formatted spreadsheets and perform calculations.

Course prerequisites

Participants will need to be familiar with Microsoft Windows and basic Windows techniques such as opening, closing and saving files.

What you will learn

  • Create, modify and format a spreadsheet
  • Use basic formulas and functions
  • Customise the print settings and print

Course Topics

  • Overview
    • Keyboard and mouse shortcuts
    • Entering data into your spreadsheet
    • Data entry ranges
  • Formatting the worksheet
    • Number and date formats
    • Fonts, colours, borders, sizes
    • Adjust column widths
    • Indenting
    • Centre aligning
    • Merging and centring
    • Text Wrap
    • Format Painter
  • Formulas
    • The Sum function
    • AutoSum
    • AutoFill a formula
    • Basic formulas
    • BODMAS (working with brackets)
    • Editing formulae
    • An introduction to relative and absolute references
  • Functions
    • The AVERAGE function
    • The MAX function
    • The MIN function
    • The COUNT function
  • Working with columns and rows
    • Inserting columns/rows
    • Deleting columns/rows
    • Hiding columns/rows
    • AutoFill
  • Printing and page setup
    • Print preview
    • Margins, orientation, scaling
    • Page layout
    • Page break preview
    • Headers and footers
    • Repeating Print titles on all pages
    • Setting a print area
    • Print
    • Save as PDF

Our Intermediate Excel Training Course may be more appropriate for you.

Level 2 - Intermediate

Excel Courses Melbourne – Intermediate Level – 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.

Course Overview

This course is suitable for people who want to use Excel to perform calculations using a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, link sheets, produce basic pivot table reports and conditionally format cells.

Course prerequisites

Participants will need to have attended or be familiar with the topics covered in the Microsoft Excel Introduction course.

What you will learn

  • How to use a range of common worksheet functions
  • Manage a database list by filtering and subtotalling
  • Use Conditional Formatting to change cell appearance
  • Create, modify and format a range of charts
  • Produce linked worksheets and 3D formulae
  • Create basic pivot table reports

Course Topics Summary

  • Multiple worksheets
    • Copy and paste
    • Copy an entire sheet
    • Calculating across worksheets
    • Copying formulas
    • Renaming sheets
    • Inserting/deleting a sheet
    • Grouping sheets
  • Charts
    • Selecting data to chart
    • Creating a chart
    • Changing the chart type
    • Switching columns/rows
    • Adding titles
    • Reposition the legend
    • Using chart layouts
    • Printing a chart
    • Plotting a secondary axis
  • Functions and formulas

    • Absolute cell referencing
    • The COUNTIF function
    • The SUMIF function
    • The IF function
    • Working with date and time
      • Date functions – TODAY and NOW
      • NETWORKDAYS function
      • AutoFill date sequences
    • Conditional formatting
      • Conditional formatting from cell value
      • Conditional formatting from a formula
      • Editing conditional formatting rules
      • Adding sparklines
    • Sorting and filtering
      • Freeze Panes
      • Sorting lists
      • Sorting by colour
      • Filtering criteria
      • Searching for criteria
      • Subtotalling a list
    • Creating a  PivotTable Report
      • Create a PivotTable
      • Rearranging data
      • Applying filters and slicers
      • Adding a timeline filter
      • Adding fields
      • Modify field settings
      • Refreshing data
      • Formatting a PivotTable
    • PivotCharts
      • Creating a PivotChart
      • Filtering a PivotChart
    • Protecting your data
      • Workbook protection
      • Protecting cells
      • Protecting structure
    • Range names
      • Defining range names
      • Using names in formulas
      • Navigating with names
      • Using named constants
      • Documenting range names
    •  
     

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 – 1 Day

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

Course overview

This course covers many advanced features of Excel including lookup and advanced functions, What-if analysis, and how to automate processes and be more productive.

Course prerequisites

Participants will need to have attended or be familiar with the topics covered in the Microsoft Excel Intermediate course.

Course Topics Summary

  • Functions

    • IF Function revision
    • The AND function
    • The OR function
    • Nested IF function
    • The VLOOKUP function
    • The HLOOKUP function
    • Transposing data
    • Concatenating functions
    • INDEX and MATCH functions

    Data Validation

    • Limiting cell values
    • Creating drop-down cell lists
    • Validation error messages

    What-if analysis tools

    • Using goal seek
    • Scenario manager

    Importing data

    • Importing CSV files
    • Text import wizard
    • Converting text to columns
    • Formatting imported data and troubleshooting

    Workbook linking

    • Workbook linking
    • Dealing with broken links
    • Data consolidation

    Exporting data

    • Saving as a different file type
    • Exporting to Word
    • Pasting data with a link
    • Copying a graph with a link

    Macros

    • Recording a Macro
    • Editing a Macro
    • Relative/Absolute Recording
    • Custom Macro buttons
    • Customising the ribbon
    • Editing a line of code
    • Deleting a Macro

We also offer Excel VBA training for expert level Excel users and tailored Microsoft Excel macros training. Get in touch for the best advanced Excel Training in Melbourne.

Bespoke

Users who require a blend of topics from different levels may choose to combine topics to create a tailor made Excel course. Ask about our free online 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

 

Suite 3, 6/49 Frenchs Forest Rd E, NSW2097

02 9454 7702