HOW TO… Excel: Create a hierarchical series of drop down boxes

As a result of prodding around the excel subreddit I found a query from user innocuous_gorilla about creating drop downs that are dependent upon each other. Due to working at NHS England where we have a massive array of organisation types and hierarchies, I quickly learnt how to do this! For example, in NHS England … Continue reading HOW TO… Excel: Create a hierarchical series of drop down boxes

Advertisements

HOW TO… Excel: Create a Dynamic Data Table Using INDIRECT and Combo Boxes

Creating a full and cohesive user experience in an Excel based dashboard can be really difficult if you don't know where to start. Often, the easiest way to approach the situation will be to utilise Pivot Tables and Pivot Charts, which come with useful tools like slicers to dynamically filter the data with a touch … Continue reading HOW TO… Excel: Create a Dynamic Data Table Using INDIRECT and Combo Boxes