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

Microsoft Excel for Construction (Basic)

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


Overview

Do you work with numerical data? Are you interested in reducing the time it takes to produce reports based on that data? If you answered yes to either of these questions, then you will find great benefit in taking this engaging course.

During this course you will learn the tools to help you to better understand your business performance, examine profitability of various jobs and business areas, plan budgets and examine business scenarios all through the use of Microsoft Excel. We will show you how you can simplify the presentation and analysis of complex data.

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

This seminar covering the following topics:

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

      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
      Jun 19th, 2024
      Jun 26th, 2024
      Instructor-Led Webinar
      Online
      Register
      Jul 10th, 2024
      Jul 15th, 2024
      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.