Quantity Estimating & Costing for Building
Master Excel for accurate quantity estimation & building material calculations. Learn to prepare bills of quantities & analyze rates efficiently.
Course Content
Quantity Estimating & Costing for Building is an advanced Udemy course taught by Pravin Khandve. It runs 40h 57m, is taught in English, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 20 reviews, with 143 students enrolled. It is a paid course, first published February 2023.
Excel Skills for Quantity Surveying & Cost Estimating
Part-A: Mastering Excel Fundamentals
This section provides a comprehensive introduction to Excel for practical application in quantity surveying. You'll learn the essential tools and techniques to efficiently manage and analyze construction data.
- Navigating the Interface: Become familiar with the Excel Ribbon, Quick Access Toolbar, and File Tab for streamlined workflow.
- Data Entry & Basic Formatting: Learn to accurately enter data into cells, format labels and values, and utilize basic formulas for calculations.
- Formula Proficiency: Master copying formulas with Autofill, leveraging the AutoSum function for quick calculations, and understanding the Payment Function.
- Data Organization with Tables: Create and utilize Excel Tables for enhanced data management and efficient sorting and filtering. Explore the Table Tools - Design Tab.
- Data Analysis & Visualization: Sort and filter data within tables, and insert basic graphs to visualize trends and insights. Learn to move charts between worksheets.
- Advanced Data Tools: Efficiently convert text to columns, apply conditional formatting for data highlighting, and utilize Count & Countif functions for data aggregation. Remove duplicates and protect your Excel sheets.
Exercises: Practical exercises reinforce each concept, building your confidence and skill.
Part-B: Professional Quantity Estimating & Costing with Excel
This section focuses on applying Excel to the specific tasks of PWD (Public Works Department) quantity estimation and costing.
- Plan Preparation: Learn to prepare building plans and sections specifically for estimating purposes.
- Measurement Sheets: Create detailed measurement sheets using Excel covering 60 common building items.
- Schedule of Rates Integration: Effectively utilize the current Schedule of Rates published by the PWD.
- Abstract Sheets: Develop abstract sheets using Excel to summarize quantities and costs.
- General Abstract Sheets: Create comprehensive general abstract sheets using Excel for detailed cost breakdowns.
- Material Quantity Calculation: Accurately calculate the quantity of all materials required for construction projects using Excel.
- Site Visit Integration: Learn how to integrate site visit data into your Excel estimates for offline batch processing.
Upon completion, you will be able to:
- Prepare complete and detailed building estimates using Excel.
- Apply the current PWD Schedule of Rates effectively.
- Calculate detailed quantities for all building items using Excel.
- Calculate floor-wise, phase-wise, and duration-wise costs using Excel.
- Calculate the complete material quantity required for a building project using Excel.
- Fill Measurement Books from site work to prepare running bills.
This course equips you with the practical Excel skills necessary for accurate and efficient quantity surveying and cost estimating within the PWD framework.
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.