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

This course is worth 2 Gold Seal Credits

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

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

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

More Information

This course is part of the Managing Construction Series

More Information

This course is part of the Managing Construction Series

More Information

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

More Information

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

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

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

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

This course is part of the Managing Construction Series.

More Information

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

More Information

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

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

More Information

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

More Information

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

More Information

Gain a comprehensive approach to managing risk within the construction industry

More Information

This course is part of the Managing Construction Series

More Information

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

More Information

Who does what when in the field?

More Information

Lead towards efficiency and start seeing improvements to your bottom line

More Information

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

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

More Information

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

More Information

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

More Information

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

More Information

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

More Information

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

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

More Information

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

More Information

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

More Information

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

More Information

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

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

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

More Information

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

More Information

Empower the Next Generation of Construction Professional

More Information

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

In this workshop, we will introduce you to MS Teams highly collaborative work environment and discover how to leverage these collaboration tools to maximize your team's productivity.

More Information

Is your Inbox out of control? Have important tasks been falling through the cracks? Do you find yourself spending too much time looking for things?

More Information

You can’t market effectively without having a plan that looks at all factors

More Information

If you’ve been showing up to networking events but not getting any leads or new business, it’s time to up your networking game

More Information