ES Computer Training Workshops, continuing education, sessions, accredited courses for construction, finance, insurance, business.
9/5370498.jpg9/1520251.jpg9/1514644.jpg9/4736454.jpg

Our highly effective computer training courses designed for Construction will help to guide your staff by enhancing their current skills and improving their overall productivity.

Microsoft Excel for Construction (Intermediate) - Interactive Webinar

Overview

We will demonstrate tools to help you better calculate your business metrics, profitability of jobs, and production rates, all through the use of Microsoft Excel. In this intermediate level course you will also. In this intermediate level course you will also:

  • Learn how to create simple Gantt charts and timelines in Excel.
  • Learn how to use Excel with other programs to efficiently make presentation materials from spreadsheets containing estimates and schedules
  • Discover the capacity to manipulate and analyze information (via pivot tables) to create management analysis reports.

Topics

  1. Expense Tracking
  2. Analyzing Budgets and Business Metrics
  3. Analyzing Data
    • Filters
    • Subtotals
    • Pivot Tables
  4. Project Bidding
    • Incorporating Excel spreadsheets in other documents
    • Linking and Automatic Updates
    • Precedents and Dependants
  5. Data Analysis (Production Rates, Progress Tracking, Costing)
    • Consolidating
    • Data Validation
    • If Statements
    • Vlookup
    • Conditional Formulas
    • Conditional Formatting
  6. Creating a simple Gantt Chart for a Schedule

Enrollment is limited to 6 persons to ensure that each participant receives individualized attention. This is a hands-on workshop. We will utilize screen sharing software and file sharing software to present the course and exercises. You may share your screen to get personalized assistance with your work.

Cost of this course is $299 + applicable taxes for Canadian Customers Only. Course runs from 1:00 p.m. to 4:00 p.m. Eastern Time



Schedule

Remote Workshop
Jan 30th, 2019
Interactive Webinar
Online
Register
ES Computer Training Workshops, continuing education, sessions, accredited courses for construction, finance, insurance, business.

© 2018 ES Computer Training, a division of ESCTT Inc. All Rights Reserved.