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.
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.
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.
Click Here to Learn More About PivotPal
Thank you!
Great site.
Thanks Fernando!
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 Francisco,
Thank you for you purchase. You will want to use the sort and filter features on the pivot table to filter for your top products by past due amount, then sort by order date. The video on this page explains how to do this at about the 2:00 mark in the video. https://www.excelcampus.com/charts/pivot-tables-dashboards-part-2/.
Check it out and let me know if you have any questions. You can also email me your file if you still have questions. I’d be happy to take a look at it. [email protected]
Thanks again!
Jon
Thanks Jon for this cool excel product!
Thank YOU Erica! 🙂
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.
https://www.excelcampus.com/vba/add-in-ribbon-disappears/
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!