Cost tracking, job tracking, production rates, schedules, estimates: If you would like to create spreadsheets to make this work easy and consistent, then this course is for you. Learn to create spreadsheets for cost tracking, calculating production rates and creating estimates. We will show you how to create spreadsheets that can be used by co-workers and that are robust and secure.
Is running or analyzing a business or individual jobs important for you? We 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).
Laptops, software, and manuals will be provided.
Format: One day (8 hours) of in-class instruction
The course is designed for anyone in the construction industry who works with numerical data. Microsoft Excel is an essential tool to learn for anyone tracking data.
Anne Leroux, P.Eng. is a founding partner of ES Computer Training and Technologies, ESCTT Inc. A graduate of the University of Waterloo, Anne is a professional engineer with over 25 years experience in construction, engineering and project management. Anne possesses prolific experience in the field and as a consultant. She has been responsible for the development and implementation of numerous software programs used in the construction and architectural industries. Established in 1992, ESCTT Inc. provides computer infrastructure services to businesses in various industry verticals. Products/ventures have included risk management software for construction, business intelligence software, thin client data systems and distributed workforce software.
Greg Leroux has been a leading financial strategist, consultant and instructor to the construction industry since 2008, Greg Leroux has become an authority on getting construction firms to maximize their productivity through the use of information technology. Greg is not only an expert with standard construction software, but has been a key developer of the Risk Managment application - RiskMP. Greg has worked closely with construction companies throughout Canada, lending his practical, results-driven approach to ensure success.
This course has been accredited by the Canadian Construction Association (CCA) for one (1) credit towards Gold Seal certification for in-class attendance.
Fee Includes: Student manual, digital certificate upon completion, complimentary Wi-Fi access, lunch and free parking.
Cancellation & Substitution Policy: Payment is non-refundable for cancellations made within 5 business days of the course, or non-attendance on the day. Complimentary substitution of another member of your company is accepted.
If VRCA has to postpone or cancel courses due to insufficient enrolment, VRCA will refund the registration fee or, if possible, the attendee may choose to move to an identical session in the future.