Onsite Excel Training Sydney, Melbourne, Canberra, Brisbane

Excel Training at Your Offices
Get a Quote
onsite excel training sydney

Onsite Excel Training Sydney 

Trainers Direct specialises in short onsite Excel training courses tailored to your needs. Our trainers are experts in delivering Excel training at your workplace in a flexible format for individuals and teams. Our trainers travel all over New South Wales as well as other major states.

Trainers Direct also delivers short Excel courses in Western Sydney with a uniquely small class size. View Parramatta Excel Course Dates.

We Provide:-

Hands on customised Excel Training courses for professionals in Sydney 

Tailored Excel training and a free training needs analysis

Flexible content enabling you to train different  groups of users on several topics over a day

Cost effective solutions 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. Trainers Direct are the leading trainers for delivering short courses in Excel. We also offer Excel training in Melbourne, Canberra and Brisbane.

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

Microsoft Online Best Sellers

Microsoft Excel – Excel from Beginner to Advanced
Microsoft Excel – Advanced Excel Formulas & Functions

Microsoft Excel – Data Analysis with Excel Pivot Tables

View our Prices page or Get a Quote

Level 1 - Introduction

Onsite Excel Training Sydney

Our introductory level Excel training 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

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 if you already know formulas and functions.

If you’re looking for classroom short courses in Excel, view our Classroom Dates.

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.

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

Advanced MS 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

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.

What you will learn

  • Build complex calculations with advanced functions including lookups
  • Link and consolidate data
  • Restrict data entry with data validation 
  • Importing, exporting and cleaning data 
  • Create and modify Macros

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
    • Stepping through a Macro
    • Macro buttons
    • Customising the toolbar
    • Writing a line of code
    • Deleting a Macro

We also offer vVisual Basic VBA training courses 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.

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

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.

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

Download Excel Keyboard Shortcuts
EXCEL KEYBOARD SHORTCUTS MAC
EXCEL KEYBOARD SHORTCUTS

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

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