MS Excel Expert - Part 2
Description
Power Query and Power Pivot
(Prerequisite is MS Excel Advanced - Part 2 or equivalent)
Power Query and Power Pivot revolutionize how professionals handle large and complex datasets. In
this course, you’ll learn to import, clean, and connect data from multiple sources to create
automated, dynamic reports. Using Power Pivot, participants will build data models, define
relationships, and create meaningful KPIs for monitoring performance across projects or divisions.
These tools are invaluable for anyone managing detailed engineering or construction data, offering
a faster, smarter way to consolidate and analyze information at scale.
• Power Query
o Import data
o Clean irregularly formatted data
o Connect to Data Sources
o Automating Data Updates
o Summarizing automatically update data info Pivot Tables and Pivot Charts
• Power Pivot
o Build data models
o Manage your data relationships
o Connecting to internal and external data sources
o Creating Measures
o Creating KPI’s
Delivery Method: Virtual Session – Zoom Meetings
Course Fee Includes: Access to the course, course materials, and a digital certificate upon completion.
This course is delivered in partnership with local and provincial construction associations across Canada. You will be participating with a group of industry peers from multiple regions.
Sharing a single registration between two or more individuals is not permitted. Please register each person that will be in attendance.
Prerequisites
MS Excel Advanced - Part 2 or equivalent