Exploring Data with PivotTables
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 Journey Context
Designed for experienced practitioners. We recommend having a solid grasp of Data Science fundamentals before starting this specialization.
Relevant for professionals pursuing roles within Data Science.
💡This course fits perfectly into our comprehensiveData Science Learning Path. Explore the ecosystem to see how it compares to other foundational skills.
Quick Facts
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.
Outcomes
- Course Overview : 1min.
- Creating Your First PivotTable : 26mins.
- Modifying PivotTable Formatting : 18mins.
- Choosing How PivotTable Values Are Presented and Displayed : 13mins.
- Creating New PivotTable Values : 10mins.
- Adding Grouping, Slicing, and Filtering Interactivity : 25mins.
- Exploring Other Excel Capabilities : 4mins.
FAQs
Top Alternatives
Highly-rated courses worth your attention
