Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Unfortunately, if you're using Excel 2019 or earlier, you won't be able to create your own functions using the methods described in this guide.

A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.

Microsoft Excel sorts slider buttons alphabetically and numerically. Fortunately, you can add a custom sort list to sort the buttons in a more meaningful way, when necessary.