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 an amazing tool when it comes to tracking ​Key performance indicators (KPIs), comparing data points, and getting data-backed views that can help management make decisions.In this tutorial, you will learn how to create an Excel dashboard, best practices to follow while creating one and features and tools you can use in Excel.

This lesson is a contenuation 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 Dashboard Data Sheet, or use the Datasheet from Part 1 of this assignment.

The video tutorials will cover all the requirements once completed. 

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 with a link for all.

Make sure to name the tabs exactly as the requirements mention above.

*

03

Submit the assignment

-

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

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.