Today’s podcast takes a solution found in “Pivot Table Data Crunching: Microsoft Excel 2010” by Michael Alexander and Bill Jelen. Taking a table that is currently set up as a Two-Way Table, Bill uses the ‘Old Pivot Table Dialogue’ in Excel to set up a Pivot Table to transform the current Table to a Linear Table. Follow along with Episode #1572 to learn how to access that ‘Old Dialogue’ and transform the Two-Way Table.
For more information on ‘Pivot Table Tricks’, Usage and general ‘Pivot Table How-To’, check out: “”Pivot Table Data Crunching: Microsoft Excel 2010” by Bill Jelen and Michael Alexander
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!