Excel Tutorials for Construction

Practical spreadsheet templates and step-by-step guides for estimating, scheduling, and tracking jobs — no fluff, just formulas that work.

ESTIMATING

Building a Materials Takeoff Sheet

Set up a reusable takeoff template that scales from a small remodel to a full build, with automatic quantity totals.

8 min readRead tutorial →
FORMULAS

Concrete & Rebar Quantity Calculator

A formula-driven sheet that converts slab dimensions into concrete volume, bag counts, and rebar linear footage.

10 min readRead tutorial →
ESTIMATING

Project Cost Estimator with SUMIF & VLOOKUP

Pull unit costs from a price list and roll them up into a bid total automatically as line items change.

12 min readRead tutorial →
SCHEDULING

Gantt-Style Construction Schedule

Build a simple bar-chart schedule using conditional formatting — no add-ins, works in any version of Excel.

9 min readRead tutorial →
COST TRACKING

Change Order Tracker

Log change orders against the original contract value and see running budget impact in real time.

7 min readRead tutorial →
FORMULAS

Auto-Converting Units with CONVERT()

Stop retyping numbers between feet, meters, and yards — let Excel's built-in CONVERT function do it for you.

5 min readRead tutorial →