MS Intermediate Excel for Construction 1& 2

MS Intermediate Excel for Construction 1 & 2 – Excel Training for Construction Professionals

Enhance your Excel skills with our MS Intermediate Excel for Construction 1 & 2 course—designed specifically for construction professionals looking to improve spreadsheet efficiency and data analysis capabilities. This intermediate Excel training is perfect for users who have basic experience with Microsoft Excel and want to confidently manage and manipulate spreadsheets used in construction projects.

Whether you’re a quantity surveyor, project manager, estimator, or site engineer, this course builds upon foundational Excel knowledge to help you master tools commonly used in Bills of Quantities (BOQs), project tracking, budgeting, and reporting.

Course Prerequisites:
Participants should already know how to create, edit, format, and print spreadsheets. A good understanding of basic formulas is essential. Ideally, learners will have completed an Excel Introduction course prior to joining.

What You’ll Learn in MS Intermediate Excel for Construction 1 & 2:

• Build complex formulas using relative and absolute cell referencing, essential in BOQs and costing.

• Apply powerful Excel functions including SUMIF, COUNTIF, IF, OR, AND, VLOOKUP, HLOOKUP, IFERROR, and more.

• Use Conditional Formatting to highlight key project data dynamically.

• Link spreadsheets and external files to consolidate project data across documents.

• Master data manipulation through sorting, filtering, and validation tools.

• Analyse construction data with Pivot Tables.

• Visualise trends and metrics using a variety of chart types.

This course bridges the gap between basic and advanced Excel use in the construction industry, helping you to work faster and smarter. Enroll in MS Intermediate Excel for Construction today to streamline your workflow and gain a competitive edge.

Learn more about your trainer: Marta Maslowska

For more information or to book contact Laura at 087 3688491 or cpskillnet@cif.ie.