The Excel Dashboard Toolbox: 5 Data Transformation Techniques

The Excel Dashboard Toolbox is made up of 3 different components

• The Table of Contents
  

•  A Dashboard Worksheet for each Dashboard Tool/Trick

•  A How To Worksheet (Summarized and Detailed) for each Dashboard Tool/Trick

You'll Get 5 Different Data Transformation Techniques

1 - A dashboard that allows you to dynamically highlight a data set using a drop down.

2 - A dashboard that allows you to dynamically display data inside of customized Excel shapes using a drop down menu.

3 - A dashboard that allows you to use Excel slicers buttons to change the data on your dashboard on the fly.

4 - A dashboard that allows you to use Excel option buttons to find the top 5 and bottom 5 records of large data sets.

5 - A dashboard that allows you to create a question and answer drop down and display.