ES Computer Training Workshops, continuing education, sessions, accredited courses for construction, finance, insurance, business.
9/1514644.jpg9/4736454.jpg9/5370498.jpg9/1520251.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.

Using Microsoft Excel Macros for Construction - Interactive Webinar

Overview

In this workshop, we will create a series of macros using predefined exercises. We will further develop your Excel skills by opening the session up to work on your specific category of challenges and tools. This workshop is being offered exclusively to the construction industry to ensure that the examples and problems are relevant to you and your work.

  • How to write a macro and the Developer Tab
  • Absolute vs Relative
  • Storing and Organizing Macros
  • Multiple Macro calls – keep it short and simple
  • Basic Macro commands and code to allow you to tweek the Macro without rewriting

Topics

  1. How to write a macro and the Developer Tab
  2. Absolute vs Relative
  3. Storing and Organizing Macros
  4. Multiple Macro calls – keep it short and simple
  5. Basic Macro commands and code to allow you to tweek the Macro without rewriting
    • Active Workbook.Worksheets
    • ChDir "C:\Users\......
    • SetRange Range("A1:D2099")
    • ActiveCell.Formula IF
    • ActiveWorkbook.Save
    • Dim as Variant
    • InputBox

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
Mar 1st, 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.