Excel Dashboards are a great way to visually display your data in a way to understand your data better. They can help you make decisions on the data easier.
To make one in Excel does take a few steps. After retrieving the data, you need to study it, decide on the data you want to see, make pivot tables, create charts off of it and then put them on the dashboard.
It can be time consuming and difficult if you aren’t familiar with doing on.
Check out this video below where I show you how to go from data to interactive Excel Dashboard using fake Paper sales data from The Office tv show.
DOWNLOAD the Spreadsheet I use in this video to follow along: Download the Excel file of the data to follow along at: http://bit.ly/excelbyjoe_downloads