BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//ABC Eastern PA Chapter - ECPv6.15.12.2//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:ABC Eastern PA Chapter
X-ORIGINAL-URL:https://abceastpa.org
X-WR-CALDESC:Events for ABC Eastern PA Chapter
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20230312T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20231105T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20240310T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20241103T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20240508T093000
DTEND;TZID=America/New_York:20240508T103000
DTSTAMP:20260404T070146
CREATED:20240426T150849Z
LAST-MODIFIED:20240502T121711Z
UID:33156-1715160600-1715164200@abceastpa.org
SUMMARY:Microsoft Excel for Construction Scheduling & Estimating (4 Week Class)
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 Gannt 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. \nZenTek 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 eight (8) hour program is delivered in four (4)\, two-hour long sessions that students can attend online\, right from their own desk. A live instructor will explain the detailed functions\, and address questions as the class progresses. \nNote: Instructor will be using the latest version of Microsoft Excel and students are encouraged to use same. \nRecording: Registrants for this course will receive access to a recording of each session for 7 consecutive hours. Access will start the next business day after the session ends. \nMust attend all four sessions. \nSession 1: Excel Overview and Basics \n\nReview the functions & interface within Excel\nLoading templates from Microsoft\nNavigating Excel\nFormulas\, Number Types\nAdding Notes & Comments to Cells\nFreezing Cells\, Printing\, and Headers\n\nSession 2: Fun with Functions and Formulas \n\nUsing scheduling specific formulas\nConditional Formatting related to dates & scheduling\nUsing Data Validation within a schedule\nDeveloping a Gantt Chart within Excel\n\nSession 3: Delving into Data \n\nCreating & Using Tables\nUsing estimating specific formulas\nConditional Formatting related to estimating\nUsing Data Validation within an estimate\nProtecting your workbook\n\nSession 4: Summarizing Simplified \n\nAdvanced formulas\nWorkflow Improvement & Efficiency\nBest Practices for Presenting Data (Estimate\, Schedule\, Financial\, etc.)\n\nSessions will be held May 8th\, 15th\, 22nd & 29th
URL:https://abceastpa.org/event/microsoft-excel-for-construction-scheduling-estimating-4-week-class/
CATEGORIES:Classes,Management Education,Online Training
ORGANIZER;CN="Amy McCafferty":MAILTO:amccafferty@abceastpa.org
END:VEVENT
END:VCALENDAR