It’s confusing isn’t it? How are we supposed to keep it all straight when there are times when the legal requirements of both FMLA and the ADAAA are similar, yet at other times one law contradicts another? We find that we can’t comply with both laws at the same time, so which one takes precedence over the other? And where does WC come in? To complicate matters even more, WC is a state law, while FMLA and ADAAA are federal laws, and there are other state civil rights laws that also impact FMLA and the ADAAA. Consider that an injury under WC may also be a “serious health condition” under FMLA. State laws may differ from federal laws by covering additional health conditions, may apply to small organizations, or may cover situations in which the federal laws have no say such as domestic abuse.
This program is directed primarily at compensation and HR professionals or individuals responsible for designing and implementing compensation programs or for leaders interested in having a better understanding of compensation systems.
The OFCCP’s updated sex discrimination guidelines, called the Final Rule, “Discrimination on the Basis of Sex”, clarifies the connection between Title VII Civil Rights law, and OFCCP”S regulations. The Final Rule, according to OFCCP’s Fact Sheet, facilitates contractors’ understanding and compliance with Title VII, which results in a possible reduction in contractor costs as well as an increase in labor-market efficiency. The Final Rule is necessary to ensure contractors are consistent with today’s workplace culture and challenges. It prohibits contractors and subcontractors from discriminating against employees and applicants based on their religion, race, color, national origin, sex, sexual orientation, and gender identity (protected classes). The Rule makes clear that discrimination of the protected classes includes issues related to hiring, promotions, recruitment, job assignments, training, benefits, pay, and discipline, as well as harassment.
Do you work with "Big Data"? Do you import and manipulate large datasets in Excel? If so you’ll already be familiar with the limitations of Excel. Power Query, (known as Get and Transform in Excel 2016) is designed to get you past these limitations, allowing you to import and work with 1-million-plus-row datasets from virtually any source.
Power Query / Get and Transform can save you a ton of time when working with imported data. In many cases when you get data from external sources, it needs work on it before it can be used. Although this can be done using Excel functionality, Power Query / Get and Transform is a lot faster, can handle much more data, and is repeatable with a couple of clicks.
This webinar provides specific and useable tools for conducting stay interviews in your company. The core of the toolkit is actual interview questions in ten key areas. This process leads to a plan of action that increases the probability of retaining valuable employees. The Retention Toolkit gets at the source of the problem and allows managers and employees to work collaboratively to create realistic plan of action.
The pressing issue is that avoidable employee turnover costs companies billions and that retention interviews offer a viable solution for managing turnover risk.
Diversity and Inclusion must be embedded into the fabric of the organization; it must become part of the organization’s strategic plan. In addition, part of the implementation process includes incorporating diversity and inclusion performance objectives within each employee and manager’s performance objectives. We’ll discuss the issue of training and the role it needs to play in the diversity and inclusions as well as how to engage middle managers—who are already stressed with too much work and too little time. And finally, once the strategy has been designed and implemented, what metrics need to be used to measure the success of your organization’s strategy.
Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If the answer is "Yes", it’s time to learn how to create a macro.
In this session you will learn how to create and edit macros, create macros that can be re-used across multiple files and create macros that run automatically based on an event such as opening or closing a file.
You'll learn how to create a macro the easy way by using the built-in macro recorder. You'll then progress on to learn how to make simple changes to a macro using the built-in programming language called VBA.
This webinar provides a specific and simple model for improving interview success that leads to reduced turnover and increased retention. Participants will also learn to use behavioral interviewing to tap into potential integrity problems.
Booking forms, sales order forms, invoices, loan agreement forms and surveys. These are just a few examples of forms that can be created using Excel (although the list of examples is endless).
By adding a splash of colour, cell protection and some drop-down lists and simple validation, you can create user-friendly forms that will make data entry simple and error free for yourself, your colleagues and your clients.
If you’ve ever had to enter and edit data into a table in Excel, you’ve probably found it to be a long-winded, repetitive and frustrating experience. Excel forms will help to take that pain away!
By following the real-world examples, in this training session you will learn how to build professional, eye-catching form-driven applications and spreadsheets.