4

## How to Copy and Align Charts and Shapes in Excel Dashbords

Bottom line: Learn a few quick tips for working with multiple charts and shapes in your Excel Dashboards.

Skill level: Beginner

34

## How to Calculate Commissions in Excel with VLOOKUP

Bottom line: Learn how to calculate commissions in Excel for a basic tiered plan and rate table using the VLOOKUP function.

Skill level: Intermediate

28

## How to Use VLOOKUP to Find the Closest Match – Last Argument is TRUE

Bottom line: Learn how to use the VLOOKUP function to find the closest match by setting the last argument to TRUE.

Skill level: Intermediate

Do you have a common activity you do when you stay home sick from work or school?  For me, it always included watching an episode of The Price is Right with Bob Barker.

17

## How To Unpivot in Excel with Power Query + Video Tutorial

Bottom line: Learn how to use Power Query to unpivot or normalize your data to get it ready for use in a pivot table.

Skill level: Intermediate

77

## Power Query Overview: An Introduction to Excel’s Most Powerful Data Tool

Bottom line: Learn how this FREE Excel add-in from Microsoft called Power Query will help transform your data into a format that is ready for pivot tables, reports, and so much more.

Skill level: Beginner

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…

David W
“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.

143

## Interactive Dashboards with Pivot Tables & Charts [Video 3 of 3]

Bottom line: Learn how to quickly create an interactive dashboard using pivot tables and pivot charts.  It's easier than you think!

Skill level: Beginner

93

## Introduction to Pivot Tables and Dashboards [Video 2 of 3]

Bottom line: Learn how to use the different calculation types to quickly answer questions about your data.  I also explain how to update your pivot table with more data.

Skill level: Beginner

148

## Introduction to Pivot Tables and Dashboards [Video 1 of 3]

Bottom line: In this video series you will learn how to use Pivot Tables to create meaningful reports and interactive charts and dashboards.

Skill level: Beginner

29

## 3 Ways to Unhide Multiple Sheets in Excel + VBA Tutorial

Bottom line: Learn a few different ways to unhide (show) multiple sheets at the same time with a VBA macro or add-in.

Skill Level: Intermediate