Excel Dashboard for Beginners | Create a Dynamic Dashboard with Pivot Tables and Pivot Charts

Create a professional-looking Excel dashboard from scratch and elevate your data analysis skills, even if you're just starting!

In this tutorial, I’ll walk you through how to build a comparative sales dashboard in Excel using pivot tables, charts, calculated fields, and slicers. You’ll learn how to prep your data, calculate Year-over-Year (YoY) growth, wireframe your layout, and visualize KPIs, all in under 45 minutes.

Perfect for beginners or anyone looking to enhance their Excel and data storytelling skills!

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: freedomoboh123@yahoo.com
What You’ll Learn:
~ Preparing your dataset and adding calculated columns (Month, Year)
~ Creating Pivot Tables and calculated fields
~ Calculating YoY growth using Excel functions
~ Designing a wireframe based on Pinterest inspiration
~ Creating interactive dashboards with slicers, icons, and labels
~ Linking dashboard elements for easy navigation

Download Resources (Dataset + Sample File):
👉[https://drive.google.com/drive/folders/14eRKuM7R8YhUmFy9A5NqFpnQbuHiCNJf?usp=sharing]
Color Picker 👉 https://imagecolorpicker.com

Connect with Me:
LinkedIn: http://www.linkedin.com/in/freedomoboh
X (Twitter): https://x.com/ObohX
YouTube: http://www.youtube.com/@ObohYT
TikTok: https://www.tiktok.com/@obohtt

Who This Video is For:
- Aspiring Data Analysts
- Excel Beginners
- Business Professionals
- Students learning dashboard design
- Anyone interested in data visualization and storytelling

📌 Tools Used:
Microsoft Excel, Pivot Tables, Slicers, Excel Functions (TEXT, IF, TODAY)
, Pinterest for Layout Inspiration.

📢 Don’t forget to Like 👍, Comment 💬, and Subscribe 🔔

⏱️ Timestamp
0:00 – Introduction
0:59 – Prep your Data for analysis
1:40 – Add Year & Month Column using TEXT function
2:30 – Insert Pivot Tables
3:34 – Add Calculated Field (Profit)
4:13 – Calculate YoY Growth
7:35 – Add Indicator using IF function
9:10 – Add more Pivot Tables
13:10 – Wireframing our Dashboard
20:10 – Add Icons into Excel sheet
21:10 – Add Labels to Wireframe
26:20 – Add KPIs
29:01 – Add Pivot Charts & Format Them
40:00 – Add Slicers
41:10 – Add Date using TODAY Function
41:31 – Link Icons for Easy Navigation
44:00 – Outro

#ExcelDashboard #DataAnalytics #DataVisualization #ExcelForBeginners
#ExcelTutorial #BusinessIntelligence #ExcelCharts #InteractiveDashboard

Видео Excel Dashboard for Beginners | Create a Dynamic Dashboard with Pivot Tables and Pivot Charts канала Freedom Oboh