How to create an interactive Dashboard in Excel – PivotTables Tutorial Part 2
In this video, you will learn a universal approach to creating an interactive dashboard in Excel. In this highly practical tutorial, you’ll build your own dashboard and gain hands-on experience on how to easily visualize raw data in Excel.
The practice file from the video can be downloaded from this link:
https://docs.google.com/spreadsheets/d/1dGPVEbmrcDV0Zr2nzM6MVJpaG-ssJtck/edit?usp=sharing&ouid=104968505004400136199&rtpof=true&sd=true
Links and attributions to images used in this video:
David Liuzzo, CC BY-SA 2.0 DE https://creativecommons.org/licenses/by-sa/2.0/de/deed.en, via Wikimedia Commons
https://commons.wikimedia.org/wiki/File:Karte_Deutschland.svg
And here are the timestamps so you can easily jump to the right part of the video later:
0:00 – Intro
1:36 – Data Table Preparation
2:05 – First Chart – Categories
8:37 – Second Chart – Producers
9:33 – Third Chart – Top 10 Products
10:43 – Fourth Chart – Revenue by Region
14:03 – Fifth Chart – Revenue by Month
15:39 – Sixth Chart – Map Chart
16:08 – Assembling the Dashboard from Individual Charts
seo grundlagen 2023
Recommended Posts
Comments
Comments are closed.
thank you so much sir
+ для продвижения. Удачи.
Thanks!
Fantastic tutorial 👌 Ещё и английский прокачать можно🔥 Many thanks!