Quantity Estimating & Costing for Building

🚀 Master Quantity Estimating & Costing with Excel for Construction 🚀

Introduction: Welcome to the comprehensive course, "Quantity Estimating & Costing for Building," designed specifically for construction professionals. This course will empower you with the skills to master Excel for quantity estimation, calculate material requirements, and prepare detailed bills of quantities using real-world examples from the Public Works Department (PWD) rate book.

Part-A] Spreadsheet Mastery with Excel 📊 Excel isn't just a tool; it's your partner in precision. In this section, we'll navigate through:

• The Interface: Get cozy with the Ribbon, Quick Access Toolbar, and File Tab to manage your documents effectively.

• Basic Formatting: Learn to beautify your data with labels & values, and get adept at performing calculations using formulas. Discover how to copy a formula with autofill, perform quick additions with AutoSum, and save your progress without the hassle. 🛠️

• Formulas and Functions: Dive deep into writing and copying formulas like a pro, understand absolute references, master the AutoSum Function, and explore the Payment Function. We'll also run through an exercise to solidify your knowledge.

• Tables & Charts: Transform raw data into dynamic Excel Tables, sort and filter your data with ease, and insert basic graphs to visualize your data effectively. Learn to move charts to new worksheets for better organization. 📈

• Extra Tools: From converting text to columns to implementing conditional formatting, we'll cover it all. We'll also show you how to use the Count and CountIf functions, remove duplicates, protect sheets, and make the most of the Excel Table feature.

Part-B] Professional Quantity Estimating & Costing Techniques 🏗️ Take your skills to the next level with professional quantity estimating and costing techniques tailored for the construction industry:

• Preparing Building Plan & Section: Learn how to prepare building plans and sections accurately for estimation purposes.

• Measuring Building Items: Utilize Excel to create a comprehensive Measurement Sheet, covering up to 60 building items.

• Using Current Schedule of Rates: Gain proficiency in using the PWD rate book to ensure accurate and up-to-date costing for your projects.

• Abstract Sheet & General Abstract Sheet: Understand how to prepare an Abstract Sheet, detailing quantities and rates for different components of a construction project.

• Material Quantity Calculation: Learn the ins and outs of calculating material quantities using Excel, ensuring you have everything needed for a successful build.

• On-site Visit: For our offline batch, an essential site visit will guide your practical understanding of the estimation process on-location.

Skills Acquired: By the end of this course, you'll be equipped to:

• Prepare a Complete Detailed Estimate for building projects using Excel.
• Use the Current Schedule of Rates book published by PWD effectively.
• Calculate detailed quantities of complete building items and materials using Excel with precision.
• Calculate cost estimates for specific periods, such as floor wise or phase wise, using Excel's powerful tools.
• Compile a Complete Quantity of all materials required for construction projects using Excel, ensuring no detail is overlooked.
• Fill in the Measurement Book from site work to prepare running bills accurately. 📚✨

Join us on this journey to become a quantity estimating and costing expert with Excel! 🎉