Excel 101 - What Is A Pivot Table? Don't Fear The Spreadsheet: Episode 1626

3,674 views · Published 22 January 2013 · 3:23 · Indexed 26 October 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial:  What is a Pivot Table?

Welcome to the "Don't Fear the Spreadsheet" podcast, episode number 18. In today's episode, we will be discussing one of the most powerful features in Excel - the pivot table. I'm Bill Jelen from MrExcel, and I'm excited to answer a question from Tyler Nash about this amazing tool.

So, what exactly is a pivot table? Well, back in the 1990s, when pivot tables were first introduced, they revolutionized data analysis in Excel. With just a few clicks, you can easily summarize and analyze large amounts of data. For example, let's say you have a few hundred rows of data and you need a summary of revenue by region and month or year. With a pivot table, this is incredibly easy to do.

To create a pivot table, simply select a cell in your data set and go to the Insert tab. From there, click on "Pivot Table" and a new window will appear. Next, choose the fields you want to include in your pivot table - in this case, regions and dates. Then, add the revenue field to the values area. And just like that, you have a summary of revenue by region and date.

But that's not all - pivot tables offer even more powerful features. For example, you can group dates by year or month, add filters to see data for specific customers, and even double-click on a cell to create a new report with more detailed information. And the best part? Pivot tables can handle thousands or even millions of rows of data, making it the perfect tool for any data analysis task. So don't be afraid to dive into pivot tables and see what they can do for you. And if you want to learn more, check out our book "Excel for Beginners" - the perfect guide for mastering pivot tables and other essential Excel skills. Thanks for tuning in to the "Don't Fear the Spreadsheet" podcast, and we'll see you next time!

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/


Table of Contents:
(00:00) Explaining what a Pivot Table is
(00:38) History of Pivot Tables and their impact on data analysis
(00:48) Example of using a Pivot Table to summarize data
(01:02) Step-by-step guide to creating a Pivot Table
(01:30) Customizing the Pivot Table to show data by year or month
(02:10) Additional features and capabilities of Pivot Tables
(03:04) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Creating one-page summaries with pivot tables
Don't Fear the Spreadsheet podcast
Excel data analysis
Excel for beginners book
Field settings in pivot table
Group field in pivot table
Pivot table
Slicer in pivot table
Summary of regions
Total revenue by region


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

Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel -- 'Don't Fear The Spreadsheet' actually will. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner -- Tyler Nash -- with the answers provided by three (3) Microsoft MVPs specializing in and dedicated to teaching others Microsoft Excel, from the ground up -- Kevin Jones, Tom Urtis and Bill Jelen. http://www.mrexcel.com/dftss_home.html 

And for more information about Pivot Tables, see "Pivot Table Data Crunching: Microsoft Excel 2010" by Bill Jelen and Michael Alexander! http://www.mrexcel.com/2010Books/pvttdc2010.html 

"The Learn Excel from MrExcel Podcast Series"

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

More from this channel