Introduction
~context~
Business Dashboard Part 2
Excel Data Analysis and Excel Data Visualization with Excel Pivot Tables, Formulas, Pivot Charts and Excel Dashboard

Creating a Business Dashboard in Excel
An Excel Dashboard can be a fantastic tool for tracking ​Key performance indicators (KPIs), comparing data points, and getting data-backed views to help management make decisions. This tutorial will teach you how to create an Excel dashboard, best practices to follow while designing one, and features and tools you can use in Excel.

This lesson is a continuation of the last assignment (Part 1).  

Submission Requirements

The following steps must be completed to receive the associated points for each step.
Any item marked with a * must be completed to receive a score above 0.

01

Follow the tutorial

-

Complete the tutorial provided in the resources area.

Add data related to your project.

Add a working dropdown list form object to your dashboard.

Add three or more working Options Buttons to your dashboard

Add a working Check Box form object to your dashboard.

Follow the tutorial listed in resources area and ​Download Dashbaord Data Sheet or use the Datrasheet from Part 1 of this assignment. 

Note: You may also use your own business data at this point.

25 points

02

Create a folder

-

Create a project folder on your Google drive or a cloud drive of your choice.

Make the folder sharable and not restricted.

*

03

Submit the assignment

-

Upload a screenshot of your final dashboard to the CIT 101 discord channel.

Include a screenshot image showing your Discord submission, in your project folder.

Upload your finished project to Canvas by providing a link to it on Google Drive or another cloud storage site.

Note: If you decide to complete this assignment as a group, you must create a simple contract stating what each member will be responsible for.
The advantages of doing this project as a group are that the project's tasks can be spread out and the team can turn in the same link. To understand how the contracts must be created please check with students on discord as this is an option and not a requirement to complete this assignment.

ALERT: ​Any item marked with a * must be completed to receive a score above 0.

*

25 Points

Total Points if all the above steps are completed and submitted.

5u

5 unit credits when you receive 100% for all assignments in this pipeline.