EXCEL DASHBOARD CHALLENGE

1
Add your review

$9.95

EXCEL DASHBOARD CHALLENGE
EXCEL DASHBOARD CHALLENGE

$9.95

Description

 

EXCEL PROJECTS FOR PRACTICE

EXCEL DASHBOARD CHALLENGE

 

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.

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. The project is broken down in 25 exercises so you can finish the assignment step by step solving each exercise 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.

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
This project 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 email confirmation after purchase. If you are a registered user, it is also available on your account.
The file contains 2 PDFs and 2 Excel files:
– 1 PDF with the instructions.
– 1 PDF with the  solutions (36 pages). It includes detailed explanations  of each exercise. You will also find print screens of the location and layout of the requested options and tools.
– 1 Excel file with the solutions.
– 1 Excel file with data.

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

  •  

Additional information

Specification: EXCEL DASHBOARD CHALLENGE

Difficulty

Time Estimate

12 Hours

Reviews (1)

1 review for EXCEL DASHBOARD CHALLENGE

0.0 out of 5
0
0
0
0
0
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.

    Practity
    Register New Account
    Shopping cart