How to Create Pivot Tables in Excel

In this step-by-step tutorial for beginners, learn how to create a pivot table in Microsoft Excel. With an Excel Pivot Table, you can very quickly and easily analyze data without needing to use any formulas or functions.

You can generate insights just by dragging and dropping fields. We start with how to prep your data and then walk through all the core functionality of pivot tables, including sorting, filtering, inserting charts, slicers, timelines, and more. By the end of this tutorial, you'll be confident using pivot tables in Excel.

Exercise workbook to follow along:

https://1drv.ms/x/s!AmxrofZZlZ-whO06Y...

Excel for Beginners course:

https://kevinstratvert.thinkific.com/

More about PivotTable

Create a PivotTable to analyze worksheet data

A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. PivotTables work a little bit differently depending on what platform you are using to run Excel.

https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576

Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)

Discover hidden productivity tips when working with Excel Pivot Tables. At first Pivot Tables might seem like a complex tool but they are one of Excel's EASIEST features to work with. They help you summarize data really FAST.

https://www.youtube.com/watch?v=UsdedFoTA68

In this Video

00:00 Introduction

00:41 Overview of data

01:56 Prep data

02:48 Turn data into table

03:43 Insert pivot table

04:16 Pivot table interface

04:59 Build basic pivot table with rows and values

06:27 Change formatting

06:40 Summarize values by

07:59 Remove fields

08:43 Sorting

09:47 Filtering

11:03 Show values as

11:54 Custom field headers

12:19 Multiple rows

12:50 Columns

13:30 Design

14:13 Pivot charts

14:44 Insert slicer

15:25 Insert timeline

15:56 Copy pivot table

16:13 Calculated fields

17:25 Refresh for new data

18:20 Source data

18:33 Recommended and Analyze Data

20:02 Wrap up