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