Microsoft Excel for Construction Scheduling & Estimating

$225 per person (in the US and Canada)

Have you ever wanted to improve your estimating templates in Microsoft Excel? Would you like to be able to quickly create and view a simple Gannt schedule? Using Excel, you can do that and much more. Learning specific Excel formulas that assist the Estimating team can result in more accurate bids, less human error, and provide automation – all of which save time and money. Project Managers and Superintendents can create a schedule in just a few minutes and calculate working loads/durations in seconds.

ZenTek Consultants, a nationally recognized Construction Consulting expert and Microsoft Partner, will show you the most effective ways of using Excel in a construction environment. This eight (8) hour program is delivered in four (4), two-hour long sessions that students can attend online, right from their own desk. A live instructor will explain the detailed functions, and address questions as the class progresses.

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

Recording: Registrants for this 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.

Must attend all four sessions.

Session 1: Excel Overview and Basics

  • Review the functions & interface within Excel
  • Loading templates from Microsoft
  • Navigating Excel
  • Formulas, Number Types
  • Adding Notes & Comments to Cells
  • Freezing Cells, Printing, and Headers

Session 2: Fun with Functions and Formulas

  • Using scheduling specific formulas
  • Conditional Formatting related to dates & scheduling
  • Using Data Validation within a schedule
  • Developing a Gantt Chart within Excel

Session 3: Delving into Data

  • Creating & Using Tables
  • Using estimating specific formulas
  • Conditional Formatting related to estimating
  • Using Data Validation within an estimate
  • Protecting your workbook

Session 4: Summarizing Simplified

  • Advanced formulas
  • Workflow Improvement & Efficiency
  • Best Practices for Presenting Data (Estimate, Schedule, Financial, etc.)

Upcoming Live Class

Live class not available or can’t make the scheduled dates? Fill out the Training Waitlist form and we’ll contact you when the class is available.

Custom/Private Training

We also offer this training for individual firms who want to arrange a group session at a time that’s convenient for them. Group rates are available. Contact us to schedule a group session.