MS Excel for Construction Estimating *Virtual Instructor Led*

Full Day Virtual Instructor Led
$450.00 excl. GST

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.

PREREQUISITES:

  • A general understanding of project management concepts 
  • Basic skills with any Windows operating system
  • Two Monitors are recommended. One for the Student MS Excel and one showing the Instructor Screen. Very difficult for the student to try to see both on one computer screen!

COURSE OBJECTIVES:

Upon successful completion of this course, participants will be able to:

  • 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 to access an MS EXCEL Database
  • Print work product to PDF

AUDIENCE:

This course is for any estimator 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 delivered in partnership between your local construction association and other associations throughout Western Canada. You’ll be participating in a cohort with industry peers from across these regions.


CANADA ALBERTA PRODUCTIVITY GRANT (CAPG)

(Replacing the Canada – Alberta Job Grant)

The Canada-Alberta Productivity Grant (CAPG) helps employers invest in training that focuses on enhancing productivity skills for their current and future employees that aligns with the needs of their business. It is an employer-driven program meant to partially reimburse the cost for an employer to send their employee(s) for training.

Did you know!! Eligible employers can get government funding to help employees access training opportunities. The CAPG will give you up to 50% of the registration fee (up to $5,000/employee/fiscal year) for training. Whether taking one eligible course or a combination of eligible courses.

OVERVIEW

HOW TO APPLY

 


This course is worth 2 Gold Seal Credits


Instructor

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


Cancellation Policy:

Payment is non-refundable for cancellations made within 5 business days of the course, or non-attendance on the day. Complimentary substitution of another member of your company is accepted. If CCA has to postpone or cancel courses due to insufficient enrolment, CCA will refund the registration fee or, if possible, the attendee may choose to move to an identical session in the future. Unless otherwise stated, every person able to see, hear, and observe the virtual course sessions must be a paid participant. Non-compliance of this requirement will result in removal from course. Refunds will not be issued to students who are removed from the course for non-compliance of this requirement.


Filters

Interested in attending? Have a suggestion about running this event near you?
Register your interest now