Download workbook: : http://ift.tt/2zdkYFt
and
http://ift.tt/2hcNeB0
Bill Mr Excel Jelen and Mike excelisfun Girvin show how to use
Topics:
1. (00:11) Introduction
2. (00:31) Method 1: Power Pivot Data Model & Create PivotTable dialog box with Data Model PivotTable
3. (02:34) Method 2: Array Formula with SUMIFS and SUMPRODUCT
4. (06:42) Method 3: VLOOKUP and Standard PivotTable
5. (08:10) Method 4: Power Pivot Data Model & Relationships with Data Model PivotTable
6. (11:05) Method 5: Power Query with Pivot, Merge and Group By features
7. (14:37) Wrap up and conclusion
Excel Duel, Dueling Excel, Excel Duel 188