Excel Unplugged
Pivot Table vs Power Pivot or what is Power Pivot
  • May 16, 2014

    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 they are two totally different things altogether. And just like you can cruise around in your Ford Mustang (you ...

    PowerPivot Inside Out (Part 2/3)
  • May 16, 2014

    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 already covered the first three of the ten things you need to know. So we will continue with number four… 4. ...

    Do not change Column Width on a Pivot Table Refresh
  • May 14, 2014

    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 Sheet. Otherwise, it keeps changing the layout of other data or other Pivot Tables. Here Is how you change this. ...

    PowerPivot Inside Out (Part 1/3)
  • March 24, 2014

    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 workbook in Excel. I always believed that understanding is key, and therefore this article is written to deepen your ...

    Does a PowerPivot Pivot Table beat a regular Pivot Table
  • October 11, 2013

    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 the PowerPivot Add-In, or if you just heard it being mentioned in passing, what you should know is that ...

    Dynamic ranges in Excel
  • October 9, 2013

    For the purposes of this article (if you wish to follow long and I strongly suggest you do so) we will be using a workbook that has the A2:E10 Range filled with the following random data. In real life Ranges like this are very rare and very unkind to the user, since no ...

    Taking the Data Validation Dropdown list to the next level
  • July 1, 2013

    Creating a dependent or linked Dropdown list In this article I will show you how to create dependent Dropdown lists using Data Validation and an Excel function called INDIRECT. First let’s take a look at what we are trying to accomplish. We will start with the ...

    How do I “separate” Pivot Tables
  • June 5, 2013

    During the creation of Office 2007, 2010 and 2013, a great emphasis was given to the file size. Of course you would like to make the file size as small as possible and for this purpose even the creation or better yet the behavior of Pivot Tables has changed since Excel 2003. ...

    Removing old Row and Column Items from the Pivot Table
  • May 25, 2013

    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 soon. One is the automatic resizing of columns on Pivot Table refresh which you can read about here. The second ...

    Sorting months chronologically and not alphabetically in a Power Pivot Pivot Table
  • April 16, 2013

    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, …). But when you create a Pivot Table based on Power Pivot, the grouping does not work! (This can also ...

    MONTH function madness in Excel
  • March 29, 2013

    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 use of the MONTH function you might not be used to… If for example cell A1 contains a name of […]

    Increase your efficiency in Excel with these mouse based Excel shortcuts
  • March 8, 2013

    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 efficient without the mouse, let’s see what are the hidden, but great uses of the mouse in Excel. Paste as Value ...