MrExcel on MSN

Excel Trick: Instantly Show Underlying Data in Pivot Tables

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 ...
Geeky Gadgets

How to Use Power Pivot for Advanced Data Analysis in Excel

If you’ve ever found yourself wrestling with Excel’s traditional Pivot Tables, you know the frustration of hitting their limitations. They’re great for basic tasks but can leave you scratching your ...
MrExcel on MSN

Excel Pivot Table Fix – Show Account and Customer Names Together

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 ...
PC World

Create Excel reports from multiple spreadsheets with Multi-file Pivot Tables

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. Once you select the portion of your spreadsheet that contains the target data, then define it as a ...