Learn Excel – Pivot Table Formatting: Podcast #1347

February 24, 2011 at 3:53 pm

Dealing with Pivot Tables can be frustrating. Today, Linda asks how to fix some Pivot Table formatting. Linda would like to get rid of “Sum of” and “Count of”; she also wants to format all of the numeric fields with currency instead of general formatting. In today’s  Episode [#1347], Bill shows several ways to achieve the desired results.

"Learn Excel 97-2007 from MrExcel" by Bill Jelen…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

If you need more information concerning Pivot Tables in Microsoft Excel 2003, 2007 or 2010:

Pivot Tables in Excel 2003 see Pivot Table Data Crunching

Pivot Tables in Excel 2007, see Pivot Table Data Crunching Excel 2007

Pivot Tables in Excel 2010, see Pivot Table Data Crunching: Microsoft Excel 2010


Entry filed under: Learn Excel 97-2007, Learn Excel from MrExcel, MrExcel Podcast, MrExcel Products, Pivot Tables. Tags: , , , , , , , , , , , , , , , , .

Learn Excel – Many Pivot Charts: Podcast #1346 Dueling Excel – Match Month: Podcast #1349

Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 742 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive

%d bloggers like this: