Скачать или смотреть Interactive Excel Dashboard Step-by-Step Tutorial for Beginners

#ExcelDashboard #ExcelTutorial #Excel



In this step-by-step tutorial, you'll learn how to create a clean, interactive, and fully dynamic Excel dashboard, perfect for showcasing key metrics like Sales, Profit, Shipping Duration, and State-wise Distribution.
Whether you're a beginner or want to sharpen your dashboard design skills, this project will walk you through the entire workflow, from raw data to a polished final dashboard, all using just Microsoft Excel (no VBA, no third-party tools).
This dashboard is perfect for business reports, management reviews, or presentations where clarity and design matter.

Work With Me
I help businesses and individuals make sense of their data with dashboards, trackers, and custom solutions and excel coaching.
📩 To work with me, send a message to:
📱 WhatsApp / iMessage: +234 816 299 8619
✉️ Email: [email protected]


📁 Download the resources to follow along:[https://drive.google.com/drive/folder...]
✔️ Dataset (Furniture Sales Data)
✔️ Final Excel Dashboard File
✔️ Documentation with color codes & project notes

🤝 CONNECT WITH ME
Let’s stay connected and grow together in this data journey:

🔹 X (formerly Twitter): https://x.com/ObohX
🔹 LinkedIn:   / freedomoboh  

I share Excel tips, dashboard inspiration, project walkthroughs, and behind-the-scenes from my data journey.
Feel free to connect, drop your questions, or share your own project attempts, I’d love to see what you’re building!

⏱️ TIMESTAMPS

00:00 – Introduction
02:10 – Load Data into Power Query
05:28 – Add Custom Column (Duration Days)
06:01 – Add Suffix for Days
06:53 – Extract Month Name from Order Date
07:40 – Create Pivot Table
09:20 – KPI Calculations (Sales, Quantity, Profit)
14:15 – Year-on-Year (YoY) Calculations
29:40 – Wireframing Your Dashboard Layout
37:52 – Label Your Dashboard Sections
45:39 – Add KPI Cards to Dashboard
48:45 – Insert & Customize Line Chart
49:15 – Format Line Chart as Lollipop Chart
55:00 – Insert Map Chart (Sales by State)
56:45 – Insert Bar Chart (Progress Bars)
59:50 – Insert Donut Chart (Shipping Mode)
1:05:14 – Insert Bar Chart (Sub-Category Sales)
1:08:47 – Add Slicers (Region, Segment)
1:11:10 – Link Slicers to All Pivot Tables
1:13:33 – Outro

#ExcelDashboard #Excel #exceltutorial #exceltutorialforbeginners #vbaexcel