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

Microsoft Excel for Construction (Basic) - Part 1 - Instructor-Led Webinar

Overview

The course will teach you how to use Excel to create estimates, track expenses, calculate overruns, track production rates, and calculate material usage.

By the end of the workshop, you will be well-versed in the most widely-used functions of Excel. You’ll know how to minimize errors and misrepresentations of numerical data. You will be able to create estimates and project plans, track expenses quickly, and create summary cost reports. You’ll also be able to provide better advice and accurately present information to your clients.

Course Objectives

  • Create better, more accurate financial estimates of projects
  • Calculate and create records of production rates
  • Spend less time and effort maintaining better financial records of business expenses
  • Spend less time and effort creating financial reports
  • Be able to effectively track expenses and revenues by job

Topics

  • 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

Space is limited to 6 students , so sign up today to gain valuable insight into one of the most helpful tools a Construction Professional can use in today’s market.

Cost of this course is $299 + applicable taxes for Canadian Customers Only. Course runs from 1:00 p.m. to 4:15 p.m. EST



Schedule

Remote Workshop
Oct 28th, 2020
Instructor-Led Webinar
Online
Register
Nov 25th, 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.