adporn.net Create a results dashboard - Microsoft Excel Video Tutorial | LinkedIn Learning, formerly Lynda.com

LinkedIn and 3rd parties use essential and non-essential cookies to provide, secure, analyze and improve our Services, and to show you relevant ads (including professional and job ads) on and off LinkedIn. Learn more in our Cookie Policy.

Select Accept to consent or Reject to decline non-essential cookies for this use. You can update your choices at any time in your settings.

Start free trial Sign in

From the course: Excel Supply Chain Analysis: Managing Simulations Using VBA

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Create a results dashboard

Create a results dashboard - Microsoft Excel Tutorial

From the course: Excel Supply Chain Analysis: Managing Simulations Using VBA

Start my 1-month free trial Buy for my team

Create a results dashboard

“

- [Instructor] After you write your simulation output to an Excel table, you can summarize those results using a dashboard. A dashboard worksheet provides a high level overview for your data, giving you a summary that you can use to guide operations and further analysis. I'll demonstrate how to do that. And I'll work with the 02_04 dashboard workbook. You can find that in the exercise files collection. So here I have a fairly straightforward dashboard. And over on the left, you see that I have demand for each of my three cities and I'm calculating the average, the maximum and the minimum. If I go back to the demand worksheet, you can see that I have demand for Portland, demand for Oregon City and demand for Beaverton. Also, I have the total, whether demand was greater than capacity and also the number of units that went unfulfilled. So I will use each of these measurements in my dashboard. I'll switch back to the dashboard…

Contents