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

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

  • Advanced
      1. Project Forms for Estimating, Costing
        • Industry Best Practices for Creating Professional Forms
        • Developing “what if” analysis for estimates and project plans
      2. File Security
        • Locking Cells
        • Protecting Worksheets
        • Protecting Data
      3. Creating Forms (Estimate Sheets, Production Calculations)
        • Data Validation
        • If Statements
        • Date Functions
        • LookUps (Vlookup, Match, Hlookup, Index)
      4. Helping Users
        • Comments
        • Naming
      5. Project Bidding
        • Incorporating Excel spreadsheets in other documents
        • Linking and Automatic Updates
        • Precedents and dependents
        • Auditing/Verifying information
  • Macros
    • How to write a macro and the Developer Tab
    • Absolute vs Relative references when recording Macros
    • Storing and Organizing Macros
    • Editing recorded macros with VBA
    • VBA code fundamentals

    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 + applicable taxes for Canadian Customers Only. Course runs from 1:00 p.m. to 4:15 p.m. Eastern Time



    Schedule

    Remote Workshop
    Sep 30th, 2020
    Oct 7th, 2020
    Instructor-Led Webinar
    Online
    Register
    Nov 12th, 2020
    Nov 18th, 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.