Quantity Surveying Building Estimation And Project Planning (Udemy.com)
Quantity Surveying, Quantity Takeoff, BBS In Excel ,Complete Project In Autocad, Project Planning With Primavera P6.
Created by: Mudessar Afraz
Last updated September 2026
What you will learn
- Estimate a complete building from AutoCAD drawings using Excel
- Use AI to do quantity takeoff in a fraction of the time
- Learn Bar Bending Schedule (BBS) from the basics, even with zero experience
- Make a complete Bar Bending Schedule in Excel, ready for site use
- Calculate cement, sand, crush, and bricks by hand, step by step
- Do all material calculations in Excel quickly and accurately
- Build a complete Material Statement sheet in Excel
- Make a complete Material Statement with the help of AI
- Do rate analysis for all major items of work in Excel
- Prepare a professional Bill of Quantities (BOQ) in Excel
- Prepare rate analysis and BOQ faster using AI
- Make monthly contractor payments (IPCs) in Excel like a pro QS
- Prepare variation orders in Excel, a must-have skill for every QS
- Estimate a full project in PlanSwift with fast digital takeoff
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.6 out of 5higher than 63% of them
- Reviews4,323#73 of 356 by number of reviews
- Length43.2 hourslonger than 98% of them
- Last updatedSeptember 2026more recently than 98% of them
Course Description
Complete Updated Course: Last Update 09/2026
Now with AI-Powered Estimation!
Become a Job-Ready Quantity Surveyor, Estimator, and Planner in One Course
Are you a fresh civil engineer, a student, or a site engineer who wants to learn estimation and project planning the way it's done in real projects?
This course takes you from zero to estimating a complete building, from foundation to finishing, and then planning that same project in Primavera P6 and MS Project.
No theory-only lessons. You'll work on a real, full project from start to end.
Important Note: Patience and Dedication Required
Dear students,
Before you enroll, please know this is not a quick course. It has 43 hours of detailed training, covering estimation, BBS, rate analysis, BOQ, payments, planning, and AutoCAD.
Your success in this course depends on your commitment. Learning estimation and planning takes time, practice, and patience.
So before you click "Enroll," ask yourself:
"Do I have the time and patience to invest in my own growth?"
If your answer is yes, this course can be your gateway to a strong career in quantity surveying, estimation, and project planning.
What Makes This Course Different
One project, every method: You estimate the same building through AutoCAD, PDF drawings (manual), PlanSwift, and AI, then plan it in Primavera P6 and MS Project.
AI-powered estimation: Learn how to use AI to do quantity takeoff, material statements, rate analysis, and BOQ in a fraction of the time.
Beginner training included: Never used Excel, AutoCAD, PlanSwift, Primavera, or MS Project? Beginner training for each one is included.
Practice after every module: Complete a mini project yourself and build real confidence.
43 hours of practical training in one place.
Course Content
1. Complete Building Estimation Through AutoCAD and Excel
Take off quantities directly from AutoCAD drawings and calculate everything in Excel.
Isolated footing and sloped footing: excavation, formwork, concrete
Columns, grade beams, slab on grade, lintel and top beams, slabs: formwork and concrete
Brickwork, plaster, tile and marble, paint
2. Estimation Through PDF Drawings (Manual Calculations)
Estimate the same project from PDF files or hard copy drawings, the way it's done on many sites.
3. Estimation Through PlanSwift
Estimate the same project with fast digital takeoff in PlanSwift.
4. AI-Powered Estimation (New!)
Quantity takeoff using AI
Developing a material statement using AI
Developing rate analysis and BOQ using AI
5. Bar Bending Schedule (BBS)
Start with the basics, then build complete BBS sheets in Excel for:
Isolated footings
Column necks and columns
Beams
Stair
Slab
6. Material Calculations
Manual calculation of cement, sand, crush, and bricks, step by step for beginners
Material calculations in Excel
Complete material statement Excel sheet
7. Rate Analysis in Excel
Excavation, PCC, RCC (columns, beams, slabs), masonry, plaster, tiles, and paint.
8. Bill of Quantities (BOQ)
Prepare BOQ according to CSI codes.
9. Contractor Payments and Interim Payment Certificates (IPC)
Introduction To Interim Payment Certificates
Create monthly interim payment certificates in Excel from scratch
10. Variation Orders
Introduction to variation orders in construction
How to prepare variation orders in Excel
11. Complete Project Planning in Primavera P6
Plan the same project you estimated:
Create the activity list in Excel
Add manpower and productivity, and find activity durations
Import activities from Excel to P6
WBS and relationships
Create and assign resources (labour and material)
Update the project with actual time and cost
12. Complete Project Planning in MS Project
Plan the same project again in MS Project with the same full workflow: activities, WBS, relationships, resources, and updates.
13. Complete Project in AutoCAD
Draw the full project yourself: plan, section, elevation, and steel detailing.
14. Beginner Training for All Software
Microsoft Excel beginner training
AutoCAD beginner training
PlanSwift beginner training
Primavera P6 beginner training
MS Project beginner training
15. Practice Questions and Mini Project
Practice questions come at the end of every module. If you complete them step by step, you will finish a full mini project on your own: estimation, planning in P6 and MS Project, and drawing it in AutoCAD with steel detailing.
One Course, Everything You Need
AutoCAD, Excel, PlanSwift, AI, Primavera P6, and MS Project, all in one place, all applied to one real project.
No need to buy multiple courses. Everything is here.
Enroll now and start building your career in civil engineering today!
Instructor Details
- 4.6 Rating
4,323 Reviews
Mudessar Afraz
My Name Is Mudessar Afraz And I am skilled and experienced civil engineer with a strong background in Quantity Surveying And Project Planning. I have a proven track record of delivering projects on time and within budget. In addition to my technical expertise, I am also an experienced online instructor, with a passion for teaching and a talent for making complex concepts easy to understand. With my combination of engineering knowledge and teaching skills, I am well-suited to help students succeed in the field of civil engineering.
More courses by Mudessar Afraz
Quantity Surveying/Bar-bending Schedule (B.B.S) Course (2024)
4.6 (508 Reviews)
Provider: Udemy
Time: 9.5h
$64.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By Artemio Lausin on 7/24/2026
Instructor is highly knowledgeable about all the topics covered and shared his experienced effectively, including valuable tips and techniques. I also appreciated that the course covered a wide range of topics related to civil engineering management software.
By Md Asif Jawed on 4/3/2026
Very useful and informative for Beginner and also for mid level people as we see many people nowadays don't know these things even after going in the field of professionalism.
By Muhammad Danish Maqsood on 10/11/2025
I appreciate the effort of Eng, who gives us this gift of huge knowledge. Quantity Surveying Building Estimation And Project Planning courses are very essential for Planning and Cost Controllers. Thanks! Our prayers are always with Eng. Mudessar Afraz!
By Hafiz Naeem Ullah Bajwa on 2/24/2025
"I am highly satisfied with this course! It's detailed, comprehensive, and very easy to follow. The instructor covers all the necessary topics in a well-structured manner, making it accessible even for beginners. The course content is practical and provides valuable insights. I would definitely recommend it to anyone looking to learn or enhance their skills in this field."
By Muhammad Humayoon on 8/11/2024
This course was extremely helpful and made me realize that even though I thought I was proficient in AutoCAD, there were still many new concepts to learn. Through this course, I gained deeper insights into structural drawings, Quantity Takeoffs, and Construction Processes, along with software and real-time workflow, and much more.
By Mohammed Nazeer Attaliq on 7/20/2024
I am Abdul Hameed, I'm from India I am reviewing this of course after learning quantity survey which I have enrolled 2 years before. To be honest he has explained in a fruitful smart, simple and detailed way. Apart from this he has also provided Primavera course we don't have to invest a penny to learn this software, initially he has describe regarding software and then after afterwards he explained definitions each and everything... last but not least he has also explained the whole project I appreciate him thank you
By Eurika Rymbai on 7/15/2024
Truly above expectation course!! The teacher actually teaches all knowledge properly this is the best course for any civil engineer! Please provide more courses with various different type of projects like G+10 structures with BOQ preparation from IS codes etc.
By Tural Alizada on 11/21/2020
I like it. Really good explanations of IPC with it's all necessary details. You could find lots of text materials, definitions in internet but without tutor and detailed explanations, all these knowledge can be confusing. Here with almost real project examples, with templates student learns a lot or strengthens it's skills.
By Om Sanjay Prasade on 11/21/2020
Yes, Basics fundamentals are well taken care of.
By Sana Qadar on 11/14/2020
best course so far. every concept is explained in a very simple way.
By Himanshu Agarwal on 11/7/2020
very much intresting and good teaching so thank you sir
By Richard McKenzie on 11/7/2020
Above and beyond expectations.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100








