Construction Project Management Fundamentals Course - 25 | Creating a Progress Dashboard in Excel

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: https://planningengineer.net/courses/construction-project-management-fundamentals-course/ 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: https://planningengineer.net/newsletter/ Our Services: https://planningengineer.net/our-services/ Our Courses: https://planningengineer.net/lp-courses/ Free Arabic Basic Course Playlist: https://youtube.com/playlist?list=PL7qHhNmknL6F5IOHAsNnPVMt1X-fvYe3J Keep in Touch: WhatsApp: +201277767728 Email: [email protected] English YouTube Channel: https://www.youtube.com/c/PlanningengineerNet/videos Arabic YouTube Channel: https://www.youtube.com/@planningengineer3906 LinkedIn: https://www.linkedin.com/company/planning-engineer-est/ Facebook Page: https://www.facebook.com/PlanningEngineerDotNet Facebook Group: https://www.facebook.com/groups/1138400132963230 Twitter: https://twitter.com/PlanningEEst Instagram: https://www.instagram.com/planningengineerest/ TikTok: https://www.tiktok.com/@planningengineerest Hashtags: #ExcelDashboard, #ProjectManagement, #ConstructionPlanning, #ProgressTracking, #PlanningEngineer, #HanyIsmail