📊 How to Build Excel Interactive Dashboards
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.
👋 Additional 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
0:00 Introduction
0:52 Background on dashboard
1:25 Overview of data
2:15 Create table
2:55 Insert pivot tables
4:10 Pivot table 1
8: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
📃 Watch related playlists
- Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
Видео 📊 How to Build Excel Interactive Dashboards канала Kevin Stratvert
👋 Additional 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
0:00 Introduction
0:52 Background on dashboard
1:25 Overview of data
2:15 Create table
2:55 Insert pivot tables
4:10 Pivot table 1
8: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
📃 Watch related playlists
- Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
Видео 📊 How to Build Excel Interactive Dashboards канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use Power Pivot in ExcelExcel INDEX MATCH Made Simple - Lookup like a ProHow to Remove Background from Picture4 Hidden Excel Dashboard Design Tips for Beautiful ReportsHow to make Fillable Form in Microsoft Word📨 10 Tips to Take Control of your Outlook Inbox & avoid email overload!How to Use Excel Checkboxes | Interactive Checklists & ReportsHow to build Interactive Excel DashboardsExcel Dashboard - Plan vs Actual Variances - FREE Download🧙♂️ Top 14 Excel Pivot Table Tips & Tricks - Tutorial👑 10 BEST FREE Web Sites You Should Use in 2021How to Create Macros in Excel TutorialSecrets to Building Excel Dashboards in Under 15 Minutes!💥 How to use PowerPoint Morph TransitionCreate INTERACTIVE Excel Dashboards With Option Buttons | How to use Radio ButtonsHow to use Microsoft Power QueryHow to use Microsoft Access - Beginner TutorialHow to Forecast & use Trendlines in Microsoft ExcelSecrets to Building Excel Dashboards based on Non-financial Data