Find a Course/Course Calendar
BACK TO EDUCATION CALENDAR
12May

MS Excel Intermediate- VILT

Single-day Course
  • 2026-05-12 07:30:00 | 2026-05-12 11:30:00
Show more...
Single-day Event:\n\n
  • 2026-05-12 07:30:00 | 2026-05-12 11:30:00
    • \n
Location Title: Virtual Instructor Led Training via GoToTraining
Cancellation Period: 5 Business Days

This course can be difficult if using only one (1) monitor.  It is recommended to have two monitors - one for your MS Excel and one for the Instructors screen.  

This course is intended for anyone who has a foundational understanding of Microsoft Excel and wants to dive deeper into some of its more advanced features and functions.

Prerequisites: 

A basic knowledge of and experience with Excel and Windows, including being able to start programs, switch between programs, locate saved files, and close programs. Basic Excel skills are also required.

Note: Access to the Microsoft Excel desktop app is required for this course. It is also highly recommended to have two screens/monitors.

Course Length: ½ day (4 hours)

Course Outline:
Part 1: Cleaning and Formatting Data

  • Data Cleanup
  • Text To Columns
  • Flash Fill
  • Removing Duplicates
  • Conditional Formatting
  • Tables

Part 2: Summarizing and Analyzing Data

  • PivotTables
  • Slicers
  • Charts
  • PivotCharts

Part 3: Smart Functions for Work Tracking

  • The IF Function
  • IFS
  • SUMIF and SUMIFS
  • SUMIF
  • SUMIFS
  • IFERROR
  • TODAY

Part 4: Lookups & Automation

  • Dropdown Lists
  • XLOOKUP

Next Scheduled Date:  June 9, 2026

Course Credits: 

  • 1 - Gold Seal Credit

Cancellation Policy
Ticket Not Available? Click here to add yourself to the waitlist. Please describe the ticket type you would like to purchase.
Course Credits Information
pointer
Gold Seal Credits:
1
Course Certificates

Upon successful completion of this seminar, a certificate of completion will be sent to the registered email address.

Course Instructor Information

Presenter:  Phil Perry, P.Eng.

 

Phil Perry has 30 plus years in the Construction Industry, most of which was Project Managing Industrial Projects for General Contractors. He has been teaching Post-Secondary Construction Management Courses for the last twelve years for organizations such as the Edmonton Construction Association, Calgary Construction Association, Winnipeg Construction Association, Ontario Roadbuilders Association, Newfoundland and Labrador Construction Association, University of Alberta Faculty of Extension, and the Northern Alberta Institute of Technology. He has been facilitating Better SuperVision programs since 2009.  He has facilitated over 350 courses and over 2500 students over the last four years. In his spare time, Phil is a Master Course Facilitator for a National Sports Organization and chaired their National Coaching/Instructional Program for four years. He was the recipient of the 2018 IG Wealth Management Community National Coaching Certification Program (NCCP) Coach Developer Award.

Course Contact Information

training@sicabc.ca
778-721-8451

MS Excel Intermediate- VILT is currently full. Please continue to checkout or add your email address to the waiting list