Microsoft Excel Advanced

Advanced Microsoft
Excel Training

Customised Excel Advanced Training

Customised

Face to Face Excel Advanced Training

Face to Face

Live Online or Onsite Excel Advanced Training

Live Online or Onsite

Qualified Excel Advanced Trainers

Qualified

Advanced Excel Training Course

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


I need help in Microsoft Excel with:

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

​

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.

Microsoft Excel 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 customise your own Microsoft Excel course?

GET STARTED

  • "One of the most useful trainings I've ever completed that will allow me to use Excel more productively and efficiently.

     

    I wish I'd done it sooner. 


    Nicole was a brilliant and engaging virtual facilitator."


    Mel - LivaNova


  • "Nicole was awesome. 


    The pace was perfect, not too quick or too slow. Nicole checked in often to ensure we were all still along for the ride. 


    The explanations were clear and it made it a joy to learn Pivot tables! Thank you!"


    Don - City of Casey Council

  • "I have never used OneNote before. Now I know where I can make random notes into an organised one. 


    That's gonna increase my work efficiencies a lot!"


    Ivan - City of Casey Council

  • "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."


    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. 


    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


  • "I was able to follow along easily. I actually thought that doing the training online like this was better than sitting in a room in person. 


    I felt like I got more out of training this way than I would have in person. I think I was more focussed."


    Dianne N - City of Casey Council

  • "Thank you very much for the training - I have gained so much from it.


    You have a wonderful and patient way of teaching which makes it so much easier to understand. 


    I certainly hope to do more training with you in the future."


    Denise - LivaNova

  • "#MINDBLOWN"


    Beck S - City of Casey Council

  • "Acquired useful knowledge about how to retrieve useful data in the view that I feel comfortable with in Pivot Tables. 


    Easy!"


    Ivan - City of Casey Council

  • "Excellent training session - well done Nicole. 


    Loved the tips the best on how to manage it!"


    Amalka - City of Casey Council

  • "We have received positive feedback from your style of training and ability to explain concepts in simple terms."


    Adrian L - Yarra Ranges Council

  • "Hi Nicole – thanks for the user guide, and for a terrific training session. 


    I wouldn’t hesitate to recommend you to others – you were knowledgeable, patient and lovely to deal with. 


    Thank you for your assistance!"


    Elizabeth H - Navy Health

  • "Took away way more than I ever expected to. 


    Would recommend this course to anyone who uses outlook regularly. 


    Nicole was very engaging and helpful with her advice and knowledge"


    Zoe P - City of Casey Council

  • "I have had some really wonderful feedback from the team in regards to the intermediate excel training you provided. 


    It has been reported to me that both the content and the delivery were done in a way that everyone could follow and feel that they gained something."


    Jody K - Yarra Ranges Council

  • "I just wanted to say how much I enjoyed the Excel, Outlook and OneNote courses yesterday with Nicole.  


    She really is an excellent trainer and the things which she covered will really allow me to work smarter"


    Name Withheld - Bayside City Council

  • "Thank you for the professional and knowledgeable courses provided by you. 


    I have heard nothing but positive feedback in regards to your online training in all M365 modules."


    Craig W - Yarra Ranges Council

  • "Working with Long Documents in Word - This session is brillian!"


    Kelly S - City of Casey Council

  • "Just wanted to say how great a trainer Nicole is for 365.  Really works for me."


    Debbie N - Yarra Ranges Council

  • "We received great feedback on the training sessions provided, the staff were able to get a lot out of the sessions. 


    Thank you for providing such a great service."


    Phillip O - Bayside City Council

  • "A huge thanks to Nicole. The custom user guide will be an invaluable resource for us to refer people to on topics of metadata etc. 


    Thanks again for your training session In SharePoint too - it was great."


    Simon W - Dept of Parliamentary Services

  • "An excellent webinar on the basics of Excel. Extremely detailed and all topics were well explained. 


    Nicole did not rush through any of the material (unlike other instructors), and was happy to re-explain topics if an attendee was facing any difficulties.


    I have absolutely no complaints - 10/10!"


    Name withheld - Parliamentary Services

  • "I really enjoyed the Word training, it’s going to make such a difference . 


    I wonder how many people use it like I have been and curse it, without realising that even with just those tips from today’s session , they could do so much more . . ."


    Leah G - City of Casey Council

  • "I have received very positive feedback from the Parks team and they have all said that the sessions have been excellent."


    Neda R - Glen Eira Council

  • "Just a quick note to say how good Nicole McClelland’s training was this morning for One Note - Beginner. I got a lot out of it and being new to One note, her explanation and guidance was great. 


    Her examples were easy to follow and I can see myself utilising this program well."


    Lisa - City of Casey Council

  • "Great session this morning! 


    The pace was perfect for an intro course and the way you explain why people would do things is really valuable. 


    The web part section was excellent as this is where I get most questions on Help Desk! This and site access and sharing documents."


    Simon W - Dept of Parliamentary Services

  • "Nicole was a great teacher. Great to be actively trying the skills during the course. 


    OneNote is a fabulour program."


    Emma S - Kingston City Council 

  • "Nicole is fantastic, the first session was great. I look forward to the next."


    Name Withheld - Bayside City Council

  • "Thank you for the Teams session. The introduction was simple to comprehend and instruction was on point. 


    It was straight forward and I was able to navigate on my own. 


    I look forward to future training. Please thank Nicole."


    Miah - Museum Victoria

  • "I have recently attended a few of your training sessions which were amazing, so thankyou for making your sessions so user friendly. "


    Leeanne H - City of Casey Council

  • "Thanks very much for the M365 training. I thought it was the most informative and enjoyable IT training I’ve participated in. 


    The presenter was great, responsive and personable – and I enjoyed seeing and hearing from some of our lovely MV team.


    Thanks again from a normally reluctant IT related training participant."


    Name Withheld - Museum Victoria

  • "I received great feedback on your presentation style! 


    The team really enjoyed how interesting you made the topic and provided great responses to their questions etc."


    Phoebe C - Mercedes Benz Australia

  • "Nicole was great. I really enjoyed the course. She is very effective teacher who manages to keep your attention - even on Zoom! 


    I learned a lot."


    Benjamin  - Parliamentary Services

  • "We received really good feedback from everyone that attended the Microsoft Project course. 


    They were very pleased with your delivery method and got a lot out of the course, so thanks heaps."


    Jenna S - McCormack

  • "Thank you so much for your time the recent Microsoft Project training. 


    The feedback has been astounding!"


    Laura M - Yarra Ranges Council

  • "Thank you for the training in OneNote. I will be using OneNote more effeciently now. 


    Nicole presents the information in a very clear manner and is very easy to follow."


    Priya P - Kingston City Council

  • "I now know how to setup OneNote appropriately and use it and share with other staff. 


    Nicole was very informative and engaging."


    Sharon M - Kingston City Council

  • "I believe the team all took a lot away from the sessions and we’ve had nothing but positive feedback from the business."


    Jimmy F - LeasePlan

  • "Thank you for the recent training sessions. 


    There was great feedback from the course – you were complimented on your manor and clear explanation."


    Marina H - Eastern Health

  • "Training was fantastic. Great to learn the better ways of doing things in Excel."


    Mel C - LivaNova

  • "Having attendedthe some sessions myself, I also wanted to personally say thanks for very helpful and informative sessions – picked up some great tips that will really benefit me daily."


    Ilsa M - Bayside City Council

  • "Wonderful course and wonderfully delivered. Made Excel fun as well as much more useful."


    Andrew - Parliamentary Services

  • "Time well spent with a very good trainer! 


    Would recommend to anyone wanting to learn more about Excel."


    Name Withheld

  • "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."


    NAME WITHHELD - MUSEUMS VICTORIA

  • "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