MS-Excel For Civil Engineers for Project Planning From Zero

Master the format painter to copy formatting across cells and leverage inbuilt templates to build dashboards, then customize ribbon and quick access toolbar for your civil engineering dashboard in Excel.

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.

Apply the subtotal command in Excel to sort by year, compute yearly project totals, and view breakdowns by railway, building, road, and water supply projects.

Apply conditional formatting in Excel to color-code costs above or below 50 lakh, using green for above and red for below, and extend formatting to related cells.

Apply Excel conditional formatting to highlight marks, use formulas and paste special, and visualize data with bars, color scales, and top/bottom rules for civil engineering dashboards.

Learn to create data validation in Excel with dropdown lists, using list or custom sources, and build dynamic dropdowns by converting ranges to tables for civil engineering project planning.

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.

Master flash fill in Excel with Ctrl-E to extract first names, initials, and other patterns. Apply these techniques to estimation sheets in civil engineering.

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.

Learn to use roundup and round down in Excel to round to the nearest ten, hundred, and thousand, with minus one, minus two, and minus three examples.

Learn to use sum, autosum, subtotal, and aggregate tools in Excel to total costs, filter by year, and handle absent values and hidden rows.

Remove duplicates in Excel by using the data tab's remove duplicates feature to ensure unique records, selecting fields such as student name, roll number, science, mathematics, and total.

Learn how to enter dates in Excel, convert numbers to dates, and use end of month and start date of the next month calculations, plus today and now for dates.

Master cell referencing in Excel by calculating project cost percentages from a total, using absolute and relative references, and anchoring with dollar signs to drag formulas across rows and columns.

Learn how to use Excel text commands to count characters with len, extract left, right, and middle letters, and format case with lower, upper, and proper, including flash fill.

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.

Protect an Excel sheet with a password to prevent changes. Unprotect to edit and unlock specific cells (like English marks) while restricting others.

Learn how to hide formulas in Excel sheets and protect workbooks, protect sheets with passwords, and manage who can edit specific cells using allow edit ranges.

Learn to use sum, sumif, and countif in Excel to calculate contractor totals, apply filters, and build dynamic summaries of concrete consumption and cement bags.

Master min, max, and rank in Excel for civil project planning, learn to compute averages with average if, identify extreme values, rank students, and anchor references using F4.

Explore the match function in Excel to locate a value in large data lists, practice exact-match lookups, and prepare to combine with index for project data analysis.

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.

Define the scope and nature of the project, comparing RCC office blocks with steel factory areas. Plan the sequence from excavation to concreting, prioritizing the factory area per client requirements.

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.

Prepare a baseline schedule for a G+4 office block foundation works, detailing the sequence of earthwork, PCC, reinforcement, formwork, and concreting, with parallel activities and labor productivity considerations.

Create a baseline schedule in excel for column works up to the plinth beam, detailing starter concrete, reinforcement, formwork, and concreting with overlaps and holiday adjustments.

Set up a baseline schedule for plinth beams and backfilling, coordinating backfilling, consolidation, PCC, shuttering, reinforcement, and concreting with overlaps to optimize site work.

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.

Develop a baseline schedule for the first floor column activities in Excel, detailing starter concrete, reinforcement, formwork, slab concreting, and overlaps with finish-to-start links.

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 build a ground floor finishing baseline schedule in Excel by mapping brickwork to plastering and painting, detailing dependencies and overlaps to optimize construction flow.

Develop a terrace floor finishing baseline schedule by setting shuttering dates, overlaps, and activity durations across masonry, plastering, electrical and sanitary works, doors, flooring, tiling, painting, and finishing.

Develop a baseline schedule for external finishing and common areas, sequencing external plumbing, sewer lines, plastering, waterproofing, painting, and handrails with overlaps for timely site handover.

Learn to generate monthwise quantities from a baseline schedule in Excel, mapping earthwork, substructure and superstructure activities to start and finish dates, and building a clear BOQ.

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

Learn to calculate the asking rate per day and derive monthwise quantities for earthwork, PCC, shuttering, reinforcement, concreting, and backfilling using start and end dates to plan manpower and equipment.

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 compute monthwise quantities in square meters for ground floor finishing activities, including masonry, plastering, flooring, tiling, and internal painting, using a baseline schedule and outsourcing external work.

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

Learn to compute month-wise invoicing by deriving average rates from quantities and contractor rates, covering earthwork, reinforcement, concreting, shuttering, and backfilling from the bill of quantities.

Calculate month-wise invoicing for earthwork, PCC, reinforcement, and concreting by multiplying monthly quantities by average rates. Update the zero schedule to reflect changes across August, September, and beyond.

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.

Calculate month-wise bulk material quantities for a civil project using the S1 schedule, covering cement, aggregates, bricks, earthwork, reinforcement, shuttering, plastering, flooring, and tiling.

Prepare a duration Excel sheet for a civil project by computing start and finish dates for all activities, from earthwork to finishing, aligned with the S1 schedule and total quantity.

Calculate the asking rate per day for the entire project by dividing total quantity by duration, then determine month-wise requirements for all activities.

Learn to calculate coefficients for pcc and rcc and determine material quantities for cement, sand, and aggregates. Apply these coefficients to plastering, masonry, and flooring works.

Compute August cement bags and material quantities for PCC and concrete work, based on month-wise data. Apply sand and aggregate coefficients and add a 3% wastage to deliver practical cement, sand, and aggregate requirements.

Learn to calculate month-wise quantities of cement, sand, aggregate, and steel for civil projects, applying wastage factors and simple multipliers using real-world August and September examples.

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.

Create and analyze a manpower schedule in Excel, selecting carpenters, helpers, masons, and unskilled labor, and use productivity norms to estimate monthly workforce needs for shuttering, reinforcement, and masonry work.

Use Excel to calculate monthly manpower for reinforcement and civil works, identifying bar benders, helpers, and unskilled labor needs. Build a month by month plan and chart to visualize staffing.