Beginners

Intermediate

Advanced

Advanced Excel

So, you’ve been using Microsoft Excel for awhile and want to learn more?

Perhaps you’ve been using LOOKUP functions but don’t really understand how they work – let alone use them with other functions.

In this course, students will learn about some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing your data with other people, analysing data, and using Excel data in other applications.

What do you need help with:

• Understanding exactly how LOOKUP Functions work
• Combine Functions to analyse data
• Learn more about Pivot tables
• Efficiently analyse large amounts of data
• Summarise data using Excel Tables
• Consolidate data from multiple workbooks
• Hide or display data to show summary totals
• Control data entry using data validation

​
This course aims to provide you with the skills and knowledge necessary to use the majority of Excel’s analysis tools for modelling and manipulating data.

Topics Covered

• Using Range Names
• Using complex Functions (eg. VLOOKUP and Nested Functions)
• Adding Data Validation
• Create Outlines (Groups)
• Use Data Consolidation to create summary tables
• Insert Subtotals
• More options for manipulating Pivot Tables
• Using What If Analysis Tools
• Introduction to Macros

And don't worry if you're not sure what level you are at. Check out our list of topics to see which ones you are interested in and we can customise a course to suit. How clever are we!

Want to customize your own course?

Click Here to Customize!

"I attended the Excel training session yesterday, and was amazed at how much I learnt - this is in no small way due to the high calibre of the instructor who has done an absolutely fantastic job at each course I attended.

​A more friendly, pleasant and professional person you could not wish to meet! To be able to convey so much wisdom in such a clear and understandable way is a credit to her."
​
KEVIN ADAMS - MUSEUM VICTORIA

"M.S Planet Computer Training was relevant, practical, able to match the varying skills of the participants and have everyone come out with the 'WOW' factor and feeling like real improvements in the way we do things is achievable. The staff all enjoyed the training. At no point did anyone feel that something was beyond them or beneath them. This is a significant achievement in a diverse group. We would definitely choose M.S Planet for our future computer training."
TANYA GILCHRIST
CEO
SAMARINDA AGED SERVICES​

"I will reiterate the comments I have previously made about Nicole, in that I like that her sessions have structure but she's very open to being flexible and dealing with people's questions as they come up. 
She's a very clear communicator. I think she's great."
[NAME WITHHELD]
MUSEUM VICTORIA