• Post category:StudyBullet-13
  • Reading time:5 mins read


For Quantity Surveyors, Engineers and Construction Professionals

What you will learn

Introduction to MS Excel

Formulas and Shortcuts in MS Excel

BOQ Preparations

Payment Application Preparations

Reinforcement Quantities

Quantities in Road Projects

Description

This course is designed to provide students with a comprehensive understanding of the application of Microsoft Excel in Quantity Surveying. The course will cover a range of topics, including the basics of using Excel, advanced Excel functions and features, and the practical application of Excel in Quantity Surveying.

The course will begin with an introduction to Excel, covering the basic features and functions of the program, including formatting, creating and editing spreadsheets, and using formulas and functions. Students will learn how to create and manage spreadsheets, including how to create tables, charts, and graphs to visualize data.

The course will then move on to more advanced Excel functions and features that are specifically relevant to Quantity Surveying. This will include topics such as creating and managing cost estimates, analyzing and managing project budgets, and tracking project progress. Students will learn how to use Excel to manage complex data sets and perform advanced data analysis.


Get Instant Notification of New Courses on our Telegram channel.


Throughout the course, students will work on a range of practical exercises and case studies that will allow them to apply their Excel skills in a real-world context. These exercises will cover topics such as preparing bills of quantities, cost estimation, and financial analysis. By the end of the course, students will have a thorough understanding of how Excel can be used to streamline and enhance the Quantity Surveying process.

Overall, this course is designed to provide students with a comprehensive understanding of the practical application of Microsoft Excel in Quantity Surveying. By the end of the course, students will have the skills and knowledge necessary to use Excel to effectively manage data and streamline the Quantity Surveying process.

English
language

Content

Introduction

Introduction

Introduction to MS Excel

Basics of Excel

Applications of Excel in Quantity Surveying

Convert pdf to Excel and Create Table
Delete Tables
Format Painter
Wrap Text
Text to Column
Transpose and absolute cell reference
Freee pans, Filter, Columns and Rows , Remove Duplicate & Hyper link
Serial numbers , Label and Create new sheet
Text
Password Protection, Comment and Jump

Frequently Used Functions

SUM, Auto Sum & Sub Total
IF and COUNTIF
SUMIF
VLOOKUP
Pivot Table
Product, Round and Tim
Concatenate, Conditional Formatting and Link

BOQ Preparation

BOQ Preparation

Payment Application

Create Payment Application

Reinforcement Weight Calculations

Reinforcement Weight Calculation Method

Retention

Calculation 01
Calculation 2

Road Projects

Quantities in Road Projects

Last Session

Excel Templates