Exploring Data with PivotTables

Focused View

Ben Howard

1:40:50

24 View

01 - Course Overview

01 - Course Overview.mp4

01:45

02 - Creating Your First PivotTable

02 - Introduction to PivotTables.mp4

06:51

03 - PivotTable Examples.mp4

06:54

04 - When to Use PivotTables vs. Standard Excel Tables.mp4

02:28

05 - PivotTables with Multiple Sources.mp4

01:00

06 - Demo - Creating Your First PivotTable.mp4

05:04

07 - Demo - Creating a PivotTable from Multiple Sources.mp4

04:37

03 - Modifying PivotTable Formatting

08 - Introduction to PivotTable Formatting.mp4

01:16

09 - Demo - Adding Fields to the PivotTable.mp4

03:02

10 - Demo - Modifying the Design.mp4

06:55

11 - Demo - Formatting PivotTables.mp4

05:26

12 - Formatting Summary.mp4

01:46

04 - Choosing How PivotTable Values Are Presented and Displayed

13 - Introduction.mp4

01:06

14 - Demo - Summarization Options.mp4

03:36

15 - Demo - Calculation Options.mp4

04:48

16 - Demo - Sorting PivotTables.mp4

03:14

17 - Summary.mp4

00:48

05 - Creating New PivotTable Values

18 - Creating New Values Using Calculated Fields.mp4

03:38

19 - Creating New Values Using DAX.mp4

05:34

20 - Summary.mp4

01:00

06 - Adding Grouping, Slicing, and Filtering Interactivity

21 - Introduction to Grouping, Filtering, and Slicing.mp4

01:46

22 - Demo - Grouping Fields.mp4

02:44

23 - Demo - Grouping Dates.mp4

05:54

24 - Filters and Slicers.mp4

03:09

25 - Demo - Filters.mp4

02:53

26 - Demo - Slicers.mp4

06:54

27 - Summary.mp4

02:04

07 - Exploring Other Excel Capabilities

28 - Exploring Other Excel Capabilities.mp4

04:38

Description

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.

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Data Analysis

Pivot Tables

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.