Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Construction Project Data Analysis & Control Using Excel

Name: Construction Project Data Analysis & Control Using Excel
Rating: 4.8 (36 reviews)

Analyze real construction project data using Excel formulas, VLOOKUP, SUMIFS, Pivot Tables and reporting techniques

Created byHesamoddin Kheirbakhsh

Last updated 7/2026

English

English [Auto],Spanish

What you'll learn

Analyze real construction project data from multiple real-world projects
Build structured project databases for reporting and project control decision-making
Track and evaluate project costs across cost centers and project categories
Monitor invoices, expenses, and overall financial performance of projects
Calculate and compare planned vs actual project progress and performance indicators
Create dynamic permission systems based on real project conditions (e.g. weather-based rules)
Clean, structure, and prepare large construction datasets using Excel techniques
Automate reporting processes using Excel formulas and logical structures
Extract actionable insights from construction data for management reporting
Build project control reports using Excel, Pivot Tables, and structured analysis

Course content

6 sections • 28 lectures • 4h 24m total length

Basic Excel Concepts and Navigation Shortcuts5:49
Navigate and select large data ranges in Excel quickly using Ctrl+Arrow to reach the last row or column, and Ctrl+Shift+Arrow to select full range for project data analysis.
Data Entry and Fast Editing Techniques6:57
Master fast data entry in Excel by filling a selected range with the same value using Ctrl+Enter, and navigate with Ctrl and arrow keys for daily reports.
Data Selection and Management in Excel7:08
Master navigating large Excel databases with Ctrl+arrow key to reach the edge of continuous data, Ctrl+Shift+arrow key to select, and Ctrl+A to select the entire data area.
Creating Tables and Formatting Layouts12:20
Customize the Excel environment for project databases by refreshing MSP data and building a days-by-months matrix to track hours and progress using center across selection.
Random Data Generation with RANDBETWEEN and Auto Recalculation11:20
Learn to generate random integers with rand between in Excel, apply it across ranges, and freeze results by paste special values; find and fill blanks with go to special.

Introduction to Real Construction Project Database11:12
Explore managing a course database in Excel, apply filters for weather data, and extract a unique list using the Excel 2021 unique function.
Creating Unique Lists from Weather Conditions9:45
Discover practical methods to create a unique list from a column in Excel, using remove duplicates and advanced filter to copy results to another location without affecting original data.
Designing a Permission System Using IF Function13:43
Learn to categorize project data by weather in Excel for project data analysis and reporting, using nested IF formulas to map conditions like sunny, rainy, and snowy to permitted tasks.
Registering Permissions and Relative vs Absolute References14:44
Design practical database conditions with nested if statements in Excel, using absolute and relative references, dollar signs, and F4 to lock references while dragging formulas.

.Creating Dynamic Row Numbers in Tables12:21
Use the row, rows, column, and columns functions to create dynamic row numbers in Excel, and apply the if function to display numbers only when a name exists.
Using SUMIF for Reporting and Data Analysis15:31
Apply sum if to aggregate project expenses by cost center in Excel, and compare sum product and if logic for array-based reporting.
Multi-Dimensional Cost Analysis with SUMIFS7:41
Learn to create a multi-criteria sum matrix in Excel using SUMIFS, enabling costs by cost center across projects, with unique lists, absolute references, and dynamic reporting.
COUNT Functions and Date/Time Formatting in Excel15:40
Explore how Excel counts data using COUNT, COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS, and understand how dates and times are stored as numbers for accurate project data analysis.

Invoice Counting Using COUNTIF and COUNTIFS5:14
Learn how counta counts non-empty cells, and countblank counts empty cells, then apply countif and countifs to tally by cost center and by project using absolute references.
Using Wildcards (* and ?) iin COUNT Functions for Data Analysis5:58
Learn to use wildcards in excel to count Paris occurrences with countif and countifs. Count six character names using six question marks and len.
Data Comparison Using LARGE and SMALL Functions and Conditional Formatting4:04
Learn to count numbers greater than 50 with countif and countifs, use an if test to flag values, and apply conditional formatting to highlight and filter by color.
Data Cleaning and Text Splitting Techniques (Text to Columns, Flash Fill, LEFT/R8:54
Learn to organize and split project data in Excel using Text to Columns and Flash Fill, separating delimited values and extracting year, month, and day.

Introduction to Data Lookup Using VLOOKUP15:06
Master vlookup to retrieve age, weight, and height by matching a name in the first column and returning values from subsequent columns, with exact match and key arguments explained.
Advanced VLOOKUP with COLUMNS for Dynamic Results5:52
Explore dynamic vlookup in Excel by leveraging the columns function to count columns, and apply absolute and relative references to create flexible, drag-ready lookup ranges for project data analysis.
Professional Use of VLOOKUP in Defined Ranges8:14
Master approximate lookups in Excel using VLOOKUP to map values to weight ranges, return attributes from the third column, and understand exact vs approximate matches on a sorted list.
Extracting SPI Metrics Using VLOOKUP4:25
Use vlookup in Excel to map SPI values to a status label in MSP dashboards. Identify ranges like bad to ideal and reveal plan errors.
Data Cleaning for VLOOKUP Using TRIM Function6:21
learn how to clean data in excel by using trim to remove extra spaces and apply vlookup with exact matching to ensure correct commission results.
Error Handling in VLOOKUP Using IFERROR11:09
Master VLOOKUP in tricky conditions by handling text-to-number conversions with value, using exact matches and absolute references, and error handling with iferror for dynamic project budgets and multi-column lookups.
Advanced Data Analysis Using VLOOKUP and CHOOSE Function5:21
Learn how to design combined vlookup formulas using the choose function to search across non-sequential data, creating dynamic lookup tables for project cost and part data.

Dependent Dropdown Lists Using Data Validation and INDEX/MATCH7:35
Learn to combine index and match with dropdowns to dynamically retrieve schedule data from a grid, using exact matches for row and column lookups in project datasets.
Structuring Data with Excel Tables and Slicer Filters12:43
Learn to use tables and pivot tables in Microsoft Excel for project data analysis and reporting, including formatting, filtering, totals, and slicers.
Project Reporting with Pivot Tables and Dynamic Dashboards13:14
Advanced Data Validation and Dynamic Drop-down Lists5:40

Requirements

A basic understanding of construction project concepts is helpful, but not required
No advanced Excel knowledge is needed — everything is explained from the fundamentals
A computer with Microsoft Excel installed (2016 or later recommended)
Willingness to work with real-world construction project data and practical scenarios
No prior experience in project data analysis is required.

Description

In construction projects, data is everywhere — but the real value comes from transforming raw project data into meaningful information for cost analysis, project control, and better decision-making.

This course is designed for Planning Engineers, Project Control Engineers, Civil Engineers, and Technical Office professionals who want to move beyond basic Excel usage and learn how to analyze real construction project data in a structured, practical, and job-focused way.

Unlike generic Excel courses, this course is built entirely around real construction project databases collected from multiple projects. You will work with practical project information including costs, invoices, progress data, weather conditions, cost centers, resources, and performance indicators.

Step by step, you will learn how to organize, clean, structure, and analyze construction project data using Excel tools and functions. Instead of learning isolated formulas, you will understand how Excel can be applied as a practical analytical tool in real project environments.

Throughout the course, you will learn how to build and manage project databases and use powerful Excel functions such as IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS, VLOOKUP, INDEX/MATCH, and Pivot Tables to extract meaningful information from complex datasets.

You will develop practical systems for construction project analysis, including cost analysis, invoice analysis, performance tracking, data management, and permission-based logic systems based on real-world project conditions.

You will also learn how to improve data organization using Excel Tables, Data Validation, dynamic lists, filtering tools, and Pivot Tables to support project reporting and decision-making processes.

This course is fully based on realistic construction project data, meaning every concept is applied to engineering and project control scenarios rather than simple Excel examples.

What Makes This Course Different

Real construction project databases from multiple projects
Practical Excel applications for construction data analysis
Learning through realistic engineering and project control scenarios
Professional use of Excel formulas for project workflows
Cost, invoice, progress, and performance data analysis
Structured project data management techniques
Focus on practical skills used in construction environments

Main Topics Covered

Construction project database structure and data management
Excel Tables and efficient data organization
Logical functions and permission-based systems using IF
Project data analysis using SUMIF and SUMIFS
Cost and invoice analysis using COUNTIF and COUNTIFS
Data cleaning and text processing techniques
Professional data lookup using VLOOKUP
Advanced lookup methods using INDEX/MATCH and CHOOSE
Error handling with IFERROR
Dynamic lists and Data Validation
Pivot Tables for project data analysis
Practical reporting techniques using Excel tools

If you are a civil engineer, structural engineer, planning engineer, project control engineer, or technical office professional who wants to improve your ability to work with construction project data, this course will guide you step by step through a practical Excel-based workflow.

By the end of this course, you will be able to confidently manage construction project databases, analyze project information, extract valuable insights, and use Excel as a powerful tool for engineering and project control activities.

If you have any questions during the course, feel free to ask — I’m here to help you understand each concept step by step.

Who this course is for:

Engineers working with project data in Excel
Planning Engineers
Project Controls Engineers
Technical Office Engineers
Construction Project Professionals

Construction Project Data Analysis & Control Using Excel

What you'll learn

Explore related topics

Course content

Excel Fundamentals for Project Work5 lectures • 44min

Project Database & Permission System4 lectures • 49min

Data Structuring & Dynamic Calculations4 lectures • 51min

Cost & Invoice Analysis4 lectures • 24min

Data Lookup & Analysis (VLOOKUP Core)7 lectures • 56min

Data Analysis and Reporting for Project Data4 lectures • 39min

Requirements

Description

Who this course is for: