Excel Unplugged
Removing old Row and Column Items from the Pivot Table

Pivot tables still remains the go to solution in Excel for Data Analysis. And for those who do work with them on a regular basis, three things begin to bother them ...

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, ...

MONTH function madness in Excel

I guess we are all familiar with the MONTH function in Excel. If you give it a date as an argument, it will return the month number. So far so good. But here is a ...

Increase your efficiency in Excel with these mouse based Excel shortcuts

These days when talking about efficiency in any Office application, particularly in Excel, keyboard shortcuts are a must. But since we can’t really be ...