Probably the longest title of all times, but it leads to something great. First let’s explain Power Query. Power Query is an AddInn for Excel and part of ...

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

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

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

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? Hands down, YES! If you would like to read about the comparison of definitions of the two, you can do so ...

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