Excel Charts Exercises

Excel Dashboard with Charts Challenge

DESCRIPTION

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.

INSTRUCTOR

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.

WHAT YOU WILL PRACTICE

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.

REQUIREMENTS

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.

DOWNLOAD

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.

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