Excel Unplugged

Tag Archives: Pivot Table

The New Pivot Column option in Power Query

If some pictures are hard to view, you can get the PDF of the article The Pivot option in Power Query. With the latest update of Power Query AddInn for Excel quite a ...

Option Button Control on the Developer Tab, Top Bottom 5 in Pivot Table and CHOOSE Function in Excel

We have a dish where I come from (Slovenia), called Minestrone. It’s interesting since there is no single recipe for it. It’s made from whatever ...

Unpivot with Power Query

One might think that analyzing data with a Pivot table is hard, but Unpivot a Pivot table proves to be even harder. But Power Query or better yet a Query editor ...

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

Do not change Column Width on a Pivot Table Refresh

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

Power Pivot Inside Out (Part 1/3)

Power Pivot Inside Out is a three part series on 10 things you need to know about Power Pivot. Update 2022: we recently published a video on the Excel Olympics ...

Does a Power Pivot Pivot Table beat a regular Pivot Table

Does a Power Pivot 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 ...

How do I “separate” Pivot Tables

How to separate pivot tables in Excel? In this article we will discuss three different ways how to do this. Why does Excel do this During the creation of Office ...

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 based Pivot Table

Here is our “problem”. When you create a Pivot Table in Excel that has a date field and is based on data in Excel, you can Group that field by month and ...