Pravin Vyankatrao Khandve

Online School by Mission IAS Foundation, Amravati by Prof Pravin Khandve and Nareshchandra Kathole

Course available for lifetime after purchase

PWD Estimating & Costing Expert
Duration:	1 Month (45 Hours)
Medium:	Hindi + English
Eligibility:	ITI DMan, Diploma, BE, B.Arch. & Freshers Students 

Learning Outcome:	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
f)	Fill Measurement Book from site work for preparing running bills.

Course Content:
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


PWD Estimating & Costing Expert

PVKT School

Maharashtra

Hey! I’m learning with PVKT School and you can too. Here’s a course you might like: PWD Estimating & Costing Expert by Pravin Vyankatrao Khandve
    https://www.pvktschool.in/courses/250443?utm_source=whatsapp&utm_medium=social&utm_campaign=web-course-share

Hey! I’m learning with PVKT School and you can too. Here’s a course you might like: PWD Estimating & Costing Expert by Pravin Vyankatrao Khandve
    https://www.pvktschool.in/courses/250443?utm_source=facebook&utm_medium=social-fb&utm_campaign=web-course-share

Hey! I’m learning with PVKT School and you can too. Here’s a course you might like: PWD Estimating & Costing Expert by Pravin Vyankatrao Khandve
    https://www.pvktschool.in/courses/250443?utm_source=telegram&utm_medium=social&utm_campaign=web-course-share

Hey! I’m learning with PVKT School and you can too. Here’s a course you might like: PWD Estimating & Costing Expert by Pravin Vyankatrao Khandve
    https://www.pvktschool.in/courses/250443?utm_source=linkedin&utm_medium=social-link&utm_campaign=web-course-share

Hey! I’m learning with PVKT School and you can too. Here’s a course you might like: PWD Estimating & Costing Expert by Pravin Vyankatrao Khandve
    https://www.pvktschool.in/courses/250443?utm_source=copy-link&utm_medium=social&utm_campaign=web-course-share