Step by step, you create a smart data model that links the cost estimate to the project schedule, calculates monthly direct and indirect costs, payments and cash in / cash out, and updates the cost plan automatically with every progress update. You then update actual costs, compare them with the budget and find the activities that overrun in materials, labour, equipment and subcontractors.
39Lessons
30 HoursDuration
EnglishLanguage
LifetimeAccess
CertificateWith QR verification
What you’ll learn
- Create a cost control process from scratch
- Distribute the estimated cost over time using the project schedule
- Calculate monthly direct and indirect costs, payments, and cash in and cash out
- Link weekly progress updates to the budget cost
- Update actual costs quickly with our smart sheet
- Find cost overruns for materials, labour, equipment and subcontractors
- Build summary and detailed cost reports for all projects
- Make the data model dynamic and reuse it for any custom report
Who this course is for
- Planning and cost engineers
- Quantity surveyors
- Site engineers
- Project and construction managers
- Anyone with construction experience who wants to learn cost control
Requirements
- Basic construction project experience
- Microsoft Excel (Office 365 recommended)
- Recommended: Primavera Online Basic Course
What you get
Lifetime accessWatch every lesson anytime, as many times as you like.
Course filesDownload the lesson files, templates and tools.
WhatsApp support groupAsk questions and get answers from our team in the course group.
Articles libraryPractical articles, files and ready-to-use templates.
Course Q&AAnswers to common student questions, curated by our team.
Certificate of completionVerified with a QR code when you complete the course.
FAQ
What is the price?
Prices are in US dollars and vary from one country to another. The price shown on this page is the price for your country.
Do I need an account?
No. If you don’t have an account, it is created automatically during checkout.
How do I start after checkout?
You are enrolled automatically. Open the course page and start the first lesson.
Do I need expensive cost control software?
No. The whole system is built in Excel using its data model and Power Query, so you can apply it on any project.
Does the course teach cost estimation or scheduling?
No. Cost estimation is a quantity surveying task and scheduling is covered in our other courses. This course starts from an existing estimate and schedule and shows you how to control the cost.
Is there a bonus?
Yes. You receive the “Cost Control in Construction Projects” manual e-book and the Activity–BOQ linking tool.
What is in the Articles Library?
The course includes a library of practical articles, downloadable files and ready-to-use templates on cost control and project controls topics. Anyone can browse it in the Library tab; enrolled trainees can download every file.