# Construction Estimating Using Excel

Course Number: P-2005
Credit: 2 PDH
Subject Matter Expert: Robert Duane Nickols, P.E., R.L.S.
Price: \$59.90 Purchase using Reward Tokens. Details
38 reviews
Overview

#### In Construction Estimating Using Excel, you'll learn ...

• How to use built-in functions, SUM and PRODUCT in Excel
• 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

#### Overview

Preview a portion of this course before purchasing it.

Credit: 2 PDH

Length: 20 pages

Construction Estimating Using Excel 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 & Moisture Protection
• Wood

The take-off is performed using many different units:

• Cubic feet, cf, ft3, cu ft
• Cubic yards, cu yd, yd3
• Feet, ft
• Square feet, sf, ft2, 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.

#### Specific Knowledge or Skill Obtained

This course teaches the following specific knowledge and skills:

• How to use built-in functions, SUM and PRODUCT in Excel
• 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 that are used in construction: Cubic feet, Cubic yards, Feet, Square feet, Tons, Pounds, Linear feet, Square, Foot board measure and 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

#### Certificate of Completion

You will be able to immediately print a certificate of completion after passing a multiple-choice quiz consisting of 10 questions. PDH credits are not awarded until the course is completed and quiz is passed.

Board Acceptance
 This course is applicable to professional engineers in: Alabama (P.E.) Alaska (P.E.) Arkansas (P.E.) Delaware (P.E.) Florida (P.E. Other Topics) Georgia (P.E.) Idaho (P.E.) Illinois (P.E.) Illinois (S.E.) Iowa (P.E.) Kansas (P.E.) Kentucky (P.E.) Louisiana (P.E.) Maine (P.E.) Maryland (P.E. Category A) Michigan (P.E.) Minnesota (P.E.) Mississippi (P.E.) Missouri (P.E.) Montana (P.E.) Nevada (P.E.) New Hampshire (P.E.) New Jersey (P.E.) New Mexico (P.E.) North Carolina (P.E.) North Dakota (P.E.) Oklahoma (P.E.) Oregon (P.E.) Pennsylvania (P.E.) South Carolina (P.E.) South Dakota (P.E.) Tennessee (P.E.) Texas (P.E.) Utah (P.E.) Vermont (P.E.) Virginia (P.E.) West Virginia (P.E.) Wisconsin (P.E.) Wyoming (P.E.)
Reviews (38)
More Details

Preview a portion of this course before purchasing it.

Credit: 2 PDH

Length: 20 pages