Create an Excel Dashbaord from Scratch. Creating charts, formulas, conditional formatting, a custom function and using power query to upload data automatically. The tutorial has stacks of valuable information about how to set up a flexible excel workbook. File is contained on thesmallman.com - link below.
www.thesmallman.com/blog/2020/4/13/excel-dashboards-tracking-a-crisis
