Microsoft Excel – Basic ( 2 parts)
May 27 @ 1:00 pm - 4:00 pm
Excel for Construction (Basic) Webinar
(costs, tracking, lists, schedules, estimates, production rates)
(2 Gold Seal Special Industry Credit (SIC)
Do you calculate production rates? Keep track of costs or budgets? Excel makes these tasks easy, and it gives you a record of all your calculations (unlike your calculator). Excel makes it easy to verify your work and enter changes. Construction professionals will use Excel to create estimates, track expenses, monitor production rates, and manage job-based financial performance.
Topics Covered
- Basic Excel spreadsheets for estimating
- Numerical calculations and formulas
- Creating simple estimates and budgets
- Charts and basic reporting
- Integrating Excel data into Word documents
- Calculating production and material usage rates
Expense & Job Tracking
- Expense tracking and overtime calculations
- Job and equipment record-keeping
- Subtotals by job or location
- Filters and IF statements for analysis
- Linking multiple workbooks for job tracking
Analysis & Reporting
- Year-over-year comparisons
- Formatting and conditional formatting
- Linking and exporting reports