Microsoft Excel Essentials For Quantity Surveyors

Microsoft Excel, Quantity Surveyors, Quantity Surveying, Excel Tips & Tricks for QS

What you'll learn

Understanding of the MS-Excel application in quantity surveying.

Learning essential formulas for day to day calculations

Utilizing advanced Excel features for problem solving

MS-Excel Tips & Tricks for quantity surveyors

Important data cleaning functions for productivity improvement.

Useful Templates for Quantity Surveyors

Requirements

Basic computer and MS-Excel knowledge needed, You will learn everything you need to know for quantity surveying functions.

Description

Welcome to MS Excel Essentials for Quantity Surveyors and Construction ProfessionalsUnlock 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 LearnYou’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 errorsBuild structured databases for cost management and quantity take-offsAnalyze data using PivotTables for summaries, comparisons, and reportsCreate clean, efficient spreadsheets for BOQs, cost tracking, and reportingApply key functions like SUM, ROUND, IF, VLOOKUP, and moreClean and organize messy project data using smart techniquesWork with dates, filters, and formatting for project schedulesAutomate repetitive tasks to improve your workflowUse logical and lookup functions for decision-makingPrepare BOQs and measurement sheets with accuracyLeverage tools like VSTACK, remove duplicates, and compare listsDiscover hidden Excel features and productivity tips specific to QS workAll lessons are delivered through step-by-step video tutorials, focusing on real construction industry scenarios.Who This Course is ForQuantity Surveyors (Junior to Experienced)Cost Engineers and EstimatorsSite Engineers managing cost tracking and measurementsConstruction professionals looking to enhance productivity with ExcelProject AdminsDocument ControllersCourse OutcomesBy the end of this course, you will:Confidently use Excel in a QS-specific contextUnderstand and apply essential Excel tools for daily tasksSave time, reduce errors, and improve report qualityBuild reusable templates for estimating, budgeting, and reportingClearly present project information to clients, contractors, and stakeholdersGain job-relevant skills to stand out professionallyWhy 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.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Excel Basics Refresher (For Beginners)

Lecture 2 Understanding Basic Arithmetical Operators in Excel

Lecture 3 Working with Columns and Rows in Excel

Lecture 4 Deleting Rows

Lecture 5 Hiding Tab Bar for Better Working Space

Lecture 6 Working with Filter and Short in Excel

Lecture 7 Copy and Paste in Excel

Lecture 8 Application of Paste Special in Excel

Lecture 9 Use of Freeze Panes in QS Functions

Lecture 10 Focus Cell - New Feature in Excel

Lecture 11 Use of F4 Key in Excel

Section 3: Data Cleaning in QS Functions

Lecture 12 Data Cleaning Functions - Full Guide

Lecture 13 Application of VSTACK Function in QS Works

Lecture 14 Comparing Two Lists

Lecture 15 Removing Duplicates

Section 4: Basic Functions For Quantity Surveyors in Excel

Lecture 16 SUM Function and it's Applications in QS Works

Lecture 17 SUBTOTAL Function and it's Applications in QS Works

Lecture 18 Various ROUND Functions and their Applications in QS Works

Lecture 19 SQRT Function and it's application

Section 5: Working with Date Functions in QS Works

Lecture 20 Date Functions - A Series

Lecture 21 Working with Dates - Trick For QS Professionals

Section 6: Application of Logical Functions in QS Works

Lecture 22 IF Function and Application

Lecture 23 IFERROR Function and Application

Lecture 24 COUNTIF Function and Application

Lecture 25 SUMIF Function and Application

Section 7: Application of Lookup Functions in QS Works

Lecture 26 VLOOKUP Function and Application

Lecture 27 HLOOKUP Function and Application

Lecture 28 XLOOKUP Function and Application

Lecture 29 INDEX and MATCH Functions and Application

Section 8: Conditional Formatting and It's Applications in QS Works

Lecture 30 Learn Various Conditional Formatting and It's Applications

Section 9: Use of PIVOT Table in QS Tasks

Lecture 31 PIVOT Table and It's Application in QS Functions

Section 10: BOQ and Measurement Sheet Preparation

Lecture 32 Preparation of BOQ

Lecture 33 Preparation of Measurement Sheet

Section 11: Important Excel Tricks For Quantity Surveyors

Lecture 34 Combining Item Descriptions

Lecture 35 Copy and Paste Trick - 01

Lecture 36 Copy and Paste Trick - 02

Lecture 37 Flash Fill

Lecture 38 Text to Column

Lecture 39 Useful Trick - 01

Lecture 40 Useful Trick - 02

Lecture 41 Useful Trick - 03

Lecture 42 Useful Trick - 04

Quantity Surveyors,Civil Engineers,MEP Engineers,Freshers,Cost Professionals,Engineering Students,Estimators,Other Construction Professionals