ES Computer Training Workshops, continuing education, sessions, accredited courses for construction, finance, insurance, business.
9/4736454.jpg9/1514644.jpg9/1520251.jpg9/5370498.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 (Basic) - 2 Part Instructor-Led Webinar

Gold Seal has accredited this course for 1 Special Industry Credit (SIC)


This seminar is delivered in 2 three hours instructor-led webinars covering the following topics:

Overview

Topics

  • Basic - Part 1
    • Structuring a basic estimate table
    • Formulas
    • Filling a series with formulas
    • Sum totals
    • Formatting
    • Simple Graphics
    • Linking to Word/PowerPoint
    • Print Layouts
    • Templating
    • Recovering Unsaved Files
    • Duplicating Sheets
    • Internal linking
    • Date Functions And Scheduling
    • Custom Lists
    • Data Aggregation With Filters/Subtotals/Sumif
    • Advanced Formulas
    • Conditional Logic and IF statements
  • Basic – Part 2
      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 $448. Course runs from 1:00 p.m. to 4:15 p.m. Eastern Time



      Schedule

      Remote Workshop
      Oct 14th, 2020
      Oct 21st, 2020
      Instructor-Led Webinar
      Online
      Register
      Oct 28th, 2020
      Nov 4th, 2020
      Instructor-Led Webinar
      Online
      Register
    ES Computer Training Workshops, continuing education, sessions, accredited courses for construction, finance, insurance, business.

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