Description
Introducing Advanced Functions
Building on your budgeting skills, this course introduces advanced Excel functions and visualization tools that bring data to life. Participants will learn how to create dynamic charts, use slicers for interactive analysis, and apply multiple arguments in functions for deeper insights. With a focus on practical construction and engineering applications, this class also covers check boxes, nested functions, and conditional formatting—allowing you to make smarter, more flexible spreadsheets. By mastering these tools, you’ll develop greater confidence in analyzing data, producing visuals, and presenting professional reports that stand out in both clarity and impact.
• Expanding the budget
• Creating and customizing charts
• Create a table
- Table functions
- Filtering tables
- Using slicers
- Adding and customizing the total row
- Apply named ranges to a table
• Building functions with multiple arguments
• Working with Check Boxes
- Apply to conditional formatting
- Apply to conditional functions
• Learning how to nest functions within functions
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.