September 18, 2024

Microsoft Excel for Construction Estimating

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.

Date & Time

Wednesday, September 18, 2024 (7:00 am – 4:00 pm pt)

Location

Online

Details

This one-day workshop covers:

  • Use Excel formulas and functions 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 functions 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 subcontractors in all segments of the construction industry.

Gold Seal Certification

With the completion of the workshop, you will receive 2 credits towards your Gold Seal Certification.
Certificate Details

Instructor(s)

Phil Perry

Perry Educational Services Ltd

Phil brings over thirty years of experience in the Construction industry, specializing in managing industrial projects for general contractors. For the past thirteen years, he has taught construction management courses at the post-secondary level and facilitated over five hundred Better SuperVision programs since 2009, impacting over four thousand students. Beyond his professional life, Phil serves as a Master Course Facilitator for the Canadian Sport Parachuting Association, where he chaired their national Coaching/Instructional program for four years. He was honored with the 2018 IG Wealth Management Community National Coaching Certification Program (NCCP) Coach Developer Award for his outstanding contributions to developing trained and certified NCCP Coaches.

Learn More

Cancellation Policy

Fees will be collected at the time of registration. Should it be necessary to cancel your attendance please contact ECABC at any time up to 4 weeks prior to the course start date for a full refund. A cancellation from 2 weeks to 4 weeks will result in a 50% refund. There will be no refund for cancellations less than 10 business days prior to the scheduled start date. Participant substitutions may be made up to 2 days before the course start date, at no additional fee.

If the course needs to be to be postponed or cancelled due to insufficient enrollment, ECABC will refund the registration fee or, if possible, the attendee may choose to move to an identical session in the future.

Registration & Information

Upcoming courses

July 16, 2024

Bluebeam Revu Basics

This 2-day webinar series teaches you the fundamentals of using Bluebeam's award-winning...

July 16, 2024

WEBINAR: BC Hydro: 2024 Major Supplier and Contractor Engagement presentation

BC Hydro invites you to attend the 2024 Major Supplier and Contractor...

July 18, 2024

Field Scheduling 101

Project management and site management (superintendent, general foremen and foremen) influence millions...

July 19, 2024

Getting Paid and Managing the Cash Flow in Construction

Payment in the construction industry is a problem. This create problems for...

ECABC Proud Partner:

Schneider Electric Canada