Build the ULTIMATE Excel Dashboard from Scratch
Excel
10. Sept 2022 14:43

Build the ULTIMATE Excel Dashboard from Scratch

von HubSite 365 über Kevin Stratvert

Content Creator & former Microsoft Product Manager

Pro UserExcel

Build an interactive Excel dashboard from scratch using pivot tables.

In this tutorial, it is shown to you how to use Excel to construct an interactive sales dashboard for Adidas that will dynamically change according on the filters you choose from the side.

To show us the relevant facts, we will first review the dataset and generate pivot tables. Second, we'll design the dashboard's appropriate charts and graphics.

The real dashboard's design will then start from scratch.

Finally, we'll assemble everything into an interactive dashboard by dynamically combining the graphics.

In this video:

  • 0:00​ -​ Pivot Table Analysis & Charts
  • 6:52​ - Designing the Dashboard
  • 11:31​ - Table format & Sparklines
  • 16:19​ - Making the Dashboard Dynamic

Download the Excel Sheet

https://view.flodesk.com/pages/62e6c1afc4d48aec3664b8e4

More about Excel in the News Center

https://www.hubsite365.com/en-de/news?id=7247e0d8-7e2f-ed11-9db1-6045bd8b9c1a&topic=1bab3dee-e796-eb11-b1ac-000d3a46c042