25 | Creating a Progress Dashboard in Excel
Вставка
- Опубліковано 14 жов 2024
- In this lesson, Hany Ismail from Planning Engineer website walks you through the step-by-step process of creating a progress dashboard in Excel. By following along, you’ll learn how to set up a functional, professional dashboard that can be used to track project progress, including SPI, planned vs. actual percentages, and shop drawing and material submittals.
This video covers:
How to set up data sheets and dashboard layout.
The use of Excel formulas like COUNTIF, IF, and conditional formatting.
How to create and format charts (pie charts, bar charts) for visual representation.
Tips for linking data dynamically to reports, using project information and KPI tracking.
Download Practice Files:
Link to the dashboard file and instructions: planningengine...
Timestamps:
00:10 Setting Up the Dashboard Layout
03:00 Linking Data and Using Formulas for Planned & Actual Progress
07:40 Creating and Formatting Progress Charts
11:30 Using COUNTIF for Shop Drawing and Material Submittals
15:50 Generating Pie Charts for Shop Drawings and Materials
19:30 Organizing and Formatting the Dashboard Layout
22:30 Adding Conditional Formatting for SPI and Performance Indicators
26:00 Final Touches and Tips for Customizing Your Dashboard
Additional Resources:
Join our email Newsletter: planningengine...
Our Services: planningengine...
Our Courses: planningengine...
Free Arabic Basic Course Playlist: • كورس اعداد مهندس تخطيط...
Keep in Touch:
WhatsApp: +201277767728
Email: Info@PlanningEngineer.Net
English UA-cam Channel: / planningengineernet
Arabic UA-cam Channel: / @planningengineer3906
LinkedIn: / planning-engineer-est
Facebook Page: / planningengineerdotnet
Facebook Group: / 1138400132963230
Twitter: / planningeest
Instagram: / planningengineerest
TikTok: / planningengineerest
Hashtags:
#ExcelDashboard, #ProjectManagement, #ConstructionPlanning, #ProgressTracking, #PlanningEngineer, #HanyIsmail
Thanks Sir
Great