Events

 

Loading Events

« All Events

Microsoft Excel for Construction Scheduling & Estimating (4 Sessions)

October 15 @ 11:30 am - 1:30 pm

$200.00

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.

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 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.

Note: Instructor will be using the latest version of Microsoft Excel and students are encouraged to use same.

Recording: Registrants for this course will receive access to a recording of each session for 7 consecutive days. Access will start the next business day after the session ends.

Must attend all four sessions.

Session 1: Excel Overview and Basics Oct 15th

  • 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 Oct 22nd

  • 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 Oct 29th

  • 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 Nov 5th

  • Advanced formulas
  • Workflow Improvement & Efficiency
  • Best Practices for Presenting Data (Estimate, Schedule, Financial, etc.)

Details

Date:
October 15
Time:
11:30 am - 1:30 pm
Cost:
$200.00
Event Categories:
, ,

Organizer

Amy Aldred
Phone
610-279-6666
Email
aaldred@abceastpa.org

Venue

Online

Cancellation Policy: Registration is financially binding unless cancelled 1 week prior to the date of the class/event.
Read ABC East's Payment and Refund Policy

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Registration
$ 200.00
Unlimited

News & Resources

Events

LOCATIONS
  • ABC Suburban Philadelphia Office
  • ABC Lehigh Valley Office & Training Center
  • ABC Philadelphia Office & Training Center
  • ABC Northeast Pennsylvania Office