MS Excel Advanced - Part 2
Description
Data Management & Pivot Tables
When managing large construction or engineering datasets, Excel’s data management and Pivot Table tools are essential. This course teaches you how to clean, validate, and organize data efficiently before transforming it into powerful reports and visual insights. You’ll create Pivot Tables and Pivot Charts that automatically update, enabling quick comparisons and summaries across multiple projects or departments.
By learning to control and visualize your data effectively, you’ll turn raw information into actionable intelligence—saving hours of manual work while improving reporting accuracy and decision-making.
• Collecting Data using Data Validation
o Add data validation, including using pick lists
o Remove duplicate data; highlight invalid data
• Advanced Filtering of Data
• Summarizing data with Pivot Tables
o Five steps in creating your first Pivot Table from a data set
o Using a Pivot Source sheet to efficiently create multiple reports
o Creating and printing multiple custom reports
o Visualizing data with Pivot Charts
o Applying slicers to data and charts
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.