What you'll learn
Prepare Complete Detailed Estimate of Building using Excel.
Use Current Schedule of Rate book published by PWD
Calculate detailed quantity of complete building items using Excel
Calculate Floor wise / Phase wise / Duration wise Cost using Excel
Calculate Complete Quantity of all material require for building using Excel
Fill Measurement Book from site work for preparing running bills.
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 PracticeThe Interface – The Ribbon, Quick Access Toolbar, File Tab, Entering Data into CellsBasic Formatting – Basic Formatting – Labels & Values, Calculating with Formulas, Copy a Formula with Autofill, Quick Addition with AutoSum, Save Your Work. Exercise –1 & 2Formulas and Functions – Writing and Copying Formulas, Absolute References, The AutoSum Function, The Payment Function, ExerciseTables & 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 FeaturePart-B] Professional PWD Quantity Estimating & Costinga) Preparing Building Plan & Section for Estimatingb) Measurement Sheet using Excel – 60 Building Itemsc) Using Current Schedule of Ratesd) Abstract Sheet using Excele) General Abstract Sheet using Excelf) Material Quantity Calculationg) Site Visit for Offline batch onlyTrainee will be able to –a) Prepare Complete Detailed Estimate of Building using Excel.b) Use Current Schedule of Rate book published by PWDc) Calculate detailed quantity of complete building items using Exceld) Calculate Floor wise / Phase wise / Duration wise Cost using Excele) Calculate Complete Quantity of all material require for building using ExcelFill Measurement Book from site work for preparing running bills.
Overview
Section 1: Part-A] Spreadsheet Practice
Lecture 1 Introduction
Lecture 2 Day-1 Lecture
Lecture 3 Day-2 Lecture
Lecture 4 Day-3 Lecture
Lecture 5 Day-4 Lecture
Lecture 6 Day-5 Lecture
Lecture 7 Day-6 Lecture
Lecture 8 Day-7 Lecture
Lecture 9 Day-8 Lecture
Section 2: Part-B] Professional PWD Quantity Estimating & Costing
Lecture 10 Day-9 Lecture
Lecture 11 Day-10 Lecture
Lecture 12 Day-11 Lecture
Lecture 13 Day-12 Lecture
Lecture 14 Day-13 Lecture
Lecture 15 Day-14 Lecture
Lecture 16 Day-15 Lecture
Lecture 17 Day-16 Lecture
Lecture 18 Day-17 Lecture
Lecture 19 Day-18 Lecture
Lecture 20 Day-19 Lecture
Lecture 21 Day-20 Lecture
Lecture 22 Day-21 Lecture
Lecture 23 Day-22 Lecture
Lecture 24 Day-23 Lecture
Lecture 25 Day-24 Lecture
Lecture 26 Day-25 Lecture
Lecture 27 Day-26 Lecture
Lecture 28 Day-27 Lecture
Lecture 29 Day-28 Lecture
Lecture 30 Day-29 Lecture
Lecture 31 Day-30 Lecture
Building Site Supervisor,,ITI Draughtsman,,Civil Engineering Polytechnic Diploma Students,Civil Engineering Fresher Graduates,,B. Arch. Fresher Graduates,Civil Engineering Assistant,Junior Quantity Surveyor

Homepage

https://www.udemy.com/course/quantity-estimating-costing-for-building/