Learn Excel – “Merge Price List (with Bad Data)” – Podcast #1733
Touma sends in what should be an easy question. Sheet 1 contains Customer, Item, and Quantity Sold. Sheet 2 is a Price List with Unique Prices per Customer Name. Bill could have solved this with PowerPivot or with a Two-Way LOOKUP. As he started to do the LOOKUP, though, he discovered that the Sales Database include a lot of Items that are not in the Pricing Table. Some are simple misspellings, but others are simply missing. This is representative of real life – the Pricing Manager’s Data doesn’t match the Sales Data. Follow along with Episode #1733 as Bill sorts this Data and – once again – displays the versatile utility of PowerPivot.
This episode is the video podcast companion to the book, “PowerPivot For The Data Analyst: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel. The First book on PowerPivot, the breakthrough Microsoft technology that can extend business intelligence to any Excel user. Use PowerPivot, SharePoint Analysis Services, and Microsoft SQL Server together, to slice and dice huge amounts of data, and create and share powerful business models.
For all of your Microsoft Excel needs visit MrExcel.com
Your One Stop for Excel Tips and Solutions.
Entry filed under: Accounting, Bill Jelen, Excel 2010, Excel 2010 In Depth, Excel 2013, Excel 2013 In Depth, Excel for Business, Excel for Educators, Excel for Students, Excel For Teachers, Excel Formula, Learn Excel 2007 through Excel 2010, Learn Excel 2010, Learn Excel 2013, Learn Excel 2013 from MrExcel, Learn Excel from MrExcel, LOOKUP in Excel, Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel MVP, MrExcel, MrExcel Podcast, MrExcel Products, Office 15, Pivot Tables, PowerPivot, PowerPivot 2010. Tags: #N/A, accounting, Bad Data, Bill Jelen, business, Calculate Revenue, Client, Customer, Data Cleansing, Error, Excel, Excel 2010, Excel 2013, INDEX, Learn Excel, Mashup Data, MATCH, MrExcel, Pivot Table, Price List, Price List by Customer, Pricing Table, Spreadsheet, technology, tutorial, Two-Way Lookup, Workbook, Worksheet.