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.
Author Name: Ben Howard
Author Description:
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 14 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.