In this assignment you are required to create an Excel Dashboard by usingat leastthree of the Excel functions and/or capabilities that we have learned in class. The details of the caseand the raw data from which to workare in the attached Excel workbook. Since this is raw data there may be analysis steps that you have to perform to prepare the data for its final presentation on your dashboard.Attached is a special lecture on Dashboards. Please read it carefully. You should recognize most of this advice from our early lectures on graphs and charts. What is different for this dashboard assignment is that you are bringing together multiple displays of information in a meaningful way to tell a story or in this case respond to the question in the problem (will the company achieve 2010 forecasted sales)You will be graded on the following criteria:1) appropriateness and complexity of Excel features used2) accuracy of calculations analyses or presentations3) overall theme and presentation4) effectiveness of dashboard in communicating results and responding to the question5) the quality and accuracy of your narrative response to the questionMake the dashboard meaningful but have fun!
Attachments: