Look Who it Was Random video

Excel Rev Up - Pivot Table 2010: Episode 1340

2,304 views · Published 14 February 2011 · 3:50 · Indexed 7 October 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial: Excel Pivot Table: New Features and Improvements | MrExcel Podcast.

Welcome to the MrExcel podcast. In this episode, we're diving into the world of pivot tables in Excel 2010. As many of you know, I believe pivot tables are one of the coolest features in Excel and I could talk about them for hours. However, today we'll be focusing on some of the brand new features in Excel 2010 that make pivot tables even more powerful and user-friendly.

First, let's take a look at the layout of a pivot table. We have our data on one side, and four drop zones on the other: report filter, row labels, column labels, and sum values. In Excel 2010, they introduced a new compact layout, but I personally prefer the old tabular layout from Excel 2003. It's important to have the row labels in separate columns for easy copying and pasting of data. Luckily, Excel 2010 has a feature that allows us to fill in those blank cells that always seemed to be a hassle before. Simply go to the design tab and select "repeat all item labels" to fill in those blanks.

Another great addition in Excel 2010 is the ability to change the calculation of values in a pivot table. Under the "show values as" option, we now have access to some new calculations such as percentage of parent row total and rank. These were previously buried and hard to find, but now they are easily accessible and make analyzing data even easier.

But perhaps the most talked about feature in Excel 2010 pivot tables is the visual filter called a slicer. With a slicer, we can easily filter our data by selecting different options from a list. This makes it much easier to analyze specific data without having to manually filter through the pivot table. And the best part is, the slicer is linked to the pivot table, so any changes made in the slicer will automatically update the pivot table.

There are many more improvements and features in Excel 2010 pivot tables that we could go on about, but these are just a few of the highlights. I've done numerous podcasts on pivot tables in the past, so be sure to check those out for more in-depth discussions. Thank you for tuning in to this episode of the MrExcel podcast, and we'll see you next time for more Excel tips and tricks.

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) Importance of Pivot Tables
(00:23) New Features in Excel 2010
(00:33) Adding Row Labels and Values
(00:43) Using the Pivot Table Field List
(01:00) Changing the Report Layout
(01:30) Filling in Blank Cells
(01:50) Changing Calculations
(02:14) New Calculation Options
(02:58) Filtering with Slicers
(03:33) 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:
Changing calculations in Excel
Excel features
Excel report layout
Filling in blank cells
Improvements in Excel 2010 pivot tables
Percentage of parent row total
Pivot tables
Ranking values in Excel
Using slicers to filter data
Visual filter (slicer) in Excel


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


Today, in Episode #1340, Bill looks at Pivot Tables in Excel 2010. While reviewing new features in Excel 2010, learn how to fill in blanks in the row area, change a calculation to % of parent row, create Rank results, and learn about Slicers

More from this channel