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

Learn to Create a Pivot Table and Pivot Chart in Excel

Video #1 – Introduction to Pivot Tables

In this first video we are going to learn how to setup your source data, then create a Pivot Table and Pivot Chart. I also show you how to reformat the chart to upgrade the look from the default settings.

Best viewed in Full Screen HD.

Note: If you are familiar with Pivot Tables then this video might be too basic for you.  I would still love for you to watch the video, but don't want to waste your time.  In the next two videos we will be putting together the dashboard.  There is also a shorter video below where I give a Pivot Chart a makeover…

Downloads

Use this checklist to cleanup your source data before creating a Pivot Table.

Pivot Table Source Data Checklist - Excel Campus.pdf (262.2 KB)

Use the following file to follow along with the video and create your own Pivot Table and Pivot Chart.

Intro To Pivot Tables Part 1.xlsx (76.5 KB)

Pivot Tables are Amazing!

A few days ago I shared a story about how I got to teach my Dad how to use Pivot Tables.  As you know he is really excited about Pivot Tables.  They were easier to learn than he expected, and he is saving a ton of time when creating reports and summarizing his data.

So I want to share this same training with you!

Create Dashboards with Pivot Tables and Charts

In this video series we are going to follow my friend Andy on the journey to learn Pivot Tables.

Andy and his Boss - Excel Campus

Andy has been tasked by his boss to create some charts and a dashboard for an upcoming presentation.  He really wants to impress his boss, but doesn't have time to learn complex formulas or macros.  What he really needs it Pivot Tables and Pivot Charts.

Turn Data into a Dashboard with Pivot Tables

As you will see, Pivot Tables allow you to quickly summarize and analyze your data.  I am going to show you how you can discover trends and learn a lot about your data with just a few clicks.

Bonus Video: Pivot Chart Makeover in Excel 2010

In the video above I explained how to reformat the Pivot Chart.  In that video I was using Excel 2013.  I recreated the video using Excel 2010 because the menus are a bit different and I want to make sure you could follow along if you are using Excel 2007 or 2010.

Intro To Pivot Tables Part 1.xlsx (76.5 KB)

Why the Chart Makeover?

When presenting your data visually on a chart you want the reader to be able to easily understand the story you are trying to tell.  To do this you want to get rid of all the extra elements that do not contribute to the story.

In this case we removed the axis labels, legend, vertical lines, and field buttons.  This stuff can be referred to as “chart junk” because it tends to clutter the chart.

The default settings of the Pivot Charts typically contain a lot of chart junk.  These extras elements can be distracting for the reader, and take away from your story.

The type of chart you create will determine what elements you want to display.   There are entire books written on the art and science of data visualization, and it is definitely a good topic to study.

PivotPal is Here!

PivotPal Logo Pivot Table Add-in for Excel

I show a few of PivotPal's features in the 11:28 mark in the video above.

PivotPal is now available!

Click here to learn more about PivotPal!

Thank You!

I want to say a big THANK YOU if you took the time to complete the pivot tables survey!  The response was overwhelming and I am still going through all the results.  I will share more about that with you in the coming weeks.

Additional Resources

Please leave a comment below with any questions.  Thanks again!

 

152 comments

Your email address will not be published. Required fields are marked *

  • Fantastic video! I had no idea what a pivot table was before watching your video. This is so cool and seems like an easier way to view data. I really enjoyed your tutorial, you made is so easy to follow. Looking forward to the next video!

Search
Generic filters
Exact matches only
Filter by Custom Post Type

JOIN US & LEARN EXCEL

Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
Plus weekly updates to help you learn Excel.

Download the eBook

About Me

Jon Acampora Profile

Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...

MVP_Horizontal_BlueOnly