Visualize Data with PivotCharts in Microsoft Excel

Focused View

Ben Howard

33:39

0 View

1-Understand the Basics of PivotCharts and Create Your First Chart

1 -An Introduction to PivotCharts.mp4

04:24

2 -Comparison of Chart Types.mp4

02:58

3 -Demo Create Your First PivotChart.mp4

03:36

2-Customize PivotChart Elements

4 -Demo Customize the Look and Feel of PivotCharts.mp4

05:02

5 -Demo Swapping Rows and Columns.mp4

02:22

6 -Demo Changing Data Values.mp4

03:11

7 -Demo Move and Position PivotCharts.mp4

03:40

3-Perform Interactive and Dynamic Analysis

8 -Demo Filtering, Drill Down, and Drill Up.mp4

05:49

9 -Demo Using Slicers.mp4

02:37

Description

Are you struggling to present data to your colleagues in a meaningful way? This course will teach you how to create and customize PivotCharts, what type of chart should be used in a certain instance, and how to provide interactivity on a chart.

What You'll Learn?

A picture is worth a thousand words, or in our case, a thousand data points! However, understanding the trend across a thousand, ten thousand, or even a million data points is difficult without some sort of summarization or visualization technique. In this course, Visualize Data with PivotCharts in Microsoft Excel, you’ll gain the ability to create stunning, interactive PivotCharts that allow you to tell the story of your data. First, you’ll explore how to create PivotCharts. Next, you’ll discover how to customize PivotCharts to enable you to highlight specific data points. Finally, you’ll learn how to add interactivity onto your PivotCharts. When you’re finished with this course, you’ll have the skills and knowledge of PivotCharts in Microsoft Excel needed to create and present the story behind your data.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Visualization

Ben Howard

Instructor's Courses

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.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.