Overview

The course will teach you how to use 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 Excel. You’ll know how to minimize errors and misrepresentations of numerical data. You will be able to create estimates and project plans, track expenses quickly, and create summary cost reports. You’ll also be able to provide better advice and accurately present information to your clients.

Course Objectives

• 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 creating financial reports
• Be able to effectively track expenses and revenues by job

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

Space is limited to 6 students , so sign up today to gain valuable insight into one of the most helpful tools a Construction Professional can use in today’s market.

Cost of this course is $314+ applicable taxes for Canadian Customers Only. Course runs from 1:00 p.m. to 4:15 p.m. EST

Schedule