Lookup formulas are far superior to manually searching for specific data elements in a spreadsheet. VLOOKUP, HLOOKUP, INDEX and MATCH are some of the most well-known (and most useful) functions in Excel which are used to return data from other locations in worksheets. If you handle large amounts of data in Excel, this webinar will help you tremendously. Objectives of the Presentation Recognize when and why a lookup function is better than a di...

Many companies today do not take advantage of the selection science that is available to them to make sure that the people they hire into particular job roles have a high probability of success. You can save significant costs and add to your organization’s bottom line by properly using proven screening tools and other attraction and selection practices. Learn how to improve your selection and hiring practices so you don’t suffer fr...

How do we manage projects and customer relationships effectively? How do we understand the full scope of a customer "project"? How do we assemble the necessary resources to effectively manage a customer relationship and attendant projects? To whom do we delegate specific responsibilities and when? These are among a number of questions we discuss and about which we learn as we strive to effectively manage projects and the customers whose projec...

The failure to maintain adequate and sufficient timekeeping records under the Fair Labor Standards Act (FLSA) can result in a substantial back pay award. Under the FLSA, the burden is on the employer to maintain and preserve such records. If this burden is not properly met, courts will accept as evidence of overtime worked information provided by the employee, whose recollections about the number of hours worked will undoubtedly be much more g...

Today's 24/7, "always on" world often cycles between "do more with less" downsizing and ever faster upgrading and can even appear to be spinning out of control. How do you harness the problem-solving support, resiliency and creativity in your work team. Are you ready to cultivate communication and conflict resolution skills that affirm your integrity and also set appropriate boundaries while being collaborative and compassionate.Learn key psyc...

General Carl von Clausewitz defined friction as "…the force that makes the apparently easy so difficult," and "countless minor incidents… combine to lower the general level of performance, so that one always falls short of the intended goal." Friction is why, in civilian occupations, organizational performance often falls short of plans, and for no obvious reason. Variation is a form of friction that, among other things, generate...

Use a SmartArt graphic if you want to do any of the following: » Create an organization chart or Excel sparkline charts » Show hierarchy, such as a decision tree » Illustrate steps or stages in a process or workflow » Show the flow of a process, procedure, or other event » List information Use a chart if you want to do any of the following: » Create a bar chart or column chart » Create a line or XY sca...

Engagement, motivation and job satisfaction are inextricably linked. Understanding the difference between intrinsic and extrinsic motivators is key to being able to create engagement and job satisfaction with your staff. People are more motivated by individual internal factors than external. Learn how to identify the unique motivators for each person. Why Should You Attend Are you Disheartened when you see staff who are just going through the...

The health-related dangers of COVID-19 are obvious but the good news is that diligent compliance with the recommended countermeasures, especially social distancing, can end the outbreak very quickly. The consequences of noncompliance are however equally obvious. Force majeure interruptions of supply chains have exposed the risks associated with complex international supply chains, and China has threatened overtly to cut off supplies of rare ea...

Maintaining order while managing long-distance teams and employees can often raise plenty of issues. This training program will help determine the fastest way to get a poorly performing location up to speed and offer attendees pointers on how to quickly and accurately check the quality of products or services at any location. It will also discuss ideal frequency for site visits, and best ways to approach a site problem without alienating anyon...