Sandra asks:
“Any way to add a rank to a pivot table”?
DataPig Answers:
In Excel 2010, it’s really easy. In Excel 2007/2003, it’s a bit clunky.
Archive for the ‘Excel 2010’ Category
Add Rank to PivotTable
August 24th, 2010Excel 2010 Slicers
December 23rd, 2009A lull in the action this week gives me time to talk about the new features in Excel 2010 that strike me as real improvements.
Today, I want to share my thoughts on Slicers.
Excel 2010 Customizable Ribbon
December 22nd, 2009A lull in the action this week gives me time to talk about the new features in Excel 2010 that strike me as real improvements.
Today, we’ll take a look at Customizing the Ribbon in Excel 2010.
Excel 2010 Paste Special Commands
December 17th, 2009A lull in the action this week gives me time to talk about Excel 2010.
Every day this week, I’ll take time to blog about some of the new features in Excel 2010 that strike me as real improvements.
Today, I’d like to talk about the improvements in the Paste Special functionality in Excel 2010.
» More: Excel 2010 Paste Special Commands
Excel 2010 Week – PivotTable SubTotals
December 15th, 2009A lull in the action this week gives me time to talk about Excel 2010. So I’ve made this week, Excel 2010 Improvements week.
Every day this week, I’ll take time to blog about some of the new features in Excel 2010 that strike me as real improvements.
Today’s topic is the new ‘Percent of PivotTable SubTotals’ function in Excel 2010.
» More: Excel 2010 Week – PivotTable SubTotals
Excel 2010 Improvements Week – Data Bars
December 14th, 2009Christmas is coming soon and this week will be a slow work week for many of you. This lull in the action gives me time to talk about Excel 2010.
I’ve dubbed this week, ‘Excel 2010 Improvements week’. Every day this week, I’ll take time to blog about some of the new features in Excel 2010 that strike me as real improvements.
The first topic of the week is Data Bars.
» More: Excel 2010 Improvements Week – Data Bars
