Main content

Half Day Classes

Half day classes

Building Employee Engagement and Winning Commitment

Inspiring commitment is a key to enhancing organizational efficiency and boosting employee engagement. Utilize our helpful guidebook as you develop a fresh perspective, effectively communicate with colleagues, and motivate employees towards success.

Achieving employee buy-in towards new initiatives can present significant challenges. How does leadership properly balance motivational incentives with the team’s productivity, satisfaction and/or profit objectives? Inspiring commitment is a key to success for enhancing organizational efficiency and boosting employee engagement. Utilize our helpful guidebook and action planning tools in order to develop a fresh perspective, effectively communicate with colleagues, and motivate employees towards success.

After this class, you will be able to:
  • Describe the three types of commitment and implications of each
  • Increase awareness and use of best practices for enhancing influence and motivation and mitigating resistance to change
  • Practice analyzing situations to identify the types of commitment that exist and needs to be encouraged
  • Identify barriers to commitment and change
  • Practice developing awareness and use of proactive influence tactics to gain commitment for timely and meaningful information based on a simple request

Building Teams - Building Culture

How do leaders successfully develop high-performing teams while fostering a harmonious, culturally-driven environment? Identify techniques to increase staff engagement levels, create stronger interpersonal connections, and maximize performance results.

‘Teamwork’ is a common tenet of many companies – but how do leaders successfully develop high-performing teams while fostering a harmonious, culturally-driven environment? By learning methodologies commonly utilized to assemble productive groups and acquiring the skills necessary to facilitate effective collaboration—even among virtual teams—participants in this course can increase staff engagement levels, create stronger interpersonal connections and maximize performance results.

    After completing this course, participants will be able to:
  • Describe the stages of team development, the functions at each stage, and the benefits of teaming
  • Identify the communication characteristics of high-performing teams and team members’ behavioral styles
  • Set goals successfully, and avoid common goal-setting mistakes
  • Explain how to foster accountability among team members to ensure all members succeed
  • Explore the effect of different behavioral styles on managing virtual employees
  • Develop esprit de corps and coordinate effective team-building activities

Coaching Effectively

Identify powerful coaching techniques to teach, correct, and motivate. Topics covered include building a coaching relationship, the five-step coaching plan, providing feedback, and how to avoid the demotivating effect of overcoaching.

Coaching is the one-on-one work of a manager to help employees’ efforts to improve their performance. Success in a changing business environment requires employees who are constantly learning and adapting. This course provides managers with powerful coaching techniques to teach, correct and motivate. Topics covered include following the five-step coaching plan, developing your own coaching skills, using the GROW Model for Coaching Conversations, and providing feedback.


After this class, you will be able to:
  • Define coaching
  • Follow a 5 step coaching process
  • Develop a coaching plan
  • Implement proactive coaching skills

Dealing with Difficult People

Learn to identify and handle the four most common types of difficult people and turn confrontation into constructive stepping stones to conflict resolution. Be a catalyst for changing behavior, and understand what triggers people to behave negatively.

Anyone who struggles with the aggravation, frustration, and pain of dealing with a truly difficult person will look back on this workshop with a sense of satisfaction and gratitude. Do you dread certain situations at work or in your personal life because of hostile or unresponsive encounters or feel powerless to cope with behavior that consistently leaves you depressed and defeated? Learn to identify and handle the four most common types of difficult people, turn confrontation into constructive stepping stones to conflict resolution, be a catalyst for changing difficult behavior, and understand what really triggers difficult people to behave negatively.

After this class, you will be able to:
  • Define what a difficult person is and what makes some people.
  • Identify the most common types of difficult people and strategies for dealing with them.
  • Recognize key causes of communication problems in the workplace and outline thoughtful, effective strategies for resolving them.
  • Assess their basic communication style and utilize this knowledge to communicate and address different types of people in any work situation.
  • Apply techniques for dealing with difficult people through the use of role plays and in-class action planning.

Delegating Effectively

Always wanting to 'own the process'? Explore benefits and barriers to delegation and the importance of authority and responsibility, as well as strategies and tools for implementing delegation. Leave with a four-step delegation plan ready to implement.

Delegation is the practice of turning over your tasks and/or authority to employees. Many managers struggle with delegation because of a fear of losing control or a desire to "own" the process. However, managers can accomplish more and develop their employees' skills by learning to better delegate. This course explores the benefits and barriers to delegation, the importance of authority and responsibility, as well as strategies and tools for implementing delegation. Participants leave with a four-step delegation plan to use immediately.


After this class, you will be able to:
  • Define delegating and understand its benefits to managers, employees and the organization
  • Assess current level of delegation skills and experience
  • Apply an eight-step delegation process
  • Integrate the five-levels of authority model into delegating tasks to employees
  • Practice delegation skills, using a checklist of delegation behaviors
  • Understand delegation resistance and develop appropriate strategies to overcome employee resistance

Essentials of Conflict Management

Conflict management can distinguish good workplaces from great workplaces. Analyze conflict to understand the issues and emotions involved. Explore personal conflict management style and resolve issues in a sensible, equitable, and efficient manner.

Conflict management is the practice of identifying and handling conflict in a sensible, equitable, and efficient manner. While conflict is inevitable in the workplace, the way conflict is managed can distinguish good workplaces from great workplaces. Participants will learn to analyze conflict to understand the issues and emotions involved. Then, they will learn to resolve conflict using a proven 4-step method. This course allows participants to explore their personal conflict management style and develop skills to manage conflict more effectively.

 

After this course, students will be able to:

  • Manage conflict by understanding and exploring what it is
  • Recognize all five styles of conflict.
  • Know which style of conflict is their preferred style by assessing their own personal style
  • Develop basic skills in the five styles so they can use any one of them
  • Learn to diagnose situations in order to chose the most appropriate style
  • Learn troubleshooting techniques and other skills for successful conflict resolution

Excelling at Excel: Formulas and Functions

Excel helps us perform very complex tasks using very simple built-in functions. Learn different cell references—relative, absolute/mixed, and 3-D—and begin developing formulas. Track monthly budget expenses and efficiently create organized worksheets.


Knowing how to work efficiently with Excel’s formulas and functions is a critical skill whether you are creating a monthly budget or working in complex worksheets at a Fortune 100 company.

Excel helps us perform very complex tasks using very simple built-in functions. In this course, you will learn different cell references—Relative, Absolute/Mixed, and 3-D—and use them to begin creating and using formulas. From there, you will begin introductory functions such as SUM, AVERAGE, COUNT, and TODAY to help track your monthly budget and expenses. We will discuss how to more efficiently create, copy, and organize worksheets before creating an annual budget using summary worksheets and Mixed and Absolute cell references to forecast your budget for the future.

We will also calculate loan payments, amortization, and repayment schedules using the Name Box, Name Manager, PMT, and CONCATENATE functions. Finally, we begin looking at different database functions like VLOOKUP/HLOOKUP and IF…THEN…ELSE to locate information in a workbook and avoid duplicate entries.

Audience: We designed this course for current, experienced users of Excel who want to know more about formulas and functions. This course builds on "Excelling at Excel: The FUNdamentals" and “Excelling at Excel: The 5 Fs.”

Software: We teach this course using Microsoft Excel 2016 on our lab PCs, but the content should also apply to Excel 2007, 2010, and 2013 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, participants will be able to:
  • Prepare formulas using basic, intermediate, and advance functions
  • Differentiate between cell references in Excel – Relative, Absolute/Mixed, and 3-D
  • Optimize budgeting with introductory functions including SUM, AVERAGE, COUNT, and TODAY
  • Evaluate loan repayment options using intermediate functions – PMT and CONCATENATE
  • Construct advanced functions to find and display data with VLOOKUP/HLOOKUP and IF-THEN-ELSE.

Excelling at Excel: More Formulas and Functions

Pull information from large, database-like workbooks and construct logical comparisons to make data more readable. Formulate smarter worksheets, use data validation criteria, and repackage data. Perform calculations on data meeting specific criteria.


In Part 2 of this course, we will continue to discuss VLOOKUPS/HLOOKUPS to pull together information from large, database-like workbooks. From there, we will construct logical comparisons between given and expected values using IF…THEN…ELSE statements to make data more readable.

You will discover how to formulate smarter worksheets by understanding Excel’s time format and using Date Calculations such as TODAY, YEAR, and ROUNDDOWN. Track time spent volunteering, traveling, or working by creating a worksheet that calculates the interval between time in and time out. To keep data accurate, we will also learn to use Data Validation criteria.

Using COUNTIF, SUMIF and AVERAGEIF will help us perform calculations on data meeting specific criteria to extract more meaning from our worksheets. Finally, discover how to calculate totals, averages, and counts within a database system based on certain criteria using DSUM, DAVERAGE, and DCOUNT

Audience: We designed this course for current, advanced users of Excel who want to know more about formulas and functions. This course builds on "Excelling at Excel: The FUNdamentals," “Excelling at Excel: The 5 Fs,” and “Excelling at Excel: Formulas and Functions.”

Software: We teach this course using Microsoft Excel 2016 on our lab PCs, but the content should also apply to Excel 2007, 2010, and 2013 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, participants will be able to:
  • Explain more uses of VLOOKUPS/HLOOKUPS
  • Establish criteria using Data Validation to more easily search for data
  • Measure time in hours and minutes, days, and years
  • Create multiple IF-THEN-ELSE statements for more efficient functions
  • Develop functions—COUNTIFS, SUMIFS, AVERAGEIFS, DSUM, DCOUNT, and DAVERAGE—that give results based on criteria

Excelling at Excel: The 5 Fs: Formatting, Fills, Formulas, Functions, and Filters/Sorts

Discover the 5 Fs of Excel: Formatting, Fills, Formulas, Functions, and Filters/Sorts, as well as custom formatting, creating and using fills for dates, numbers, and formulas/functions; how to use different types of functions, and filtering/sorting data.


In this half-day course, students will discover the important 5 Fs of Excel: Formatting, Fills, Formulas, Functions, and Filters/Sorts.

  1. Formatting: Using and creating custom formatting for SSNs, phone numbers, and other special types of data.
  2. Fills: Using fills for dates, numbers, formulas/functions, and how to create your fills.
  3. Functions: Using SUM, AVERAGE, COUNT, COUNTA, TODAY, CONCATENATE, and other functions.
  4. Formulas: Using Relative, Absolute/Mixed, and 3-D references
  5. Filters/Sorts: Using Excel as a database/table for filtering and sorting data.

Audience: This course is designed for those who are familiar with Excel and want to learn to perform more complex tasks and functions. This course builds on "Excelling at Excel: The FUNdamentals."

Software: This class is taught using Microsoft Excel 2016 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, you will be able to:
  • Create and use special and custom formats
  • Employ Conditional Formatting based on various criteria
  • Use AutoFill to save lists and for dates, text, numbers, and formulas and functions
  • Develop formulas and functions in Excel for tables and databases
  • Filter your information quickly for date ranges, numbers, and text lists

Excelling at Excel: The FUNdamentals

Discover tips and tricks to better navigate and select data in Excel. We'll customize Excel through our Quick Access Toolbar and learn important shortcuts to optimize workflow. Create formulas and functions the right way the first time.

In this half-day course, students will discover important shortcuts and tips and tricks in navigating and selecting data in Excel. We’ll customize Excel through our Quick Access Toolbar and important options. The course teaches formatting, using Autofill, and how to create formulas and functions the right way the first time. Finally, we will print and view Excel worksheets using Freeze and Split panes, Page Layout View, and Page Break Preview.

Audience: This course is designed for those who are new to Excel and want to learn to create and work with electronic spreadsheets.

Software: This class is taught using Microsoft Excel 2016 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, you will be able to:
  1. Increase productivity through shortcuts and the Quick Access Toolbar
  2. Create attractive worksheets with formatting
  3. Use AutoFill to save time and input for text, numbers, dates, and formulas/functions
  4. Develop formulas and functions in Excel
  5. Understand syntax of Excel’s formulas and functions
  6. Print and view Excel worksheets the right way

Improving Your Listening Skills

Identify the keys to clear communication and build more productive relationships via effective listening techniques. Learn about priorities and biases in a conversation -- including unspoken messages -- utilizing five distinct listening approaches.

Improving Your Listening Skills provides individuals with the key to clear communication through developing an understanding of effective listening techniques. This session is designed to help people understand their priorities and biases in a conversation, the unspoken messages they send to others when listening, and all of the information they might be missing without ever realizing it. Further, participants are given the practice they need to hone their skills in five distinct listening approaches and internalize the situations that call for each. And ultimately, people come away with the communication skills they need to build more synchronized, productive relationships.

Completion of a brief, online assessment prior to the course is required; to ensure timely analysis, we recommend enrolling at least 3-5 days prior to course start date.

After this course, participants will be able to:
  • Recognize the importance of developing good listening skills by reflecting on their past listening experiences
  • Discover the five different listening approaches used in communication and the specific characteristics of each approach
  • Discover their most natural listening approaches
  • Explore their strengths and challenges as listeners
  • Identify effective listening approaches and behaviors, and practice modifying their listening approaches to meet the communication needs of team members
  • Create action plans to improve their ability to communicate effectively to all team members by using different listening approaches

Leading Through Change

Great managers recognize change and help employees adjust in a realistic and strategic manner, using sound principles and workable tools. We can't control uncertainty, but we can guide, shape, and influence this variable. Learn how and why in this class.

In every organization today, regardless of size, industry or location, change is a constant. Leaders must recognize change and help their employees deal with it in a realistic and strategic manner using sound principles and workable tools. Managers must realize that people don’t resist change as much as they resist being changed. All of us respond to change differently. We don’t start at the same level, adapt at the same pace or end up in the same place. Organizational leaders don’t control change or uncertainty; rather they guide, shape and influence this variable.

After this course, you will be able to:
  • Prepare for change by conducting change analysis
  • Communicate consistently about change to engage the organization
  • Manage emotions that arise during change
  • Shrink the change to keep employees focused

Managing Diverse Behavioral Styles

DiSC allows managers to read the style, fears, goals, and needs of their employees, often removing barriers to performance. Learning to adapt management approaches to match the staff's abilities/motivations may help reduce opposition and resistance.

Once managers have a thorough understanding of themselves, they can use DiSC to help manage the people they work with. When managers are able to accurately read the DiSC style, fears, goals, and needs of their employees, they can remove barriers to performance and adjust their management approach for more productive interactions. Learning to adapt their management approach to match the abilities and motivation of employees will help reduce opposition and resistance. Learn when to most effectively use Directing, Coaching, Supporting, and Delegating approaches.

DiSC can help managers gauge the needs of their key contributors in the organization and identify any potential obstacles that may be holding them back. An understanding of the DiSC model gives managers important tools to recognize whether the employee isn't motivated or committed to the project, or whether they simply don't have the skills necessary to succeed in a particular task.

Students enrolling in this course are required to have taken either the Strategic Communications class or the Executive Presence for the Non-Executive class. Please bring your DiSC assessment completed in these previous classes with you to class for reference.


After this class, you will be able to:
  • Recognize needs of the different styles each person manages
  • Discover strategies for managing to the needs of each style
  • Analyze management situations in terms of employee willingness vs. ability
  • Create an action plan that will help increase each participants’ effectiveness with one person he/she manages

Managing Employee Performance

Effective performance management can provide managers and supervisors with a framework to monitor, discipline, and reward employees. Implement a process that addresses goal-setting, evaluations, and handling difficult conversations about job performance.

The concept of ‘performance management’ often conjures up negative thoughts for both managers and employees -- poorly-timed developmental feedback, endless paperwork, and minimal net benefit. Good news: performance management is now evolving from a one-time, backward-looking annual appraisal to a methodology emphasizing ongoing feedback and coaching. Learn how you can apply a simple model and powerful tools to drive employee engagement throughout the year, motivating staff members toward peak performance while mitigating potential legal risks. By taking these steps and utilizing best practices, the path to successfully building and retaining critical talent becomes much less stressful.


After this course, you will be able to:
  • Describe the best practices and current trends in performance management and the shift to “performance development”
  • Describe a simple performance management model that will increase employee engagement, reduce legal risks, and help people do their best work
  • Develop a plan for managing performance that will achieve desired objectives

Managing Multi-Generations

Today's workforce represents a multitude of generations -- understand similarities and differences while adopting strategies for motivation, coaching and development. Create an environment conducive to attracting and retaining staff from each generation.

With four different generations currently employed in today’s unique workforce, the resulting work environments can present tremendous challenges -- as well as the potential for great rewards. How can our management and leadership techniques bridge multiple generational divides in order to adapt and respond accordingly? In order to effectively handle these critical issues -- work ethic, the role of leadership, work/life balance, and more -- we need to better understand how the diversity of our backgrounds may have shaped varying workplace expectations. Our interactive workshop will explore these generational differences and similarities as participants develop and practice helpful techniques for better managing the wide range of ages and personalities that comprise the current labor force. After this class, you will be able to:
  • Describe common characteristics of the generations at work today and the formative events that define them
  • Determine the most effective approaches for communication with different generations
  • Custom fit their communication style to meet the challenges of generational differences


Managing Up: Forging a Successful Relationship with Your Supervisor

Recognizing the principles of managing up can help increase the chances of success for both you and your manager. Identifying your boss's needs can lead to a smoother work environment with less conflict and a more effective relationship.

The accomplishments of your manager are often more critical to your success than your own achievements. When bosses miss deadlines, ignore goals, and fail to meet expectations, those unmet obligations inevitably become yours -- and the communication between you and your manager can suffer greatly as a result. Recognizing the principles of managing up can help increase the chances of success for both you and your manager. Identifying your boss’s needs while supporting these daily obligations can lead to a smoother work environment with more positive vibes, less conflict, and ultimately an effective relationship.

After this class, you will be able to:

  • Identify and support your supervisor’s strengths, weaknesses and working style.
  • Proactively seek consistent communication and monitor results for necessary improvements.
  • Determine your supervisor’s priorities, goals and pressures.
  • Establish expectations and a clear system of organization.
  • Help to eliminate preventable problems and use effective problem solving skills to find resolutions.
  • Exhibit positive behaviors that make you an invaluable employee.

Microsoft Excel: Data Analysis Using Pivot Tables

PivotTables allow for quick and easy data view modifications while generating totals, averages and other results. We'll build different PivotTables using existing databases to obtain insights into account management, human resources, marketing, and more.


When you use Excel as a tracking system or database, you can have a tremendous amount of data in thousands of rows and hundreds of columns. Summarizing the data and reviewing key components of the worksheet can be difficult, but PivotTables can help with this information overload. If you work in an analytical role, being able to create and manipulate PivotTables is a necessary skill.

PivotTables allow you to change the view of your data quickly and easily. They also automatically sort your data and create totals, averages and other functions, too. PivotCharts add visualizations to the data summarized into a PivotTable and can help you spot trends and patterns within the data.

Students in this half-day course will build different PivotTables using existing databases to obtain insights into account management, human resources, marketing, and more. We will use sorting and filtering to help restrict our data and use PivotTables for SUM, AVERAGE, COUNT, and PERCENTAGE functions. We will also discuss the advantages and disadvantages of the new Format as a Table feature.

Audience: We designed this course for current, experienced users of Excel who are comfortable using formatting, sorting, and filtering features.

Software: We teach this course using Microsoft Excel 2016 on our lab PCs, but much of the content should also apply to Excel 2007, 2010, and 2013 for Windows. Material learned in this course may not apply to any version of Excel for Mac.

After completing this course, participants will be able to:
  • Create custom PivotTables and edit existing PivotTables
  • Use the Format as a Table feature
  • Analyze data through PivotTables
  • Increase productivity using the Report Filter Pages
  • Produce attractive and professional reports with PivotTable styles
  • Filter data interactively through slicers
  • Apply PivotTables to a wide variety of datasets
  • Incorporate custom calculations for data items and fields

Microsoft Excel: Data Management and Manipulation

Control data! We'll discuss how Excel can be used to manage and manipulate data, both in flat-file databases and relational databases. Create and import databases and tables while handling multiple sorting and filtering tasks using a variety of criteria.


Control data without data controlling you!

In this half-day course, we will discuss how Excel can be used to manage and manipulate data in Excel, both in flat file databases and relational databases. Create and import databases and tables in Excel while handling multiple sorting and filtering tasks using a variety of criteria. We will also discuss how to format tables and databases in a professional manner while using Excel’s Format as Table feature.

Discover how to retrieve the information you need quickly and easily using multiple filters and custom views. We will also employ Excel’s terrific Name Box and Name Manager features to make data clearer and easier to reference.

We will use advanced functions to repackage data into more useful forms— such as correctly formatted addresses—using the CONCATENATE function to pull data together from two or more columns. Split data using delimiters and the Text to Columns feature to deconstruct names, dates, and other data into more useful formats.

Audience: We designed this course for current, experienced users of Excel who want to know more about managing and manipulating data

Software: This class is taught using Microsoft Excel 2016 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, participants will be able to:
  • Sort and filter data using multiple criteria in order to get needed information with little effort
  • Download databases from other applications and servers
  • Create a data table or database avoiding common pitfalls
  • Format a professional and attractive table
  • Use the Name Box and Name Manager to efficiently navigate, print select, and add other functionality for your database and tables
  • Create the CONCATENATE function to bring columns together
  • Employ Text to Columns to separate data from one column into multiple columns

Project Management: Cost Tools & Techniques

Properly estimating, measuring, and communicating project costs are critical project management skills. Determine budgets and control spending using generally accepted estimating techniques and tools for capturing, measuring, and forecasting expenses.

Project costs are one of the factors that are typically used to measure a project’s success. Being able to properly estimate, measure and effectively communicate project costs is a critical success factor for a Project Manager. Cost management includes the policies, processes and procedures and utilizing them to effectively manage this important project component.

In this course, participants will learn the generally accepted industry estimating techniques and tools for capturing, measuring and forecasting project costs.

After this class, you will be able to:
  • Estimate project costs
  • Apply techniques to measure costs
  • Respond appropriately to cost variances
  • Utilize methods to control project costs

Project Management: Risk Tools & Techniques

Learn where to look for risk and how to assess impact and probability by performing quantitative risk analysis -- then use that information to create and maintain effective risk management plans to respond to and control variables.

Risk is a future event and the project manager has some luxury of time to plan and prepare for its potential eventuality. Risk can also have either a positive or negative impact on a project’s execution and proper planning is critical to properly manage risk. In this class, participants will learn where to look for risk, how to assess the impact and probability and to use that information to create and maintain an effective Risk Management Plan.

After completing this class, participants will be able to:
  • Utilize techniques to identify project Risks
  • Determine probability and impact of project Risks from qualitative and quantitative perspectives
  • Plan appropriate Risk response techniques
  • Utilize processes to monitor risks throughout a project

Project Management: Scope Tools & Techniques

Well-defined projects scopes help ensure the execution of other project elements—cost, time, and quality. Learn how to develop a clear and concise scope, define the work required, validate the deliverables, and control the scope throughout the project.

Proper scope definition is critical to ensuring success in all areas of a project. Without a well-defined scope the development and definition of all of the other project elements are left to chance (e.g. Cost, Time, Quality). During the course of the project when change occurs, scope must be maintained to ensure appropriate project integration. The Scope Management processes and procedures must also be well-defined to prevent scope creep, cost overruns and missing schedule deadlines.

In this course, participants will learn techniques to more clearly define scope and create manageable scope management processes. Also, to be able to understand the importance of working closely with project integration and change control processes.

After completing this course, participants will be able to:
  • Develop a clear and concise scope statement
  • Define the work required to complete the project scope
  • Apply techniques to validate scope deliverables
  • Use the appropriate tools to control Scope throughout a project