arrow_back
Module 1: Introduction to Excel for Quantity Surveying
1-Excel-and-Its-Formulas-for-Quantity-Surveying-and-Estimation-Calculations
1.1 Basics of Excel Interface and Functions
1.2 Using Excel Formulas and Cell Referencing
1.3 Data Validation and Error Checking
1.4 Creating and Managing Worksheets for QS Projects
Module 2: Quantification and Measurement Calculations Using Excel
2-Excel-and-Its-Formulas-for-Quantity-Surveying-and-Estimation-Calculations2-Excel-and-Its-Formulas
2.1 Calculating Areas and Volumes from Dimensions
2.2 Complex Measurement Formulas for Irregular Shapes
2.3 Unit Conversion Techniques in Excel
2.4 Creating Measurement Summary Tables with Dynamic Totals
Module 3: Cost Estimation Using Excel Calculations
3-Excel-and-Its-Formulas-for-Quantity-Surveying-and-Estimation-Calculations
3.1 Linking Quantities to Unit Rates for Costing
3.2 Using Lookup Functions for Rate Retrieval
3.3 Calculating Material, Labor, and Equipment Costs Separately
3.4 Applying Percentage Markups and Taxes Automatically
Module 4: Quantity Surveying Data Analysis and Reporting
4-Excel-and-Its-Formulas-for-Quantity-Surveying-and-Estimation-Calculations
4.1 Using Pivot Tables for Quantity and Cost Summarization
4.2 Conditional Formatting for Visual Quantity Highlights
4.3 Creating Dynamic Dashboards for QS Reports
4.4 Exporting and Printing QS Reports Professionally
Module 5: Advanced Excel Formulas for Quantity Surveying
5-Advanced-Excel-Formulas-for-Quantity-Surveying
5.1 Nested IFs and Logical Formulas in Quantity Validation
5.2 Using SUMIFS and COUNTIFS for Conditional Calculations
5.3 Array Formulas and Dynamic Ranges
5.4 Text Functions for Data Cleanup and Processing
Module 6: Templates and Automation in QS Excel Workbooks
6-Excel-and-Its-Formulas-for-Quantity-Surveying-and-Estimation-Calculations
6.1 Designing Reusable QS Calculation Templates
6.2 Using Named Ranges for Easy Formula Management
6.3 Creating Drop-Down Lists for Standardized Inputs
6.4 Introduction to Simple Macros for Repetitive Tasks
Module 7: Real Case Scenario - Earthworks Quantity Calculation
7-Excel-and-Its-Formulas-for-Quantity-Surveying-and-Estimation-Calculations7-Excel-and-Its-Formulas-
7.1 Setting up the Project Worksheet for Earthworks
7.2 Calculating Cut and Fill Volumes Using Excel Formulas
7.3 Costing Earthworks with Rates and Overheads
7.4 Reporting and Visualizing Earthworks Quantities
Module 8: Real Case Scenario - Concrete Works Quantity and Cost Estimation
8-Excel-and-Its-Formulas-for-Quantity-Surveying-and-Estimation-Calculations8-Excel-and-Its-Formulas
8.1 Inputting Structural Element Dimensions
8.2 Calculating Concrete Volume and Steel Reinforcement Quantities
8.3 Linking Quantities to Material and Labor Rates
8.4 Quality Checks and Cross-Verification Techniques
Module 9: Real Case Scenario - Finishes and Fixtures Quantity Surveying
9-Excel-and-Its-Formulas-for-Quantity-Surveying-and-Estimation-Calculations
9.1 Quantifying Wall Finishes: Plastering, Painting, Tiling
9.2 Calculating Fixtures and Fittings Quantities
9.3 Applying Rate Analysis for Finishing Items
9.4 Preparing BOQ Section for Finishes and Fixtures
Module 10: Practical Templates and Final Project Workbook
10-Excel-and-Its-Formulas-for-Quantity-Surveying-and-Estimation-Calculations
10.1 Compiling All Work Sections into a Master QS Workbook
10.2 Creating a Project Summary and Cost Control Sheet
10.3 Final Quality Assurance and Validation Checks
10.4 Exporting, Sharing, and Updating QS Workbooks