![](/images/products/large/705180.jpg)
Exploring Excel: Fantastic Filtering Techniques
David H Ringstrom
90 Min
Product Id: 705180
Microsoft Excel has powerful tools that can be used to quickly tame large sets of data. This training session will help attendees discover techniques that can simplify and format data according to your audience.
![](/images/products/large/705166.jpg)
Evaluating, Selecting, and Contracting for Compensation/Payroll/HR (HRIS)/Benefits/Consultants/Software
Rob J Thurston
60 Min
Product Id: 705166
This training program will take a closer at human resources administration and benefits administration. It will help attendees evaluate and find quality services, determine whether Software as a Service (SAAS), cloud-based or onsite implementation is best for your needs, and detail best practices to do a cost-benefit analysis.
![](/images/products/large/705150.jpg)
Advanced Excel Charting Skills Using Spinners, Sliders, Check Boxes, Other ActiveX Tools That Turn You Into a Guru
Joe Weil
100 Min
Product Id: 705150
This Excel training program will help attendees create interactive, dynamic Excel Charts helpful for financial modeling and dashboards. It will also help build Excel Charts to save time and eliminate manual input. Attendees will learn Excel Lookup functions, understand how to use INDEX and MATCH to retrieve data and chart with multiple criteria, learn how to use Excel dynamic named ranges with tables for chart automation, and more.
![](/images/products/large/705118.jpg)
Key Payroll Practices for 2017
Vicki M. Lambert
90 Min
Product Id: 705118
This webinar will discuss 4 key payroll practices that will be crucial to the department in 2017. These practices will increase efficiency, cut costs, prevent fines and penalties for errors and help the department identify areas to focus on for improvement in 2017 and beyond. The training session will address other payroll essentials such as why it isn’t just Forms W-2 that are being scrutinized by the IRS - it is also fringe benefits and all tax practices.
![](/images/products/large/704462.jpg)
Withholding Computations for Unusual Circumstances to avoid under withheld Tax Penalties
Patrick A Haggerty
90 Min
Product Id: 704462
In this training program, participants will learn how to compute the correct or target annual withholding to avoid underwithheld tax penalties, understand how to test employer designed withholding methods for compliance with IRS requirements, and learn to compute withholding using the four alternative methods provided by the IRS.
![](/images/products/large/705144.jpg)
Preparing for Mediation, Arbitration, Fact-Finding
Matthew W Burr
60 Min
Product Id: 705144
This training program will define and discuss mediation, arbitration and fact-finding. It will enumerate best practices to prepare for the process, checklist of areas to remember, key considerations such as evidence and witnesses, and essential questions to ask.
![](/images/products/large/705066.jpg)
Putting the Quality in Audit Reports
Jonnie T Keith
90 Min
Product Id: 705066
The objective of any report is to provide important information to management in the area reviewed. It represents the end result of weeks of reviews, analyses, interviews and discussions. The quality of that report will have an impact on how well the report is understood and accepted. This training program will review the audit standards related to audit report quality and encourage attendees to participate in various quality report exercises.
![](/images/products/large/705035.jpg)
Audits: Dealing with the Agencies and Conducting Your Own
Vicki M. Lambert
90 Min
Product Id: 705035
This training program will discuss what to do when you receive communications from the IRS and also what to do when doing business with other federal, state and local regulatory agencies and lawmaking bodies. It will also explain how to conduct internal audits of the payroll department to pre-emptively uncover issues of non-compliance that could be extremely costly if found by official audits from regulating agencies. Additionally, best practices in performing audits for fraud will also be covered.
![](/images/products/large/705062.jpg)
Final Updates on Exempt vs Nonexempt Classifications and More
David Sanders
90 Min
Product Id: 705062
This training program will help attendees comprehend revised rules regarding exempt vs nonexempt classifications starting December 1, 2016. Attendees will learn how the automatic updates starting in 2020 will affect companies. The webinar will also define primary duties, suffer or permit, working time and compensable hours and distinguish between discretionary payments and non-discretionary payments in calculating overtime.
![](/images/products/large/705080.jpg)
FLSA Overtime Rule Injunction vs. Future
Matthew W Burr
60 Min
Product Id: 705080
The webinar will overview the injunction on the FLSA overtime rule. It will offer attendees an understanding of the effect it can have on their organization and discuss the implications of the change.
![](/images/products/large/703948.jpg)
Interview Questions and Pre-Employment Screening What Every Employer Needs to Know - Title VII, ADA/ADAAA, PDL, GINA, I-9s and Affirmative Action
Janette Levey Frisch
120 Min
Product Id: 703948
This training program will offer an overview of anti-discrimination laws and affirmative action issued for federal contractors; illegal and ill-advised interview questions; pre-employment tests (skills, strength, medical tests) use of social media, criminal background checks; and more.
![](/images/products/large/705071.jpg)
NYS Department of Labor Proposed Salary Increases
Matthew W Burr
60 Min
Product Id: 705071
With the overtime changes in New York State, this training program will discuss areas in New York State where the change will take effect. It will also discuss future changes to the rate and potential federal changes to the overtime rule.
![](/images/products/large/705058.jpg)
Effective Discipline and Lawsuit-Proof Termination: How to Remedy Performance and Conduct Problems While Minimizing Your Legal Risks
Susan Fahey Desmond
90 Min
Product Id: 705058
This training program will elucidate effective documentation techniques. It will discuss what documentation is needed to justify a termination decision and key record retention requirements. Attendees will learn how to fill out a performance appraisal and understand the essentials of a document retention program.
![](/images/products/large/704965.jpg)
Overview of Penalties for Different OSHA Violations in 2017
Michael Aust
60 Min
Product Id: 704965
This training program addresses the increase in OSHA penalties. The new penalties took effect August 2, 2016. Any citations issued by OSHA on or after this date will be subject to the new penalties if the related violations occurred after November 2, 2015.
![](/images/products/large/704182.jpg)
Let's Get Back to Basics: Withholding, Depositing and Reporting Federal Taxes
Vicki M. Lambert
90 Min
Product Id: 704182
This webinar will cover the basics of withholding, depositing, paying and reporting payroll taxes. It will provide a good solid foundation for the payroll beginner or an excellent refresher course for the seasoned professional.
![](/images/products/large/703780.jpg)
What Employers Need to Know About Severance Arrangements - EEOC, ACA and ERISA
Janette Levey Frisch
90 Min
Product Id: 703780
This webinar will highlight the importance of effectively handling severance pay and agreements. It will discuss several frequently asked questions on employee termination, severance pay, severance agreements, and ERISA laws.
![](/images/products/large/704987.jpg)
Interviewing and Hiring the Right People
Catherine Mattice Zundel
75 Min
Product Id: 704987
This training program will cover the interviewing and hiring process in six steps: understanding the organization’s culture, conducting a job analysis, developing behavior-based interview questions, recruitment strategies, interviewing and selection, and HR onboarding.
![](/images/products/large/704976.jpg)
Sexual Harassment in the Age of Social Media - Investigation, Assessment & Prevention Strategies
U Harold Levy
60 Min
Product Id: 704976
Given the ease of receiving and viewing sexually explicit materials on cell phones, computers and social media, employers as well as employees should be concerned about preventing sexual harassment in the workplace. This workshop will focus on the issue of sexual harassment and how to prevent it in the workplace. It will provide an overview of sexual harassment, sex discrimination, its definition and the laws that prohibit it.
![](/images/products/large/705037.jpg)
Employment and Labor Laws With Respect to Social Networking: Understanding the Cause and Effect Relationship
Susan Fahey Desmond
90 Min
Product Id: 705037
Every company will find at some point that it will have a problem that arises from an employee’s use of social networking sites. This training program will discuss the legal implications behind improper handling of social networking issues at the workplace, the standpoint of regulatory agencies, and drafting policies to address these concerns.
![](/images/products/large/705040.jpg)
Getting the Best from Your Performance Appraisal
Meloney Sallie Dosunmu
90 Min
Product Id: 705040
This training program will describe the key components of a performance management system. It will also highlight key strategies for engaging employees in the success of the business and discuss developing measurable performance goals.