Excel Courses Melbourne Onsite Training for Professionals
Trainers Direct Excel training courses in Melbourne are designed for businesses who need flexible training in the workplace
Choose from a huge list of subjects combining intro, intermediate and advanced course levels
Break the day into several sessions to cater for different staff members and abilities
Benefit from a free training needs analysis and lifetime membership of our support forum
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 BaileyOnsite Training
Book an onsite group course at your offices with flexible content
Online Courses
Get the best discounts for online training through our partner, Udemy.
Microsoft Excel Introduction
Microsoft Excel – Advanced Excel Formulas & Functions
Learn Vlookup in Less Than One Hour
Data Modelling and Analysis with Excel Power Pivot
Excel Financial Modelling and Valuation
Excel VBA: The Beginner’s Guide to Programming Excel
View our Prices page or Get a Quote
Level 1 - Introduction
Excel 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 5/49 Frenchs Forest Road East Frenchs Forest NSW 2086
Email: trainers@trainers-direct.com.au
Tel: 02 9454 7702
Sitemap
FOLLOW US