Construction Estimating Using Excel

Course No. P-2005

Credit: 2 PDH

Course Fee: $57.90 Purchase course

Subject Matter Expert: Robert Duane Nickols, P.E., R.L.S.

Attention Engineers Licensed in the States of: Indiana, New York, Ohio

This course cannot be taken to fulfill the continuing education requirements of the states shown above since the subject matter does not fall within the state guidelines. For more information, check your State Board Requirements.

Indiana | New York | Ohio

Overview

This course is of particular interest anybody involved with construction. Very little knowledge of Excel is needed. This course covers many different spreadsheets needed to do a quantity take-off on many different construction materials.

• Concrete
• Earthwork
• Finishes
• Masonry
• Metals
• Openings
• Paving
• Thermal and Moisture Protection
• Wood

The take-off is performed using many different units.

• Cubic feet, cf, ft³, cu ft
• Cubic yards, cu yd, yd³
• Feet, ft
• Square feet, sf, ft², sq ft
• Tons
• Pounds, lbs, #
• Linear feet, lf
• Square, sq
• Foot board measure, fbm
• Gallons, gal

We will use only a few commands, like border and fill color. We will use only a few built-in functions like SUM and PRODUCT. I have included an installation program that will install all the files covered in the course plus some additional blank forms.

The student must take a multiple-choice quiz consisting of ten (10) questions at the end of the course to obtain PDH credits.

Specific Knowledge or Skill Obtained

This course teaches the following specific knowledge and skills:

• How to use built-in functions in Excel
  • SUM
  • PRODUCT
• Know the order of precedence of arithmetic operators
• How to apply a border and fill color to a cell
• Become familiar with different construction material
• Become familiar with different types of units used in construction
  • Cubic feet
  • Cubic yards
  • Feet
  • Square feet
  • Tons
  • Pounds
  • Linear feet
  • Square
  • Foot board measure
  • Gallons
• Know how to convert some units, like cubic feet to cubic yards
• Become familiar with the Master Format by CSI
• Know how to specify a range of adjacent or non-adjacent cells in Excel

Course

Click on the following link to the PDF document to review the course material before taking the quiz for credit.

Construction Estimating Using Excel

Excel worksheets used in the course can be downloaded and installed on your hard drive in the following manner:

1 - RIGHT click the link below and select "Save Target As" (Internet Explorer) or "Save Link As" (Firefox)

2 - Save the file to your desktop

3 - When completed, double click on the icon to install the files on your computer

Worksheet installation file for Construction Estimating Using Excel

Having trouble downloading the PDF file?

If clicking the link does not bring you to the PDF file, then right-click the link. Click "Save Target As" and save on your desktop. To view the file, double-click the icon on your desktop and return to this page to take the quiz. You may want to bookmark this page for your convenience. If you have questions, Live Support Chat can help.

You may need Adobe Reader to view this document. Click on the link to download a free copy of the latest version of Adobe Reader.

To receive PDH credit for this course, you must pass a multiple-choice quiz. Click the button below to Purchase Course and Take Quiz. To take the quiz, your computer must be set to accept cookies. See how to check your cookie settings.