Creating a Dashboard on excel

Our mini-project consists of creating an excel dashboard that presents all relevant information about your topic. You may choose any financial topic and present it with several different kinds of charts, dropdown lists, statistics, financial functions, objective function models, etc. The first sheet of the excel spreadsheet should be where all information that is presented to the user is collated. All other information that is being used/referenced should be on other sheets. You will be graded on: 1. Presentation: a. Clear, concise and informative set-up b. Easy access to different views c. Conditional formatting d. Tables, Sorting, Filtering, Charts 2. Functions: a. Using all the financial functions b. Using lookup, counting, summing, and frequency functions c. Naming areas, using text and date function d. If functions, nested if functions e. Buttons/forms You can do on anything. Example: Coke vs Pepsi