Excel Unplugged

Tag Archives: PowerPivot

Pivot Table vs Power Pivot or what is Power Pivot

This question or rather comparison never seizes to amaze me, since it’s just like comparing Eric Clapton to a Ford Mustang. It just can’t be done since ...

PowerPivot Inside Out (Part 2/3)

This is the second article of three. If you hadn’t read the first part yet, it is recommended that you do so. It talked about the basics of PowerPivot and ...

PowerPivot Inside Out (Part 1/3)

10 things you need to know The following article is kind of a baseline knowledge, one should possess, before attempting the creation of their first PowerPivot ...

Does a PowerPivot Pivot Table beat a regular Pivot Table

Hands down, YES! If you would like to read about the comparison of definitions of the two, you can do so in the Pivot Table vs Power Pivot post. If you are new to ...

Sorting months chronologically and not alphabetically in a Power Pivot Pivot Table

Here is our problem. When you create a Pivot Table in Excel that has a date field, you can Group that field by month and the sort will be logical (January, February, ...