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.

Note: Instructor will be using the latest version of Microsoft Excel and students are encouraged to use same.

Recording: Registrants for a course will receive access to a recording of each session for 7 consecutive days. Access will start the next business day after the session ends.

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.)