Excel Dashboards

Sale Dynamic Dashboard with No VBA


Select the year and press F9 Key. The main function used to design this dashboard is INDIRECT(CELL(“address”)) used in AA1 cell on data and calculations sheet. The equally important is the function used in AB1 cell on data and calculation sheet to return one of the years value always. In order to make summaries of data, the functions benefited from are SumIf, SumIFS, Vlookup. To unprotect dashboard sheet go to Review Tab and Select Unprotect Sheet. There is no password.

Download Excel File

Dynamic Dashboard Using Form Control

Go To Tutorial Page
Download Excel File Form Controls Tutorial

Leave a Reply

Your email address will not be published. Required fields are marked *