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.
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.
Ben is a Microsoft Project, Project Server/Online consultant, and Data Specialist with over 20 years of implementation experience. He has been a Microsoft MVP for nine years, as well as blogging on various project server scenarios, has articles published on the Microsoft Project User Group (MPUG), and is the author of Microsoft Project 2013 Plain & Simple.
Course Overview Hello, everyone. My name is Ben Howard, and welcome to my course, Exploring Data with PivotTables. I'm a data consultant, and I'm constantly analyzing, summarizing, and generally exploring data in order to gain useful insights from it, and then presenting that data and the results to my clients and customers. Excel has been around for many years, but the features regarding data analysis are relatively new. I find that PivotTables are typically the first advanced data analysis feature that many users will come across and attempt to use. This course will start by explaining what a PivotTable is and when you should use them, and then moves on to correcting PivotTables, changing their layout, look and feel, and then we explore how to create new derived values and add custom groups of data. Finally, we add end‑user interactivity to the PivotTables using filters and slices. At the end of this course, you'll be able to use PivotTables to analyze and summarize your data and present it in a meaningful way that provides clarity and insight into that data, thereby turning the data into useful information. This course provides solid and effective demonstrations that will allow you to quickly get to grips with PivotTables. In terms of prerequisites, they're pretty easy. You should be familiar with working with and entering data into Excel and understand the concept of rows and columns. I hope you'll join me on this course, Exploring Data with PivotTables, at Pluralsight.