MS-Excel For Civil Engineers for Project Planning From Zero

Master freeze panes to keep headers visible while scrolling in long estimation sheets, and use the filter command with alt d f f to isolate LA, Afcons, NCC.

Sort data in Excel using filters and multi-level sorting to rank contractors by total project cost and then by name, using alt+d f f and alt+d s.

Learn how to remove and configure drop-down lists using data validation, set allowed values from a list or manual input, and customize input messages and error alerts in Excel.

Learn advanced filter in Excel by defining a criteria range, applying multi-criteria filters across month and year, and copying results elsewhere, with conditional formatting for earthwork, concrete, and shuttering.

Master Excel roundup and rounddown to convert decimals into whole numbers for civil engineering calculations, including concrete mix volumes, material costs, and cement bag counts.

Explore how to trace precedents and trace dependents in Excel, reveal and review formulas with show formulas, remove arrows, and evaluate formula to trace inter-sheet links.

Define planning as a systematic process to achieve targets within time and cost, considering scope, milestones and priorities, resources, site and climatic conditions, and construction methodology to optimize outcomes.

Learn how start-to-start and finish-to-start links enable overlapping activities—earthwork, reinforcement, formwork, and concreting—to finish on schedule by dynamic duration adjustments in a project plan.

Learn to prepare a baseline schedule for a ground floor column, from starter concrete and reinforcement to formwork, shuttering, slab centering, and eventual concreting, including electrical conduits and overlap planning.

Create a baseline schedule for the first floor slab concreting, coordinating column, beam, and reinforcement with 5–6 day overlaps to enable parallel activities and prevent delays.

Create a baseline schedule for the lift machine room terrace portion, reflecting reduced scope and shorter durations, and align reinforcement, formwork, slab concreting, and overlaps with limited electrical conduit work.

Learn to calculate month‑wise quantities and start‑finish dates for earthwork, PCC, reinforcement, and substructure activities from the baseline schedule in Excel.

Calculate monthwise quantities for ground floor activities by linking start and end dates to daily productivity of earthwork, formwork, reinforcement, and concreting.

Calculate monthwise quantities for the first floor and other floors in Excel by applying ground floor values to columns, beams, slab shuttering, concrete and reinforcement.

Learn to calculate monthwise quantities for external finishes, using square meter and running meter units, with example timings, rate calculations, and optional plumbing lines.

Compute month-wise quantities and invoices for excavation, shuttering, and concreting in the superstructure using average rates, then apply the same method to finishing works for budgeting.

Master month-wise estimation of cement, concrete, and masonry quantities, including cement blocks and red bricks, using coefficients and wastage allowances for December planning.

Practice building a baseline schedule in excel by adjusting start and end dates, durations, and quantities, and inputting values across baseline, s1, and bulk materials sheets to complete assignments.