Excel PivotTables Part 1: PivotTables 101 | Chris Dutton | Skillshare

Playback Speed

• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x

# Excel PivotTables Part 1: PivotTables 101

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

### Lessons in This Class

44 Lessons (3h 3m)

3:26

2:21

1:14

4:10

2:00

3:13

7:43

1:33

5:14

7:30

6:49

3:39

2:12

1:41

5:30

2:20

1:16

6:51

2:13

5:01

2:01

8:15

3:15

3:10

2:42

3:23

4:25

4:51

4:13

4:45

3:49

3:35

3:47

3:02

4:42

2:44

2:36

8:06

6:30

4:32

7:20

4:19

6:11
• ### 44. The Solve Order & List Formulas Tools

4:54
• --
• Beginner level
• Intermediate level
• All levels
• Beg/Int level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

3,097

Students

1

Projects

This class is Part 1 of a three-part series covering data analysis with Excel PivotTables and PivotCharts.

PivotTables are an absolutely essential tool for anyone working with data in Microsoft Excel. Pivots allow you to quickly explore and analyze raw data, reveal powerful insights and trends otherwise buried in the noise, and provide fast, accurate and intuitive solutions to even the most complicated questions.

In Part 1 of this course, I'll show you when, why, and how to use PivotTables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and exercises every step of the way.

We'll cover everything you need to know to get up and running with PivotTables, including:

• Raw data structure
• Table layouts & styles
• Design & formatting options
• Sorting, filtering, & grouping tools
• Calculated fields, items & values

From there we'll take what we've learned and move on to Part 2, which introduces PivotCharts, slicers, timelines and custom dashboards. Finally we'll wrap up with Part 3, where we'll tie it all together and explore several advanced, real-world case studies!

Requirements:

• Microsoft Excel (2010, 2013, 2016), ideally for PC
• Mac users are welcome, but note that the PivotTable interface varies across platforms
• Basic experience with Excel functionality (charts & formulas a plus!)

### Chris Dutton

Founder, Excel Maven

Teacher

Chris Dutton is a Certified Microsoft Expert and Founder of Excel Maven, with more than a decade of experience specializing in data science and business intelligence. His work has been featured by Microsoft, the Society of American Baseball Research (SABR) and the New York Times.

Excel Maven provides high-quality online analytics training, hands-on workshops, and project-based consulting services to more than 100,000 students across 180+ countries.

See full profile

## Class Ratings

Expectations Met?
• Exceeded!
0%
• Yes
0%
• Somewhat
0%
• Not really
0%
##### Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects