Microsoft Power Query for Quantity Surveyors

Microsoft Power Query is a powerful data connectivity and transformation tool within Excel that allows participants to seamlessly connect, clean, manipulate, and analyze vast amounts of data from various sources with efficiency and precision.

This course is designed to equip professionals with the skills to streamline data handling, analysis, and reporting using Excel’s powerful Power Query tool.

In today’s construction environment, managing tender and project data efficiently is critical for accuracy, cost control, and informed decision-making. This course empowers participants to automate repetitive tasks, transform raw data into actionable insights, and create dynamic reports that can be refreshed with ease — all within the familiar Excel environment.

Over four in-depth sessions, participants will gain practical experience in connecting to diverse data sources, cleaning and transforming tender data, and applying advanced data analysis techniques. By the end of the course, participants will not only be proficient in Power Query, but also capable of integrating it into daily workflows to enhance organizational efficiency and project outcomes.

COURSE OBJECTIVES

• Understand Power Query fundamentals and its role in data management
• Seamlessly connect, import, and clean data from multiple sources
• Perform advanced data transformations for accurate tender analysis
• Automate repetitive tasks to save time and reduce errors
• Create dynamic, refreshable reports for ongoing project management
• Apply Power Query in real-world tender evaluation scenarios

VENUE

The training topics will run as VILT (virtual instructor-led training) via Microsoft Teams.