How to Create a Dashboard Using Pivot Tables and Charts in Excel (Part 3)

Excel Campus - Jon February 18, 2015
Video Thumbnail
Excel Campus - Jon Logo

Excel Campus - Jon

@excelcampus

About

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!

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