How to Use GetPivotData

Michael sends in a great tip today about pivot tables. While Excel 2007 replaced the drag and drop feature with drop zones, there is an obscure setting in Excel 2007 that will let you go back to the old drag and drop method. Episode 1058 shows you how. This 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!

- Don't use HLOOKUP...just turn the table back to a vertical table using the two methods shown in Episode 1125.

- A dueling podcast...how to find the first week of the month. Mike and Bill show you various ways in Episode 1129.

Excel Lessons - Using a Pivot Table - A big car company offered a boat load of money to put an annoying ad in this podcast for the next two months. Rather than sell out, a reminder that the podcast is sponsored by the MrExcel.com store. Then; a fast way to group age data using a pivot table. Episode #950 shows you how.

Jason from Texas asks about formatting percentages in a pivot table. I thought this would be an easy question, but Jason wants to format the grouped percentages in the row area of the pivot table. Episode 912 talks about grouping in a pivot table but doesn't come up with a good solution to the problem.

- Learn how to increase the size of the text in a chart at once. Episode 1131 shows you how.

Excel Lessons - Grouping Ages - Steve asks how to group records into age ranges. In Episode 949, I show how to use the range version of VLOOKUP to solve this problem.

Learn how to set preferences in Adobe Acrobat 7.

- Dak asks how to take a long cell entry and to split it into 20 character entries going down a column without using wrap text. Episode 1102 shows a couple of ways to solve the problem. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of 377 tips from the book!