November 12, 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

Tuesday, November 12, 2024 (8: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 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...

July 25, 2024

Virtual Tech Talk: Role of the Prime Contractor

Tech Talk key takeaways: • Identifying owner/prime contractor responsibilities • Coordinating health...

July 31, 2024

Managing Shop Drawings, Samples and Submittals

The process for submitting shop drawings, submittals and samples is key to...

ECABC Proud Partner:

Schneider Electric Canada