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.
Microsoft Excel for Construction Estimating
Description
Duration:
Instructor: Phil Perry
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.
Who should attend: 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.
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
