WATCH PART 2:
Download file used in the video:

In this video series you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts.

Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac

Don’t worry if you have never created a Pivot Table before, I cover the basics of formatting your source data and creating your first Pivot Table as well. You will also get to see an add-in I developed named PivotPal that makes it easier to work with some aspects of Pivot Tables.

Download the files to follow along at the following link.

I have another video that shows how to reformat the pivot chart in Excel 2010. In the video above I’m using Excel 2013 and the menus are different from Excel 2007/2010. Here is the link to that video.

Get PivotPal:

Free webinar on The 5 Secrets to Understanding Pivot Tables:

Subscribe to my free newsletter:

Nguồn:https://madisonrep.org/

28 Comments

Prachi Peshkar

March 27, 2020

Thanks for best training on Pivot tables.

Reply

Tofa Sualauvi Sua

March 27, 2020

very exciting

Reply

George Ertel

March 27, 2020

Your data sheet opened with each column header having this little arrows on the bottom right. How did you set up the data sheet to have those?

Reply

John Jenkins

March 27, 2020

Is PivotPal available?

Reply

Khaled Shanawany

March 27, 2020

when we can get the next video

Reply

Khaled Shanawany

March 27, 2020

I loved the video, it's so useful for me

Reply

Muditha Ratnayake

March 27, 2020

Really nice video..

Reply

ICT Nuggets

March 27, 2020

Very informative

Reply

Roland Lim

March 27, 2020

Hi – I want to follow your tutorial and have downloaded the link but there is no data file. Share where to dowlnload

Reply

Peter Omicioli

March 27, 2020

Awesome video! Very well presented. So easy to follow along. I was clueless on how to create a simple pivot table and this tremendously helped me . Thanks sooooooo much!

Reply

regina cameron

March 27, 2020

wow so much great information. I learned some great new stuff. I don't do any of this in my current job. But I plan to open my own business so learning this is great for me. Thanks for the videos.

Reply

Nicholas Scotland

March 27, 2020

I normally dont comment, but here I had to. What a great job – thank you!

Reply

jayesh mistry

March 27, 2020

Can you pl send a link to download above excel file

Reply

Swapneel Chitale

March 27, 2020

Wonderful video Jon. I have worked on excel for more than 5 years, but never actually used a pivot table. This has made it very easy for me. Thanks!

Reply

Jaritza Elizabeth Burgos Villamar

March 27, 2020

I am from Ecuador, but I've received class in english language, I can sure that your video, and language are very clear for anyone.

Reply

Stephen Rudolph

March 27, 2020

Hi Jon, Fantastic series! Really helpful. Many years ago I first used pivot tables but have been retired for most of those many years. I recall needing to format values using the field value settings. Seemed natural enough since a lot of things were very manual anyway. Why is it that pivot tables don't use the formatted values of their source tables? After all these years I am astounded that this has not changed. I have noted that the preserve formatting when refresh setting works once the pivot table has been formatted. Seems like a dumb feature to have when the main need is to use the source format in the first place. Am I overlooking something? Is there a trick this old dog can be taught. I did see some kind of macro or VBA or something that seemed would do it but…over my head. Appreciate any comments/directions. Again, great work and teaching style!

Reply

bijoudeaux1

March 27, 2020

Thanks for this excellent tutorial. I have a question: how do I "save" the current structure of a pivot table and create a "new" one without distubring the current structure? I'm not seeing that option. Eg. if I want to add shipping and quantity to the pivot table, I want to do so without "losing" the table with only revenue. Excel automatically adds shipping and quantity to the current table but I want to create several tables essentially.

Reply

Hinson Leung

March 27, 2020

amazing! So easy and clear to understand. Thanks for the great work.

Reply

azza elrasheed

March 27, 2020

Thanks a lot , How to handle lost data in pivot table?

Reply

Asitonka Zack

March 27, 2020

Please how do I get your raw data to practice with?

Reply

Eddison Lewis

March 27, 2020

Insightful

Reply

Jaya Prakash

March 27, 2020

Thanking You So Much. Great Learning 🙏🙏🙏

Reply

marina amir

March 27, 2020

great lesson and great teacher

Reply

Khairil Anwar

March 27, 2020

the great Tutorial

Reply

Chris

March 27, 2020

The link is dead

Reply

Jonas Moses

March 27, 2020

How can I use a pivot table when I am not pulling out total sales for each person on my sales team; rather, seeking to visualize concentrations of certain proteins identified from a sample drawn from test subjects, at certain time intervals?

Reply

Rasoul Khoshravan

March 27, 2020

very nice

Reply

Deborah Guenther

March 27, 2020

Very informative and easily understood. Kudos Jon

Reply

Leave a Reply