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

How to Create a Dashboard Using Pivot Tables and Charts in Excel (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.

Related Topics:

• Paste Buddy Tutorial - Create Keyboard Shortcuts to Paste Values in Excel 
• Quickly Find Worksheets and Unhide Multiple Sheets using Tab Hound 
• The Fastest Way to Copy an Excel Worksheet - plus Tab Hound and Tab Control 
• How to Automate Excel Processes with the Tab Control Add-in