Advanced Excel Project 3

A small Toy store chain in United States

Prepare a new monthly dashboard that can be used to filter by region, track monthly revenue trends, and see performance year-over-year.
Compare performance across stores, and identify which specific products drove the biggest gain and losses.

Recommended Examination

  • Define the purpose of the dashboard
  • Choose the key metrics and interactivity
  • Prepare the data for visualization
  • Create the primary and supporting visuals
  • Design the final dashboard layout
  • Configure the workbook for viewers

Concept Covered

  • Top N Formulas
  • Previous period calculations
  • Automatic sorting
  • Conditional formatting
  • Sharing online

FILE TYPE: CSV

Date Added:

Source:

License: