MOHD FAUZAN MAT NOOR Komputer & Elektronik

(Video) 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.