Quantity Surveying Building Estimation With Cad And Excel

Quantity Surveying, Quantity Takeoff, B.B.S , Rate Analysis, B.O.Q, Interim Payment In Excel, Variation Orders.

Advanced 0(0 Ratings) 0 Students enrolled English
Created by Mudessar Afraz
Last updated Thu, 12-Jan-2023
+ View more
Course overview

Complete Updated Course Last Update 11/2022

Complete Package.

  1. Complete Project Estimation Through AutoCAD And Excel.


  2. Complete Project Estimation (Manual Calculations PDF Drawings Same Project.)


  3. Complete Project Estimation (Through Plan Swift Software  Same Project)


  4. Primavera P6 Training For Beginners.


  5. We, Will, Create Complete Project In Primavera P6 (The same Project For Which We did the Estimation)


  6. MS Project 2019 Training For Beginners


  7. We, Will, Create Complete Project In MS PROJECT  (The same Project For Which We did the Estimation)


  8. Excel Training For Beginners.


  9. Autocad Training For Beginners.


  10. Interim Payment Certificate (Payment process in construction)


  11. Variation Orders In Construction Projects


  12. Practice Questions After the Ending Of Each Module

    In Practice Questions,

    I have designed a mini Project for you if you did all of the practice questions Step By Step then after ending of this Course You will be able to Do complete project Estimation. And Also Able to do the Planning Of the Same Project In Primavera P6 And Microsoft Project.

Welcome to Quantity Surveying /Building Estimation online training course. it is focused on practical application of Estimation using Auto Cad & M.S Excel 

This course is a field-oriented course and contains real examples and a full fledge real project for better understanding

After successful completion of this course, you will be able to Estimate Any Building Project (From Foundation To Finishing)

Major Topics That We Will Learn In This Course:


Quantity Of Substructure (Isolated Footing) Through AutoCAD

  1. Excavation Quantity

  2. Formwork Calculations

  3. Concrete Quantity

    Quantity Of Sloped Footing Through AutoCAD

  1. Excavation Quantity

  2. Formwork Calculations

  3. Concrete Quantity

    Quantity Of Different Items In Superstructure  Through AutoCAD

  1. Column In S.S (Formwork, Concrete)

  2. Grade Beams (Formwork,Concrete )

  3. Slab On Grade (Formwork, Concrete)

  4. Lintel And Top Beam (Formwork, Concrete)

  5. Slab (Concrete And Formwork)

  6. Brick Works

  7. Plaster Works

  8. Tile And Marble Works

  9. Paint Works

    Quantity Of Substructure (Isolated Footing) Manual Calculations PDF File Or Hard Copy Of Drawings

  1. Excavation Quantity

  2. Formwork Calculations

  3. Concrete Quantity

    Quantity Of Different Items In Superstructure  Through PDF File, Manual Calculations

  1. Column In S.S (Formwork , Concrete)

  2. Grade Beams (Formwork , Concrete )

  3. Slab On Grade (Formwork, Concrete)

  4. Lintel And Top Beam (Formwork, Concrete)

  5. Slab (Concrete And Formwork)

  6. Brick Works

  7. Plaster Works

  8. Tile And Marble Works

  9. Paint Works

    Quantity Of Substructure (Through Planswift)

  1. Excavation Quantity

  2. Formwork Calculations

  3. Concrete Quantity

    Quantity Of Different Items In Superstructure (Through Planswift)

  1. Column In S.S (Formwork, Concrete)

  2. Grade Beams (Formwork, Concrete )

  3. Slab On Grade (Formwork, Concrete)

  4. Lintel And Top Beam (Formwork, Concrete)

  5. Slab (Concrete And Formwork)

  6. Brick Works

  7. Plaster Works

  8. Tile And Marble Works

  9. Paint Works

    Bar bending Schedule:

  1. Bar-bending Schedule Of Isolated Footing

  2. Bar-bending Schedule Of Column Necks And Columns

  3. Bar-bending Schedule Of Beams

  4. Bar-bending Schedule Of Stairs

  5. Bar Bending Schedule Of Slab

  6. Bar-Bending Schedule Of Two-Way Slab

    Rate Analysis Of Different Works:

  1. Rate Analysis For Excavation

  2. Rate Analysis For Plain Cement Concrete (P.C.C)

  3. Rate Analysis For Reinforcement Concrete (Column Beam And Slab)

  4. Rate Analysis For Masonry Work

  5. Rate Analysis For Plaster Work

  6. Rate Analysis For Tile Work

  7. Rate Analysis For Paint Work

    Material Statement :

  1. Material Statement In Excel

    Bill Of Quantity (B.O.Q)

  1. Bill Of Quantity For A Project According To CSI Codes

    Mode Of Payments To Contractor

  1. Interim Payment

  2. Advance Payment

  3. Secured Advance

  4. Petty Advance

  5. Mobilization Advance

  6. Procedure To Create Interim Payment In Excel From Scratch.

    Variation Orders In Construction:

  1. · Introduction To Variation Orders In Construction.

  2. · How to Create Variation Orders In Excel.

    Primavera P6 Training For Beginners

  1. As We are Doing Same Project In Primavera So This Training Is For Those Who Are Beginners In Planning OR In Primavera.

    Complete Project In Primavera P6 With The Help Of MS Excel.

  1. Creating Activity List In Ms Excel.

  2. Add Manpower And Their Productivity In MS Excel

  3. Adding Duration To Activities Based On Productivity

  4. Creating Project In Primavera P6

  5. Importing All Of Activities From Excel To P6

  6. W.B.S And Relationship For Activities

  7. Creating And Assigning Resources To Activities (Work And Material Resources)

  8. Update The Project According To Actual (Time And Cost)

    MS PROJECT Training For Beginners

  1. As We are Doing Same Project In MS Project So This Training Is For Those Who Are Beginners In Planning OR In MS Project.

    Complete Project In MS Project With The Help Of MS Excel.

  1. Creating Activity List In Ms Excel.

  2. Add Manpower And Their Productivity In MS Excel

  3. Adding Duration To Activities Based On Productivity

  4. Creating Project In MS Project

  5. Importing All Of Activities From Excel To MS Project

  6. W.B.S And Relationship For Activities

  7. Creating And Assigning Resources To Activities (Work And Material Resources)

  8. Update The Project According To Actual (Time And Cost)

    Excel Training For Beginners

  1. As Excel Is Important For This Course So I Have Add Basic Training And Formulas For Those Who Are Beginners In Excel

    Auto-cad Training

  1. As Auto-cad Is Also Essential For This Course So I Have Also Included Auto-cad Training For Those Who Are Beginner In Auto-cad

    Practice Questions After the Ending Of Each Module.

  1. In Practice You will do a complete mini-project (Estimation, Project Planning)

What will i learn?

  • Estimation Of Complete Project Through Auto-cad And Excel
  • Estimation Of Complete Project Through PDF Files/Hard Copy
  • Beginner Training For Plan Swift
  • Estimation Of Complete Project Through Plan Swift Software
  • Bar bending Schedule Of Foundation,Columns,Beams,Slab,Stairs, In Excel
  • How to Find Material Like Cement,Sand,Coarse Aggregates,Bricks
  • Complete Material Statement In Excel
  • Rate Analysis For Different Works Like ,Excavation, P.C.C, R.C.C, Masonry, Tiles, Plaster, Paint In Excel
  • Will Learn How to Create B.O.Q Of Project
  • Mode Of Payments To Contractor
  • Interim Payment In Excel
  • Variations Order In Construction.
  • How to Create Variations Order In Excel (Important For Quantity Surveyors)
  • Microsoft Excel For Beginners
  • Primavera P6 Training For Beginners
  • Auto-cad 2020 For Beginners
  • MS Project Training For Beginners
  • Activities And W.B.S List In MS Excel
  • Adding Manpower In Excel (Labor, Mason, Carpenter etc.)
  • Finding The Duration Of Activities Based On Productivity
  • Complete Project In Primavera p6 (Activities ,W.B.S, Relationship, Creating And Assigning Resources And Much More
  • Complete Project In MS PROJECT (Activities ,W.B.S, Relationship, Creating And Assigning Resources And Much More
  • Practice Question After Ending Of Each Module
Requirements
  • • To have the Auto Cad And M.S Excel installed in your computer.
  • • To have the minimum understanding for Civil Quantity/Estimation
  • • To have a minimum understanding of construction processes.
Curriculum for this course
326 Lessons 37:25:21 Hours
Introduction
5 Lessons 00:23:59 Hours
  • Quick Introduction To This Course
    00:02:50
  • Introduction To Estimation
    00:13:48
  • How to Create Measurement Sheet In Excel
    00:06:21
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:01:00
  • Resources (Drawings ,IPC ,Variation orders,Rate analysis sheet,MB Project Planning And much more)
    .
Foundation Work (Isolated Footing) Estimation With AutoCad
9 Lessons 00:46:37 Hours
  • Drawing Overview
    00:10:29
  • Introduction To Isolated Footing
    00:01:49
  • Excavation For Foundation(Estimation Through Cad)
    00:06:22
  • Quantity Of Plain Cement Concrete (P.C.C) For Foundation (Estimation With Cad)
    00:05:03
  • How to Find Quantity Of Formwork For Isolated Footing(Estimation With Cad)
    00:07:31
  • How to Find Quantity Of Concrete For Isolated Footing (Estimation With Cad)
    00:03:53
  • Practice Question 1 For This Module (Please Don't Move Next Till You Done This)
    00:04:52
  • Practice Question 2 For This Module (Please Don't Move Next Till You Done This)
    00:02:12
  • Practice Question 3 For This Module (Please Don't Move Next Till You Done This)
    00:04:26
Column Necks (Estimation With AutoCad)
3 Lessons 00:12:36 Hours
  • How to Find Quantity Of Formwork For Column Necks(Estimation With Cad)
    00:05:34
  • How to Find Quantity Of Concrete For Column Necks (Estimation With Cad)
    00:03:28
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:03:34
Backfilling (Estimation With Cad)
2 Lessons 00:08:50 Hours
  • How to find Quantity Of Backfilling For Isolated Footing(Estimation With Cad)
    00:05:43
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:03:07
Grade Beam (Estimation With AutoCad)
8 Lessons 01:09:12 Hours
  • Quantity Of Formwork For Grade Beams Part 1 (Estimation With Cad)
    00:14:55
  • Quantity Of Formwork For Grade Beams Part 2 (Estimation With Cad)
    00:05:26
  • Quantity Of Formwork For Grade Beams Part 3 (Estimation With Cad)
    00:09:48
  • Quantity Of Formwork For Grade Beams Part 4 (Estimation With Cad)
    00:03:40
  • Quantity Of Concrete For Grade Beams Part 1 (Estimation With Cad)
    00:10:19
  • Quantity Of Concrete For Grade Beams Part 2 (Estimation With Cad)
    00:06:57
  • Practice Question 1 For This Module (Please Don't Move Next Till You Done This)
    00:11:55
  • Practice Question 2 For This Module (Please Don't Move Next Till You Done This)
    00:06:12
Slab On Grade (Estimation With AutoCad)
3 Lessons 00:27:34 Hours
  • How to Find Quantity Of Slab On Grade Part 1 (Estimation with Cad)
    00:15:21
  • How to Find Quantity Of Slab On Grade Part 2 (Estimation with Cad)
    00:06:49
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:05:24
Column In Superstructure (Estimation With AutoCad)
3 Lessons 00:14:33 Hours
  • How to Find Quantity Of Formwork For Column In Superstructure.
    00:07:29
  • How to Find Quantity Of Concrete For Column In Superstructure.
    00:03:12
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:03:52
Formwork And Concrete For Lintels (Estimation With Cad)
4 Lessons 00:27:56 Hours
  • How to Find Quantity Of Formwork For Lintels (Estimation With Cad)
    00:13:39
  • How to Find Quantity Of Concrete For Lintels (Estimation With Cad)
    00:04:39
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:06:29
  • Practice Question 2 For This Module (Please Don't Move Next Till You Done This)
    00:03:09
Stairs (Estimation With AutoCad)
2 Lessons 00:22:34 Hours
  • Quantity Of Formwork For Stair (Estimation Through Cad)
    00:14:02
  • Quantity Of Concrete For Stair (Estimation Through Cad)
    00:08:32
Top Beam (Estimation Through Cad)
3 Lessons 00:23:14 Hours
  • Formwork For Top Beam Part 1 (Estimation Through Cad)
    00:13:11
  • Formwork For Top Beam Part 2 (Estimation Through Cad)
    00:05:32
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:04:31
Slab (Estimation With AutoCad)
4 Lessons 00:41:39 Hours
  • Form-work For Slab Part 1 (Calculations Through AutoCAD)
    00:12:02
  • Form-work For Slab Part 2 (Calculations Through AutoCAD)
    00:12:11
  • Concrete For Slab (Calculations Through AutoCAD)
    00:08:27
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:08:59
Brick Work In Superstructure (Estimation With AutoCad)
4 Lessons 00:47:54 Hours
  • Brick Work For Superstructure Part 1 (Calculations Through AutoCAD)
    00:13:03
  • Brick Work For Superstructure Part 2 (Calculations Through AutoCAD)
    00:04:40
  • Brick Work For Superstructure Part 3 (Calculations Through AutoCAD)
    00:15:27
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:14:44
Brick Works In Parapet Wall And Mumty (Estimation With AutoCad)
3 Lessons 00:18:35 Hours
  • Brick Works In Mumty (Calculations With Cad)
    00:07:55
  • Brick Works In Parapet Wall (Calculations With Cad)
    00:07:48
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:02:52
Plaster Work (Estimation With AutoCad)
7 Lessons 00:57:33 Hours
  • Internal Plaster Part 1 (Calculations Through AutoCAD)
    00:09:04
  • Internal Plaster Part 2 (Calculations Through AutoCAD)
    00:10:32
  • Ceiling Plaster (Calculations through Cad)
    00:09:30
  • Plaster For Stairs (Calculations Through Cad)
    00:11:13
  • External Plaster (Calculations Through Cad)
    00:06:35
  • Practice Question 1 For This Module (Please Don't Move Next Till You Done This)
    00:06:08
  • Practice Question 2 For This Module (Please Don't Move Next Till You Done This)
    00:04:31
Tiles And Marble (Estimation With AutoCad)
7 Lessons 00:41:59 Hours
  • Quantity Of Tiles (Calculations Through AutoCAD)
    00:08:59
  • Quantity Of Marble For Floor (Calculations Through AutoCAD)
    00:07:33
  • Skirting Quantity (Calculations Through AutoCAD)
    00:11:37
  • Marble For Stairs (Calculations Through AutoCAD)
    00:04:56
  • Practice Question 1 For This Module (Please Don't Move Next Till You Done This)
    00:04:04
  • Practice Question 2 For This Module (Please Don't Move Next Till You Done This)
    00:03:54
  • Practice Question 3 For This Module (Please Don't Move Next Till You Done This)
    00:00:56
Paint Work (Estimation With AutoCad)
2 Lessons 00:12:54 Hours
  • Quantity Of Paints (Calculations Through Cad)
    00:11:45
  • Practice Question 3 For This Module (Please Don't Move Next Till You Done This)
    00:01:09
Bar bending Schedule Basic
11 Lessons 01:06:34 Hours
  • Bar Bending Schedule Basic
    00:11:35
  • Bend Deductions (You Can Do Bend Deduction For Any Angle Through this method)
    00:03:20
  • Clear And Effective Cover.
    00:03:58
  • Cut Length Of Main Or Distribution Bars.
    00:06:29
  • Cut Length Of Bent-up/Crank Bar.
    00:08:11
  • Cut Length of Rectangular Stirrups.
    00:03:00
  • Cut Length of Triangular Stirrups.
    00:03:40
  • Cut Length Of Diamond Stirrups.
    00:07:31
  • Cut Length of Circular Stirrups.
    00:03:30
  • Cut Length Of Chair Bar.
    00:06:05
  • Cut Length of 4 or 6 Legged Stirrups.
    00:09:15
Bar Bending Schedule Excel Sheet (Meter And Millimeters)
2 Lessons 00:15:58 Hours
  • Introduction To B.B.S Sheet.
    00:11:57
  • How to Do Formatting In B.B.S Sheet.
    00:04:01
Bar Bending Schedule For Footing
2 Lessons 00:23:02 Hours
  • B.B.S For Isolated Footing
    00:13:04
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:09:58
Bar Bending Schedule For Columns
4 Lessons 00:47:35 Hours
  • B.B.S For Column Necks
    00:12:34
  • B.B.S For Column In Superstructure.
    00:13:45
  • Practice Question 1 For This Module (Please Don't Move Next Till You Done This)
    00:10:31
  • Practice Question 2 For This Module (Please Don't Move Next Till You Done This)
    00:10:45
Bar Bending Schedule For Grade Beams
5 Lessons 00:57:13 Hours
  • Bar Bending Schedule For GB1 Part 1
    00:14:08
  • Bar Bending Schedule For GB1 Part 2
    00:11:46
  • Bar Bending Schedule For GB2 Part 1
    00:08:01
  • Bar Bending Schedule For GB2 Part 2
    00:07:56
  • Practice Question 2 For This Module (Please Don't Move Next Till You Done This)
    00:15:22
Bar Bending Schedule For Top Beams
1 Lessons 00:09:44 Hours
  • B.B.S For TB1
    00:09:44
Bar Bending Schedule For Stairs.
2 Lessons 00:16:53 Hours
  • B.B.S For Stairs Part1
    00:12:16
  • B.B.S For Stairs Part 2
    00:04:37
Bar Bending Schedule For Slab
4 Lessons 00:26:54 Hours
  • Bar Bending Schedule For Slab Part 1
    00:10:16
  • Bar Bending Schedule For Slab Part 2
    00:05:16
  • Bar Bending Schedule For Slab Part 3
    00:05:02
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:06:20
Foundation Work (Estimation Through PDF File/Hard Copy)
3 Lessons 00:13:49 Hours
  • Excavation For Foundation (Manual Calculations)
    00:07:47
  • Formwork And Concrete For Foundation (Manual Calculations)
    00:04:31
  • Practice Question 1 For This Module (Please Don't Move Next Till You Done This)
    00:01:31
Backfilling And Column Necks (PDF/Hard Copy)
2 Lessons 00:06:46 Hours
  • Quantity Of Column Necks And Backfilling (Manual Calculations)
    00:06:16
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:30
Grade Beam (Estimation Through PDF File/Hard Copy)
5 Lessons 00:41:02 Hours
  • Formwork For Grade Beams Part 1 (PDF/Hard Copy)
    00:13:15
  • Formwork For Grade Beams Part 2 (PDF/Hard Copy)
    00:08:11
  • Formwork For Grade Beams Part 3 (PDF/Hard Copy)
    00:07:30
  • Concrete For Grade Beams (PDF/Hard Copy)
    00:11:06
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:01:00
Slab On Grade (Estimation Through PDF File/Hard Copy)
3 Lessons 00:22:23 Hours
  • Concrete For Slab On Grade Part 1 (PDF File Manual Calculations )
    00:13:39
  • Concrete For Slab On Grade Part 2 (PDF File Manual Calculations )
    00:08:17
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:27
Column In Superstructure (Estimation Through PDF File/Hard Copy)
2 Lessons 00:04:34 Hours
  • Formwork And Concrete For Columns In SS (PDF Drawings)
    00:03:56
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:38
Stair Formwork And Concrete (Estimation Through PDF File/Hard Copy)
3 Lessons 00:29:15 Hours
  • Formwork For Stairs Part 1 ( What If File Is In Pdf Format Or Hard Copy)
    00:14:07
  • Formwork For Stairs Part 2 ( What If File Is In Pdf Format Or Hard Copy)
    00:04:11
  • Concrete For For Stairs ( What If File Is In Pdf Format Or Hard Copy)
    00:10:57
Formwork And Concrete For Slab (Estimation Through PDF File/Hard Copy)
2 Lessons 00:11:05 Hours
  • Formwork And Concrete For Slab (PDF Format or Hard Copy)
    00:10:12
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:53
Brickwork In Superstructure (Estimation Through PDF File/Hard Copy)
4 Lessons 00:21:52 Hours
  • Brick work in S.S Part 1 (What if Drawing Is in PDF Format)
    00:08:43
  • Brick work in S.S Part 2 (What if Drawing Is in PDF Format)
    00:06:08
  • Brick work in S.S Part 3 (What if Drawing Is in PDF Format)
    00:06:14
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:47
Plaster Work (Estimation Through PDF File/Hard Copy)
4 Lessons 00:29:32 Hours
  • Internal Plaster (What if Drawing is in PDF Format)
    00:12:56
  • Ceiling Plaster (What if Drawing is in PDF Format)
    00:05:17
  • Plaster For Stairs (What if Drawing is in PDF Format)
    00:10:46
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:33
Tiles And Marble (Estimation Through PDF File/Hard Copy)
2 Lessons 00:07:50 Hours
  • Marble For Floor (What If Drawings Are In PDF)
    00:07:11
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:39
PLANSWIFT BEGINNERS TRAINING (If You Know Basic Tools Of Plan Swift you can skip
7 Lessons 00:57:07 Hours
  • User Interface Of Planswift
    00:13:35
  • How to Create Job In Plan Swift
    00:06:07
  • Scale In Plan swift
    00:07:17
  • Area Tool
    00:13:07
  • Linear Tool
    00:09:38
  • Segment Tool.
    00:04:34
  • Count Tool.
    00:02:49
Foundation Works (Estimation Through Plan swift) PDF OR SCAN FILE
5 Lessons 00:36:07 Hours
  • Excavation For Foundation (Through Plan swift Software)
    00:18:00
  • P.C.C For Foundation.
    00:06:25
  • Formwork For Foundation.
    00:05:58
  • Concrete For Foundation
    00:04:13
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:01:31
Column Necks (Calculations Through Plan Swift No 1 Take off Software)
3 Lessons 00:10:01 Hours
  • Formwork For Column Necks
    00:05:21
  • Concrete For Column Necks
    00:04:10
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:30
Grade Beam (Calculations Through Plan Swift No 1 Take off Software)
3 Lessons 00:29:11 Hours
  • Formwork For Grade Beam
    00:19:37
  • Concrete For Grade Beams
    00:08:34
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:01:00
Slab On Grade (Calculations Through Plan Swift No 1 Take off Software)
2 Lessons 00:05:26 Hours
  • Concrete For Slab On Grade
    00:04:59
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:27
Column In Super Structure(Calculations Through Plan Swift No 1 Take off Software
2 Lessons 00:12:06 Hours
  • Formwork And Concrete For Column In S.S
    00:11:28
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:38
Stairs (Calculations Through Plan Swift No 1 Take off Software)
2 Lessons 00:21:50 Hours
  • Formwork For Stairs
    00:14:13
  • Concrete For Stairs
    00:07:37
Slab (Calculations Through Plan Swift No 1 Take off Software)
3 Lessons 00:18:47 Hours
  • Formwork For Slab
    00:13:12
  • Concrete For Slab
    00:04:42
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:53
Brick Work (Calculations Through Plan Swift No 1 Take off Software)
3 Lessons 00:29:04 Hours
  • Brick Works In S.S Part 1
    00:16:32
  • Brick Works In S.S Part 2
    00:11:45
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:47
Plaster Works (Calculations Through Plan Swift No 1 Take off Software)
2 Lessons 00:08:10 Hours
  • Internal plaster
    00:07:37
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:33
Tiles And Marble Works(Calculations Through Plan Swift No 1 Take off Software)
3 Lessons 00:10:17 Hours
  • Tiles For Toilet
    00:06:21
  • Marble For Floors
    00:03:17
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:39
Rate Analysis Manual Calculations
7 Lessons 00:31:51 Hours
  • Rate Analysis For Excavation MKS
    00:04:00
  • Rate Analysis For R.C.C
    00:08:32
  • Rate Analysis For Brick Works
    00:05:09
  • Rate Analysis For Plaster Works
    00:04:27
  • Rate Analysis For Tile Works
    00:04:52
  • Rate Analysis For Paint Works
    00:02:18
  • Rate Analysis Excel Sheet
    00:02:33
Material Statement Excel Sheet (Imp For Project Planning In Material Resources)
1 Lessons 00:11:09 Hours
  • Material Statement Excel Sheet
    00:11:09
Bill Of Quantity (B.O.Q)
2 Lessons 00:11:15 Hours
  • How to Prepare Bill Of Quantity (Excavation)
    00:03:50
  • How to Prepare Bill Of Quantity (Concrete Works)
    00:07:25
Primavera p6 Training (Important if you are beginner in primavera and planning)
14 Lessons 02:01:18 Hours
  • User interface of primavera p6
    00:01:57
  • Organizational Break Down Structure (O.B.S) In Primavera P6
    00:08:53
  • Enterprise Project Structure (E.P.S) In Primavera P6
    00:09:41
  • User Preferences In Primavera P6 (Step 1 Important)
    00:05:48
  • How To Create And Assign Calendar In Primavera P6 (Step 2 Important)
    00:11:19
  • How to Create Project, W.B.S, And Activities In Primavera P6 (Important Step 3)
    00:19:54
  • Milestone And Relationship
    00:07:44
  • Scheduling Project
    00:05:17
  • Some Of Steps Must Be Done Before Creating And Assigning Resources In P6
    00:06:37
  • How Resource Loading Works In P6
    00:04:40
  • Importance Of Resources
    00:05:36
  • Creating And Assigning Resources
    00:17:37
  • Creating And Assigning Baseline In P6
    00:07:20
  • How to Update The Project According to actual Work Done At Site
    00:08:55
Project Planning (Activity WBS List In Excel In Detail)
5 Lessons 00:36:50 Hours
  • W.B.S Activity List Part 1 (Defining Activities Of Our Project In Excel)
    00:12:08
  • W.B.S Activity List Part 2 (Defining Activities Of Our Project In Excel)
    00:08:34
  • W.B.S Activity List (Defining W.B.S Of Our Project In Excel)
    00:06:27
  • W.B.S Activity List (Adding Activities Under W.B.S)
    00:07:14
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:02:27
Defining Resources And Their Productivity In Excel Sheet
4 Lessons 00:21:44 Hours
  • Defining Labor Resources In Excel Sheet.
    00:14:45
  • Productivity Of Different Resources.
    00:05:38
  • Practice Question 1 For This Module (Please Don't Move Next Till You Done This)
    00:00:44
  • Practice Question 2 For This Module (Please Don't Move Next Till You Done This)
    00:00:37
Budgeted Unit And Duration To Activities.
5 Lessons 00:27:21 Hours
  • How to Add Quantities To Our Main W.B.S Activity Excel Sheet.
    00:08:18
  • How to Find Budgeted Unit Of Resources In Our Project
    00:05:45
  • How to Give Duration To Activities.
    00:10:54
  • Practice Question 1 For This Module (Please Don't Move Next Till You Done This)
    00:00:45
  • Practice Question 2 For This Module (Please Don't Move Next Till You Done This)
    00:01:39
Creating Complete Project In Primavera p6
5 Lessons 00:29:59 Hours
  • Creating Project In Primavera P6 (Same Project For Which We Did Estimation)
    00:06:30
  • Importing Activities From W.B.S Activity List To Primavera P6
    00:09:59
  • Creating W.B.S In Primavera P6
    00:07:32
  • Adding Activities Under W.B.S
    00:04:46
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:01:12
Relationships
3 Lessons 00:14:33 Hours
  • Relationships to Activities Part 1
    00:07:46
  • Relationships to Activities Part 2
    00:06:23
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:24
How to Create And Assign Resources In Primavera For Our Project
11 Lessons 01:07:44 Hours
  • Important Steps Before Creating And Assigning Resources.
    00:03:31
  • Creating Labor Resources
    00:08:35
  • Creating Material Resources
    00:09:18
  • Assigning Labor Resources Part 1
    00:09:52
  • Assigning Labor Resources Part 2
    00:05:27
  • Assigning Labor Resources Part 3
    00:09:08
  • Assigning Labor Resources Part 4
    00:05:52
  • Assigning Labor Resources Part 5
    00:03:09
  • Assigning Material Resources Part 1
    00:03:04
  • Assigning Material Resources Part 2
    00:08:49
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:59
How to Update The Project According To Actual.
3 Lessons 00:14:51 Hours
  • How to Update The Project In Term Of Time
    00:09:04
  • How to Update The Project In Term Of Cost
    00:05:07
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:40
Ms Project Training For Beginners (Very Important If You Are Begin In MS PROJECT
13 Lessons 02:08:21 Hours
  • User Interface Of MS Project
    00:14:13
  • Backstage Options (Important Settings)
    00:10:30
  • How to Create Calendar In MS Project
    00:10:45
  • Project Information
    00:03:22
  • How to Create Project W.B.S And Activities In MS Project
    00:11:30
  • Milestone And Relationship In Ms Project Part 1
    00:15:23
  • Milestone And Relationship In Ms Project Part 2
    00:07:55
  • Slack / Float
    00:03:56
  • Resource Loading In MS Project
    00:04:47
  • Importance Of Resources
    00:04:43
  • Creating And Assigning Resources In MS Project
    00:17:09
  • How to Create Baseline In Ms Project
    00:07:03
  • How to Update The Project In MS Project
    00:17:05
Important Setting And Importing Activities In Ms. Project.
3 Lessons 00:11:29 Hours
  • Must Do Settings Before Creating Project In MS Project.
    00:06:28
  • Importing Activities From W.B.S Activity Excel Sheet To MS Project.
    00:04:22
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:39
Defining W.B.S For Our Project In MS Project.
2 Lessons 00:07:33 Hours
  • W.B.S In MS PROJECT
    00:06:57
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:36
Relationships To Activities
2 Lessons 00:06:15 Hours
  • How to Give Relationships To Activities.
    00:05:55
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:20
Creating And Assigning Resources In MS PROJECT
5 Lessons 00:38:07 Hours
  • How to Create Labor Resources In MS PROJECT.
    00:04:58
  • How to Create Material Resources In MS PROJECT.
    00:04:01
  • How to Assign Labor Resources To Our Project In MS PROJECT
    00:19:21
  • How to assign Material Resources To Our Project In MS PROJECT
    00:09:11
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:36
How to Update The Project In MS Project.
3 Lessons 00:12:25 Hours
  • How to Update The Project In MS PROJECT In term Of Time.
    00:05:59
  • How to Update The Project In MS PROJECT In term Of Cost.
    00:05:42
  • Practice Question For This Module (Please Don't Move Next Till You Done This)
    00:00:44
Mode Of Payments To Contractor
8 Lessons 01:00:48 Hours
  • Mode Of Payments To Contractor.
    00:06:41
  • Advance And Secured Advance Payment.
    00:03:07
  • Final Payment And Petty Advance.
    00:03:22
  • Introduction To Format Of Interim Payment Certificate (IPC) In Excel.
    00:16:40
  • How to Create Measurement Book (M.B) For IPC
    00:06:14
  • How to Create Summary For IPC
    00:05:23
  • Creating IPC For Any Specific Work Like Civil Works.
    00:10:11
  • Understanding Previous Paid Quantity Practically.
    00:09:10
Variations Orders In Constructions (Very Important For Quantity Surveyors.
5 Lessons 00:40:43 Hours
  • Introduction To Variations In Construction (Fidic Red Book Clause 13.1)
    00:14:12
  • Variation Excel Sheet (Important Document For Quantity Surveyors.)
    00:03:52
  • How to Create Variation Orders In Excel Format 1 Part 1
    00:11:18
  • How to Create Variation Orders In Excel Format 1 Part 2
    00:08:42
  • How to Create Variation Order In Excel Format 2.
    00:02:39
Excel Training For Beginners
3 Lessons 00:15:40 Hours
  • Font Panel
    00:04:33
  • Border In Excel
    00:05:41
  • Alignment Panel
    00:05:26
Formulas In Excel
4 Lessons 00:24:22 Hours
  • Formulas (Countblank ,Countif ,Sumif)
    00:05:21
  • Formula ( IF )
    00:06:06
  • Formulas (NETWORKDAYSINTL, VLOOKUP)
    00:07:00
  • Formulas (Sum,Subtract,Multiply,Divide)
    00:05:55
Auto-cad Training For Beginners (Introduction)
9 Lessons 00:35:27 Hours
  • User Interface Of Auto-cad
    00:09:21
  • Application Button
    00:02:37
  • Navigation Options
    00:03:49
  • Cartesian And Polar Co-ordinates In Auto-cad
    00:02:57
  • How to Set Drawing Units
    00:04:11
  • How to Set Measuring Unit
    00:04:12
  • How to Set Drawing Limits
    00:03:53
  • Template
    00:01:45
  • Practice Question
    00:02:42
Commands
8 Lessons 00:59:56 Hours
  • Line Command
    00:13:37
  • How to Draw Circle In Auto-cad
    00:05:56
  • How to Draw Arc
    00:08:59
  • How to Draw Ellipse
    00:04:14
  • How to Draw Rectangle
    00:08:25
  • How to Draw Polygon
    00:05:52
  • Poly-line And Spline
    00:09:15
  • Practice Question
    00:03:38
Modifying Object
15 Lessons 01:08:54 Hours
  • Selection
    00:04:36
  • Move And Copy
    00:03:56
  • Rotate
    00:04:14
  • Offset
    00:04:29
  • Scale
    00:05:12
  • Mirror
    00:03:27
  • Trim And Extend
    00:05:51
  • Explode And Erase
    00:02:18
  • Stretch
    00:03:35
  • Break And Break At Point
    00:04:14
  • Fillet
    00:06:56
  • Chamfer
    00:07:24
  • Lengthen Command
    00:05:34
  • Join And Overkill
    00:03:55
  • Practice Question
    00:03:13
Dimensions
10 Lessons 00:50:27 Hours
  • Creating Dimensions
    00:06:38
  • DIM Command
    00:07:39
  • Editing Dimensions
    00:05:05
  • Own Dimension Style
    00:05:23
  • Continue And Baseline Dimension
    00:03:07
  • Associative And Non Associative Dimension
    00:05:38
  • Add Multi leader
    00:04:10
  • Edit Multi-leader
    00:04:39
  • Creating Own Multi leader Style
    00:05:58
  • Practice Question
    00:02:10
(Bonus) Lectures Foundation Work ( Sloped Footing)
2 Lessons 00:13:50 Hours
  • Quantity Of Sloped / Trapezoidal Footing (Manual Calculation)
    00:07:26
  • Concrete For Sloped Footing In Excel.
    00:06:24
(Bonus) Bar Bending Schedule Excel Sheet (Feet And Inches)
2 Lessons 00:23:44 Hours
  • Introduction To B.B.S Sheet.
    00:14:54
  • How to Do Formatting In B.B.S Sheet.
    00:08:50
(Bonus) Bar Bending Schedule For Septic Tank.
6 Lessons 01:10:59 Hours
  • Understanding Reinforcement Detail For Septic Tank.
    00:06:04
  • B.B.S For Septic Tank Bed Part 1
    00:14:44
  • B.B.S For Septic Tank Bed Part 2
    00:13:37
  • B.B.S For Septic Tank Walls Part 1
    00:15:49
  • B.B.S For Septic Tank Walls Part 2
    00:09:56
  • B.B.S For Septic Tank Slab
    00:10:49
Certificate Of Completion.
1 Lessons 00:00:00 Hours
  • How to Download Certificate Of Completion
    .

Frequently asked question

Who Is This Course For?
Civil Engineers,Quantity Surveyors,Estmators,Project Planner,
+ View more
Other related courses
13:53:16 Hours
Quantity Surveying/Building Estimation Cad and Excel In Urdu
Updated Tue, 16-Aug-2022
5 4 9000₨ 1900₨
01:39:44 Hours
Estimating And Costing Basic [ENGLISH]
Updated Wed, 21-Dec-2022
5 39 Free
02:59:00 Hours
Bar Bending Schedule For Beginners [ENGLISH]
Updated Tue, 16-Aug-2022
5 29 Free
05:58:46 Hours
Bar Bending Schedule For Beginners In Urdu.
Updated Sun, 22-Jan-2023
0 7 Free
About instructor

Mudessar Afraz

Civil Engineer

8 Reviews | 72 Students | 10 Courses
Planning Engineer Quantity Surveyor
Student feedback
0
0 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Reviews

Preview this course
15000₨ 3500₨
Includes: