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:
Create an Excel Dashboard from Scratch - Part 1 - Offset Match Formula & Data Validation
(as of September 19, 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:
Nilight 10 Pack NI-FH01 Inline Holder 14AWG Wiring Harness ATC/ATO 30AMP Blade Automotive Fuse Holder-10, 2 Years Warranty
Nilight high-quality 14 AWG in-line blade ATC/ATO standard fuse holders type: ATO/ATC fuse holder cable type: 14 AWG loop length: 12 inches certification: UL in-line ATO/ATC fuse holder with cover for blade fuses fit for fuse dimension: 19.1 ... (as of September 19, 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:
Parrot MKi9200 Advanced Color Display Bluetooth Hands-Free Music Kit
Parrot MKi9200 Advanced Color Display Bluetooth Hands-Free Music KitParrot MKi9200 Advanced Color Display Bluetooth Hands-Free Music KitAmazon.com Product DescriptionThe Parrot MKi9200 Advanced Color Display Bluetooth Hands-Free Car Kit syste... (as of September 19, 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