Quantity Surveying Building Estimation With Cad And Excel

BY
Udemy

Acquire a hands-on understanding of the functionalities of Auto CAD and Microsoft excel for quantity surveying building estimation.

Mode

Online

Fees

₹ 2999

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Quantity Surveying Building Estimation With Cad And Excel certification course is developed by Mudessar Afraz - Professional Civil Engineer which is accessible on Udemy and is meant for learners who want to learn how to estimate any building project from foundation to finish. The Quantity Surveying Building Estimation With Cad And Excel online course by Udemy is a hands-on course that includes real-world examples and a full-fledged real-world project to help students better learn how to use Auto CAD and Microsoft Excel.

Quantity Surveying Building Estimation With Cad And Excel online classes features 41 hours of digital video sessions and 74 downloadable learning resources covering topics such as project estimation, building automation, substructure quantity, isolated foundation, sloped foundation, raft foundation, bar bending schedule, interim payment, bills of quantities, rate analysis, and more. Learners will have acquired the ability to use the functionalities and principles of software such as Auto CAD, Excel, Plan Swift and Primavera P6, and MS Project by the end of this session.

The highlights

  • Certificate of completion
  • Self-paced course
  • 41 hours of pre-recorded video content
  • 74 downloadable resources

Program offerings

  • Online course
  • Learning resources. 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 2,999
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

After completing the Quantity Surveying Building Estimation With Cad And Excel online certification, learners will gain an insight into the fundamentals features and techniques used in quantity surveying and building estimation using Auto CAD and Microsoft Excel. Learners will investigate various building estimation technologies such as Plan Swift, Primavera, and MS Projects. Isolated foundations, sloped foundations, raft foundations, and bar bending schedules will all be covered. Learners will also learn about concepts like building automation, rate analysis, bills of quantity, and interim payment.

The syllabus

Introduction

  • Quick Introduction To This Course
  • Introduction To Estimation
  • if you want to slow down the pace of speaking
  • Resources
  • Resources For MS Project And Primavera p6

Foundation Work (Isolated Footing) Estimation With AutoCad

  • Introduction To Isolated Foundation
  • Quantity Of Excavation For Isolated Foundation (Quantity Through AutoCAD)
  • Quantity Of P.C.C (Calculations Through AutoCAD)
  • How to Find Quantity Of Form-work In Foundation (Calculations Through AutoCAD)
  • How to Find Quantity Of Concrete In Foundation (Calculations Through AutoCAD)
  • Practice Question 1 For This Module (Important Solve It And Submit To Me)
  • Practice Question 2 (Important Solve It And Submit To Me)
  • Practice Question 3 (Important Solve It And Submit To Me)

Foundation Work ( Sloped Footing)

  • Quantity Of Sloped / Trapezoidal Footing (Manual Calculation)
  • Excavation For Sloped Footing
  • P.C.C And Formwork For Sloped Footing
  • Concrete For Sloped Footing

Foundation Work (Raft Foundation) Estimation With AutoCad

  • Excavation And P.C.C For Raft Foundation
  • Formwork And Concrete For Raft Foundation

Column Necks (Estimation With AutoCad)

  • Quantity Of Form-work In Column Necks (Calculations Through AutoCAD)
  • Concrete In Column Necks (Calculations Through AutoCAD)
  • Practice Question (Important Solve It And Submit To Me)

Grade Beam (Estimation With AutoCad)

  • Form-work For Grade Beams Part 1 (Calculations Through AutoCAD)
  • Form-work For Grade Beams Part 2 (Calculations Through AutoCAD)
  • Form-work For Grade Beams Part 3 (Calculations Through AutoCAD)
  • Form-work For Grade Beams Part 4 (Calculations Through AutoCAD)
  • Concrete For Grade Beams Part 1 (Calculations Through AutoCAD)
  • Concrete For Grade Beams Part 2 (Calculations Through AutoCAD)
  • Practice Question (Important Solve It And Submit To Me)

Slab On Grade (Estimation With AutoCad)

  • Concrete For Slab On Grade Part 1 (Calculations Through AutoCAD)
  • Concrete For Slab On Grade Part 2 (Calculations Through AutoCAD)

Column In Superstructure (Estimation With AutoCad)

  • Concrete For Column In S.S (Calculations Through AutoCAD)
  • Practice Question (Important Solve It And Submit To Me)

Question

  • Practice Question (Important Solve It And Submit To Me)

Brick Work In Superstructure (Estimation With AutoCad)

  • Brick Work For Superstructure Part 1 (Calculations Through AutoCAD)
  • Brick Work For Superstructure Part 2 (Calculations Through AutoCAD)
  • Practice Question (Important Solve It And Submit To Me)

Stairs (Estimation With AutoCad)

  • Form-work For Stairs (Calculations Through AutoCAD)
  • Concrete For Stairs (Calculations Through AutoCAD)

Slab (Estimation With AutoCad)

  • Form-work For Slab Part 1 (Calculations Through AutoCAD)
  • Form-work For Slab Part 2 (Calculations Through AutoCAD)
  • Concrete For Slab (Calculations Through AutoCAD)
  • Practice Question (Important Solve It And Submit To Me)

Parapet Wall And Mumty (Estimation With AutoCad)

  • B.W In Parapet Wall (Calculations Through AutoCAD)
  • Practice Question (Important Solve It And Submit To Me)

Plaster Work (Estimation With AutoCad)

  • Internal Plaster Part 1 (Calculations Through AutoCAD)
  • Internal Plaster Part 2 (Calculations Through AutoCAD)
  • Plaster For Stairs (Calculations Through AutoCAD)
  • Ceiling Plaster (Calculations Through AutoCAD)
  • External Plaster (Calculations Through AutoCAD)
  • Practice Question (Important Solve It And Submit To Me)

Tiles And Marble (Estimation With AutoCad)

  • Quantity Of Tiles (Calculations Through AutoCAD)
  • Quantity Of Marble (Calculations Through AutoCAD)
  • Skirting Quantity (Calculations Through AutoCAD)
  • Quantity Of Marble In Stairs (Calculations Through AutoCAD)
  • Practice Question (Important Solve It And Submit To Me)

Paint Work (Estimation With AutoCad)

  • Quantity Of Internal Paint Part 1 (Calculations Through AutoCAD)
  • Quantity Of Internal Paint Part 2 (Calculations Through AutoCAD)
  • Stairs Ceiling And External Painting (Calculations Through AutoCAD)
  • Practice Question (Important Solve It And Submit To Me)

Foundation Work (Estimation Through PDF File/Hard Copy)

  • Excavation And P.C.C For Foundation (What If We Have Hard Copy Or PDF Drawing)
  • Foundation And Column Necks (Hard Copy Or PDF Drawing)

Grade Beam (Estimation Through PDF File/Hard Copy)

  • Formwork For Grade Beam Part 1 (PDF File Manual Calculations)
  • Formwork For Grade Beam Part 2 (PDF File Manual Calculations)
  • Concrete For Grade Beam Part 1(PDF File Manual Calculations)
  • Concrete For Grade Beam Part 2 (PDF File Manual Calculations)

Slab On Grade (Estimation Through PDF File/Hard Copy)

  • Concrete For Slab On Grade Part 1 (PDF File Manual Calculations )
  • Concrete For Slab On Grade Part 2 (PDF File Manual Calculations )

Column In Superstructure (Estimation Through PDF File/Hard Copy)

  • Concrete In S.S Columns (PDF Drawing)

Brickwork In Superstructure (Estimation Through PDF File/Hard Copy)

  • Brick work in S.S Part 1 (What if Drawing Is in PDF Format)
  • Brick work in S.S Part 2 (What if Drawing Is in PDF Format)

Stair Formwork And Concrete (Estimation Through PDF File/Hard Copy)

  • Formwork For Stair ( What If File Is In Pdf Format Or Hard Copy)
  • Concrete For Stair (What if Drawing Is in PDF Format)

Formwork And Concrete For Slab (Estimation Through PDF File/Hard Copy)

  • Formwork For Slab Part 1(PDF Format or Hard Copy)
  • Formwork For Slab Part 2(PDF Format or Hard Copy)
  • Concrete For Slab (PDF Drawing)

Parapet Wall (PDF Drawing)

  • Brick Work For Parapet Wall ( PDF Drawing)

Plaster Work (Estimation Through PDF File/Hard Copy)

  • Internal Plaster Part 1 (What if Drawing is in PDF Format)
  • Internal Plaster Part 2 (What if Drawing is in PDF Format)
  • Ceiling Plaster Part 1 (What if Drawing is in PDF Format)
  • Ceiling Plaster Part 2 (What if Drawing is in PDF Format)
  • External Plaster Part 1 (What if Drawing is in PDF Format)
  • Plaster For Stairs (What IF Drawing Is IN PDF Format)

Tiles And Marble (Estimation Through PDF File/Hard Copy)

  • Tiles For Toilet (PDF Drawing Or Hard Copy
  • Marble For Floor Part 1 (PDF Drawing / Hard Copy)
  • Marble For Floor Part 2 (PDF Drawing / Hard Copy)
  • Marble For Stairs ( PDF Drawing)
  • Skirting Part 1 (PDF Drawing / Hard Copy)
  • Skirting Part 2 (PDF Drawing / Hard Copy)

Paint Work (Estimation Through PDF File/Hard Copy)

  • Internal External And Ceiling Paint ( PDF Drawing )
  • Paint Work For Stairs (PDF Drawing)

PLANSWIFT BEGINNERS TRAINING (If You Know Basic Tools Of Plan Swift you can skip

  • User Interface Of Plan Swift (No 1 Takeoff software)
  • How to Create New Job In Plan swift
  • How to Scale The Drawing In Plan Swift
  • How to Use Area Tool In plan Swift
  • How To Use Linear Tool In Plan Swift
  • How to Use Segment Tool In Plan Swift
  • How to Use Count Tool In Plan Swift

Foundation Works (Estimation Through Plan swift) PDF OR SCAN FILE

  • Excavation For Foundation (Plan Swift Made it easy pdf drawing or scan copy)
  • P.C.C For Foundation (Through Plan Swift)
  • Formwork For Foundation (Through Plan Swift)
  • Concrete For Foundation (Through Plan Swift)

Column Necks (Calculations Through Plan Swift No 1 Take off Software)

  • Formwork And Concrete For Column Necks

Grade Beam (Calculations Through Plan Swift No 1 Take off Software)

  • Formwork For Grade Beam
  • Concrete For Grade Beams

Slab On Grade (Calculations Through Plan Swift No 1 Take off Software)

  • Concrete For Slab On Grade

Column In Super Structure(Calculations Through Plan Swift No 1 Take off Software

  • Formwork And Concrete For Column In S.S

Brick Work (Calculations Through Plan Swift No 1 Take off Software)

  • Brick Works In S.S

Stairs (Calculations Through Plan Swift No 1 Take off Software)

  • Formwork For Stairs
  • Concrete For Stairs

Slab (Calculations Through Plan Swift No 1 Take off Software)

  • Formwork For Slab
  • Concrete For Slab

Parapet Wall (Calculations Through Plan Swift No 1 Take off Software)

  • Brick Works In parapet Wall

Plaster Works (Calculations Through Plan Swift No 1 Take off Software)

  • Internal plaster
  • Ceiling Plaster
  • Plaster For Stairs
  • External Plaster

Tiles And Marble Works(Calculations Through Plan Swift No 1 Take off Software)

  • Tiles For Toilet
  • Marble For Floors

Paint Works (Calculations Through Plan Swift No 1 Take off Software)

  • Paint Works

Bar bending Schedule Basic

  • Bar Bending Schedule Basic
  • Cut Length For Main Bar
  • Overlapping
  • Cut Length Of Bent-up Or Crank Bar
  • Cut Length Of Rectangular Stirrups
  • Cut Length Of Triangular Stirrups
  • Cut Length Of Diamond Stirrups
  • Cut Length Of Circular Stirrups And Chair Bar

Bar Bending Schedule In Excel

  • How to Prepare B.B.S Sheet In Excel Part 1
  • How to Prepare B.B.S Sheet In Excel Part 2
  • Bar Bending Schedule For Isolated Footing
  • Bar Bending Schedule For Raft Foundation Part 1
  • Bar Bending Schedule For Raft Foundation Part 2
  • Bar Bending Schedule For Raft Foundation Part 3
  • Bar Bending Schedule For Column Necks
  • Bar Bending Schedule For Columns
  • Bar Bending Schedule For Beam Part 1
  • Bar Bending Schedule For Beam Part 2
  • Bar Bending Schedule For Beam Part 3
  • Bar Bending Schedule For Stairs Part 1
  • Bar Bending Schedule For Stairs Part 2
  • Bar Bending Schedule For Slab Part 1
  • Bar Bending Schedule For Slab Part 2
  • Bar Bending Schedule For Two Way Slab Part 1
  • Bar Bending Schedule For Two Way Slab Part 2
  • Bar Bending Schedule For Two Way Slab Part 3
  • Bar Bending Schedule For Two Way Slab Part 4
  • Practice Question 1 For This Module
  • Practice Question 2 For This Module
  • Practice Question 3 For This Module
  • Practice Question 4 For This Module

Procedure To Find-out Material

  • How to Find Quantity Of Cement Sand And Coarse Aggregates In Concrete (Metric)
  • How to Find Quantity Of Cement And Sand In Plaster (Metric)
  • How to Find Quantity Of Bricks (Metric)
  • How to Find Quantity Of Cement Sand And Coarse Aggregates In Concrete (Imperial)
  • How to Find Quantity Of Cement And Sand In Plaster (Imperial)
  • How to Find Quantity Of Bricks (Imperial)

Material Statement In Excel

  • Material Statement Part 1
  • Material Statement Part 2
  • Material Statement Part 3
  • Material Statement Part 4
  • Explanation Of Material Statement Sheet In Excel
  • Practice Question For This Module

Rate Analysis

  • Introduction To Rate Analysis And Excavation Rate Analysis
  • Rate Analysis For P.C.C
  • Rate Analysis For R.C.C (Column,Beam,Slab)
  • Rate Analysis For Brick Work
  • Rate Analysis For Plaster
  • Rate Analysis For Tiles
  • Rate Analysis For Paint

Bill Of Quantity (B.O.Q)

  • B.O.Q For Excavation
  • B.O.Q For Concrete Work

Mode Of Payments To Contractor

  • Introduction To Contractor Payments And Interim Payment
  • Advance And Secured Advance Payment
  • Final Payment And Mobilization Advance
  • Intro To Interim Payment In Excel
  • How to Prepare Interim Payment (IPC) In Excel Part 1
  • How to Prepare Interim Payment (IPC) In Excel Part 2
  • How to Prepare Interim Payment (IPC) In Excel Part 3
  • How to Prepare Interim Payment (IPC) In Excel Part 4
  • How to Prepare Interim Payment (IPC) In Excel Part 5

Excel Training For Beginners

  • Font Panel
  • Border In Excel
  • Alignment Panel
  • Number Panel
  • Conditional Formatting

Formulas In Excel

  • Formulas (Sum,Subtract,Multiply,Divide)
  • Formulas (Countblank ,Countif ,Sumif)
  • Formula ( IF )
  • Formulas (NETWORKDAYSINTL, VLOOKUP)

Primavera p6 Training (Important if you are beginner in primavera and planning)

  • User interface of primavera p6
  • Organizational Break Down Structure (O.B.S) In Primavera P6
  • Enterprise Project Structure (E.P.S) In Primavera P6
  • User Preferences In Primavera P6 (Step 1 Important)
  • How To Create And Assign Calendar In Primavera P6 (Step 2 Important)
  • How to Create Project, W.B.S, And Activities In Primavera P6 (Important Step 3)
  • Milestone And Relationship
  • Scheduling Project
  • Some Of Steps Must Be Done Before Creating And Assigning Resources In P6
  • How Resource Loading Works In P6
  • Importance Of Resources
  • Creating And Assigning Resources
  • Creating And Assigning Baseline In P6
  • How to Update The Project According to actual Work Done At Site

Creating Activity List In MS Excel

  • Activity List Intro
  • Activity List Part 1
  • Activity List Part 2
  • Activity List Part 3

Adding Manpower And Productivity In Excel

  • Adding Manpower (Labor Mason Carpenter etc)
  • Productivity Of Different Manpower (Labor Mason Carpenter etc)
  • Adding Quantities To Activities

How to Give Duration To Activities (In Detail)

  • Adding Duration To Activities Part 1
  • Adding Duration To Activities Part 2

Creating Project W.B.S Importing Activities in p6 From Excel Sheet (Imp Section)

  • Creating Project In Primavera P6
  • How to Import All Of Project Activities Excel To Primavera P6
  • How to Create W.B.S Of Our Project According To Our Excel Sheet
  • Adding Activities Under Right W.B.S

Relationship To Project Activities

  • How to Give Relationship To Activities Part 1
  • How to Give Relationship To Activities Part 2

How to Add Project Resources ( Labor Material ) In P6

  • Some Of Steps Before Creating Resources In P6
  • Creating Labor Resources In P6
  • Creating Material Resources In P6
  • Assigning Labor Resources To Activities Part 1
  • Assigning Labor Resources To Activities Part 2
  • Assigning Labor Resources To Activities Part 3
  • Assigning Material Resources To Activities Part 1
  • Assigning Material Resources To Activities Part 2
  • Assigning Material Resources To Activities Part 3
  • Assigning Material Resources To Activities Part 4

Update The Project (In term Of Time And Cost) To Find Actual Time And Cost

  • How to Update the project according to actual (Time)
  • How to update the project according to actual (Cost)

Ms Project Training For Beginners (Very Important If You Are Begin In MS PROJECT

  • User Interface Of MS Project
  • Backstage Options (Important Settings)
  • How to Create Calendar In MS Project
  • Project Information
  • How to Create Project W.B.S And Activities In MS Project
  • Milestone And Relationship In Ms Project Part 1
  • Milestone And Relationship In Ms Project Part 2
  • Slack / Float
  • Resource Loading In MS Project
  • Importance Of Resources
  • Creating And Assigning Resources In MS Project
  • How to Create Baseline In Ms Project
  • How to Update The Project In MS Project

Complete Project In MS Project

  • Some Steps Before Importing Activities From Excel To MS Project
  • Importing Activities From Excel To MS Project
  • Creating W.B.S For Project According To Excel Sheet
  • How to Give Relationship To Activities In MS PROJECT Part 1
  • How to Give Relationship To Activities In MS PROJECT Part 2

Creating Resources In MS PROJECT (Human And Material)

  • How to Create Work Resources In MS Project
  • How to Create Material Resources In Ms Project
  • Assigning Work Resources To Activities In MS Project Part 1
  • Assigning Work Resources To Activities In MS Project Part 2
  • Assigning Work Resources To Activities In MS Project Part 3
  • Assigning Material Resources To Activities In MS Project Part 1
  • Assigning Material Resources To Activities In MS Project Part 2
  • Assigning Material Resources To Activities In MS Project Part 3
  • Assigning Material Resources To Activities In MS Project Part 4

Update The Project In MS Project According To Actual (Time And Cost)

  • How to Update The Project (In Term Of Time)
  • How to Update The Project (In Term Of Cost)

Auto-cad Training For Beginners (Introduction)

  • User Interface Of Auto-cad
  • Application Button
  • Navigation Options
  • Cartesian And Polar Co-ordinates In Auto-cad
  • How to Set Drawing Units
  • How to Set Measuring Unit
  • How to Set Drawing Limits
  • Template
  • Practice Question

Commands

  • Line Command
  • How to Draw Circle In Auto-cad
  • How to Draw Arc
  • How to Draw Ellipse
  • How to Draw Rectangle
  • How to Draw Polygon
  • Poly-line And Spline
  • Practice Question

Modifying Object

  • Selection
  • Move And Copy
  • Rotate
  • Offset
  • Scale
  • Mirror
  • Trim And Extend
  • Explode And Erase
  • Stretch
  • Break And Break At Point
  • Fillet
  • Chamfer
  • Lengthen Command
  • Join And Overkill
  • Practice Question

Dimensions

  • Creating Dimensions
  • DIM Command
  • Editing Dimensions
  • Own Dimension Style
  • Continue And Baseline Dimension
  • Associative And Non Associative Dimension
  • Add Multi leader
  • Edit Multi-leader
  • Creating Own Multi leader Style
  • Practice Question

Final Note And Resources

  • Resources

Certificate Of Completion

  • How to Claim Certificate

Instructors

Mr Mudessar Afraz

Mr Mudessar Afraz
Civil Engineer
Freelancer

Other Bachelors

Articles

Popular Articles

Latest Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books