When you have a massive Excel workbook overflowing with data, trying to make sense of it can feel like a tough task at times.

A free and compelling add-on, PowerPivot can import huge data sets from just about any data source and crunch them in Excel The core idea behind PowerPivot is deceptively simple: Since people use ...

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends. If you're new to pivot tables, this guide will get you ...

A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you've ...

Microsoft PowerPivot will equip an army of Excel users with business intelligence chops.

Learn how to use Excel pivot tables to QA bulk sheets, plus some tips and shortcuts to enhance your pivot table skills.

Microsoft PowerPivot is equipping an army of Excel users with the chops to build their own business intelligence reports Could the age of self-service BI (business intelligence) finally be near?

Master how to use Excel Pivot Tables in this quick overview guide which will quickly take you from beginning to pro explaining everything you ...

They turn into living, breathing reports that adapt to changes and provide ongoing insights. Excel Pivot Table features you might not be using Watch this video on YouTube.

PowerPivot is Microsoft's new self-service business intelligence (BI) product that seeks to make peace between IT and Excel users. PowerPivot is a component of SQL Server 2008 R2 that works with ...