Daily tips for using Microsoft Excel.

Thursday, February 11, 2010

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.

And, if you happen to be reading this before February 14, please consider voting for my entry here.

Labels: , ,

Tuesday, November 04, 2008

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 the complete article: GetPivotData in Excel

Labels: