Learn Excel – “Price List with PowerPivot” – Podcast #1734
Yesterday, in Episode #1733, it required two MATCH and one INDEX to Merge the Data from Two Worksheets. Today, in Episode #1734, using PowerPivot in Excel 2010, Bill shows us another way to find the Price for each Customer/Item combination. While PowerPivot is supposed to make life easier, this method still requires Two Concatenation Formulas, Two Ctrl+T, Two Add Linked Table, One drag from Key to Key, then One RELATED Function and an application of Mike Alexander’s trick from my Episode #493. Which is easier? #1733 or #1734?
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: Bill Jelen, Bill Jelen and Michael Alexander, Excel 2010, Excel 2010 In Depth, Excel for Business, Excel for Students, Excel For Teachers, Excel Formula, Learn Excel 2007 through Excel 2010, Learn Excel 2010, MrExcel, MrExcel Podcast, MrExcel Products, Pivot Table Data Crunching 2010, Pivot Tables, PowerPivot, PowerPivot 2010. Tags: 2010, 2013, accounting, Bill Jelen, business, Concatenation, Excel, Excel 2010, Excel 2013, formula, Functions, Keyboard, Learn Excel, Learning, Mashup Data, Merge Price Sheets, MrExcel, Pivot Table, PivotTable, Power Pivot, PowerPivot, Sales Sheet, spreadsheets, technology, tutorial, Unwind Data, VLOOKUP, Workbook, Worksheet.