Find a Course/Course Calendar

MS Excel for Construction - VILT

Single-day Course
  • 2024-06-18 07:00:00 | 2024-06-18 15:00:00
Show more...
Single-day Event:\n\n
  • 2024-06-18 07:00:00 | 2024-06-18 15:00: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.  

The ability to produce cost estimates efficiently and accurately is a critical step in many construction career paths, and a high-demand skill throughout the construction industry. Computer software has become a popular tool for estimating, and Microsoft Excel is the most widely used option. In this one- day course, learn how to produce your estimates more quickly and accurately by harnessing the power of Microsoft Excel.

Course Content:

  • Use Excel formulas for typical construction estimating tasks
  • Create takeoff sheets for use as templates
  • Learn handy shortcuts to streamline estimating
  • Link information in worksheets and workbooks
  • Accurately calculate profit, overhead, markups, and taxes
  • Generate graphs to visually display work product
  • Use features such as VLOOKUP and HLOOKUP
  • Create Pivot Tables and Pivot Charts to quickly analyze and visualize information
  • Explore formulas such as COUNTIF and SUMIF

Who should attend?

This course is for anyone who uses (or is considering using) Microsoft Excel for Construction Estimating. Whether you’re a novice or experienced Excel user, you’ll get practice using basic and extended features of Excel for a variety of typical estimating tasks.

This course is for Contractors and Sub-Contractors in all segments of the Construction Industry.

Next Scheduled Date:  July 24, 2024

Course Credits: 

  • 2 - CCA Gold Seal Credits
  • 7 - BC Housing CPD Points


Course Credits Information
Gold Seal Credits:
Other Credits:
BC Housing 7 CPD points
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

Leanne Hendrickson
Director of Education

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

Registration is now closed for this course/event.