#### Archive

Category Archives for "Pivot Tables"
22

## How to Analyze Survey Data in Excel + Video

Bottom line: Learn how to analyze multiple choice survey data.  We will use Power Query to transform the data, then analyze the results with Pivot Tables and Charts. A 3-part video series explains all the techniques in detail.

Skill level: Intermediate

62

## 3 Ways to Group Times in Excel

Bottom line: Learn how to group times in a data set for summarized reports and charts.  We will use Pivot Tables, and the FLOOR, TRUNC, and VLOOKUP functions for the different solutions.

Skill level: Intermediate

10

## How to Remove Errors in Your Pivot Tables + Video

Bottom line: Learn how to remove or replace the error values in your pivot tables.  You will also learn how the Pivot Layouts feature of the PivotPal Add-in can save a lot of time with pivot table settings.

Skill level: Beginner

18

## Interactive Histogram Chart That Uncovers The Details

Watch the video tutorial in full screen HD.

Bottom Line: Learn how to create this interactive histogram or distribution chart that displays the details behind the selected chart column.  Download the sample file and watch the tutorial video.

Skill level: Intermediate

8

## Monthly Average vs Current Year Chart

Bottom line: Learn how to create this interactive chart that displays monthly averages versus the current year.

Skill level: Intermediate

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

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.

135

## 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

84

## 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

133

## 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