This registration page may not work well in Internet Explorer. Please use a different browser to complete your registration.

Microsoft Excel for Construction Estimating (March 13, 2025)

March 13, 2025 8:00 AM - 4:00 PM (MDT)

Description


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. 

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.

Method of Delivery

This course is delivered as an interactive Virtual Instructor Led Training (VILT) course using the PESL GoToTraining platform.

Duration: 1 Day (7 hours)

Your Presenter:

Phil Perry of Perry Educational Services Ltd 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 ten years for organizations such as the Edmonton Construction Association, Calgary Construction Association, Winnipeg Construction Association, Ontario Roadbuilders Association, University of Alberta Faculty of Extension, and the Northern Alberta Institute of Technology. He has been facilitating Better SuperVision programs since 2009.  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.

    This course counts for one Gold Seal Credit. For more information about Gold Seal, click HERE.


Future offerings of this course:

Please check back for 2024 Dates!

Time

8:00AM - 4:00PM MST

Pricing

Member-only Pricing $350.00 +GST

Non-member Pricing $450.00 +GST

View Event

Contact Information

Edmonton Construction Association
Name: Brittaney Down
Email: brittaney.down@edmca.com
We're sorry. No registrations are currently available. You may wish to contact the event organizer for assistance.
{{ vm.EventInfo.ErrorMessage }}

Select Registration Options

Edit
{{vm.regWarningMessage}}
{{vm.regAlertMessage}}

Exhibitor Opportunities

Name Price Att Qty
{{ et.Name }}
{{ et.IncludedAttendeesCount }} {{ et.AttendeeRegType.RemainingPerType }} Remaining {{ et.AttendeeRegType.RemainingPerType * -1 }} on Waiting List {{ et.AttendeeRegType.RemainingPerType * -1 }} Over Limit
{{ et.Remaining }} Remaining
 Sold out

Attendee Registration Options Total Remaining: {{ vm.EventInfo.VacantSpotsPerEvent }}

Waiting List Available
{{ vm.stats.totalAttendeesCount }} Registered , {{ vm.OverallOverAmount() }} on Waiting List , {{ vm.OverallOverAmount() }} Over Limit
Name Price Qty
{{ rt.Name }}
{{ rt.IsMemberOnly ? ' (Members Only)' : '' }}
Limit: {{ rt.LimitPerPurchase }}
Included Attendees: {{ rt.AttendeesCountPerOneRegistration }}
{{rt.Price | currency }} {{rt.PriceAfterDiscount | currency }} {{ rt.Price | currency }}
{{ rt.RemainingPerType }} Remaining
{{ rt.RemainingPerType * -1 }} on Waiting List
{{ rt.RemainingPerType * -1 }} Over Limit

{{'[[Sponsorship]] Opportunities' | localizeString:'['}}

Name Price Att Qty
{{ st.Name }}
{{ st.IncludedAttendeesCount }} {{ st.AttendeeRegType.RemainingPerType }} Remaining {{ st.AttendeeRegType.RemainingPerType * -1 }} on Waiting List {{ st.AttendeeRegType.RemainingPerType * -1 }} Over Limit
{{ st.Remaining }} Remaining
 Sold out
Continue

Registration Information

Edit

Exhibitor - {{er.Name}}

Exhibitor #{{ $index + 1 }}

Total: {{exhibitor.TotalPrice | currency}} {{ exhibitor.IsBenefit ? "- Included as a Benefit" : exhibitor.IsDiscounted ? "- Discounts have been applied" : ""}}
Exhibitor Directory
Primary Contact
Booth Information
Additional Information
Additional Items

Attendee - {{er.Name}}

{{ att.getAttendeeTerm(vm.EventSettings.AdditionalAttendeesTerm, $index) }} #{{ att.getAttendeeIndexDisplay(vm.EventSettings.AdditionalAttendeesTerm, $index) }}

Total: {{att.TotalPrice | currency}} {{att.DiscountMessage | localizeString:'['}}
A No Show fee is being assessed for {{fee.EventName}} on {{fee.EventStartLocalTimeString}}.
More Information Less information

Address

Phone

Additional Information
Event Sessions

{{slot.Name}}

{{$select.selected.SessionName}}
(full)
{{slot.SelectedSession.SessionDescription + (slot.HasFees ? " (Price: " + (slot.PriceTotal | currency) +")" : "")}}
Additional Items

{{'[[Sponsorship+]]' | localizeString:'['}} - {{er.Name}}

{{'[[Sponsor]]' | localizeString:'['}} #{{ $index + 1 }}

Total: {{sponsor.Price | currency}}
Continue

Additional Items

Edit

{{(vm.EventInfo.Terms.Donation || "Fundraising") + " Opportunities"}}

Campaign Name Item Description Amount
{{item.CampaignName}} {{item.Description + (item.ShowMinimumPrice && item.MinimumPrice ? " (Min: " + item.MinimumPrice + ")" : "")}}
Continue

Complete Registration

Edit

Terms & Conditions

No Show Policy

{{ vm.EventInfo.EventSettings.NoShowPolicy }}

Enter Promo Code
This event is synced to a webinar so no confirmation email will be sent from GrowthZone.

Thank you to our {{'[[Sponsor+]]' | localizeString:'['}}