15 digit limit in Excel is something everyone should know about. Why? It both enables Excel to do lightning speed calculations and limits Excel in a great way. And ...

We have a column of dates in Excel, and our goal is to get Q1, Q2,… or QTR1, QTR2,… or Quarter 1, Quarter 2,… . I think you get the picture 🙂 First we ...

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

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

One of the most annoying things a Pivot Table does on refresh is it auto fits the column width of all columns. This is great if a Pivot Table is all you have on a ...