Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Mr Excel & excelisfun Trick 188: Sales Team Region Report: 5 Different Amazing Methods

Posted on by Annie D

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

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.