Chứng chỉ MOS Excel 2019 - Exam MO-200 Microsoft Excel
TS. Dang Xuan Tho
5.0 (500)·6h 10m · 91 lectures
$3.00$12–$199up to −98%
Loading course
Construction Project Data Analysis & Control Using Excel
Analyze real construction project data using Excel formulas, VLOOKUP, SUMIFS, Pivot Tables and reporting techniques
5.027 reviews61 learners
- All Levels
- 4h 24m video
- 28 lectures
- English
- Captions
- Updated 2026
Taught by Hesamoddin Kheirbakhsh
- 4h 24m of on-demand video
- 28 lectures across 6 sections
- One-off payment — no subscription
- Lifetime access on web and mobile
- Closed captions (English)
Curriculum
6 sections28 lectures4h 24m total
- Basic Excel Concepts and Navigation Shortcuts5:49
- Data Entry and Fast Editing Techniques6:57
- Data Selection and Management in Excel7:08
- Creating Tables and Formatting Layouts12:20
- Random Data Generation with RANDBETWEEN and Auto Recalculation11:20
- Introduction to Real Construction Project Database11:12
- Creating Unique Lists from Weather Conditions9:45
- Designing a Permission System Using IF Function13:43
- Registering Permissions and Relative vs Absolute References14:44
- .Creating Dynamic Row Numbers in Tables12:21
- Using SUMIF for Reporting and Data Analysis15:31
- Multi-Dimensional Cost Analysis with SUMIFS7:41
- COUNT Functions and Date/Time Formatting in Excel15:40
- Invoice Counting Using COUNTIF and COUNTIFS5:14
- Using Wildcards (* and ?) iin COUNT Functions for Data Analysis5:58
- Data Comparison Using LARGE and SMALL Functions and Conditional Formatting4:04
- Data Cleaning and Text Splitting Techniques (Text to Columns, Flash Fill, LEFT/R8:54
- Introduction to Data Lookup Using VLOOKUP15:06
- Advanced VLOOKUP with COLUMNS for Dynamic Results5:52
- Professional Use of VLOOKUP in Defined Ranges8:14
- Extracting SPI Metrics Using VLOOKUP4:25
- Data Cleaning for VLOOKUP Using TRIM Function6:21
- Error Handling in VLOOKUP Using IFERROR11:09
- Advanced Data Analysis Using VLOOKUP and CHOOSE Function5:21
- Dependent Dropdown Lists Using Data Validation and INDEX/MATCH7:35
- Structuring Data with Excel Tables and Slicer Filters12:43
- Project Reporting with Pivot Tables and Dynamic Dashboards13:14
- Advanced Data Validation and Dynamic Drop-down Lists5:40
About this course
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 …
Before you start
- 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.
Who it’s for
- Engineers working with project data in Excel
- Planning Engineers
- Project Controls Engineers
- Technical Office Engineers
- Construction Project Professionals
Related
More in Office Productivity
Ôn thi Chứng chỉ MOS Word 2019 - Exam MO-100 Microsoft Word
TS. Dang Xuan Tho
5.0 (467)·5h 36m · 79 lectures$3.00$12–$199up to −98%The AI-Powered Business Writing & Communication Guide
Emmanuel Essien
5.0 (178)·1h 32m · 12 lectures$3.00$12–$199up to −98%Productivity Masterclass: Master GenAI Workflows
Emmanuel Essien
5.0 (157)·2h 51m · 18 lectures$3.00$12–$199up to −98%
$3.00$12–$199