Excel Pivot Mastery: Summarize data using a Pivot Table - Episode 2191

2,565 views · Published 13 April 2018 · 1:39 · Indexed 31 October 2026

Channel: MrExcel.com · 2018 · Education

Watch on YouTube

Microsoft Excel Tutorial: Summarizing Data in Excel Using a Pivot Table

Welcome to another episode of the MrExcel Podcast, where we dive into all things Excel. In today's episode, we will be discussing how to summarize data using a Pivot Table. This is the final installment of our Summarized Data Week, where we have explored five different methods to create a summary report with one line per customer. And let me tell you, Pivot Tables are definitely the fastest, easiest, and coolest way to achieve this.

Now, you may be wondering why we didn't start with Pivot Tables first. Well, that's a great question. The truth is, there are so many different ways to summarize data in Excel, and sometimes it's easy to overlook the simplest solution. But don't worry, we're here to show you just how powerful and efficient Pivot Tables can be.

To get started, simply select one cell in your data, go to the Insert tab, and click on Pivot Table. Accept all the default settings and click OK. A new worksheet will be created to the left of your original data set, where your report will be built. From there, all you have to do is choose the fields you want to summarize, such as Customer, Quantity, Revenue, Profit, and Cost. With just nine clicks, your summary report will be ready to go.

If you want to learn more about the other methods we have covered this week, be sure to check out my book, MrExcel LIVe: The 54 Greatest Excel Tips of All Time. You can find a link to it in the top right-hand corner of this video. And don't forget to tune in tomorrow for our final episode, where we will recap all five methods and give you the chance to vote for your favorite. Thank you for watching, and we'll see you next time for another netcast from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

#excel
#microsoft
#microsoftexcel
#exceltutorial
#exceltips
#exceltricks
#evergreen
#excelpivot

This video answers these common search terms:
how to create a pivot table in excel
how pivot table in excel
how a pivot table works excel
how do pivot table in excel
how to pivot table in excel

Table of Contents:
(00:00) Summarize with a Pivot Table
(00:18) Step-by-step guide to creating a Pivot Table
(00:46) Pivot Tables are the fastest and easiest method for summarizing data
(01:02) Recap of the five methods discussed in the book
(01:12) Clicking Like really helps the algorithm

This is the fifth of a five-part series on Summarizing Data
This week, I will cover Subtotals, Remove Duplicates, Advanced Filter, Consolidate, & Pivot Tables
How to summarize with a pivot table
1. Select one cell in your data.
2. Insert, Pivot Table, OK
3. Checkmark Customer, Quantity, Revenue, Profit, Cost
9 Clicks and you will have your result.
Stop back tomorrow for a chance to vote for your favorite method.

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1154020/

More from this channel