This "Office Show" episode features a common dilemma: The budget data you want to analyze in Excel contains so many rows and columns of numbers that it seems like an impossible task to get it all sorted out. Meanwhile, there's a deadline looming and mounting pressure to figure out how to save money.

Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.

In both Excel and in Power Pivot, you can create a Data Model, a collection of tables with relationships. The data model you see in a workbook in Excel is the same data model you see in the Power Pivot window. Any data you import into Excel is available in Power Pivot, and vice versa.