This video will go over creating dashboards in Excel using pivot tables, pivot charts, and slicers.
If you want to follow along with the data I used in this example please visit this link:
http://www.howtoexcel.net/2018/01/creating-dynamic-dashboard-in-excel.html