Description
Course info
Rating
(31)
Level
Advanced
Updated
Dec 11, 2019
Duration
1h 18m
Your 10-day individual free trial includes:

Expert-led courses

Keep up with the pace of change with thousands of expert-led, in-depth courses.
Description

A picture is worth a thousand words, and PivotCharts are no exception, providing a neat way of visualizing the data from a corresponding PivotTable. In this course, Visualizing Data with PivotCharts, you will gain the skills to quickly produce charts to a professional standard, which neatly summarize the associated PivotTable, allowing you to visualize the data and spot any trends within it. First, you will learn what PivotCharts are and the different types of charts available for you to use. Next, you will discover how to create PivotCharts, choose the correct chart type, and finesse the look and feel of the chart. Finally, you will explore how to make the chart truly interactive by adding filters, slicers, and drill-up/drill-down capability, helping you answer all those difficult data-related questions that your coworkers and managers just keep on asking! When you are finished this course, you will have the skills and knowledge to use Excel PivotCharts in order to professionally present your data.

About the author
About the author

Ben is a Power BI & Data Specialist with a healthy interest in Microsoft Project with over 30 years of customer and implementation experience. He 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.

More from the author
Analyzing and Visualizing Data with Power BI
Intermediate
1h 26m
Oct 12, 2021
Optimize Power BI Reports for Mobile Devices
Intermediate
1h 45m
Jan 15, 2021
More courses by Ben Howard
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello everyone, my name is Ben Howard, and welcome to my course, Visualizing Data with PivotCharts. They say a picture is worth a thousand words, and PivotCharts are no exception, providing a neat way of visualizing the data from a corresponding PivotTable. In this course, Visualizing Data with PivotCharts, you'll gain the skills to quickly produce charts to a professional standard, which neatly summarize the associated PivotTable, allowing you to visualize the data and spot any trends within it. First, you'll learn what PivotCharts are and the different types of charts which are available for you to use. Next, you'll discover how to create PivotCharts and choose the correct chart type and finesse the look and feel of the chart. Finally, you'll explore how to make the chart truly and fully interactive by adding filters, slicers, and drill‑up/drill‑down capability, helping you answer all of those difficult data‑related questions that your coworkers and managers just keep on asking. When you've finished the course, you'll have the skills and knowledge to use Excel PivotCharts in order to professionally present your data. In terms of prerequisites, it would be an advantage if you're familiar and comfortable with manipulating data in PivotTables. I hope you'll join me on this course, Visualizing Data with PivotCharts, at Pluralsight.