Construction Industry Training Network (CITN)

Microsoft Excel Advanced 1: Functions, Forms and Data (Live Online Training)
Gold Seal: 2 Credit
Tuesday, August 6th and Wednesday, August 7th, 2024
Registration Deadline
Monday, August 5th, 2024
Event Description

This interactive, live instructor-led online training course will cover the same content as the in-person course.  All live online courses will be recorded, and participants will have access to the recorded session for 3 months.


Save hours and minimize errors by learning how to manage data and reporting through tables and with the use of pivot tables, graph data and be able to make dynamic charts and identify trends with trend lines. 


Build error proof data entry sheets using data validation techniques so that reporting is virtually error free. Learn to use advanced functions like Vlookup, If function and build complex nested functions with ease.  Learn tips, shortcuts and how to program simple macros from a Microsoft Master Instructor.


The following list summarizes skills that participants will be comfortable with after this course.

  • Use advanced functions such as:
    o Information.
    o Lookup and reference.
    o Conditional logic.
    o Conditional summary.
  • Add data validation, including using pick lists.
  • Remove duplicate data, circle invalid data.
  • Create, modify, or remove a hyperlink.
  • Work with shared workbooks.
  • Add protection to workbooks and worksheets.
  • Track changes.
  • Use data analysis tools.
  • Create and modify PivotTables or PivotCharts.
  • Use slicers with PivotTables.
  • Create and run Macros.
  • Add form controls.


This hands-on course is taught by a certified Microsoft Master Instructor.


You will need to have Excel 2016 (or newer) program downloaded and installed on computer. The course assumes that students have completed the Microsoft Office Basics course or have equivalent knowledge. The web version will not be suitable.


In order to participate in this course, you will require either two monitors or a second device (tablet) or computer so that you are able to watch the instructor while at the same time practicing and applying the new skills. 




Duration:  Two half days (7 Hours in total) of virtual lessons with an instructor.

Workshop Time: 8:30 AM - 12:30 PM Pacific Standard Time (PST) each day

Delivery Method: Virtual Session – MS Teams

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.






While there are no prerequisites for this session, this course assumes that students have completed the Microsoft Excel for Business course or have equivalent basic knowledge of how to use Excel.


Who Should Attend?


This course is ideal for any individuals that are looking to elevate their knowledge to an expert level with working with Excel.



What Previous Participants Said:


“Delighted with the course.  I feel very fortunate, in that the course appeared to address exactly what I needed at my stage of development as an Excel user. The combination of practical examples from your course instructor with the Microsoft Expert Certification guide written backup seems ideal.  Thank you!”

Contact & Support

For support or inquiries, please email or call 604-293-2339.

All prices in Canadian dollars
Ticket Price
Attendee Registration for Webinar
BC Road Builders Member $275.00
CITN Member $275.00
ICBA Member $275.00
Non-Member $299.00
Day 1    Tuesday Aug 6, 2024
8:00am - 12:00pm
Webinar Day 1
Day 2    Wednesday Aug 7, 2024
8:00am - 12:00pm
Webinar Day 2
Additional Information

Technical Requirements:


1.      Computer or laptop 

·        This course will involve on-screen interaction with your instructor and classmates, reading/viewing on-screen content (slides or videos), and interacting via typing with questions or responses. For this reason, cellphones may not be adequate.  

·        Windows 10 or Mac iOS  

2.      Software/Programs - Excel 2016 (or newer) program downloaded and installed on computer. The course assumes that students have completed the Microsoft Office Basics course or have equivalent knowledge. The web version will not be suitable. Download Program Here:

3.      Webcam (Mandatory) – in order to engage and collaborate, participants will be expected to have their webcams on for the duration of the class  

4.      Microphone (Mandatory) 

5.      Internet connection - For best results, you will want to ensure you have an internet connection with an upload/download speed of 3-5 Mbps. You can test your internet speed here. Minimum recommended speed is 1.5 Mbps, but anything below 3 Mbps may result in loss of quality or buffering. Ideally hardwired connection versus wireless for stability - connect your computer directly to your router using an ethernet cable, rather than using your home wi-fi.  

6.      A quiet space with minimal distractions - microphone will be engaged for interactive sessions. Please plan to be fully engaged in the class and clear your work schedule just as you would for the in-class program.    

7.      Comfortable chair  

Cancellation &
Refund Policy
Cancellations received at least 5 business days prior to the webinar date will result in a full refund.
Registrants who do not attend/log into a webinar, and/or who do not notify CITN of cancellation at least 5 full business days prior to the course date will be assessed the full cost of the webinar. There will be no refunds or credits in this case.
Substitution of attendees is permitted up to and including the day of the webinar.
CITN may have to postpone or cancel webinars due to insufficient enrolment, in which case CITN's liability will be limited to a refund of the registration fee.
^ Back to Top