This course advances the user's knowledge of functions, demonstrates how to manage data with Excel. The objective of this course is to provide delegates with a brief review of Microsoft Excel basics and then introduce the intermediate features of Excel. Delegates will be able to create, modify, enhance and print a wide variety of spreadsheets using their newly acquired skills.
The PD Training Microsoft Excel 2016 Intermediate Training Course is designed to provide a comprehensive understanding of the basic features of Excel 2016, and how to use them correctly to fulfill various tasks.
We use secure Video Conferencing with interactive features such as live polling, screen sharing, whiteboards, live chat and breakout sessions. Please discuss your preferred platform, most commonly we use Microsoft Teams, Skype for Business, Webex or Zoom upon request.
These courses are facilitated in English, and are open to people from different industries across the USA, Australia, New Zealand, Singapore, Malaysia and Hong Kong - this is a short but powerful learning experience that gives you global collaboration opportunities. Our trainers and processes have been refined to give you a personalised learning experience.
**Please note, these classes run to a very tight schedule, please follow the invitation and join the class 10-minutes prior to commencement so you are ready to participate and don't miss a minute!
Please click the In-House Training tab to receive a free quote for courses delivered at your preferred location.
This course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at an intermediate level.
After completing this course, participants will have learned to:
"I thought Steve was a great trainer - very enthusiastic and engaging. Made the day seem like fun, and we learnt quite a few excel tricks. Thanks for an informative and fun day."
The Kraft Heinz Company
"Course and trainer was great. I have learnt new functions which would be useful to my job."
The Kraft Heinz Company
"Steven was great. I wasn't expecting to learn as much as I did. Steven explained it very well, which made it easy."
National Stroke Foundation
"Very well presented, Trainer showed great enthusiasm in the way she presented the course."
Metcash
"I completed an identical course approx. 12 months ago and couldn't understand it at all The delivery and structure of the PD training course was put across in a way that I understood very well."
Costa's
"1. The hand book is using friendly in both electrical and printing version. 2. I like the pre-course questions, it helps to construct the class and focus on the main subjects the majority require to know."
AgriExchange Pty. Ltd.
"Paul was extremely knowledgeable and attentive. In Hindsight, I probably would've benefited from the Beginners course, as some of the content was above my Excel skills level."
"Paul was great in his presentation, the perfect pace to be able to keep up even if you miss typed something, but no too slow either."
"It was fantastic to have such an enthusiastic, knowledgeable trainer."
"Paul was a great trainer and taught us at a good pace and was very responsive to our needs."
University Of Melbourne - Melbourne Law School
"Everything that was covered is everything that I need moving forward. Sean was absolutely fantastic and catered for everyone in the training. He is an asset to PDT."
"The course was quite good and the trainer was excellent. The only reason for some of my lower scores was due to the nature of the class itself. I thought it was a bit basic and I would've preferred more advanced content. However that was more my misunderstanding than the fault of the course."
"This course was extremely helpful to myself and the team, we use excel regularly but we will now be able to get a lot more out of it."
Fujitsu General
"The trainer was very good and knowledgeable. Overall really great course which I would highly recommend to others."
BMW Group
"Steve is a ripping fella! Great deliverer and builds rapport with attendees."
Queensland Cricket
"Our trainer was very enthusiastic and happy to help, he delivered the course in a thorough attentive manner and was very helpful."
Catch Group
If you’re not happy with the outcomes from
the course we offer a money back guarantee
For every participant
valued at $199 each
No one left behind
with our 1/2 price re-run promise
12-months access to the unique REACH Future Proofing Personal Development Dashboard with personally curated learning to develop agility to adapt to different people tasks and situations.
Go further with Excel by learning to create advanced charts and formulas as well as learning time-saving formatting and visualisation features. Excel 2016 Intermediate Training Course is designed for students who are interested in going beyond basic skills and need to chart and format using Microsoft Office Excel.
After completing this course, participants will have learned to:
Topic 1
Creating Advanced Formulas
Topic 2
Analysing Data with Logical and Lookup Functions
Topic 3
Organising Worksheet Data with Tables
Topic 4
Visualising Data with Charts
Topic 5
Analysing Data with PivotTables, Slicers, and Pivot Charts
Topic 6
Inserting Graphics
Topic 7
Enhancing Workbooks
If you’re not happy with the outcomes from
the course we offer a money back guarantee
For every participant
valued at $199 each
No one left behind
with our 1/2 price re-run promise
12-months access to the unique REACH Future Proofing Personal Development Dashboard with personally curated learning to develop agility to adapt to different people tasks and situations.
We take care of all of the details, so you don’t have to:
At the completion of training participants are encouraged to create an action plan, and invite an accountability buddy via their Orgmenta App.
In your Training Management Centre you have transparency to the action plans so you can see what people are going to do differently.
Our systems and people make it easy to identify how you’ll be able to measure impacts and then report on the success in the weeks or months after training.
It’s surprisingly easy to make it so that your system can automatically be up to date with all the training record details you need.
The most important foundation for communication and building meaningful relationships is listening, develop your skills with this micro eLearning course.
Not exactly what you needed? Try other courses in the Live Online MS Office Courses Category
3158 3955
LOGIN
Register Now
Book a meeting
Request a quote