Microsoft PivotTable

Analyse and present data quickly and easily using Pivot Tables.

Learn to harness the power of Excel’s PivotTable™ with this course. We will take you step-by-step from the basics through to dominating your data.

Why Pivot Tables?

Excel can feel daunting – in particular, the infamous PivotTable™ function, which is widely spoken about and little understood. In the simplest terms, it allows you to automatically sort data from one table and present it in another, the pivot table.

But pivot tables can be far more sophisticated than that, and thanks to their flexibility and analytical clout are widely considered Excel’s most powerful tool.

What you get with this Mircosoft Excel PivotTable course:

• 39 modules of training that teach you to master the PivotTable™ function
• Multiple videos, practice exercises and test questions to aid your learning.
• You’ll be confident using a pivot table to analyse complex data sets after completing this course.

In this course you will learn:

• The primary uses of pivot tables
• How to identify the best and worst data sets
• To filter, sort and group PivotTable™ data to maximise its usefulness
• How to present your data clearly using PivotCharts and Conditional Formatting

Sample content:

More about us:

• We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
• We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
• Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
• Our platform is award-winning and improving all the time.
  

If you are not 100% happy with your EwB Microsoft PiovtTable course, you have 30 days to exchange or refund.

About the author:

Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

Syllabus:

Reviews: