WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y
Download file used in the video: http://www.excelcampus.com/pivot-table-checklist-yt
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.
http://www.excelcampus.com/pivot-table-checklist-yt
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. http://www.youtube.com/watch?v=Jt_QqG-vRRw
Get PivotPal: http://www.excelcampus.com/pivotpal
Subscribe to my free newsletter: http://www.excelcampus.com/newsletter
Price: $14.95
12 Pack Multi-Color Laminated Dry Erase Incentive Chart with 960 Reward Star Stickers for Chore Responsibility, School Attendance, Homework Progress Tracking Chart (17 Inch x 22 Inch)
(as of November 13, 2019 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Price: $18.99
D-FantiX Magnetic Responsibility Chart, Chore Chart for Multiple Kids, My Star Reward Chart for Toddlers, Encourage Responsibility and Good Behavior Charts Educational Toys for Home
The D-FantiX Chore Chart makes it easier for children to keep track of their responsibilities and help build self-esteem while teaching organizational skills, independence, and positive behavior. It breaks down different types of goals, such ... (as of November 11, 2019 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Price:
Creative Teaching Press Bright Colors Incentive 5-Chart Pack (0974)
These colorful charts will make students proud to keep track of their progress! Each chart has space for 35 student names and 20 assignments. This 5-chart pack includes one each of white, turquoise, poppy red, slate gray and lime green charts... (as of November 11, 2019 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Price:
The exemple is very well explained but it does not help if you are working with survey data like myself
Excellent tutorial. You explained it so well.
great … thank you ….
Great job Sir- I love the way how you explained, very simple and useful. Thanks a lot!!
a gud and nice video
Thank you. it is very helpful for me. thanks a lot.
Hey Jon. Great Video!. Is there a way to use Pivot Chart on Mac, or is it only a feature in the Microsoft version?
9/4/17 – NICE PRESENTATION JON, HOW DO I GET IN TOUCH WITH YOU ? TERRY / STEELHEADTJ@ZOOMINTERNET.NET THANK YOU, AND IT’S SO HELPFUL TO HEAR EXPLANATION !!
Thank you for creating these videos for Pivot Tables! Very very helpful.
This is really helpful. I was asked in a previous interview if I had experience using pivot tables & did not. This is really helpful & will allow me to get some practice with this feature!
*Thanks for the sharing knowledge. Lots of love frm pakistan.*
Really useful video to introduce pivot table concept and practices. Great Video!!!
Great Job Jon….I just subscribed.
Thanks, very easy to understand… I’ll follow up with the others videos on your channel…
Thanks for Providing this knowledge,…
wow…This is the best one i have ever seen for pivot and dashboard…thank you
Wonderfully explained and easy to understand. Simply superb!
cool
Good video, easy to understand and follow. thank you.
First of all, thank you for the good lesson.
I handed a report to my manager using pivot table and he loved it.
#Please can someone teach me how to lock the formula inside the sheet we selected?
Andy is a queer
Really nice video. Thanks.
Thank you for watching the video! Here are the links I mentioned in the video.
DOWNLOAD the Pivot Table Checklist & Excel File: https://www.excelcampus.com/pivot-table-checklist-yt
Learn more about PivotPal: https://www.excelcampus.com/pivotpal
Watch video #2: https://youtu.be/g530cnFfk8Y
Please leave a comment below with any questions, and hit the like button above if you enjoyed the video. I really appreciate your support! 🙂
Thanks Sir.
Excellent way to explain those functionalities. Jon you are a very good teacher. Thks/Octavio Leon
Excellent. Thank you.
thanks
This was incredibly helpful Jon! I’m so glad that I found your YouTube page. I have already subscribed and joined your mailing list :). Again, thank you so much!
Thank you, my current work experience is just like Andy’s….I have to impress the new boss…. :-)You make it real easy to learn these tools. Excellent video!
Excellent work, thanks!
Great video tutorial. Thank you for posting.
Jan needs to step it up
it helped me
Thank you for such an informative video. Looking forward for more vids like this!
Hi Jon, Thank you so much for sharing you knowledge. Just wanted to know do you have excel file like the one in your source data that I can work on, for practice?
https://youtu.be/RM8T1eYBjQYExcel guru also had same kind of video just watch
He makes the complex thing in layman’s term. Great course.
Fantastic tutorial, easy to understand and follow! Now those job applications/criteria seem less daunting…warm wishes from London(UK)..X