Now that you have a basic idea about interactive dashboards in Microsoft Excel, let’s check them out in action. Before beginning, clearly define the purpose and use case for your dashboard.

Create dynamic Excel dashboards with one click functionality to transform data into insights effortlessly. ... For date-based data, timelines offer an easy way to filter by specific time periods.

Back in 2020, Reddit user /u/KrakenOfLakeZurich created a Sudoku solver in Microsoft Excel. It only uses formulae and conditional formatting, and it's available for both Excel and LibreOffice Calc.

Excel slicers offer an easy way to filter a PivotTable or PivotChart, making them a great visual tool for your dashboard sheets. If you don’t like the visual properties of the slicer, you can ...