Advanced Excel Project 1

A Non-profit organization helping high school seniors find career paths.

You need to build a dashboard that seniors can use to explore wage and employment trends and compare them across industries.

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

  • Statistical and Look-up Formula
  • Inserting and Formatting custom charts
  • Dynamically highlighting series
  • Creating the new data with datatypes
  • Adding form controls
  • Protecting workbook and worksheets

FILE TYPE: xlsx

Date Added: 22nd November 2023

Source:

License: Public