Uploaded January 2024 | Updated September 2026, 3 weeks ago

---

Welcome back to the #DatatoDecisions series.
In this video, we’ll continue to build an #interactive #dashboard from a publicly available dataset from the Bureau of Labor Statistics

In continuation with the previous steps where we extracted data from the web into Excel; built a foundation for interactive slicers; calculated the necessary metrics and created data bars and map visual for our final report.

This video is all about creating tables with dynamic arrows:

1:10 How to create a dynamic Top 10 table in Excel?
7:21 How to create a dynamic Bottom 10 table in Excel?
10:25 How to create arrows for Data Bars?

Check the previous videos
Where we extracted and explored data from the website using Power Query: youtu.be/LKg8zFYPylk
Setting up a foundation for slicers: youtu.be/kL37CZkDM3g
Calculate Metrics and Create Data Bars: youtu.be/yAd34uBQHG0
Create a filled map visualization: youtu.be/ZTeVHxcJ6Jo

For tutorials that address common Excel problems, visit indzara.com/datatodecisions

#InteractiveDashboard #exceldashboards #excelmadeeasy #powerquery #DatatoDecisions #metrics #excelreport #datavisualization #exceltables
****************************************************************************

Check our video from #DatatoDecisions series on extracting Top N/Bottom N values from lists in Excel: youtu.be/HWCIkdSnizc