Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Microsoft Excel for Construction (Advanced)

1 Full day broken into 2 instructor led sessions from 1:00 PM - 4:00 PM

Description

If you have ever had to make a decision based on manually tracked data, you will greatly benefit from this workshop! You will learn, by using Electronic forms you can save hours of time, giving you a better scope for decision making and improve communications between departments.

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, 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.

Topics

Learn how to use Microsoft Excel spreadsheets to model

  • Project Cost estimation
  • Scheduling (using Gantt Charts)
  • Project bidding
  • Expense tracking

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

Related Info

With this course people in the Construction Industry will learn the advanced features of Microsoft Excel which will allow you consolidate data in minutes, perform audits, present and share complex workgroup information, as well as analyze, share, and manage data enabling you to make better informed decisions, become more accessible, and boost your profitability.

Speaker

Similar courses

Responding Successfully to a Request for Proposal

Responding to a Request for Proposal successfully requires knowledge, understanding, and a proposed solution of the subject while convincing them that your company is the best suited to build their project

More Information
Construction Project Management

The information presented in this course will help you to understand what you can do to successfully administer projects and will provide you with the necessary tools to help manage a project.

More Information
First Level Construction Supervisor Program

This course offers the critical skills and concepts needed to supervise a work team in the residential and non-residential construction sectors.

More Information
Supplementaries of CCDC Contracts

This course is part of the Managing Construction Series

More Information
CCDC 5A+5B: Construction Management Keys to Success

This course is part of the Managing Construction Series

More Information
Microsoft Excel for Construction (Basic)

2 Parts - All course dates run from 1:00 p.m. - 4:00 p.m. Eastern Time

More Information
Online Bluebeam Training: Revu Basics

This two-day instructor-led series will provide you with the knowledge and skills to create, edit, markup, and collaborate on AEC documents using Bluebeam Revu.

More Information
Online Bluebeam Training: Revu Sets - The Ultimate Drawing Management Tool

This two-day training course, combined with the Hyperlinks and Managing Drawing Revisions course, provides you and your staff with the knowledge and skills to manage as-built drawings on a construction documents using Bluebleam Revu

More Information
Online Bluebeam Training: Revu Estimating Level 1

This two-day training course provides you and your staff with the knowledge and skills to scale, measure, organize take-offs and calculate on Construction documents using Bluebeam Revu

More Information
Side-Skilling - Transitioning from the Tools to the Boardroom

This 48-hour curriculum of progressive learning courses has been specifically designed and assembled to side-skill individuals identified by their employers, or on their own, to expand their knowledge including hard skill and soft skill training designed in the context of Canadian construction and design sectors

More Information
Project Delivery Methods (DBB, CM, DB, IPD, P3)

This course is part of the Managing Construction Series.

More Information
Estimating 101 - Introduction to Construction Estimating

To ensure project success, contractors must be able to provide accurate and professional estimates of costing and materials.

More Information
Closeout of a Construction Project

Participants will be introduced to best practices and “tips and tricks” which will expedite and simplify the takeover of a project by its Owner from the Contractor, who managed the construction, so that the last 3% of the project is not 15% of the effort.

More Information
Choosing the Right Project Delivery Method to Maximize Your Investment in Construction

Identify the key decisions that need to be made in different circumstances to optimize project delivery

More Information
The Top Habits of High Performing Foremen

Foremen are the drivers of project success, and this course covers in-depth the top habits of the most effective foremen.

More Information
Change Order Pricing and Best Management Practices

Based on years of research and practical knowledge, gain the tools and information to correctly price and effectively manage change orders

More Information
CCDC 14+15 – Managing the Uniqueness of Design Build

This course is part of the Managing Construction Series

More Information
LEAN Boot Camp

This interactive six hour session will include an introduction to LEAN management principles and the Last Planner Scheduling System.

More Information
Field Scheduling 101

Who does what when in the field?

More Information
Field Productivity 101

Lead towards efficiency and start seeing improvements to your bottom line

More Information
Earned Value Management (EVM) for Construction

When it comes to cost and schedule on your construction projects, do you know where you’re at and where you’re going?

More Information
Preparing for the Next Labour Inspection

The OHSA authorizes inspectors to conduct unannounced inspections at any time. Are you prepared?

More Information
Overview of Ministry of Labour Inspections

Now that the inspector has arrived, how should you react?

More Information
Workplace Accident Aftermath

The nature of the accident or incident and the type of workplace will impact your obligations.

More Information
Compliance with Prompt Payment to Avoid Adjudication in Ontario

This 3 hour on-line LIVE course will walk attendees through all of the logistics of compliance

More Information
The Art of Construction Management

Consider this course a carefully curated cheat sheet to help you conquer the multifaceted world of construction management

More Information
Project Planning, Scheduling & Control

This course will boost both the “soft” skills and the technical skills you need to successfully plan and schedule construction projects, as well as manage time, cost, and productivity

More Information
Construction Leadership 101

Success is knowing your purpose in life; growing to your maximum potential; sowing the seeds that benefit others.

More Information
Mental Health First Aid – Standard (Virtual)

Participants who take this course are well prepared to interact confidently about mental health with their family, friends, communities, and workplaces.

More Information
LFR: Leading For Results

Are you struggling with your current workforce or perhaps seeking a different way to connect with your team?

More Information
Power Skills for Hard Job Sites

Go behind the scenes, and discover tools and resources for improving your negotiation, and communication skills

More Information
Fundamentals of Construction Contract Administration for Contract Administrators

While the contract serves the central role to manage outcomes, many tasks require the administrators to work together efficiently to avoid causing delays or to settle challenges that may arise throughout the project

More Information
The Importance of Project Commercial Management & Contract Administration

Get a better understanding of how claims arise and how to manage, mitigate and/or avoid them with proper Contract Administration and Execution

More Information
Navigating Construction Contracts: Demystifying CCDC 9A & 9B

Equip yourself with the essential knowledge and practical skills required to navigate, complete, and confidently handle CCDC 9A and B

More Information
Leading in a Hybrid World

empower construction industry leaders with the essential knowledge and skills required to effectively lead teams in a hybrid work environment

More Information
Pass it On: Building Bridges of Expertise

Empower the Next Generation of Construction Professional

More Information
Low Carbon Training Program for Construction Professionals

This program is aimed at upskilling building professionals, including architects, engineers, contractors, and owners and operators, to accelerate the adoption of low-carbon practices, reduce emissions, and contribute to Canada’s Climate Action Plan and Just Transition

More Information

Press enter to see more results