How to Create a Dashboard Using Pivot Tables and Charts in Excel (Part 3)
Excel Campus - Jon
@excelcampusAbout
Excel Campus is here to help you learn Excel and save you time with your everyday tasks. My name is Jon Acampora and my goal is to help you improve your Excel skills. This channel contains "how-to" tutorial style videos on a wide range of Excel topics including: formulas, pivot tables, macros, VBA, charts, dashboards, Power Query, Power Pivot, Power BI, and much more. I want to hear from you and learn about what you are struggling with in Excel. Please visit my website and subscribe to my free email newsletter. http://www.excelcampus.com/newsletter/ And don't forget to subscribe to our YouTube channel. Thank you!
Latest Posts
Video Description
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ http://www.excelcampus.com/charts/pivot-tables-dashboards-part-3 This is part 3 in the series on Pivot Tables and Dashboards. In this video we bring it all together to create the interactive dashboard. You will learn how to: - Group dates into months and years to create a time series trend chart. - Group amounts to create a distribution (histogram) chart. - Add slicers to your pivot tables and charts to make them interactive. - Lots of tips and shortcuts for formatting your charts. You can download the file to follow along at the following link. http://www.excelcampus.com/charts/pivot-tables-dashboards-part-3 Please subscribe to my free email newsletter to get your tutorials like this and get updated about PivotPal. Get PivotPal: http://www.excelcampus.com/pivotpal WATCH PART 1: https://www.youtube.com/watch?v=9NUjHBNWe9M WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y Subscribe to my free newsletter: http://www.excelcampus.com/newsletter
You May Also Like
Essential Excel Tools Today
AI-recommended products based on this video




















