Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Microsoft Excel for Construction Estimating

Gold Seal: 1 Credit * BC Housing: 7 CPD Points

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

This hands-on course is taught by a certified Microsoft Master Instructor. 

You will need to have MS Excel 2016 (or newer) program downloaded and installed on the computer. The web version will not be suitable.  

In order to participate in this course, you will require either two monitors or a second device (tablet) or computer so that you are able to watch the instructor while at the same time practicing and applying the new skills.  

 

Delivery Method: Virtual Session – GoToTraining  

Course Fee Includes: Access to the course, course materials, and a digital certificate upon completion. 

 

This course is delivered in partnership with local and provincial construction associations across Canada. You will be participating with a group of industry peers from multiple regions. 

Sharing a single registration between two or more individuals is not permitted. Please register each person that will be in attendance.

Prerequisites

A basic knowledge of and experience with Windows, including being able to start programs, switch between programs, locate saved files, and close programs. Note: Access to the Excel desktop app is required for this course.

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.

Technical Requirements

  1. Computer or laptop   
    • This course will involve on-screen interaction with your instructor and classmates, reading/viewing on-screen content (slides or videos), and interacting via typing with questions or responses. For this reason, cell phones will not be adequate.   
    • Windows 10 or Mac iOS   
  2. Software/Programs - Excel 2016 (or newer) program downloaded and installed on the computer. The course assumes that students have completed the Microsoft Office Basics course or have equivalent knowledge. The web version will not be suitable.
  3. Webcam (Mandatory)– in order to engage and collaborate, participants will be expected to have their webcams on for the duration of the class   
  4. Microphone (Mandatory)   
  5. Internet connection - For best results, you will want to ensure you have an internet connection with an upload/download speed of 3-5 Mbps. You can test your internet speed here. The minimum recommended speed is 1.5 Mbps, but anything below 3 Mbps may result in loss of quality or buffering. Ideally hardwired connection versus wireless for stability - connect your computer directly to your router using an ethernet cable, rather than using your home wi-fi.   
  6. A quiet space with minimal distractions - The microphone will be engaged for interactive sessions. Please plan to be fully engaged in the class and clear your work schedule just as you would for the in-class program.     
  7. Comfortable chair   

Similar courses

Time Management for Leaders

Gold Seal: 1 Credit - Previously named "Time Management Workshop"

More Information
Building Construction – Putting it all Together

Gold Seal: 2 Credits * BC Housing: 14 CPD Points

More Information
Bluebeam Revu Basics

Gold Seal: 1 Credit * BC Housing: 6.5 CPD Points

More Information
Bluebeam Revu Estimating - Level 1

Gold Seal: 1 Credit * BC Housing: 6.5 CPD Points

More Information
Bluebeam Revu Estimating - Level 2

Gold Seal: 1 Credit * BC Housing: 7.5 CPD Points

More Information
CCA Subcontracts 101

BC Housing: 4 CPD Points

More Information
Change Order Management

Gold Seal: 1 Credit * BC Housing: 8 CPD Points

More Information
Closeout of a Construction Project

Gold Seal: 1 Credit * BC Housing: 6 CPD Points

More Information
Supervisory & Management Skills

Gold Seal: 5 Credits * BC Housing: 16 CPD Points

More Information
Sales Skills Workshop

Gold Seal: 1 Credit * BC Housing: 7.5 CPD Points

More Information
Communication Skills for Construction

Gold Seal: 4 Credits * BC Housing: 16 CPD Points

More Information
Responsibilities of Joint Health & Safety Committees (JHSC) (BC)

BC Housing: 8 CPD Points **Classroom Session Only**

More Information
Responding Successfully to a Request for Proposal (RFP)

Gold Seal: 2 Credits * BC Housing: 9 CPD Points

More Information
Providing Exceptional Customer Service

Gold Seal: 1 Credit * BC Housing: 8 CPD Points

More Information
Proposal Pursuit - Strategies for Success

Gold Seal: 1 Credit * BC Housing: 9 CPD Points

More Information
Accident/Incident Investigation VR 6.0

In its broadest sense, an “incident” is anything that was not supposed to happen. There is no other activity that produces faster OH&S results than promptly reporting and investigating incidents. For this reason, incident investigation is a vital part of every health and safety management system.

More Information
Construction Business Management

Gold Seal: 5 Credits * BC Housing: 16 CPD Points

More Information
Construction Estimating

Gold Seal: 5 Credits * BC Housing: 16 CPD Points

More Information
Construction Law

Gold Seal: 5 Credits * BC Housing: 16 CPD Points

More Information
Construction Project Management

Gold Seal: 5 Credits * BC Housing: 16 CPD Points

More Information
Construction Safety for Supervisors

Gold Seal: 2-5 Credits * BC Housing: 16 CPD Points

More Information
Earned Value Management (EVM) for Construction

Gold Seal: 1 Credit * BC Housing: 7 CPD Points

More Information
Field Productivity 101

Gold Seal: 1 Credit * BC Housing: 7 CPD Points

More Information
Field Scheduling 101 - Who Does What When in the Field?

Gold Seal: 1 Credit * BC Housing: 7 CPD Points

More Information
Change Order Management

Gold Seal: 1 Credit * BC Housing: 8 CPD Credits

More Information
Construction Business Management

Gold Seal: 2 Credits * BC Housing: 8 CPD Credits

More Information
Construction Estimating

Gold Seal: 2 Credits * BC Housing: 8 CPD Credits

More Information
Construction Law

Gold Seal: 2 Credits * BC Housing: 10 CPD Credits

More Information
Mold Awareness

BC Housing: 1 CPD Point

More Information
Project Accounting and Cost Control

Gold Seal: 1 Credit * BC Housing: 6 CPD Credits

More Information
Project Management

Gold Seal: 2 Credits * BC Housing: 8 CPD Credits

More Information
Project Accounting and Cost Control

Gold Seal: 1 Credit * BC Housing: 7.5 CPD Points

More Information
Project Planning for Success

Gold Seal: 1 Credit * BC Housing: 6 CPD Points

More Information
SiteReadyBC

BC Housing: 6 CPD Points

More Information
Introduction to Blueprint Reading

Gold Seal: 1 Credit * BC Housing: 8 CPD Points

More Information
WHMIS (GHS)

BC Housing: 1.5 CPD Points

More Information
Microsoft Project - Comprehensive

Gold Seal: 2 Credits * BC Housing: 14 CPD Points

More Information
Project Management Essentials

Gold Seal: 1 Credit * BC Housing: 7 CPD Points

More Information
Hazard Recognition and Control

Gold Seal: 1 Credit * BC Housing: 7.5 CPD Points

More Information
Incident Investigations

BC Housing: 7.5 CPD Points

More Information
Trade Contracts: A Double-Edged Sword

Gold Seal: 1 Credit * BC Housing: 6 CPD Points

More Information
Supervisory & Management Skills

Gold Seal: 2 Credits * BC Housing: 8 CPD Credits

More Information
Why Supervisory Skills Matter for Retention

Keep talent from walking out the door by understanding your role in retention!

More Information
AutoCAD Fundamentals

BC Housing: 21 CPD Points

More Information
Water Damage Remediation Basics

BC Housing: 3 CPD Points * IICRC: 3.0 CEC Hours

More Information
Finance & Accounting For Non-Financial Managers

Gold Seal: 2 Credits * BC Housing: 12 CPD Points

More Information
Profitable Contracting

Gold Seal: 1 Credit * BC Housing: 7 CPD Points

More Information
Strategic Planning for Growth

Gold Seal: 1 Credit * BC Housing: 7 CPD Points

More Information
Lean Scheduling with The Last Planner System

7 CM-Lean Continuing Education Hours A Detailed Review of Production Planning & Practical Strategies for Overcoming Common Implementation Challenges

More Information
Rick Hansen Foundation Accessibility Certification™ (RHFAC) Fundamentals Training

Intended for anyone interested in creating inclusive spaces, this 4-week course provides learners with foundational knowledge to understand the needs of people with disabilities and how our physical spaces can be made more accessible.

More Information
Project Delivery Methods – Know Your Responsibilities

Gold Seal: 2 Credits * BC Housing: 9 CPD Points

More Information
Managing CCDC Contracts for Project Success

Gold Seal: 2 Credits * BC Housing: 12 CPD Points

More Information

Press enter to see more results