📊 MICROSOFT EXCEL SKILLS EVERY ASPIRING QUANTITY SURVEYOR SHOULD LEARN

Excel is a valuable tool for quantity estimation, cost calculations, BOQs, valuations, and construction reporting.

🔹 Start With These Skills

1️⃣ Basic formulas: addition, subtraction, multiplication, and division.

2️⃣ SUM: Calculate totals.

3️⃣ Percentage calculations: Work with tax, allowances, or percentage-based values where applicable.

4️⃣ Cell references: Understand relative and absolute references.

5️⃣ IF functions: Apply simple logical conditions.

6️⃣ Sorting and filtering: Organize large datasets.

7️⃣ Lookup functions: Retrieve relevant information from tables.

8️⃣ Formatting: Make cost reports and BOQs easier to read.

🏗️ Practical Exercise

Create a small BOQ containing:
Item description.
Unit.
Quantity.
Unit rate.
Total amount.

Use a formula to calculate:

Amount = Quantity × Unit Rate
Then calculate the overall total using the SUM function.

📌 Always verify quantities, formulas, units, and rounding. A spreadsheet can calculate incorrectly if its inputs or formulas are wrong.

@ETCONpWORK