Introduction1:41:53
Download the MS Excel 2010 pdf file for start learning basic excel skills. Read it carefully and try to perform the given task to learn various functionality given in Excel.
Day-1 Lecture1:17:28
Download Pdf file for day wise lecture notes.
Day-2 Lecture53:07
Explore essential Excel techniques for quantity estimating and costing, including navigation shortcuts, selecting and moving data, managing worksheets, and applying formatting for clear cost sheets.
Day-3 Lecture1:43:41
Assignment-1 on Excel Formula Tutorial
Day-4 Lecture58:59
Assignment-2 on Excel Basic Tutorial
Day-5 Lecture1:13:02
Develop professional Excel skills for quantity estimating and costing by completing daily exercises, preparing measurement and abstract sheets, and using the CSR book and the current schedule of rates.
Assignment-3 Excel Practice for Beginners
Day-6 Lecture1:17:41
Demonstrate how to create and format a measurement sheet in Excel for quantity estimating, including page setup, inserting AutoCAD screenshots, and arranging images with freeze panes, split, and autofill.
Assignment-4 Excel Practice Work Exercise
Assignment-5 Excel Extra Practice Exercise
Day-7 Lecture1:38:31
Day-7 lecture teaches Excel-based quantity estimation and costing, including creating a measurement sheet aligned with AutoCAD drawings and using formulas, functions, and data tools to automate calculations.
Assignment-6 Excel Practice Exercise
Day-8 Lecture1:51:26
Develop hands-on excel skills for quantity estimation and costing in building projects, blending field observation with measurement sheets and formulas. Practice daily, collaborate, and solve problems on site.

Day-9 Lecture1:16:05
Day-10 Lecture1:06:25
Day-11 Lecture1:20:43
Day-12 Lecture1:49:55
Learn to prepare a complete building estimate using CSR rates, compile material, labor, and equipment lists in Excel, and apply brief and detailed specifications from CSR/SSR.
Day-13 Lecture1:49:43
Day-14 Lecture1:37:50
Day-14 guides you to estimate RCC quantities—from excavation and footing to columns, beams, lintels, and slabs—using Excel and CSR-based itemization, with practical size and bearing considerations.
Day-15 Lecture1:20:26
Day-16 Lecture1:33:19
Day-16 of quantity estimating & costing for building trains interns to calculate excavation, plinth filling, RCC quantities, and record results in Excel.
Day-17 Lecture1:39:37
Day-18 Lecture1:02:23
Master quantity estimation for building substructure, from plinth construction and anti-termite treatments to RCC slab, beams, stairs, and waste slabs, guided by SSR references.
Day-19 Lecture1:08:38
Learn detail quantity estimation in the PWD style and accurate project cost planning. Apply Excel-based estimating, SSR references, and modern tools like BIM for on-site planning and management.
Day-20 Lecture56:12
Day-21 Lecture1:19:05
Learn to estimate building quantities by selecting door and window atoms, applying external and internal plaster calculations, and accounting for openings, chicken mesh, and RCC details using SSR guidelines.
Day-22 Lecture1:02:53
Learn to estimate plaster quantities for external and internal walls, deducting doors and windows. Apply SSR atoms for flooring, dado, skirting, vitrified tiles, granite, and mild steel grills.
Day-23 Lecture1:01:09
Develop professional estimating skills by calculating quantities for building components—granite platforms, tiles, jambs and sanitary fittings—and applying SSR rates for accurate cost planning of water supply systems.
Day-24 Lecture1:04:48
Day-25 Lecture1:15:01
Day-26 Lecture1:06:25
Day-27 Lecture1:10:48
Complete measurement sheets, rate analyses, and material calculations using the SSR, incorporating transportation charges, CSR rate increases for municipal areas, and first- and second-floor rate adjustments for accurate costs.
Day-28 Lecture1:19:01
Day-29 Lecture56:19
Day-30 Lecture1:24:35

Requirements

Knowledge of Basics of Building Construction
Knowledge of Building Plan, elevation and section detailing,
Use of scientific calculator
Knowledge of basic concepts of estimating and costing
Basic knowledge of M S Excel skill
Knowledge of AutoCAD Drawing

Description

Part-A] Spreadsheet Practice

The Interface – The Ribbon, Quick Access Toolbar, File Tab, Entering Data into Cells

Basic Formatting – Basic Formatting – Labels & Values, Calculating with Formulas, Copy a Formula with Autofill, Quick Addition with AutoSum, Save Your Work. Exercise –1 & 2

Formulas and Functions – Writing and Copying Formulas, Absolute References, The AutoSum Function, The Payment Function, Exercise

Tables & Charts- Create an Excel Table, Table Tools – Design Tab, Sort Your Data, Filter Your Data, Insert a basic graph, Move a chart to a new worksheet,

Extra Tools – Converting Text to Columns, Conditional Formatting, Using Count & Countif Functions, Removing Duplicates, Sheet Protection, The Excel Table Feature

Part-B] Professional PWD Quantity Estimating & Costing

a) Preparing Building Plan & Section for Estimating

b) Measurement Sheet using Excel – 60 Building Items

c) Using Current Schedule of Rates

d) Abstract Sheet using Excel

e) General Abstract Sheet using Excel

f) Material Quantity Calculation

g) Site Visit for Offline batch only

Trainee will be able to –

a) Prepare Complete Detailed Estimate of Building using Excel.

b) Use Current Schedule of Rate book published by PWD

c) Calculate detailed quantity of complete building items using Excel

d) Calculate Floor wise / Phase wise / Duration wise Cost using Excel

e) Calculate Complete Quantity of all material require for building using Excel

Fill Measurement Book from site work for preparing running bills.

Who this course is for:

Building Site Supervisor,
ITI Draughtsman,
Civil Engineering Polytechnic Diploma Students
Civil Engineering Fresher Graduates,
B. Arch. Fresher Graduates
Civil Engineering Assistant
Junior Quantity Surveyor

Quantity Estimating & Costing for Building

What you'll learn

Explore related topics

Course content

Part-A] Spreadsheet Practice9 lectures • 12hr 36min

Part-B] Professional PWD Quantity Estimating & Costing22 lectures • 28hr 21min

Requirements

Description

Who this course is for: