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
- Add data validation, including using pick lists
- Remove duplicate data; highlight invalid data
• Advanced Filtering of Data
• Summarizing data with Pivot Tables
- Five steps in creating your first Pivot Table from a data set
- Using a Pivot Source sheet to efficiently create multiple reports
- Creating and printing multiple custom reports
- Visualizing data with Pivot Charts
- 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.
For support or inquiries, please email [email protected] or call 604-293-2339.
| Ticket | Price | ||||||||
| Fees |
|
|
9:00am - 1:00pm
|
Course
|
Refund Policy
COURSE REGISTRATION CANCELLATIONS, TRANSFERS & REFUNDS:
Cancellations received at least 14 business days prior to the course will result in a full refund.
Cancellations received less than 14 business days but more than 7 full business days prior to the course are subject to an administration fee of $100 per day for full and half-day seminars, or $25 for breakfast sessions.
Registrants who do not show up for a course, and/or who do not notify CITN at least 7 full business days prior to the course date will be assessed the full cost of the course. There will be no refunds or credits in this case.
Substitution of attendees is permitted up to and including the day of the course.
COURSE CANCELLATION BY CITN:
CITN may have to postpone or cancel courses due to insufficient enrolment, in which case CITN’s liability will be limited to a refund of the registration fee.