
In this section, you'll learn the essential Excel operators that form the backbone of formulas and calculations. We’ll cover:
Arithmetic operators for basic math (add, subtract, multiply, divide)
Text concatenation to combine text and values
Reference operators to work with cell ranges and data sets
By the end, you'll be able to build accurate, efficient formulas and navigate Excel with greater confidence.
Learn to insert and delete rows and columns in a structured Excel sheet, adjust widths and heights, and use autofit while preserving formulas and formatting.
Learn to use filter, sort, and search tools in Excel to organize and quickly locate data across multiple columns in large sheets, like a master purchase order.
Learn two Excel copy methods—manual and clipboard—for copying multiple material entries, using the master materials list, with Ctrl selections and clipboard storage up to 24 items.
Master the vstack function in Excel to combine multiple project tables into one dynamic list for inventory, procurement, and dashboards. Include headers and use unique to remove duplicates.
Compare two side-by-side vendor lists in Excel, identify matches and missing or extra items row by row, and quickly highlight differences with the Ctrl+Backslash shortcut.
Master a custom number format in excel to color-code days overdue, days left, and today for a subcontractor payment tracker, using today minus due date and conditional formatting.
Learn how to use the countif function to count valve sizes in a gate valve schedule, including syntax range and criteria, and apply the formula across a data table.
Master the sumif function to total supplier purchases in a master purchase order, for procurement and quantity surveying, using range, criteria, and sum range to summarize expenditures by supplier.
Automate data lookup in Excel with Vlookup, using an invoice and a master materials list to retrieve rates and descriptions, including multi-column results with dynamic arrays.
Create and analyze pivot tables in Excel to summarize materials data, explore stock by category and supplier, and compare rates and lead times with simple, dynamic cross-tabulations.
Learn to create a professional bill of quantities in Excel with an A4 portrait layout, header setup (item, description, quantity, unit, rate, amount), and totals.
Learn to create an excavation quantity sheet in Microsoft Excel, like a quantity surveyor would prepare on site, with headers, merged cells, and formulas for accurate volume totals.
Welcome to MS Excel Essentials for Quantity Surveyors and Construction Professionals
Unlock the full potential of Microsoft Excel with this hands-on course, designed specifically for Quantity Surveyors and Construction Professionals. Whether you're managing budgets, analyzing costs, or preparing detailed reports, this course will equip you with the Excel skills needed to work faster, smarter, and more accurately.
This practical course focuses on real-world applications, helping you streamline workflows and enhance productivity in your daily QS tasks. From beginners to those looking to sharpen their skills, you'll find value at every level.
What You’ll Learn
You’ll begin with Excel fundamentals — spreadsheet setup, data entry best practices, and formatting for clarity and professionalism. As the course progresses, you’ll learn to:
Use formulas and functions to automate calculations and reduce errors
Build structured databases for cost management and quantity take-offs
Analyze data using PivotTables for summaries, comparisons, and reports
Create clean, efficient spreadsheets for BOQs, cost tracking, and reporting
Apply key functions like SUM, ROUND, IF, VLOOKUP, and more
Clean and organize messy project data using smart techniques
Work with dates, filters, and formatting for project schedules
Automate repetitive tasks to improve your workflow
Use logical and lookup functions for decision-making
Prepare BOQs and measurement sheets with accuracy
Leverage tools like VSTACK, remove duplicates, and compare lists
Discover hidden Excel features and productivity tips specific to QS work
All lessons are delivered through step-by-step video tutorials, focusing on real construction industry scenarios.
Who This Course is For
Quantity Surveyors (Junior to Experienced)
Cost Engineers and Estimators
Site Engineers managing cost tracking and measurements
Construction professionals looking to enhance productivity with Excel
Project Admins
Document Controllers
Course Outcomes
By the end of this course, you will:
Confidently use Excel in a QS-specific context
Understand and apply essential Excel tools for daily tasks
Save time, reduce errors, and improve report quality
Build reusable templates for estimating, budgeting, and reporting
Clearly present project information to clients, contractors, and stakeholders
Gain job-relevant skills to stand out professionally
Why This Course?
Excel is more than just a spreadsheet tool — it’s a vital part of the modern quantity surveyor’s workflow. This course is tailored to the specific needs of construction professionals, cutting through the noise and focusing on the tools and techniques that truly matter — both on-site and in the office.
Disclosure Statement:
This course makes use of AI-powered technology to enhance the overall learning experience. Certain elements, including audio clarity, voiceovers, and instructional delivery, may have been improved or generated with the assistance of artificial intelligence tools.
Our goal is to provide learners with a clearer, more engaging, and accessible experience. Please note that while AI enhances quality, all course content, concepts, and instructional material are designed and reviewed by the instructor to ensure accuracy and reliability.
Take the next step in your professional development. Master Excel with a course built for the construction industry — and gain a competitive edge in every project you manage.