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…
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 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.
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
In this three part series I explain how to create this dashboard of snowfall data.
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 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.
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.