Microsoft Excel - Pivot Tables
What you'll learn
- This course covers the use of Pivot Tables and Pivot Charts, one of the most powerful data analysis tools available in Excel. If you need to work with databases or tables in Excel and report on that data, chances are that Pivot Tables will provide the fastest way to report and build charts on that data.
- Intermediate knowledge of Excel
Excel Pivot tables provide a powerful way to summarise and report on vast amounts of Data. You’ll learn in detail how Pivot Tables work and the structure that must be followed to create useful reports and charts. This course is vital to gaining the most from this powerful feature of Excel.
Who this course is for:
- Anyone using Excel unfamiliar with Pivot Tables who is working with lists of data, perhaps filtering or sorting that data. Pivot Tables provide a powerful interactive way to query the data and summarise the results quickly and easily.
Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms.
Some of the world’s most prominent businesses choose us to teach their employees Excel – including Google, Facebook, Pfizer, Zurich, Aer Lingus, Allianz, HSBC, Intel, Dell, KPMG – even Microsoft use our Excel courses to train their employees on Excel.