Hi guys, Welcome to the Advanced Video Search Engine, and you are watching π How to Build Excel Interactive Dashboards. That video is uploaded by Kevin Stratvert at 2021-07-15T00:00:06-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [MTlQvyNQ3PM]
| Name | π How to Build Excel Interactive Dashboards |
| Video Uploader | Video From Kevin Stratvert |
| Upload Date | This Video Uploaded At 15-07-2021 07:00:06 |
| Video Discription | π₯ Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com 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-whMgx8bXq-2uARjf45Q?e=VU4CPy - Introduction to Pivot Tables video: https://youtu.be/m0wI61ahfLc - Advanced Pivot Tables video: https://youtu.be/3g1CSG5zvQ0 β 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: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY π© 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: 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/ π 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?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 MTlQvyNQ3PM |
| Category | Science & Technology |
| Tags | kevin stratvert | excel | dashboard | interactive | interactive dashboard | dashboards | excel interactive dashboard | interactive dashboard excel | microsoft | ms excel | excel dashboard | dynamic | pivot table | pivot chart | how to | tutorial | dynamic dashboard | kpis | kpi | pivot | data | table | tables | timeline | slicers | slicer | timelines | filter | refresh | basics | easy | simple | learn | training | dash board | console | design | report | excel dashboard for beginners | template | templates | pivottable | worksheet | spreadsheet | labels | ms |
