Skip to main content
AmigoFish

How to Create an Excel Dashboard with Copilot

From Kevin Stratvert Β· Β· 6 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Learn how to create an interactive Excel dashboard with Microsoft Copilot. In this step-by-step tutorial, we build a sales dashboard from sample data, explore interactive filters, verify key metrics, customize the design, and see the dashboard automatically update when a new order is added.

Host: Kevin Stratvert

πŸ“š RESOURCES - Sample Excel workbook: https://1drv.ms/x/c/b09f9559f6a16b6c/IQBfflBBTT40QogwtC2-DZyCAdXLGSFSJjE1NbP4yFntwPc?e=eAR7Mu

Prompt 1: Create the dashboard Create a professional, interactive sales dashboard using the data in this workbook. Include key sales metrics, charts showing sales trends and performance, and interactive filters so I can explore the data. Put everything on a new worksheet.

Prompt 2: Customize the theme Redesign the dashboard with a modern dark theme using navy blue backgrounds, gold accents, and high-contrast white text. Keep the existing layout, charts, metrics, and interactive filters fully functional. Make sure all labels and charts remain easy to read.

⌚ TIMESTAMPS 0:00 - Introduction 0:29 - Sample data and Copilot access 1:02 - Create the dashboard with Copilot 1:55 - Explore sales metrics and charts 2:28 - Use interactive filters 3:04 - Verify the dashboard results 4:14 - Customize the dashboard theme 5:00 - Add new data and see automatic updates 5:57 - Wrap up

πŸ“Ί RELATED VIDEOS - Traditional Excel dashboard tutorial: https://youtu.be/MTlQvyNQ3PM

πŸ“© NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://newsletter.kevinstratvert.com

πŸ”½ CONNECT WITH ME - Official website: http://www.kevinstratvert.com - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://bit.ly/KevinStratvertDiscord - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/

🎁 PARTNERS & DISCOUNTED OFFERS πŸ’» Hostinger | https://hostinger.kevinstratvert.com πŸ“‹ Notion | https://notion.kevinstratvert.com πŸ’΅ Quickbooks Online | https://qbo.kevinstratvert.com πŸŽ™οΈ Voicemod AI Voice Changer | https://voicemod.kevinstratvert.com πŸ•΅οΈ VidIQ | http://vidiq.kevinstratvert.com

πŸŽ’ MY COURSES - Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

πŸŽ“ TRAINING - Take your skills, or your team's, to the next level by partnering with us for expert training: https://kevinstratvert.com/training

πŸ™ REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5

πŸ”” SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1

πŸ™Œ 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 #excel

Back to Kevin Stratvert Β· Report a problem