Learn how to create a professional, efficient, and visually appealing dashboard in Excel from scratch! This step-by-step tutorial will guide you through every stage: data preparation, visualization setup, and final touches. Perfect for beginners and advanced users alike!
00:00 - Intro
01:20 - Preparing the Foundation for the Dashboard
11:44 - Sales Chart by Month
21:03 - Sales Chart by Region
24:32 - Sales Chart by Quarters
29:55 - Pie Chart of Sales by Product Subcategories
38:26 - Sales Charts by Product Categories
47:49 - Sales Charts by Segments
54:35 - Sales Ranking by Cities
01:08:43 - Setting Up Relationships Between Different Tables
01:17:18 - Setting Up Conditional Formatting
01:19:57 - Nuance of Interaction Between Objects and Cells
01:20:52 - Excel Chart in the Form of a Speedometer
01:28:20 - Displaying Key Metrics
01:38:54 - Formatting Slicers
01:42:56 - Setting Up City Rating Toggles
01:47:55 - Final Dashboard Setup
#excel
#dashboard
#dashboardinexcel
#exceltutorial
#exceldashboard