Excel Dashboard Challenge

Add to wishlistAdded to wishlistRemoved from wishlist 2
Add your review


Excel Dashboard Challenge
Excel Dashboard Challenge



Excel Charts Exercises

Excel Dashboard with Charts Challenge



You will receive an Excel file (65000 rows) with sales data of a sports store. Your task is to build a dashboard (see pics above) for senior managers to monitor the bicycles equipment internet sales. It is an Excel challenge broken down in 25 Excel charts exercises so you can finish the assignment step by step solving each Excel problem until the dashboard is complete.
It is a real project focused on the visualization capabilities of Excel. You will have to summarize sales information through pivot tables, build pie and bar charts, add filters and slicers to display raw data in a structured and graphical form so it can be easily understandable at a glance.


KEVIN ECKLAND holds  a Bachelor of Science of Mechanical Engineering. He worked more than 30 years at Pratt & Whitney as Design Engineering Manager.
He currently runs his own consultancy company building customized spreadsheets for corporate clients.


1) Generate Pivot tables from large datasets.
2) Format and modify pivot tables.
3) Change the pivot table layout to get  a more user friendly looking.
4) Pivot Charts.
5) Create and format charts and comparison graphs.
6) Create and modify dashboards.
6) Tiles, Slicers, formatting,
7) Dynamic subtitles.
8) 1 short Macro.


It is an Excel project that requires a basic knowledge of Excel visualization tools and pivot tables. It is aimed at intermediate students willing to consolidate their knowledge of Excel reporting tools.
The spreadsheet included in the project have been done with Excel 365 . It is then compatible with former versions such as  Excel 2007, Excel 2010, Excel 2013 and Excel 2016.


You will receive a zip file in the confirmation email after purchase. It is also available on your Practity account.
The file contains 2 PDFs and 2 Excel files:
– 1 PDF with the instructions.
– 1 PDF with the Excel practice questions solved and explained (36 pages). It includes detailed explanations  of each Excel exercise. You will also find print screens with the location in the ribbon of the options, buttons and tools used in all the Excel assignments.
– 1 Excel file with the solutions.
– 1 Excel file with data.

If you need additional information, do not hesitate to contact us.


Additional information

Specification: Excel Dashboard Challenge


Time Estimate

12 Hours

Reviews (1)

1 review for Excel Dashboard Challenge

0.0 out of 5
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. kuopras

    As someone who struggled with pivot tables at work, this practice has been really helpful in teaching me all about its applications. Now I can build charts and use pivot tables more easily and it doesn´t take me hours to finish the work!

    Helpful(0) Unhelpful(0)You have already voted this

    Only logged in customers who have purchased this product may leave a review.

    Python and Excel Projects for practice
    Register New Account
    Shopping cart