Excel for Construction - Basic

The course will teach you how to use Microsoft Excel to create estimates, track expenses, calculate overruns, track production rates, and calculate material usage.

By the end of the workshop, you will be well-versed in the most widely-used functions of the program and know how to minimize errors and misrepresentations of numerical data.

This course will help you:

• Create better, more accurate financial estimates of projects; • Calculate and create records of production rates; • Spend less time and effort maintaining better financial records of business expenses; • Spend less time and effort in creating financial reports; • Be able to track costs and revenues by job effectively.

Topics

• Structuring a basic estimate table • Formulas • Filling a series with formulas • Sum totals • Formatting • Simple graphics • Linking to Word/PowerPoint • Print layouts • Templating • Recovering Unsaved Files • Duplicating Sheets • Internal linking • Date Functions And Scheduling • Custom Lists • Data Aggregation With Filters/

Subtotals/Sumif • Advanced Formulas • Conditional Logic and IF statements