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

October 22, 2024

Getting Paid and Managing the Cash Flow in Construction

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

October 30, 2024

Construction Specifications 101

This is an interactive half-day course that will cover the fundamentals of...

November 5, 2024

Bluebeam Revu Basics

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

November 5, 2024

Dr. Awad Hanna Sessions

Tuesday, November 5, 2024: The Top habits of High Performing Foremen in...

ECABC Proud Partner:

Schneider Electric Canada