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