Microsoft Excel for Construction Scheduling & Estimating: Full Course
Write your awesome label here.
Course Description
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 Gantt 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 course is delivered in four (4) sessions.
Course Curriculum
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.)
Please note that this course uses Microsoft Excel.
PLEASE READ BEFORE PURCHASE:
- Course is available for viewing for 168 consecutive hours (7 consecutive days) after purchase.
- Once purchase is made, NO REFUNDS will be given.
- Purchase is for one user only. Use for multiple persons can be arranged by contacting us.
- Please read the full Terms and Conditions.
Created with
