Pivot Tables

Example of a Mash-up in PowerPivot


I just emerged from a marathon 33-day writing session where I finished five book manuscripts. One of those books is about a hot new add-in for Excel 2010 called PowerPivot. For an example of the types of data that you can mash up with PowerPivot, take a look at my guest blog post at PowerPivotPro.com.(…)

GetPivotData in Excel


People are passionate about GetPivotData. Most people hate it and want to turn it off. Some people embrace it and couldn’t live without it. Whichever side you are on, I’ve written an article with the details. You can learn how to turn it off or the details of how to actually use the function. For(…)

Learn Excel from MrExcel