By offering classroom education and online classes, SMACNA Greater Chicago keeps their contractor members on top of all they need to know to thrive in the industry. A list of classroom opportunities is available on the SMACNA Greater Chicago calendar. We are continually adding educational opportunities in a variety of formats including industry related workshops and lunch and learns, so check back often so you don’t miss an added update.
In Part 1 of this two-part series we will learn the best way to manage lists of information in Excel. After formatting the list as a table, we will expand our knowledge of making our list more usable. Some formulas that are commonly used with data lists will be explained.
Using influence to motivate others to accomplish something will go a lot further than getting something done by setting tasks that need to be completed. Someone in a position of authority will most assuredly get the task completed, but it may not be done from a sincere desire to do the best job. The truly effective individual contributors, managers and executives use influence skills to achieve results, regardless of their positional power within their organization.
Mechanical blueprint reading is an essential skill for managing projects, overseeing subcontractors, drafting contracts and RFIs, reviewing scope letters, pricing, negotiating change orders, estimating costs and managing risks.
After mastering how to work with a formatted table, we’ll take the next step by learning how to create reports from a table. This session will explain how to create a formatted table that will easily set filters and display subtotals based on those filters. Students will also learn to build dynamic Pivot table reports.
Word has some built-in features to help eliminate the stress of formatting a document. With this session, you will learn how to save blocks of text, navigate through large documents more quickly, create columns in under a minute, tricks behind setting tabs, inserting Excel workbooks and more.
In today’s competitive business arena, effective communication skills are a must! Professionals must be able to concisely and clearly express their thoughts to diverse audiences in a variety of different ways.
Part 2 is designed to expand on the knowledge and lessons learned from the first session. By the end, participants will become more comfortable and efficient using Word.