MrExcel's Learn Excel #928 - WIIW - Multiple Consolidation

Tags:: Excel Business Accounting Spreadsheets Tutorials Technology Mrexcel Pivot Tables

Edit Video Details

Share
Add to Favorites
Report
Download

By: MrExcel
Subscribers: 10
Updated: 25-Nov-09
Videos: 223

International
Comments: 0
Views: 929
Added: 18-Jan-09

Another solution to matching data on two worksheets is the Multiple Consolidation Ranges option in the pivot table. Unfortunately, it is much harder to find in Excel 2007. Episode 928 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!