Special Topics & Webinars

 
Special Topics are held on a demand basis and may be canceled due to low enrollment.

Special Topics Registration
Call Mona Zink at 330-244-3508 between 8 a.m. - 5 p.m.


SPECIAL TOPIC: EXCELLING AT EXCEL
Facilitator - Ted Younessi
Thursday, July 13, 2017
8:30 a.m. - 4:30 p.m.
$295

Everyone is familiar with Excel, but how many actually “know” Excel? This course is designed to help beginning and avid users learn new tips and features in Excel. Participants will:

Become familiar with spreadsheet terminology and the fundamental concepts of Microsoft Excel (including identifying Excel window components, navigating worksheets, and downloading templates) 
Learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats
Learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns
Learn how to use simple functions, and how to easily apply formatting techniques to worksheet data
Create and modify charts, and work with graphics
Learn how to review workbooks for spelling errors, modify page setup, and print worksheets.
This course focuses on the skills “real users” need to be productive immediately in Microsoft Excel. Our instructor is great at modifying the training to best suit “participant needs,” so participants can ask plenty of questions and get the answers they need.


SPECIAL TOPIC: ADVANCED EXCEL
Facilitator - Ted Younessi
Thursday, Aug. 10, 2017
8:30 a.m. - 4:30 p.m.
$295

They will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, participants will learn about data validation, and using advanced data filtering. Participants will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables and PivotCharts, export and import data, and query external databases. Participants will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, they will run and record macros, and explore VBA code.


WEBINAR: KNOWLEDGE MANAGEMENT
Facilitator - Edwin K. Morris
Wednesday, Aug. 16, 2017
10:00 a.m. - 11:00 a.m. 
Complimentary

What is knowledge management? As a force for organizational empowerment it is essential. We welcome you to the future through a discussion on how knowledge management can integrate into your organization's mission and operations to enable a sustainable knowledge resource. This intellectual capacity designs the foundation of many industries. Join the conversation and let us find the knowledge ecosystem together.

REGISTER HERE


SPECIAL TOPIC: PREPARING FOR THE ISO TRANSITION
Facilitators - Larry Bridges and Dan Nicol
Thursday, Aug. 31, 2017
7:30 a.m. - 10:00 a.m.
Complimentary

The ISO transition period is now. Are you ready for September 2018? Join us for a free, informational breakfast seminar. Hear from our ISO subject matter experts as they walk you through the changes required and provide helpful guidance for a successful transition.

AGENDA
7:30 - 8 a.m. Registration | Breakfast | Networking
8:00 - 9:15 a.m. Presentation
- New Direction of the ISO 9001:2015 Standard
- Key Changes to the Standard and Tips for Implementation
- Guidance for Continual Improvement and Best Practices: Lean and ISO 9001
9:15 - 9:30 a.m. Question & Answer Session
9:30 - 10:00 a.m. Final Remarks & Networking

REGISTER HERE


SPECIAL TOPIC: PMP EXAM PREPARATION
Facilitator - Loretta Harland
Monday, Sept. 25 through Friday, Sept. 29, 2017
8:30 a.m. - 4:30 p.m.
$1,725

The PMP Exam Preparation Course provides students with the all knowledge they need to pass the Project Management Institute’s (PMI)® PMP (Project Management Professional) certification exam. This course includes five days of instructor led intense focus as well as practice exams, quizzes, quick reference guides, and all the necessary materials and post-class support for passing the exam. 

  • Learn about the exam and what it takes to apply for it 
  • Save time by studying only the materials necessary for passing the exam
  • Rely on quick reference materials to enable learning
  • Acquire tools and techniques you can apply in the real world 
  • Test your knowledge throughout the course with practice exams​

SPECIAL TOPIC: SUPERVISORY BOOT CAMP
Facilitator - Faith Sheaffer-Polen
Friday, Oct. 27, 2017
8:30 a.m. - 4:30 p.m.
$345

Do your first-time and front-line supervisors have the skills and training they need to be successful in their new roles? This full-day Supervisory Boot Camp can help. Participants will:

  • Learn the five basic management functions and three critical skills needed to succeed
  • Receive clarification of their new role and the new responsibilities and accountabilities to their team, peers, managers, and organization
  • Complete a SWOT analysis for the organization and for their team
  • Identify how a supervisor must think, what they must say, and how they must behave
  • Review Federal and State Employment Laws and how they impact a supervisor's daily work

SPECIAL TOPIC: CRUCIAL SKILLS FOR CREW LEADERS
Facilitator – Diane Helbig
Tuesday, Nov. 7, 2017
8:30 a.m. - 12:30 p.m.
$195.00

Crew leaders succeed when they have a system they can implement on a consistent basis to ensure performance and productivity are realized. Three aspects of crew leadership – goals, empowerment, and communication – work in harmony to ensure not only shift success, but company success. Crew Leaders will learn how the goals of the company and the goals of the workers intersect as well as how to communicate in ways that engage commitment of the crew. Participants will:

  • Learn how company, department and individual goals support each other
  • Discover the impact of communication styles including tone, words, and intention
  • Determine the best way to get the crew to buy-in to a performance plan on a daily basis
  • Leave with a plan they can implement and monitor for effectiveness

SPECIAL TOPIC: 10 Ways to Enhance Morale without Spending a Cent
Facilitator - Mike Lehr
Tuesday, Feb. 20, 2018
8:30 a.m. - 12:30 p.m.
$295

Do your first-time and front-line supervisors have the skills and training they need to rev up employee engagement; to create, build and leverage relationships? This intense half-day work shop will help them do all this without the company needing to spend a single cent. And numerous research studies indicate that an engaged, enthusiastic team member is less likely to leave.  Participants will:

  • See how ten morale building tips work into their typical work day
  • Create a plan to apply these tips at work 
  • Use well-proven listening skills to build and leverage relationships to get things done 
  • Identify positive, intrinsic talents in their team members
  • Learn how to effect behavioral change
  • Gain confidence in dealing with conflict and other high-anxiety employee situations