Virtual and Classroom Training
- All our courses are available virtually. We have also started a safe return to classroom training. Click here to learn more.
Overview
Level
Pivot Tables
Version
2016
What Will You Learn
In particular you will be able to:
About This Course
Technology advances have made it possible to store ever increasing quantities of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic Pivot Tables to summarize data. However, Excel is capable of doing a lot more. Being able to harness the power of advanced Pivot Table features and create Pivot Charts will help you to gain a competitive edge. You will be able to summarize data for you to analyze, and organize the data in a way that can be meaningfully presented to others. This can result in data-driven business decisions that have a better chance for success for the organization.
We can arrange your own private Excel course.
Have us build a custom private course tailored to your needs.
If you are looking to training a group of people private courses can be very cost effective.
Unlimited post course email support on the course topics.
Very clear instruction, pace was kept moving, great snippets of advice given.
This course was excellent and I am delighted with how much I have achieved. The trainer was very friendly and approachable.
Trainer was very engaging, spent time explaining topics clearly.
Very good introduction. Well paced and suited a range of experience levels.
The pace he delivered the course was perfect and he explained everything so clearly and in a way I could understand.
Really good trainer. He made the training interesting and fun.
Learn the basics of the M language and how to use Power Query to organise and query your data inside Excel.
This introductory Microsoft Excel course is ideal for beginners who want to learn how to produce spreadsheets, work with data and perform basic calculations.
This course has been developed for people wanting to use Excel to perform calculations with a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.