Application of MS Excel for Construction Professinals

Master the basics of excel: open a workbook, use the home and insert tabs, format cells and borders, and apply sum, average, and rank on a student marks sheet.

Convert PDF to Excel using a free online tool and learn to build clean quantity surveyor tables with serial numbers, descriptions, units, quantities, and rates.

Learn how to delete selected cells, rows, columns, and entire tables in Excel, and explore using the format painter for quick formatting.

Use the format painter to copy cell formats across rows and columns, applying formatting quickly, then move on to wrap text.

Master wrap text in Excel by using alt+enter for line breaks, copying formatting, and applying text to column for data preparation.

learn how to use text to column in excel to split data, remove millimetre units, convert values to numbers, and perform area calculations like 250 by 450.

Master how to transpose data in Excel using the transpose paste option, and apply absolute cell references to lock a cell when dragging formulas; freeze panes, filters, and sorts.

Master freeze panes, pan, and filter in Excel; learn to copy filtered data, remove duplicates, add borders, and create hyperlinks for construction data.

Learn essential Excel techniques for construction professionals, including serial numbers and labels, date and currency formatting, and sheet management with add, rename, color, hide, and delete.

Explore text formatting in excel by applying strikethrough, subscript, and superscript, convert text to lowercase, uppercase, or proper case, and learn password protection.

Learn how to password protect cells, insert and manage comments, use select all and jump shortcuts to navigate large worksheets, and an overview of frequently used Excel functions.

Apply sum, autosum, and subtotal in Excel to total data ranges, select the region, filter data, and calculate subtotals with the subtotal function 109.

Explore how to use the if function with logical tests to include or exclude data, and apply countif to total quantities for 50mm and 20mm in construction spreadsheets.

Learn to apply countif and sumif in Excel for construction data, including selecting ranges, using criteria, and ensuring accuracy with absolute references via F4.

Learn to apply VLOOKUP to retrieve unit prices in construction data using lookup value, table array, exact match. Lock table with F4 and use pivot tables to summarize data.

Create and customize a pivot table to summarize data sets by placing area of use and size in millimeter into rows and columns, showing the total quantity.

Apply the product function for multiplying large data sets, use round options to control precision, and trim data to align PDF content in Excel.

Concatenate data from multiple cells into one using the concatenate function, and apply conditional formatting to highlight values and dates, then link data across tabs.

Discover how to prepare a bill of quantities (BOQ) in Excel, including bill number, description, unit, quantity, rate, and amount, and manage layout, printing, and repeated headers.

Create a payment application in excel for construction professionals, using bill of quantities, quantities from measurements, unit prices, and amounts across previous, current, and cumulative sections.

Calculate reinforcement weight by converting bar length and count, compute unit weight from bar diameter, and derive total weight in metric tons with Excel, dragging formulas across.

Learn to calculate monthly retention from cumulative retention in Excel using the if function and absolute references, applying 10% off to the cumulative amount for accurate results.

Learn to estimate road project quantities by calculating volumes from cross sectional areas, using left and right side measurements, chainage notation, and the average of A1 and A2.

Explore downloadable excel templates for construction and industrial use, with websites offering many excel sheets to give you a clear idea, and learn about quantity surveying in an additional course.