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:
Excel 2019: A Beginner's Guide to Learn Excel 2019 Step by Step and Boost your Productivity
Become Truly Good At Excel With This Beginner-Friendly BookAre you good at Excel?Everyone thinks they are.But honestly, have you ever made anything more complicated than a monthly budget? If not, you’ve only seen the tip of the mighty iceberg... (as of February 26, 2020 - 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:
Storytelling with Data: A Data Visualization Guide for Business Professionals
Don't simply show your data—tell a story with it! Storytelling with Data teaches you the fundamentals of data visualization and how to communicate effectively with data. You'll discover the power of storytelling and the way to make data a ... (as of February 24, 2020 - 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:
Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills)
This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functio... (as of February 26, 2020 - 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: $0.99
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