Exploring Data with PivotTables

by Ben Howard

This course explores Excel PivotTables, explaining how they are used to summarize and analyze data. The course shows you how to create, modify, and configure PivotTables to take your raw data and turn it into useful and insightful information.

What you'll learn

Learning how to summarize and analyze large and complex sets of data, and communicating the results, can be a daunting process. In this course, Exploring Data with PivotTables, you will gain the skills required to quickly summarize and present sophisticated sets of data. First, you will learn what PivotTables are and when you should use them. Next, you will discover how to create PivotTables and change their layout, look, and feel. Finally, you will explore how to add new derived values and custom groups of data, and how to restrict the data that is displayed using interactive slicers and filters, helping you answer all those difficult data related questions that your co-workers and managers keep asking! When you’re finished with this course, you will have the skills and knowledge to use Excel PivotTables in order to summarize, analyze, and present your Excel data.

About the author

Ben is a Power BI & Data Specialist with a healthy interest in Microsoft BI and planning tools. He has over 30 years of customer and implementation experience, has been a Microsoft MVP for 13 years, is a frequent speaker at several European conferences, and blogs and creates videos on a semi-regular basis. He is actively engaged in providing consultancy to UK FTSE companies, and co-runs the Manchester Power BI User Group.

Ready to upskill? Get started