Visualizing Data with PivotCharts

Focused View

Ben Howard

1:18:18

55 View

0. Course Overview

0. Course Overview.mp4

01:45

1. Creating Your First PivotChart

0. Introduction to PivotCharts.mp4

03:18

1. Demo - PivotChart Examples.mp4

06:43

2. Fundamentals of PivotCharts.mp4

02:23

3. Demo - Creating PivotCharts.mp4

04:45

4. Summary.mp4

00:55

2. Modifying the PivotChart Formatting

0. Introduction to PivotChart Design and Formatting.mp4

01:20

1. Understanding the Chart Layout.mp4

02:29

2. Demo - Choosing a Chart Type.mp4

04:21

3. Demo - Selecting Styles and Colors.mp4

01:22

4. Demo - Switching Rows and Columns.mp4

02:37

5. Demo - Positioning a Chart.mp4

03:54

6. Understanding the Quick Layout and Elements.mp4

03:21

7. Demo - Layout and Elements.mp4

03:37

8. Summary.mp4

01:40

3. Changing How PivotChart Values Are Presented and Displayed

0. Introduction.mp4

01:39

1. Demo - Changing How Values Are Summarized.mp4

04:48

2. Demo - Sorting PivotTable Data.mp4

03:18

3. Demo - Changing the Calculation Options.mp4

03:09

4. Demo - Showing Running Totals.mp4

04:03

5. Summary.mp4

01:30

4. Adding Interactivity with Filters, Slicers, and Drill Down

0. Introduction.mp4

01:19

1. Filtering and Drilling into PivotCharts.mp4

04:25

2. Adding Slicers to PivotCharts.mp4

02:55

3. Summary.mp4

01:26

5. Exploring Other Excel Capabilities

0. Course Summary and Next Steps.mp4

05:16

Description

This course explores Excel PivotCharts that display a visual representation of PivotTables. The course shows you how to choose a PivotChart, select the data to visualize and modify the look and feel of the chart to meet your requirements.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Visualization

Excel

Excel Analytics

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.