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/
Thanks for best training on Pivot tables.
very exciting
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?
Is PivotPal available?
when we can get the next video
I loved the video, it's so useful for me
Really nice video..
Very informative
Hi – I want to follow your tutorial and have downloaded the link but there is no data file. Share where to dowlnload
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!
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.
I normally dont comment, but here I had to. What a great job – thank you!
Can you pl send a link to download above excel file
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!
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.
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!
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.
amazing! So easy and clear to understand. Thanks for the great work.
Thanks a lot , How to handle lost data in pivot table?
Please how do I get your raw data to practice with?
Insightful
Thanking You So Much. Great Learning 🙏🙏🙏
great lesson and great teacher
the great Tutorial
The link is dead
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?
very nice
Very informative and easily understood. Kudos Jon