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 offers an exploration of Power Query’s robust features, designed to streamline and enhance the tender evaluation process. Over the span of four in-depth sessions, participants will gain hands-on experience in importing, cleaning, and transforming tender data, utilizing advanced data analysis techniques that ensure accuracy and cost-efficiency. Additionally, the course will guide participants in creating dynamic, refreshable reports, crucial for ongoing project management and tender reassessment.

By the end of this training, participants will be equipped with the skills to integrate Power Query into their existing workflows, automating and optimizing key processes to drive more informed decision-making. This course not only enhances their technical capabilities but also empowers them to contribute more effectively to their organization’s success in managing tenders and projects.

COURSE OBJECTIVES

• Equip Quantity Surveyors with the ability to efficiently import, clean, transform, and analyze tender data using Power Query.
• Enable participants to apply advanced data analysis techniques to streamline the tender evaluation process, ensuring accuracy and cost-efficiency.
• Develop skills in creating dynamic, refreshable reports that aid in ongoing project management and tender reassessment.

VENUE

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