Picture
   0412 751 159
Book a Training Session
MS Planet - Computer Training
  • Home
  • Microsoft Office Training
    • Microsoft Excel >
      • Microsoft Excel Beginners
      • Microsoft Excel Intermediate
      • Microsoft Excel Advanced
    • Microsoft Word >
      • Microsoft Word Beginners
      • Microsoft Word Intermediate
      • Microsoft Word Advanced
    • Microsoft PowerPoint >
      • Microsoft PowerPoint Beginners
      • Microsoft PowerPoint Advanced
    • Microsoft Outlook >
      • Microsoft Outlook Beginners
      • Microsoft Outlook Advanced
    • Microsoft Project >
      • Microsoft Project Beginners
      • Microsoft Project Advanced
    • Microsoft OneNote >
      • Microsoft OneNote Beginners
      • Microsoft OneNote Advanced
    • Microsoft Visio
    • Microsoft Teams
    • Microsoft Publisher
  • Microsoft 365
  • Upgrading Office
    • Microsoft 365
    • Office 2016
    • Office 2013
  • More Services
    • Onsite Training Options
    • Custom Software Training
    • Training Needs Analysis
  • Blog
  • About Us
    • FAQ's
  • Contact
Picture

Microsoft Excel

Advanced
Want to Learn More?
Customise Session
Book Now
Picture

Customised

Picture

Personalised

Picture

Convenient

Picture

Qualified

Picture
Customised
Picture
Personalised
Picture
Convenient
Picture
Qualified
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

    Microsoft Excel

    Customised Training Questionnaire for M.S Planet Computer Training

    WHAT DO YOU WANT TO LEARN?
    ​LIST THE TOP 3 TOPICS YOU MOST WANT TO LEARN IN TRAINING:


Submit

M.S Planet Computer Training specialises in delivering effective and affordable customised training across the suite of Microsoft programs and more.

"We offer a range of training options, working with our clients to create training solutions to improve the knowledge and productivity of their workforce."

​Contact us today to find out how our services can help your business →

Book a TRAINING SESSION
Picture
Nicole McClelland -
Principal Trainer/Owner,
​​M.S Planet Computer Training

Picture
© 2020 M.S. Planet Computer Training
Admin Login - Webmail

Designed by Jon Web Design and Powered by Sitebuilder.  


  • Home
  • Microsoft Office Training
    • Microsoft Excel >
      • Microsoft Excel Beginners
      • Microsoft Excel Intermediate
      • Microsoft Excel Advanced
    • Microsoft Word >
      • Microsoft Word Beginners
      • Microsoft Word Intermediate
      • Microsoft Word Advanced
    • Microsoft PowerPoint >
      • Microsoft PowerPoint Beginners
      • Microsoft PowerPoint Advanced
    • Microsoft Outlook >
      • Microsoft Outlook Beginners
      • Microsoft Outlook Advanced
    • Microsoft Project >
      • Microsoft Project Beginners
      • Microsoft Project Advanced
    • Microsoft OneNote >
      • Microsoft OneNote Beginners
      • Microsoft OneNote Advanced
    • Microsoft Visio
    • Microsoft Teams
    • Microsoft Publisher
  • Microsoft 365
  • Upgrading Office
    • Microsoft 365
    • Office 2016
    • Office 2013
  • More Services
    • Onsite Training Options
    • Custom Software Training
    • Training Needs Analysis
  • Blog
  • About Us
    • FAQ's
  • Contact