Multi-Course

Microsoft Excel for Construction Scheduling & Estimating

This course is designed to transform your estimating templates and introduce you to the power of quick, efficient Gantt scheduling using Excel.

Multi-Course
February 8, 2024 (Thu) to
February 29, 2024 (Thu)
Virtual Training

Are you ready to elevate your Microsoft Excel skills and revolutionize your construction project management?

Discover the vital formulas that empower estimating teams, leading to sharper bids, reduced errors, and automated processes that save both time and resources. In just minutes, Project Managers and Superintendents can craft detailed schedules and calculate workloads with unprecedented speed and precision.

Level: Intermediate

Course Outline:

Session 1: Mastering the Essentials, February 8, 2024, 10 am to 12 pm PT

  • Get acquainted with Excel’s functions & user interface
  • Explore and load ready-to-use templates from Microsoft
  • Navigate through Excel like a pro
  • Dive into formulas, number types, and cell notes & comments
  • Master techniques like freezing cells, printing, and setting up headers

Session 2: The Art of Functions and Formulas, February 15, 2024, 10 am to 12 pm PT

  • Employ scheduling-specific formulas for maximum efficiency
  • Implement conditional formatting for date-sensitive tasks
  • Enhance schedules with data validation tools
  • Craft your own Gantt Chart in Excel

Session 3: Data Deep Dive, February 22, 2024, 10 am to 12 pm PT

  • Create and utilize powerful tables
  • Apply estimating-specific formulas for accurate projections
  • Utilize conditional formatting and data validation in estimates
  • Safeguard your work by protecting your workbook

Session 4: Strategy & Summarization, February 29, 2024, 10 am to 12 pm PT

  • Advance your skills with complex formulas
  • Learn workflow improvement techniques and efficiency hacks
  • Adopt best practices for presenting various data types, including estimates and financial reports

Embark on a journey to become adept in using Excel for all your construction scheduling and estimating needs. Join us for a transformative experience where numbers meet efficiency.

Looking for other courses?

Custom Courses

AGC offers customized trainings to member companies based on their needs and priorities. Past custom courses have included Lien Construction Law, Blueprint Reading, and more. Request your custom training course today!

2024 Legacy Sponsors