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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920