In this video, we are going to show how to create and use dynamic controls, in order to make your Excel dashboards more flexible and engaging for your viewers, customers and colleagues. Dashboard controls are key, when it comes to creating a smart user interface. They should be simple, easy to use and understandable and should allow users to go through the different data, without having to scroll through larger worksheets and navigate through complex workbooks. 

The following controls are going to be used:

• Pivot Table Slicers

• Table Slicers

• Dropdown Menu

• Combo Box

• List Box

• Scroll Bar

• Spin Button

• Option Button

• Check Box

​

All with dynamic conditional formatting. It is important to understand that these controls can be used without any coding, and that they are a standard Microsoft Excel feature. Although they may first seem intimidating to use, you will learn, that these controls are rather easy to understand, set up and use. When used correctly, they bring flexibility and engagement and will help improve your Excel reports and Dashboards.

​

You are welcome to follow along! No Macros or VBA are going to be needed, just Microsoft Excel 2010 or newer.