Microsoft Excel for Construction Management II
Building on Level I, this course focuses on using Microsoft Excel to improve construction estimating and project management processes. You’ll learn how to create tables, apply estimating-specific formulas, automate calculations, and present data clearly. By mastering these tools, you can reduce errors, save time, and improve efficiency, helping your team produce more accurate estimates and smarter project decisions.
Session 1: Delving into Data
- Creating and Using Tables
- Using estimating specific formulas
- Conditional Formatting related to estimating
- Using Data Validation within an estimate
- Protecting your workbook
Session 2: Summarizing Simplified
- Advanced formulas
- Workflow Improvement and Efficiency
- Best Practices for Presenting Data (Estimate, Schedule, Financial, etc.)
Must attend both sessions – Thursday, November 19th, 11:00 AM – 1:00 PM and Friday, November 20th, 11:00 AM – 1:00 PM
