PivotPal Bonus Videos: Learn PowerQuery, Unpivoting, VBA, & More - Excel Campus
8

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!

Please share
Jon Acampora
 

Welcome to Excel Campus! I am excited you are here. My name is Jon and my goal is to help you learn Excel to save time with your job and advance in your career. I've been an avid Excel user and VBA developer for 10+ years. I am also a Microsoft MVP. I try to learn something new everyday, and want to share this knowledge with you to help you improve your skills. When I'm not looking at spreadsheets, I get outdoors and surf. :) more about me

Click Here to Leave a Comment Below 8 comments
Sathish - July 20, 2017

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

Reply
    Jon Acampora - July 20, 2017

    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!

    Reply
Erica W - March 3, 2015

Thanks Jon for this cool excel product!

Reply
Francisco - March 2, 2015

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.

Reply
Fernando Ortiz - February 26, 2015

Great site.

Reply

Leave a Reply:

Free Webinar: The 5 Secrets to Understanding Pivot Tables

x