PivotPal Bonus Videos: Learn PowerQuery, Unpivoting, VBA, & More

The add-in I have been talking about for weeks is finally available.  And I have a few bonuses to go with it.  Plus, a special limited time offer!

What's the Word on PivotPal?

Here is a quote from David, a PivotPal user…

“Using the PivotPal has been quite a ‘light bulb moment’ in that it has helped to really cement my understanding of how Pivots in MS Excel work – quite apart from making Pivot Tables much easier and faster to set up, especially for multiple tables, it’s also helped me understand much better MS Excel’s high level Pivot Table workflow.

As well as being feature rich PivotPal also uses the valuable screen and workspace real estate much more efficiently than Excel’s native Pivot management which has been a real benefit whilst developing my spreadsheet Dashboard in meeting rooms and on my sofa using just my laptop without the luxury of twin monitors back at my desk.”David W

I'm so happy to hear that I'm not the only one that has used PivotPal while sitting on the couch… 🙂  Thanks David!

What is PivotPal?

PivotPal Box + VBA Source Code side-by-side

PivotPal is an Excel Add-in that makes it faster and easier to work with your pivot tables.  It helps automate a lot of processes that normally take you extra time with Excel's built-in menus.

XL Campus Ribbon and PivotPal Buttons

Click Here to Learn More About PivotPal

Free Bonus Videos

I am including some great bonus videos with PivotPal that will help you learn more about pivot tables, pivot charts, my new favorite tool PowerQuery, and the VBA code that runs PivotPal.

Bonus#1 – PowerQuery and Pivot Tables Video Series

Click Here to Learn More About PivotPal

In this three part series I explain how to create this dashboard of snowfall data.

Mammoth Mountain Snowfall Dashboard

You will learn how to use PowerQuery to unpivot or normalize the data we download from the web.  I copy some snowfall data from the website of my favorite ski resort, and it needs to be unpivoted (re-shaped) to be in the correct structure to use for a pivot table.  This is also referred to as normalizing the data.

PowerQuery Unpivot Data for Pivot Table in Excel

PowerQuery is a free add-in from Microsoft for Excel 2010 and 2013.  It is an awesome tool and one of my new favorites.  PowerQuery will save you a ton of time when re-shaping or manipulating data.  Ever use the Text-to-Columns feature in Excel?  This is similar to that only a million times better. 🙂

And don't worry if you don't have PowerQuery yet.  I also provide instructions on how to download and install it.

Bonus #2 – Learn How PivotPal Works and the VBA Code That Makes it Run

This video explains how PivotPal works and we dive into VB Editor to look at the forms and code that make up the add-in.

This will be helpful if you are new to VBA or add-ins and want to understand how they work.

Learn How PivotPal Works and the VBA Code

The bonus includes access to a special page that contains the video, and also contains a section where you can ask questions.

Note: This bonus is only available if you buy the Developer Version of PivotPal.

Get PivotPal Today

Please click the link below to get PivotPal today.

Click Here to Learn More About PivotPal

Thank you!


Your email address will not be published. Required fields are marked *

  • Hello,

    My wife purchase PivotPal to help me out. So far so good but I’m trying to show my top past due products but order date. Help……..wife is not home.

  • Hi Jon,

    I recently bought pivot pal and paste buddy, both are installed in my laptop. Everytime, when I open my excel file, these add-ins are not appearing under Excel campus tab. I added the addin location under trusted location. I have also bought tab hound (other product) and filter mate, which are perfect, these two options appearing under XL campus tab.

    Please help me to resolve it, because everytime I open my excel application, i have remove addin and add back again. this is really annoying for me.

    How many add-ins I can add in my excel application at a time?
    How many short cuts i can add in QAT, so that the same will appear everytime I open my excel application. ?

    • Hi Sathish,
      This issue that causes the add-ins to disappear is due to a Microsoft Office security update. There is a fix for this, and you will need to Unblock the add-in. This is a new property of the file. The installation instructions that came with the add-in explain how to unblock the file. I also have an article and video that explain this issue and solution in more detail.


      I’m not sure that there is a limit on add-ins or QAT items.

      I hope that helps. Please let me know if you have any questions. Thank you!

Generic filters
Exact matches only

Excel Shortcuts List

keyboard shortcuts list banner

Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

Excel Shortcuts List

Join Our Weekly Newsletter

The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

Join Our Free Newsletter