Рет қаралды 471
Build an awesome interactive Excel dashboard in just 15 minutes.
In this video we'll build a dynamic Excel dashboard from scratch in just 15 minutes. This may be a sales dashboard for any organization or company. First, we'll make the summary tables using excel formulas. Then we'll build the overall structure using shapes and icons. Next we'll create all of the charts and visuals which include a map chart, radar chart, line chart, doughnut chart, KPIs, and more. Finally, we'll customize the visuals and add them to the dashboard.
Please join us at
YT: / @bestlearnings4265 (@bestlearnings4265
FB: profile.php?... (Excelfun)
TikTok: / bestlearnings
#DashboardDesign #ExcelDashboard #DataVisualization #DataAnalysis #KPIs #DynamicInteraction #RealTimeData #CustomizableLayout #DataIntegration #ExcelSkills #BusinessInsights #DataSummarization #ExcelTips #AdvancedExcel #businessintelligence
Chapters:
00:00 Introduction
00:29 SUMMARISE DATA IN TABLES
03:23 CREATE CHARTS
09:17 CREATE DASHBOARD
15:04 COMPLETE DASHBOARD AND KEY FEATURES