Date and Time Sept 18, 2024 8:00 AM - 4:00 PM MDT
Location Virtual Instructor Led Training
Your Presenter Perry Educational Services
Cost $350.00+GST for LCA Members
Description: Microsoft Excel for Construction
The ability to produce cost estimates efficiently and accurately is a critical step in many construction career paths, and a high-demand skill throughout the construction industry. Computer software has become a popular tool for estimating, and Microsoft Excel is the most widely used option. In this one-day course, learn how to produce your estimates more quickly and accurately by harnessing the power of Microsoft Excel.
This one-day workshop covers:
• Use Excel formulas for typical construction estimating tasks
• Create takeoff sheets for use as templates
• Learn handy shortcuts to streamline estimating
• Link information in worksheets and workbooks
• Accurately calculate profit, overhead, markups, and taxes
• Generate graphs to visually display work product
• Use features such as VLOOKUP and HLOOKUP
• Create Pivot Tables and Pivot Charts to quickly analyze and visualize information
• Explore formulas such as COUNTIF and SUMIF
Who should attend? This course is for anyone who uses (or is considering using) Microsoft Excel for Construction Estimating. Whether you’re a novice or experienced Excel user, you’ll get practice using basic and extended features of Excel for a variety of typical estimating tasks. This course is for Contractors and Sub-Contractors in all segments of the Construction Industry.
Canadian Construction Association Gold Seal Certification Program
This course is a CCA Gold Seal Certified Course (1 Credit)
Duration – 1 Day – 7 Hours
Please email admin@lethconst.ca to register for this course.