Sign in to confirm you’re not a bot
This helps protect our community. Learn more

📊 How to Build Excel Interactive Dashboards

Kevin Stratvert
3.61M subscribers
<__slot-el>
<__slot-el>
3M views 3 years ago #stratvert
In this step-by-step tutorial, learn how to create dynamic and interactive Excel dashboards. With a dashboard, you can showcase the most important information and key performance indicators (KPIs) that your organization cares about. All you need is Microsoft Excel -- there's no need for any VBA or add-ons. When you receive new data, you can easily update your dashboard to reflect the latest. You can adjust the look and feel using various themes and you can even customize the dashboard to match your organization's color scheme. Once you finish, you can share out your dashboard easily for others to consume. If you'd like to follow along, you'll find the sample sheet that I used below. 📚 RESOURCES  …...more
...more
📊 How to Build Excel Interactive Dashboards
54KLikes
3,026,264Views
2021Jul 15
In this step-by-step tutorial, learn how to create dynamic and interactive Excel dashboards. With a dashboard, you can showcase the most important information and key performance indicators (KPIs) that your organization cares about. All you need is Microsoft Excel -- there's no need for any VBA or add-ons. When you receive new data, you can easily update your dashboard to reflect the latest. You can adjust the look and feel using various themes and you can even customize the dashboard to match your organization's color scheme. Once you finish, you can share out your dashboard easily for others to consume. If you'd like to follow along, you'll find the sample sheet that I used below. 📚 RESOURCES ⌚ TIMESTAMPS 00:00 Introduction 00:52 Background on dashboard 01:25 Overview of data 02:15 Create table 02:55 Insert pivot tables 04:10 Pivot table 1 08:43 Pivot table 2 10:00 Pivot table 3 11:57 Align objects 12:31 Set chart height and width 12:50 Add timeline & slicers 14:42 Connect slicers to all pivot charts 15:47 Using slicers to filter 16:02 Add new data & refresh dashboard 17:13 Adjust view to look less like Excel 17:58 Customize theme 18:28 Share dashboard 18:54 Wrap up 📺 RELATED VIDEOS 📩 NEWSLETTER 🔽 CONNECT WITH ME 🎁 TOOLS AND DISCOUNTS ✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY ✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM ✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL ✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa ✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax ✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry ✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr 🎒 MY COURSES  …...more
...more
How this content was made
Auto-dubbed
Audio tracks for some languages were automatically generated. Learn more

Shorts remixing this video

18 July 2021

Follow along using the transcript.

Kevin Stratvert

3.61M subscribers