Excel provides the ability to connect a cell to data entered into another cell. A linked cell behaves as if it actually contains the data in the original cell. A reference that refers to the same cell or range on multiple sheets is called a 3-D reference. A 3-D reference is a useful and convenient way to reference several worksheets that follow the same pattern while cells on each worksheet contain the same..
The coronavirus epidemic's disruption of complex international supply chains, along with threats by the Chinese government to intentionally disable U.S. supply chains by withholding vital inputs (references appear below), underscores the need to restore American manufacturing as rapidly as possible. Elimination of wastes including but not limited to the cost of poor quality will support and encourage reshor..
This webinar is not a typical writing webinar. We will not be taking old findings, issues, or reports and rewriting them. Instead, we will be sharing with participants the writing disciplines necessary to develop their own style and provide impactful written communications. We will discuss how to be insightful without inciting negative reactions. We will also discuss the value of a “thought document” that c..
We must first come up with a conclusive, simple and easy to understand definition for Leadership. One good definition that I like is this: “Leadership is the ability to entice others to want to follow you!”Followers have to want to follow their leaders, which means leading by fear, intimidation, formal power, coercive power, or even reward power are not indicative of Leadership. True leaders are to use legi..
Each year, healthcare organizations are finding that cell phones are more essential than ever before for maximizing employee efficiency and patient connectedness. Join our live webinar to understand how you and your organization can employ cell phones for increased efficiency without leaving your team exposed to legal risk. In this webinar, we willDiscuss the OCR increase in HIPAA enforcementReview the ways..
More and more the US government is issuing detailed guidance to companies conducting international business on how to comply with the complex web of regulations that govern that business. Sometimes that guidance is provided in the context of regulations or informed compliance publications. Other times guidance is embedded within reports of US government enforcement action.Whatever the source, this guidance ..
The IRS has released a new version of the Form W-4 for determining employee tax withholdings. This new form is required for use by any new hire after January 1, 2020, and for any current employee with an old W-4 on file but who wants to update their withholding in 2020 or beyond. Unless existing employees want to change their withholding, they can continue to keep their old-version Form W-4 on file. This me..
The Web is an increasingly important resource in many aspects of life: education, employment, government, commerce, health care, recreation, and more. It is essential that the Web be accessible to provide equal access and equal opportunity to people with diverse abilities. The Web offers the possibility of unprecedented access to information and interaction for many people with disabilities. The accessibili..
To win in sales you must understand the process of selling fully, and master key components of the process. Two of these components are the sales presentation and the sales cycle. The sales presentation is where you make the value, qualities, and benefits of your product or service known to the prospect. There are various ways to present to the prospect, some formal, and some informal, but certain informati..
Multiple functions within a company interact with customers to generate, deliver, and secure payment for orders of products and services. The understanding of their company’s strategy in engaging the marketplace and its procedures for doing so will vary widely unless they are well articulated. Usually, different departments will have different views of the company’s market strategy and its approach to imple..
Paying employees is one of the biggest expenses for a company. Any company that has employees is required to withhold and pay payroll taxes. In addition to what you withhold from an employee, there are taxes that you as an employer must pay. The size of your business, where you are located, where your employees live and work; all of these things factor into what you must withhold from employee’s wages and w..
How Newly-Enforced US Import Restrictions on Forced Labor/Child Labor/NK Labor Made Products Can Affect You and Your Shipments to the United States
US Customs has the power to seize and detain goods that it suspects are the product of child labor, forced labor or North Korean contract labor working outside that country, the latter earning much needed foreign exchange for the Kim regime to evade US prohibitions on American entities doing business with that country. Certain foreign products are listed by the US Government as more likely to have been prod..
Learn the general steps a state government agency undertakes to conduct investigations into misconduct in health care practice with a focus on undercover investigations of various health care practitioners. Cover the differences between civil and criminal investigations with the differing goals of each, and understand how criminal rights span both kinds of investigations.Investigations either exonerate or i..
HACCP - How to Create a HACCP-Concept Including COVID19 Disease Related Requirements and How to Deal with CP's and CCP’s?
The HACCP methodology as risk management methodology is mandatory for pharma and food manufacturing and quality assurance. A quality assurance department needs to create and maintenance HACCP files documentation and find and define the check points (CP) and critical check points (CCP) in material flow from goods in control over the manufacturing steps until the final goods storage. which is mandatory for ph..
Despite best efforts, serious quality issues resulting in the recall can occur. Medical Device companies need to be prepared in advance to handle a difficult situation. This webinar will prepare you to understand the signals that trigger a need to recall, the investigation and other actions required, taking corrective and preventive action, and notifications to customers and regulatory bodies.This webinar w..