Live support chatConstruction Estimating Using Excel
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.
Learning Objectives
Upon completion of this course, participants will be able to:
- Use the built-in SUM and PRODUCT functions in Excel.
- Explain the order of precedence for arithmetic operators.
- Apply a border and fill color to a cell in Excel.
- Identify different construction materials used in estimating.
- Recognize common construction units, including cubic feet, cubic yards, feet, square feet, tons, pounds, linear feet, squares, board feet, and gallons.
- Convert between selected construction units, such as cubic feet and cubic yards.
- Describe the CSI MasterFormat system.
- Specify ranges of adjacent and nonadjacent 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.
| This course is applicable to professional engineers in: | ||
| Alabama (P.E.) | Alaska (P.E.) | Arkansas (P.E.) |
| Delaware (P.E.) | Idaho (P.E.) | Indiana (P.E.) |
| Kansas (P.E.) | Kentucky (P.E.) | Louisiana (P.E.) |
| Minnesota (P.E.) | Mississippi (P.E.) | Montana (P.E.) |
| Nevada (P.E.) | New Hampshire (P.E.) | New Jersey (P.E.) |
| New Mexico (P.E.) | North Dakota (P.E.) | Oklahoma (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.) | |
Preview a portion of this course before purchasing it.
Credit: 2 PDH
Length: 20 pages
