We are looking for the amount of scrap compared to good units – but as a percentage of production and not simply a numberical value. Using a Pivot Table in Microsoft Excel in Episode #1528, Bill produces his first solution to the query.

[Be sure to tune in for tomorrow’s “Percent of Production – Part II” when Bill employs the use of Microsoft PowerPivot and Microsoft Excel to solve this challenge.]

[youtube=http://www.youtube.com/watch?v=WQz22KbyLb8]

"Learn Excel 2007 through Excel 2010 from MrExcel" by Bill Jelen…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”

Bill also covers PowerPivot with his book ” PowerPivot for the Data Analyst: Microsoft Excel 2010” by Bil"PowerPivot For The Data Analyst" by Bill Jelenl Jelen

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!