Microsoft Excel 2019 – Part 2
2026-09-18 07:00 - 16:00 (America/Phoenix) | Virtual
Microsoft Excel 2019 – Part 2
ONLINE
New Horizons Computer Learning Center
Friday, September 18, 2026
8:00 a.m. – 4:00 p.m. MST
Member: Free
Non-Member: $299
This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2019: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. This course is designed for students who already have foundational knowledge and skills in Excel 2019 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data. To ensure success, students should have completed Microsoft® Office Excel® 2019: Part 1 or have the equivalent knowledge and experience. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level. Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will: Work with functions. Work with lists. Analyze data. Visualize data with charts. Use PivotTables and PivotCharts. The final stop, Excel 2019 Part 3 is just around the corner!

Strategic Negotiation Workshop: Negotiating Techniques for Project Managers
2026-09-30 07:00 - 14:00 | Livestream
Strategic Negotiation Workshop: Negotiating Techniques for Project Managers
LIVESTREAM
John Koontz
Wednesday, September 30, 2026
7:00 a.m. – 2:00 p.m. MST
Member: Free
Non-Member: $179
Who should attend: This course is intended for experienced Project Managers with more than 5 years of experience.
This workshop-based class is specific to the role of a project manager in the mechanical contracting industry and is designed to help mid-level to senior project managers develop their overall project negotiating abilities. This class is created to be a follow-up to the class titled “Negotiating: Basic Negotiating Skills for PM’s”. After a short remedial lecture which re-acquaints the class with the basic concepts and principles of negotiating, participants will be divided into groups to engage in simulated negotiations with predefined objectives. Most of the class will focus on role-playing simulations. After each roleplay, participants will receive structured feedback on their performance and strategies for improvement. Examples of real-life scenarios could include, but will not be limited to: supplier delivery problems, subcontractor performance and/or payment issues, change order negotiation with a client, schedule compression or acceleration negotiation with a GC and/or CM, payment and/or non-payment issues, issues between you and your foreman and other labor and performance related issues, etc.

Foreman Training 5: Project Documentation: The Field Leaders Role/ Managing Our Subcontractors – The Field Leaders Role
2026-10-01 07:00 - 14:00 | Livestream
Foreman Training 5: Project Documentation: The Field Leaders Role/Managing Our Subcontractors – The Field Leaders Role
LIVESTREAM
John Koontz
Thursday, October 1, 2026
7:00 a.m. – 2:00 p.m. MST
Member: Free
Non-Member: $179
This class will specifically examine the Field Leaders role in creating an ongoing written “first-hand account” of all significant project events that is clear, accurate, and complete. When done well, the Field Leader will provide their contractor with a powerful and nearly indisputable historical account of the project. The steps for planning and implementing the documentation process for a mechanical construction project will be reviewed and methods for improving the process will be discussed. The instructor will provide guidance, best practices, and expertise in the areas of Contractual Notice, Foreman Daily Logs, Photographs and Videos, Meeting Minutes, Follow-up Emails, Change Management, Field Authorization, Schedule Issues, Weather, Professionalism, Material Deliveries, etc.
Subcontractors represent a significant portion of most mechanical contracts, and the performance of our subcontractors is a direct reflection of our own performance in the eyes of an owner, construction manager, or general contractor. On most projects, especially smaller and midsize projects, the field leader becomes so focused on crew leadership, material expediting, and work planning for our self-performed work that the performance and progress of our subcontractors’ work is often overlooked until problems arise. The field leaders focused, and effective daily on-site management of subcontractors is necessary to prevent unforeseen problems and ensure project success. In this session the instructor will provide attendees with an understanding of the importance of developing trust-based relationships with subcontractors and will provide methods and best practices for successful subcontractor management.

Project Management 8: Effective Project Documentation: Managing Risk
2026-10-02 07:00 - 14:00 | Livestream
Project Management 8: Effective Project Documentation: Managing Risk
LIVESTREAM
John Koontz
Friday, October 2, 2026
7:00 a.m. – 2:00 p.m. MST
Member: Free
Non-Member: $179
This class focuses on the critical role that documentation plays in managing risk, protecting productivity and profitability, and supporting successful project outcomes. Attendees will learn what to document, when to document it, and how to create clear, professional records that fulfill both practical and contractual requirements. The class emphasizes timely cause-and-effect documentation—linking actions, events, and impacts—as a key tool in avoiding disputes, supporting claims, and maintaining control throughout the project. Attendees will also gain a solid understanding of how to identify and comply with documentation requirements found in construction contracts, including notice provisions, recordkeeping expectations, change order management, and communication standards. Topics include RFIs, keeping a journal, change order documentation, delay notices, meeting minutes, daily logs, photographs and videos, and follow-up emails. In addition, the instructor will stress the importance of open and continuous communication between the project manager and the field leader (foreman), ensuring that information from the field is documented accurately and timely. Through real-world examples and proven best practices, this class will help project managers develop consistent documentation practices that reduce risk, improve communication, maintain positive relationships, and strengthen project execution.

Suicide Prevention VitalCog/Mental Health First Aid
2026-10-07 07:00 - 14:00 | Livestream
Suicide Prevention VitalCog/Mental Health First Aid
LIVESTREAM
Omar Galindo/Rebecca Medaris
Wednesday, October 7, 2026
7:00 a.m. – 2:00 p.m. MST
Member: Free
Non-Member: $179
This combined training integrates VitalCog’s proactive approach to suicide prevention with the practical skills of Mental Health First Aid, equipping participants to recognize and respond to mental health challenges in the workplace. VitalCog focuses on identifying early warning signs of suicide and promoting a culture of awareness, early intervention, and support. Just as organizations work to reduce physical health risks through prevention, this training emphasizes how promoting mental health and encouraging early action can help reduce suicide in the workplace. Participants will engage in meaningful dialogue around mental health challenges, strengthening their ability to recognize risk factors and take appropriate action. Building on this foundation, the Mental Health First Aid component provides practical, hands-on tools to respond effectively when someone is experiencing a mental health concern or crisis. Similar to traditional first aid, participants will learn how to assess situations, approach individuals with care, listen without judgment, and connect them to appropriate resources and professional support. By combining awareness with action, this training builds confidence in addressing sensitive situations calmly and effectively. Participants will leave with a deeper understanding of workplace mental health, along with the skills needed to support others, encourage help-seeking, and contribute to a safer, more supportive work environment.

Microsoft Excel 2019 – Part 3
2026-10-08 08:00 - 16:00 | Virtual
Microsoft Excel 2019 – Part 3
ONLINE
New Horizons Computer Learning Center Thursday, October 8, 2026
8:00 a.m. – 4:00 p.m. MST
Member: Free
Non-Member: $299
his course builds upon the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2019: Part 1 and Microsoft® Office Excel® 2019: Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates. This course is intended for students who are experienced Excel 2019 users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets. To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel 2019. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment.

Bluebeam – INTERMEDIATE
2026-10-09 07:00 - 14:30 | Virtual
Bluebeam – INTERMEDIATE
ONLINE
Christopher Suggs
Friday, October 9, 2026
7:00 a.m. – 2:30 p.m. MST Member: Free
Non-Member: $299
PLEASE NOTE: Instructor will be using Revu 21. To follow along, please make sure you have any of the following versions of Bluebeam:
Revu 20 (Standard, CAD, eXtreme)
Revu 21 (Core, Complete)
In this session, we’ll get under the hood of Revu to get a deeper understanding of every-day tools as well as building custom content. Agenda will include:
Interface, Navigation, & Profiles (In Depth): Toolbars & Menus, Panel Access Bar & Panel Management,
Profiles & Profile Management, Standardizing Profiles, Opening a PDF, PDF Navigation
Markup Tools: Types of Markup Tools, Customizing the Properties of Markup Tools, Using the Snapshot Tool
Stamps: Applying a Stamp, Creating Custom Stamps
Tool Chest: Basics of the Tool Chest, Custom Tool Sets, Creating Legends, Adjusting & Updating Legends

HVAC 101 for Non-Technical Employees
2026-10-22 07:00 - 14:00 | Livestream
HVAC 101 for Non-Technical Employees
LIVESTREAM
Brad Perkins
Thursday, October 22, 2026
7:00 a.m. – 2:00 p.m. MST
Member: Free
Non-Member: $179
This seminar offers an introduction to HVAC (Heating, Ventilation, and Air Conditioning) systems, focusing on their importance in creating an optimal environment for building occupants. Key topics include system design principles, mechanical equipment, piping materials, and construction requirements. Participants will examine plans and specifications used in project illustrations and learn about the commissioning process. Learning Objectives:
• Define basic HVAC industry terminology.
• Recognize different HVAC equipment and systems and understand their functions.
• Describe common heating methods for rooms or facilities.
• Identify fundamental components of air conditioning systems.

Plumbing 101 for Non-Technical Employees
2026-10-23 07:00 - 14:00 | Livestream
Plumbing 101 for Non-Technical Employees
LIVESTREAM
Brad Perkins
Friday, October 23, 2026
7:00 a.m. – 2:00 p.m. MST
Member: Free
Non-Member: $179
This introductory course provides a practical overview of plumbing systems commonly used in mechanical construction, designed specifically for non-technical professionals seeking a clearer understanding of how these systems function and are applied in the field.
Participants will explore the fundamentals of domestic water distribution, including pipe sizing, system layout, and key components such as backflow preventers, booster pumps, and pressure considerations. The course will also cover sanitary systems, including pipe sizing, slope requirements, and the role of lift stations in effective wastewater management.
In addition, attendees will gain insight into specialized systems and equipment such as oil and sand interceptors, grease traps, and kitchen plumbing systems. The training will also introduce core concepts related to hydronic systems, including primary and secondary distribution for chilled water and boiler systems, as well as pump operation, pump curves, and cavitation.
The course will further examine water heating technologies, including traditional, tankless, and condensing water heaters, with an emphasis on system layout for energy efficiency. Important safety and performance considerations—such as hot water delivery temperatures, scalding prevention, and Legionella risk—will also be discussed, along with the role of hot water recirculation systems. By the end of the course, participants will have a well-rounded foundational understanding of plumbing systems, enabling them to better interpret plans, communicate with technical teams, and contribute more effectively to project discussions.

Foreman Training 6: Essential People Management Skills for Field Leaders
2026-10-29 07:00 - 14:00 | Livestream
Foreman Training 6: Essential People Management Skills for Field Leaders
LIVESTREAM
Field Leadership Academy
John Koontz
Thursday, October 29, 2026
7:00 a.m. – 2:00 p.m. MST
Member: Free
Non-Member: $179
Successful journeymen with unique abilities, but with little or no management training, are frequently promoted to “foreman” and then lead crews of workers on mechanical projects. This class is meant to be that “initial management training”. People management skills are crucial for a construction foreman because they directly impact the efficiency, safety, and morale of the team, ensuring that a project progresses smoothly. The Field Leader interacts daily with subcontractors, other trades, and stakeholders and when they learn the basics and then work hard to become better “people managers”, they’ll have more successful projects and fewer stressful days. In this session the class will explore and discuss the basic people management skills that are relative to the position of jobsite foreman. In addition, the instructor will explain and emphasize those essential traits, skills, and behaviors that allow a foreman to more effectively manage their crews, their subcontractors, other trades, and their customers.

Project Management 9: Change Order Management: Best Practices
2026-10-30 07:00 - 14:00 | Livestream
Project Management 9: Change Order Management: Best Practices
LIVESTREAM
John Koontz
Friday, October 30, 2026
7:00 a.m. – 2:00 p.m. MST
Member: Free
Non-Member: $179
This class provides mechanical project managers with the knowledge, tools, and strategies needed to manage change orders effectively – safeguarding profitability, preserving leverage, and maintaining strong customer relationships in an ever-changing project environment. While changes are inevitable, poor change management can quickly erode margins, disrupt efficiency, delay progress, spark disputes, and damage reputations. The instructor will examine the most common causes and types of project changes, emphasizing the critical need to establish a clear baseline of scope, schedule, conditions, and budget at the start of the project. Participants will develop practical skills for identifying change conditions, issuing timely and contract-compliant notices, documenting impacts, and negotiating fair, accurate pricing. This course also covers key contract requirements, the differences between private and government work, and the serious risks of performing T&M work based on direction from unauthorized personnel representing the GC, CM, or Owner. Additionally, the instructor will stress that successful change order management relies heavily on the open and consistent communication between the project manager and the field leader (foreman). To reinforce key lessons, the class will include a short workshop segment where participants will review and discuss several realistic change order scenarios drawn from actual project experiences.

Bluebeam – ADVANCED
2026-11-06 08:00 - 15:30 | Virtual
Bluebeam – ADVANCED
ONLINE
Christopher Suggs
Friday, November 6, 2026
8:00 a.m. – 3:30 p.m. MST Member: Free
Non-Member: $299
LEASE NOTE: Instructor will be using Revu 21. To follow along, please make sure you have any of the following versions of Bluebeam:
Revu 20 (Standard, CAD, eXtreme)
Revu 21 (Core, Complete)
This last session will focus on advanced tools and workflows for extracting data and collaborating in the cloud. Agenda will include:
Markups List: Organizing, Sorting, & Filtering, Statuses, Custom Columns, Importing & Exporting,
Custom Formulas, Quantity Link & Excel Templates
Revisions: Inserting Sheets & Batch Insert, Sets, Overlaying Sheets & Batch Overlay, Document
Comparison, Updating a Takeoff
Introduction to Studio: Sessions vs. Projects, Getting into Studio
Studio Sessions: Setting up a New Session, Live Session Participation, Record Reports, Closing out a Studio Session
Studio Projects: Setting up a New Project, Inviting Attendees & Setting Permissions, Working with

AI For Project Managers
2026-11-12 08:00 - 15:00 | Livestream
AI For Project Managers
LIVESTREAM
Chris Carr
November 12, 2026
8:00 a.m. – 3:00 p.m. MST
Member: Free
Non-Member: $229
Specialized AI training for Estimators and Project Managers enhances accuracy in project estimation, boosts operational efficiency, and optimizes project management practices.
This course will cover:
• AI-powered analysis for identifying schedule delays and conflicts
• Forecasting workforce needs using AI-driven labor modeling
• AI-assisted tracking of material lead times and procurement delays
• Smart takeoffs and estimating with historical labor and material cost benchmarks
• Predictive budgeting and early detection of cost overruns
• Contract review with AI for risk clauses and change orders
• Change order comparison with cost impact summaries
• AI-enhanced submittal and RFI workflows
• Consistent generation of reports and documentation using AI

AI for HR & Administrators
2026-11-12 08:00 - 15:00 | Livestream
AI for HR & Administrators
LIVESTREAM
Chris Carr
November 12, 2026
8:00 a.m. – 3:00 p.m. MST
Member: Free
Non-Member: $229
This program, AI for Administration & HR 101: Practical Foundations, is designed to equip HR and administrative professionals with the knowledge and tools needed to confidently integrate artificial intelligence into their daily work and long-term strategy.
This course will cover:
• Strategic AI Foundations for HR
• Risk, Governance & Responsible Adoption
• AI-Enabled Talent Strategy
• Practical HR Productivity Gains
• Workforce & Organizational Transformation
• Hands-On Implementation Roadmap

Collaboration Skills at Work
2026-12-04 08:00 - 15:00 | Livestream
Collaboration Skills at Work
LIVESTREAM
Dianne Young
Friday, December 4, 2026
8:00 a.m. – 3:00 p.m. MST
Members: Free
Non-Member: $179
Effective collaboration is essential for organizational success. This course helps participants develop the skills needed to work productively with others, build trust, and achieve shared goals. Participants will learn how to communicate effectively, navigate team dynamics, and leverage diverse perspectives to improve outcomes. Includes: Key principles of effective teamwork and collaboration, Techniques for improving communication within teams, Strategies for resolving conflict and building trust, How to leverage diverse perspectives for better results.
