CPMCA ONLINE TRAINING

Online courses are available free of charge to members only and can be taken at any time. You will need internet access and your username and password to log into the training. If you do not have your password information, you can receive it by calling CPMCA at 213.417.9177. To find out how to become a member, please click here: Membership Information

Select the appropriate link to run a Training Module

	Retro-Commissioning ~ NEW 2013 ~ by Chris Philbrick
Online Course - Can be taken at any time. You will need internet access to take this course. Retro-Commissioning is a commissioning process applied to existing buildings that have never been commissioned. It is a systematic, documented process that identifies low-cost operations and maintenance improvements in existing buildings and brings the building up to the design intentions of its current usage. Retro-commissioning assures that the mechanical systems are optimally integrated and perform together as efficiently as possible. Retro-commissioning's primary focus is on using O&M tune-up activities and diagnostic testing to optimize the building systems. This course will outline the process and phases of RCx: planning, investigation, implementations, measurement and verification. Chris Philbrick will cover a typical project that has moved through the retro-commissioning process and will include a summary of cost and savings for multiple projects. Typical low cost measure will be discussed as well as how the retro-commissioning process relates to LEED EB credits.

	Workplace Violence ~ NEW! 2013 ~ by Rick Maltz
Workplace violence is a leading liability to employers, but can be prevented with proper on-the-job measures. This webcast helps employers understand the impact of workplace violence, explains what Red Flag indicators to look for, and review best practices for developing a Workplace Violence Prevention program.

	Mechanical Estimating Techniques ~ By Keith Rahn
If you can expertly estimate the cost of a construction project you have the edge in the bidding process. Keith Rahn will teach you how to analyze contract documents and estimate more accurately than your competition. Keith's techniques will give you the tools you need to win the bid and establish long-term trusted relationships with your customers.

	BIM 101 ~ By Dwayne Lindsey
There is simply no easier way to learn about BIM (Building Information Modeling) than viewing this easy to understand webcast. You will learn exactly what BIM is and why it�s good for your industry in a non-technical way.

	Active Listening ~ By Mark Matteson
Active Listening is vital in today's business environment. In this webcast, you will learn from Mark Matteson the 4 steps to Active Listening and how to apply them in everyday business communication with your customers. According to Mark Matteson, the 4 steps to active listening are: Listen active and with intention Pause 3 - 5 seconds before responding Question for clarification Paraphrase Incorporating these 4 basic steps into your customer relations will improve your effectiveness and increase your sales with your customers

	Excel: Insert Excel Sheet into Word ~ By Ginnie Floraday
You can incorporate an Excel workbook into your Word document. You have the choice of linking to the actual Excel sheet or brining in a static copy of the worksheet. If you link to the original file it is called embedding. If changes are made to the original selection they will appear in the copied text within Word. A static copy will not transfer any of the changes back to the spreadsheet.

	Excel: Solver Procedure ~ By Ginnie Floraday
This webcast will show you how to use the Solver function in Excel to streamline formulas in spreadsheets. Solver allows you to calculate a formula backwards. Participants will learn how to change the value of a cell that is dependent on a formula. An example of the application of this function is budgets. After setting individual projections within each department, a department total is generated for each department. If you know that a certain department cannot exceed a certain amount, the Solver can modify the individual numbers that impact the total. All you have to do is identify what the total should be, and Solver will modify any of the related cells.

	Excel: Summarizing Data with Subtotals in Excel ~ By Ginnie Floraday
When the data is in list form, Microsoft Excel can calculate and insert subtotals in a worksheet. When you specify the items you want to create subtotals for, the values to be summarized, and the functions to use on the values, Microsoft Excel outlines the worksheet so that you can show or hide as much detail as you need. If you have summarized data by using formulas that contain functions such as SUM, Microsoft can automatically outline the data.

	Going Green - Valuable Opportunities for Mechanical Contractors ~ By Jeff Grossberg
Jeff Grossberg will inform member contractors about the growing demand of sustainable technology. Grossberg encourages contractors to become leaders, rather than followers, and offers guidance on how contractors can grow their business and garner market share by entering the green building marketplace.

Green Building: LEED Certification and Sustainable Design ~ By Lincoln Pearce

Part 1
Part 2

Once considered a passing fad, green building has driven its roots deep into the American landscape. City Halls in Chicago and Atlanta have green rooftops and green building initiatives are thriving in Los Angeles, Seattle, Denver, Dallas and other major cities nationwide. Even the United Nations headquarters in New York will be renovated with green principles in mind.

	Green Building: LEED Certification "So You Want to be a Green Contractor" ~ By Dan Bulley
Learn what it takes to become a green contractor with Dan Bulley.

	Microsoft Office 2007 Excel ~ By Ginnie Floraday
This webcast will give an overview to the updated version of Excel including improvements to Pivot tables, Filters and advanced formatting.

	Microsoft Office 2007 Overview ~ By Ginnie Floraday
This webcast will give an overview to the updated versions of Excel, Word, PowerPoint and Outlook. Some of the new features to be reviewed will be the Ribbon (the replacement for the toolbar), the Mini Toolbar, document Themes and Quick Styles in Word. Excel enhancements include improvements to Pivot tables, Filters and advanced formatting.

	Microsoft Word Fill-In Forms - Build a Word document with Fields ~ By Ginnie Floraday
A form is a structured document with spaces reserved for entering information. You design the form, and others can fill it in on paper or in Microsoft Word.

PowerPoint: Introduction to PowerPoint 2007 ~ By Ginnie Floraday

Part 1
Part 2

This webcast will provide an overview to the updated version of PowerPoint. This training is in two parts so please start with Introduction to PowerPoint Part 1 then proceed to Part 2.

	Water Efficiency and How It Relates to Green Building ~ By Jim Allen
Seventy percent of the Earth's surface is water...and yet only 3 percent is fresh water, and 57 percent of that fresh water is frozen in polar ice caps and glaciers. Only 1 percent of the Earth's water is available for human consumption - and the green building movement is working to conserve that vital, limited supply. This online course will inform member contractors about the importance of water conservation, as well as ways to improve water efficiency in a building project. The online course covers how different industries use water and provides an overview of national conservation initiatives. Upcoming technologies and emerging trends to conserve water are also discussed.