📊 How to Build Excel Interactive Dashboards

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=MTlQvyNQ3PM

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 • Sample spreadsheet to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whMgx8... • Introduction to Pivot Tables video: • Pivot Table Excel Tutorial • Advanced Pivot Tables video: • 🧙‍♂️ Pivot Table Excel Tips Tricks • ⌚ 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 • Playlist with all my videos on Excel: • ❎ How to use Excel • 📩 NEWSLETTER • Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/ • 🔽 CONNECT WITH ME • Official website: http://www.kevinstratvert.com • LinkedIn: / kevinstratvert • Discord: https://bit.ly/KevinStratvertDiscord • Twitter: / kevstrat • Facebook: / kevin-stratvert-101912218227818 • TikTok: / kevinstratvert • Instagram: / kevinstratvert • 🎁 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 • Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/ • 🙏 REQUEST VIDEOS • https://forms.gle/BDrTNUoxheEoMLGt5 • 🔔 SUBSCRIBE ON YOUTUBE • https://www.youtube.com/user/kevlers?... • 🙌 SUPPORT THE CHANNEL • Hit the THANKS button in any video! • Amazon affiliate link: https://amzn.to/3kCP2yz • ⚖ DISCLOSURE • Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same. • #stratvert

#############################

New on site