excel dashboard project

Project Description:

dashboard excel project due in 48 hours. mock-up page listing atleast 4 questions. dashboards for those questions. analysis sheets to match those dashboards. i have a 20 min youtube video describing it. and some other helpful examples. it's an easy data manipulation project for an experienced excel person who have worked on dashboards before. this is a novice project.

example:
https://www.youtube.com/watch?v=ztqcpgynh9w

dashboard
components
required points
300
analysis tabs organized and accurate 20
sparkline works properly/ appropriate use 5
pivot table works properly/ appropriate use 5
a macro works properly/ appropriate use 10
conditional formatting works properly/ appropriate use 5
what if formula works properly/ appropriate use 20
v or h lookup or choose
or index
works properly/ appropriate use 20
dashboard visually appealing and informs the user/meets the
objective
30
pivot table charts works properly/ appropriate use 10
slicer works properly/ appropriate use 5
a macro works properly/ appropriate use 10
trending chart -
(smoothing or linear
forecast)
works properly/ appropriate use 20
target chart -
(thermometer or bullet)
works properly/ appropriate use 30
interactive controls chart –
counts as challenging
component (check box or
list control)
works properly/ appropriate use
you must use a formula to control the check box to
receive credit.
40
mockup 4 questions that center around the objective 10
map hyperlinks from components to tab/ appropriate
purpose– see example for details
30
challenging component for
an grade of a
examples: calculating profit, gross revenue, use of
advanced formulas, advanced macros, histogram
and/or pareto chart (grouping chart).
30
total 300
Skills Required:
Project Stats: Edited

Price Type: Negotiable

Refunded
Total Proposals: 1
1 Current viewersl
54 Total views
Project posted by:

Proposals

Proposals Reputation Price offered