Explore Data with PivotTables in Microsoft Excel

Focused View

Ben Howard

46:48

0 View

1. Create Your First PivotTable

1. Understand and Create Your First PivotTable.mp4

04:01

2. Demo - Create Your First PivotTable.mp4

07:30

3. Demo - Create a PivotTable from Two or More Data Sources.mp4

04:03

4. Styles and Layouts.mp4

07:49

2. Analyze and Find Answers Using a PivotTable

1. Change How Values Are Displayed.mp4

03:41

2. Group Your Data Fields.mp4

06:16

3. Derive New Values Using Formulas.mp4

03:36

4. Apply Filters and Slicers.mp4

07:09

5. Learn to Sort Your Data.mp4

02:43

Description

Do you feel like you're drowning in data? This course will teach you how to create and customize PivotTables, filter and sort data, use calculated fields, and generate insightful reports to enhance your decision making.

What You'll Learn?

Around 90% of the world’s business data is held in Excel and it’s one of the most widely used tools for data storage, analysis, and reporting due to its versatility and ease of use. However, the sheer quantity of data in an Excel report can make gaining meaningful insights at best difficult and at worst impossible.

In this course, Explore Data with PivotTables in Microsoft Excel, you’ll learn to easily summarize and gain insights into large Excel datasets.

First, you’ll explore how to create PivotTables.

Next, you’ll discover how you can analyze the data in a PivotTable, creating SUMS, averages, and more.

Finally, you’ll learn how to filter and sort data in a PivotTable, allowing you to quickly find answers to specific questions.

When you’re finished with this course, you’ll have the skills and knowledge of PivotTables needed to gain meaningful insights into large Excel datasets.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

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.