Microsoft Excel – Advanced* June 17 & June 24
June 24 @ 1:00 pm - 4:00 pm
Excel for Construction *Advanced *
(1:00pm-4:00pm/ 2 sessions)
Please join ESCTT Training for a practical, hands‑on course on using Microsoft EXCEL – Advanced
ESCTT will demonstrate tools to help you better calculate your business metrics, profitability of jobs, plan budgets and examine business scenarios all through the use of Microsoft Excel. This advanced level course will give you a better comprehension of how to analyze data to create what-if scenarios (what if conditions changes…. how will these affect the cost of the job).
Topics Covered
Project Estimating & Job Costing
- Industry best practices for Creating Professional Estimates
- What‑if analysis for project planning
Scheduling & Planning
- Creating Gantt charts and timelines
- Linking schedules with estimates
Data Analysis & Reporting
- Pivot tables and filters
- Data validation
- Multi‑scenario analysis
- Management and profitability reports
Expense Tracking & Budgets
- Tracking job and business expenses
- Analyzing budgets and business metrics
Excel Integration & Presentation
- Linking Excel with Word and other programs
- Automatic updates and auditing information
- Creating presentation-ready materials
Security & Collaboration
- Locking cells and protecting worksheets
- Securing data for shared use
(2 Gold Seal Credits )