Microsoft Excel 2016 Intermediate - Online Instructor-led Training

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.


Microsoft Excel 2016 Intermediate - Online Instructor-led Training
Training courses for Live Online MS Office
Course name Length Outline Next class
Effective Time Management Using Outlook 2016 - Online Instructor-led Training 1.0 day course View schedule
Microsoft Excel 2016 Advanced - Online Instructor-led Training 1.0 day course View schedule
Microsoft Excel 2016 Intermediate - Online Instructor-led Training 1.0 day course View schedule
Microsoft Excel 2016 Introduction - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 Excel Essentials - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 OneNote Essentials Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 Outlook Essentials Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 PowerPoint Essentials Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 Training Part 1 - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 Training Part 2 - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 Word Essentials - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office OneNote 2016 Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office Upgrade 2016 Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Outlook 2016 Advanced Training Course - Online Instructor-led Training 1.0 day course View schedule
Microsoft Outlook 2016 Introduction Training Course - Online Instructor-led Training 1.0 day course View schedule
Microsoft PowerPoint 2016 Advanced Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft PowerPoint 2016 Introduction Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Project 2016 Advanced Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Project 2016 Intermediate - Online Instructor-led Training 1.0 day course View schedule
Microsoft Project 2016 Introduction - Online Instructor-led Training 1.0 day course View schedule
Microsoft Visio 2016 Advanced Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Visio 2016 Introduction Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Word 2016 Advanced Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Word 2016 Intermediate Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Word 2016 Introduction Training - Online Instructor-led Training 1.0 day course View schedule

Your Learning Outcomes

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:

  • Create advanced formulas
  • Analyse Data with Logical and Lookup Functions
  • Create and Modify Tables
  • Sort and Filter Data
  • Use Subtotal and Database Functions to Calculate Data
  • Visualise Data with Charts
  • Create Advanced Charts
  • Create a PivotTable
  • Filter Data by Using Slicers
  • Analyse Data with Pivot Charts
  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Customise Workbooks
  • Manage Themes
  • Create and Use Templates
  • Protect Files
  • Preparing a Workbook for Multiple Audiences
Duration: 1.0 day course Live Online Experts



Reviews

Microsoft Excel 2016 Intermediate - Online Instructor-led Training Reviews:

"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

 




Download Course Outline (PDF)

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.


Course Outline for Microsoft Excel 2016 Intermediate - Online Instructor-led Training

Topic 1
Creating Advanced Formulas
  • Apply Range Names
  • Use Specialised Functions
Topic 2
Analysing Data with Logical and Lookup Functions
  • Use Text Functions
  • Use Logical Functions
  • Use Lookup Functions
  • Use Date Functions
  • Use Financial Functions
Topic 3
Organising Worksheet Data with Tables
  • Create and Modify Tables
  • Sort and Filter Data
  • Use Subtotal and Database Functions to Calculate Data
Topic 4
Visualising Data with Charts
  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts
Topic 5
Analysing Data with PivotTables, Slicers, and Pivot Charts
  • Create a PivotTable
  • Filter Data by Using Slicers
  • Analyse Data with Pivot Charts
Topic 6
Inserting Graphics
  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Incorporate SmartArt
Topic 7
Enhancing Workbooks
  • Customise Workbooks
  • Manage Themes
  • Create and Use Templates
  • Protect Files
  • Preparing a Workbook for Multiple Audiences
 

In-House Training - We’ll focus on what matters most to you and tailor to your context


Face-to-Face, Live Online, or Hybrid Class Tailored to Your Needs

When you want a tailored learning experience targeting exactly what you want without bringing everyone physically together, the best choice is a Live Online Class run by PDT.

We tailor the content and activities to be specific to your current needs and the needs of the people and run the course in our usual activity-based workshop style training, however, the participants can all be offsite, or some can be in the room with others offsite.

Unless you have a preferred tools we use 'Zoom for Education' that includes enhanced collaboration features such as One-click content sharing, real-time co-annotation (people can work together in activity files), and digital whiteboarding, we also include things like live polls and group chats so you virtually have the same collaborative learning experience of attending a course in a room with other people.

live online & hybrid

We have delivered these 100's (if not 1000's) of times, and get great outcomes. We achieve great outcomes because we keep our learner centric approach - just because it’s delivered through a screen to some or all participants doesn’t mean it needs to be less tailored or less personalised.

You still have an expert trainer who talks to you prior to the session and tailors the delivery to use your terminology, ensure activities are relevant and directly applicable and ensures an engaging learning experience that provide people with skills and techniques they can apply the very next day.

A hybrid class is with some people connecting online, and some people physically together in the same room.

Live Online Participant Feedback:

90% Overall Trainer Rating

88% Delivery was Adapted to me Personally

75% I Would Recommend this Course to Someone Else

Face to Face Options With Everyone in the same room

1-hour Motivator
one hour motivator
3-hour Power Sessions
3 hour power session
Full-day training
full day training
Conferences
Conferences
At your workplace At your workplace
In our Training Rooms In our Training Rooms
 In our Online Training  Room - the HIVE In our Online Training Room

We’ll make things easier so you can focus on adding more value

PDT Training Management Centre Logo

We provide the Training Management Centre which is an information hub before, during and after training.
(Let us know if there’s parts you don’t want to use)

Invites people to training

(So you don’t have to)

Invite People icon

Generates Sign in Sheet

(So you don’t have to)

Generate Sign In Sheet Icon

Generates Branded Flyer

If you want to ‘promote’ internally

Generate Branded Flyer Example

PDF’s of Certificates

(can be co-branded with your logo)

Completion Certificate Included

Collects and Reports feedback

(So you don’t have to)

Feedback Report Example

Complete Results Dashboard

(including trainer insights)

Results Dashboard Example

What are people going to do differently?

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.

My Action Plan
Participants encouraged to create

Want to get clear on impacts and measure success? Our system and expert consultants support you.


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.

Measure metrics your way

Do you already have a training management system and wish they were automatically up to date?

Training APIs

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.

More than just a training provider - we are your Learning and Development Partner, we look forward to working with you, talk to one of our friendly expert consultants today.

Outstanding learning that people can do in the flow of work

  • Fresh targeted video-based microlearning content with interactive lessons and quizzes included.
  • Rigourous review process
  • Only $11.00 per course per person per year.
  • Or get the $110.00 bundle and save.
Bite Size learning that people love
Not exactly what you needed? Try other courses in the Live Online MS Office Courses Category