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

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


Overview

Discover how to capture and link data from different files, track changes, and create simple macros. Become educated in auditing and tracking data and data validation. Understand about file security. These features save hours of manual effort and help keep numbers confidential.

Gain a better comprehension of consolidating data from disparate reports and master the ability to create, analyze, and compare budget scenarios electronically. Discover the capacity to manipulate and analyze databases via pivot tables and to create management analysis reports. Microsoft Excel is an essential tool to learn for anyone tracking data.

This seminar is delivered as a 2- three-hour instructor-led webinar or as a 1-day onsite course. Please contact us if you are interested in an onsite course.

The course covers the following topics:

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

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



    Schedule

    Remote Workshop
    Feb 26th, 2025
    Mar 5th, 2025
    Instructor-Led Webinar
    Online
    Register
    May 21st, 2025
    May 28th, 2025
    Instructor-Led Webinar
    Online
    Register
    ES Computer Training Workshops, continuing education, sessions, accredited courses for construction, finance, insurance, business.

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