~
Become an Excel Dashboard PRO with this hands-on tutorial. Learn how to think like a business analyst, create KPIs, set up calculations, use pivot tables, slicers and build interactive charts + maps to create this dynamic business dashboard in just 30 minutes.
This is the perfect end to end Excel project for a data analyst.
⭐ What you will learn:
1) How to set up the data for your dashboard in Excel?
2) What KPIs and business questions to address with the dashboard?
3) How to use Pivot Tables to build the "calculation engine" for your Excel dashboard
4) Storytelling with "summary" & "detail" approach
5) Building dashboard canvas with shapes and formatting in Excel
6) Creating various kinds of charts with Excel
7) Formatting charts so they look professional and slick!
8) Setting up Map Charts in Excel
9) Using Picture Links to create grids in dashboard
10) Interactive dashboards with slicers
11) Dashboard theming with Page Layout options
12) Storytelling with strong & insightful titles for your charts
🕐 Topic-wise timestamps:
0:00 - Master Excel Dashboards in 26 Minutes (intro)
1:36 - Data for our dashboard
2:34 - KPIs and business questions for our dashboard
3:32 - Analysing data with Excel - Formulas vs. Pivots
4:00 - Calculated columns in our data
4:42 - Creating Pivot Tables for our dashboard
5:55 - Display format for the pivot values
6:18 - Dashboard Sheet Setup
8:24 - Building the Dashboard Side-panel (for summaries)
10:46 - 13 Week Sales Trend Graph
12:15 - Purchase Patterns Grid Chart (Picture Links)
14:49 - Quantity Distribution Chart (Pivot Grouping!)
16:23 - Most Popular Products Chart
18:02 - Map chart to see Geographic Trends
20:02 - Days to Delivery Chart
20:20 - Customer Satisfaction Chart
21:46 - Slicers for Dashboard Interactions!
26:18 - Adding Chart Titles
27:01 - Dashboard Theming (colors) with Page Layout options
28:44 - Closing Remarks (where to go from here)
📂 Download Sample Data:
🧑💻 Learn more
Join my Excel School program and learn how to build world-class dashboards with Microsoft Excel. Use the coupon code SAVE50 to get $50 discount on the course.
~
#excel #exceldashboard #dashboard