1099 & W9 Update

For years, the IRS has struggled with independent contractors (ICs) and tax collection. Recently, they have re-evaluated ways to close the tax gap (taxes due but not reported or paid) and determined one of the greatest opportunities comes from expanding the information reporting on taxpayers by payors – the 1099. But, fortunately, this time consuming reporting obligations can be streamlined in a number of ways.

Join nationally known speaker and expert on 1099 and W-9 issues Miles Hutchinson, CGMA, for this practical 90-minutes CPE webinar that will provide participants with answers to the following questions:

• What are the rules regarding paying and IRS reporting on Independent Contractors? 

• How do you avoid the IRS CP-2100 (B-Notices)? 

• What if your vendor claims exemption; must you obtain a W-9 anyway? 

• What are the best practices? 

• How can you minimize risk of improper exemption claims by your vendors? 

Get the answers to these and related questions to reduce your risk of huge penalties from the IRS. 

Mr. Hutchinson will help you learn the rules requiring W-9 documentation and 1099 reporting as well as how to properly establish the independent contractor relationship with the right documentation. Plus, understand the rules and keep your company or clients' companies in compliance and ensure that your records will stand the scrutiny of an IRS Third-party Documentation and Reporting audit. You will also learn how to avoid the onerous penalties for noncompliance and build the best defense against the 972-CG Notice of Proposed Penalty Letter.

This course is essential for all professionals in industry or in public practice who are responsible for filing or overseeing compliance with IRS Form 1099, as well as those charged with gathering the necessary documentation for independent contractors to accompany Form W-9. The presentation time will include opportunities for you to ask questions to Mr. Hutchinson live.

Register for this webcast 1099 & W9 Update at a discounted price.

Success Strategies for the Introverted Leader

Introducing a new webinar that helps you tackle the challenges and capitalize on advantages of being an introvert in a leadership role.

Introverts are often misunderstood, and that can negatively impact how you’re seen as a leader. In general, extroverts are much easier to read than introverts. Extroverts think out loud and don’t hesitate to share their ideas without vetting them internally first. Their nature is to be bold and gregarious, even dominant, traits that people often associate with leaders.

Introverts are generally quieter and more reserved. They are less likely to put their ideas on the table until they’ve had sufficient time to think them through. Unfortunately, this can leave room for misinterpretation of the introvert’s intentions as well as undervaluation of his or her leadership abilities.

If you’re an introvert in a leadership position, the social interactions your job requires can leave you drained and overwhelmed. But what can you do? You became a leader because of your skill set; abandoning your position is not an option. You need help. You need Success Strategies for the Introverted Leader. This 2-hours webinar has all the information you need to reach new levels of success, without changing who you are.

In a workplace filled with extroverts, it can be easy to overlook introverts, even those in leadership positions. So as an introvert, it’s your duty to speak up, make yourself known and get your point of view taken into account. That’s not always a comfortable thing to do, which is exactly why you can’t miss Success Strategies for the Introverted Leader. You’re a good leader; learn how to make others see it too!

A look at what you’ll learn:

• An introvert’s guide to great leadership: Tips and tricks

• Preparation: The key to successful introvert leadership

• Simple ways to become more comfortable embracing your inner extrovert

• Overcoming your discomfort at being the center of attention

• Making your words count—the importance of word choice for maximum impact

• 5 strategies for getting your voice heard, even when dealing with louder colleagues

When you attend Success Strategies for the Introverted Leader, you will learn all about the dangers of being misunderstood and how to adjust your communication style to make sure you are seen as a competent, capable, cooperative leader who knows how to get things done.

Assertive or Aggressive? Assertiveness Skills for Executives, Managers, Supervisors and HR Professionals

This program is designed to highlight the need to demonstrate assertive behavior and how it impacts overall performance.  You will learn to interact more effectively with people and manage your relationship with others with greater confidence and authority.

Being assertive means communicating your needs, wants and opinion to others in a direct and tactful manner, while at the same time receptive to their needs and without being confrontational or aggressive.

You cannot manage effectively if you feel uncomfortable saying ‘NO’ to your employees and are afraid to influence upwards and shy away from conflicts.  Participants will learn to:

• Take charge in their jobs
• Handle conflicts with strength and decisiveness
• Get tasks accomplished while maintaining effective relationships
• Make requests and refuse others
• Negotiate diplomatically
• Influence others without being coercive or manipulative

Assertiveness isn’t an option for success-minded managers – it’s a must-have skill.

Assertiveness Skills for Executives, Managers, HR professionals and Supervisors is a powerful webinar designed to provide you with the communication essentials you need to manage with greater confidence and authority. Through interactive exercises, insightful discussions, and activities, you’ll master people skills and assertive communication techniques guaranteed to give you an edge when you deal with people, problems, and situations that once caused you stress.

In just 60 minutes training, you’ll find out how to give criticism that motivates improved performance, how to get the results you expect from employees, and how to implement unpopular policies without losing staff loyalty. You’ll learn how to negotiate better, so you’ll be able to win time, resources, and the backing of upper management for your department. Plus, this webinar will give you dozens of problem-solving techniques for handling interdepartmental conflicts with tact so that you can reach compromises that are “win-win” solutions for everyone involved. You’ll also build solid strategies for protecting your authority as a manager – without making enemies along the way.

Assertive or Aggressive? Assertiveness Skills for Executives,Managers, Supervisors and HR Professionals - Enroll today and draw on some of the best ideas and methods available for more assertive, proactive management.

Two days workshop on Mastering Management: The Ultimate Problem-Solving

Two Days in person workshop on Ultimate Problem-Solving Skills essential for all Executives, Vice Presidents, Directors, Managers and Team Leaders.

This practical, interactive and participate training course will enhance your management skills in order to motivate your team members by projecting a charismatic and inspiring approach to your role. With practical insights into managerial and behavioral styles, you will explore the core competencies needed in effectively managing in an organisation, managing people and managing change. This Mastering Management Skills training course will give delegates:

• An assessment of their managerial style

• Clear direction for action in their areas for improvement

• The skills and knowledge to take their performance up to the next level

• The management tools and techniques to create effective change

Delegates who attend this Mastering Management Skills training course will learn to take responsibility for helping their team members to build the personal capacity needed to increase productivity and business results. Delegates will learn how to channel their skills and motivation into improving their key performance factors. Delegates will leave the training course with new insights into their preferred management and behavioral styles. Every delegate will have renewed confidence and energy to implement their personal action plans developed on the training course.

By attending this training program individual who have some experience at the supervisor/manager level and are ready to take more management responsibilities and are being groomed to make the transition from supervision to management. Managers who are looking to improve their managerial competencies, those who have been appointed to manage a change initiative will clarify role as manager. Program Objectives is to know the importance of character in management and the dimensions of behavioral style will embrace core functions of effective managers. Discuss the key elements used by major organisations to achieve business excellence. Understand how to implement a successful strategy, the need to take responsibility for leading change and how to be a Champion of Change.

Mastering Management Skills explores the issues, pressures and dilemmas faced by all managers. Setting these wide-ranging and complex situations in a realistic context, the common and universal problems of integrity, leadership, presentation and motivation are addressed in this session - Mastering Management: The Ultimate Problem-Solving Workshop. Enroll for the seminar today.

Workshop On BSA/AML/OFAC Risk Assessments - Are you Doing them Correctly

The seminar highlights BSA/AML/OFAC risk assessments. The areas of focus outlined in this session are based on best industry practice, supervisory experience and cover the major components of an effective BSA risk assessment program that audit focuses on. The instructor will look at these areas and the specifics of each area as it pertains to BSA compliance.

This Bank Secrecy Act risk Assessment training will emphasize BSA best practices that are being acknowledged and recognized by regulators and examiners and will discuss each risk assessment area. The areas covered in the session:

• Implementing BSA risk assessment
• Assessing policies and procedures for risk assessments
• Comprehensive risk assessment review for BSA / AML / OFAC
• Review of risk assessment matrixes
• Determining effectiveness and thoroughness of risk assessments
• Performing risk assessments

Financial institutions are required to be compliant with BSA rules and regulations. Such compliance needs to be well documented and consistent to ensure financial institutions avoid BSA violations and implications. Financial institutions’ BSA Programs must have adequate risk assessment policies and procedures, monitoring programs, training programs, qualified employees overseeing the BSA daily operations and independent testing programs. An effective BSA risk assessment program will ensure that all areas are being evaluated for risk appropriately and being monitored on a routine basis. Having a strong BSA risk assessment program will ensure that financial institutions are proactive in assisting the Bank in mitigating risk that can negatively impact its strategic and business plans for growth, development, and compliance.

All financial institutions have some level of risk to money laundering, terrorist financing, or financial fraud. The cornerstone of any good anti-money laundering (AML) compliance program is an assessment of these risks in order to develop strategies to manage and mitigate them.  The principle of the risk-based approach is that resources are directed congruently with priorities so that the greatest risks receive the highest attention.

Risk assessments are the foundation of a BSA/AML Program. The purpose is to identify the BSA/AML risk profile and use the results to apply appropriate controls to mitigate risk. Steps to identify specific risk categories, such as: customers, products, services, and geographies and quantify the specific risk categories.

An Office of the Treasury that administers and enforces economic and trade sanctions based on U.S. foreign policy objectives and national security goals against targeted: Foreign countries and regimes, Individuals, Entities, and Practices. The sanctions programs administered by OFAC require transactions, accounts and/or other property to be blocked or rejected; depending on the specific program requirements. OFAC can assess Civil Money Penalties (CMPs) for processing or engaging in an apparent violation of a U.S. sanctions program. OFAC operates under a clause of strict liability. If a sanctioned transaction is processed, there is a violation of law. When determining whether a CMP is appropriate, or in calculating the CMP amount, OFAC reviews the existence, nature, and adequacy of the bank’s OFAC compliance program, including the views of the institution’s regulator.

Register yourself for this brainstorming session now- BSA/AML/OFAC Risk Assessments - Are you Doing them Correctly

Status Classification: Exempt vs Non-exempt

This topic will help you understand the current overtime exemptions, the nature of the claims asserted by plaintiffs, and common areas of focus and arguments advanced by plaintiffs' counsel and the Department of Labor. It will also explain what steps you can take to assure proper classification and minimize the likelihood and success of these misclassification claims.

The differences between exempt employees and non-exempt employees can cause a lot of confusion for both workers and employers. Whether or not you are entitled to minimum wage and/or overtime pay for working more than 40 hours per week depends on your exemption status, as governed by the federal Fair Labor Standards Act (FLSA).

Non-Exempt Employee vs Exempt Employee

a) Definition of Non-exempt employee- Most employees are entitled to overtime pay under the Fair Labor Standards Act. They are called non-exempt employees. Employers must pay them one-and-a-half times their regular rate of pay when they work more than 40 hours in a week. The biggest problem most employers have with non-exempt employees is miscalculating how much overtime workers are owed.

A non-exempt employee must be paid the minimum wage and overtime pay for any time worked beyond 40 hours in a given week. Under FLSA rules, non exempt employees are entitled to time and one-half of their regular pay rates for each hour of overtime. Non-exempt employees mistakenly treated as exempt employees, or whose "off-the-clock" hours are not properly recorded and compensated, may file FLSA overtime claims with the U.S. Department of Labor.

Most workers, particularly those working an hourly wage, are in fact non-exempt employees.

b) Definition of exempt employee- The Fair Labor Standards Act contains dozens of exemptions under which specific categories of employers and employees are exempted from overtime requirements. The most common exemptions are the white-collar exemptions for administrative, executive, and professional employees, computer professionals, and outside sales employees. There is an also a lesser known exemption for certain retail or service organizations. The primary advantages of classifying employees as exempt are that you don’t have to track their hours or pay them overtime, no matter how many hours they work.

Obviously, this is an appealing scenario for employers. However, exemptions from the overtime requirements of the FLSA are just those exceptions to the rule. They are very narrowly construed, and as the employer, you will always bear the burden of proving that you have correctly classified an employee as exempt.

Understanding of the FLSA exemption categories and how to apply them including:

• Executive Exemption: what is management and how many employees must the executive supervise

• Administrative Exemption: what is management or general business operations and what is discretion and independent judgment

• Professional Exemption: who is a learned professional and who is a creative professional

• Computer Employee Exemption: what makes certain of computer professionals exempt and how is their salary test different

• Outside Sales Exemption: what are the requirements and how much do they have to be paid

• Highly Compensated Employees: how does their salary get calculated

• Other exemption rules: who is automatically covered and who is excluded by rule

Register yourself for this interactive webinar now - Status Classification: Exempt vs Non-exempt

Compensation Systems Explained: Essentials of Creating Pay Structures

In this training program, participants will understand the fundamental concepts of creating a compensation system. They will receive information on the concepts of: compensation policy, internal and external equity, ranges, grades, position analysis, job evaluation systems, and point factor systems, benchmark positions, using market analysis to establish pay ranges and midpoints, options for movement through salary ranges, and calculating compa-ratios. Sample pay grade with variable ranges will also be discussed in the session.

Best practices relating to base salary is a fixed amount of money paid to an employee by an employer in return for work performed. Understand why developing a company philosophy on base salary structure is important and discusses how managers can work with different approaches for their company. The two usual approaches for base salary structure creation are identified (pay for the job and pay for the person) and explained. Readers are then introduced to the concepts of broadband and salary ranges. How broadband and salary ranges function and why they are vital in the creation of a base salary structure. Readers are also taught the practical issues surrounding base pay structure from the four perspectives: people, economic, risk, and operational.

Less than half the companies with fewer than 100 employees have formal salary structures and only 70% of all U.S. companies have such structures. Yet almost all companies report that they have hard-to-recruit positions and they are vulnerable to loosing top talent. Having a competitive well-designed compensation system has long been a corner stone of employee recruitment and retention and regardless of the economy, it is critical to have a competitive compensation structure that fulfils your company's goals. This webinar will give you the tools to get started in developing a base pay plan or tune up your current plan. It will present a broad overview of the philosophy and application of compensation systems.

Here are ten steps to develop a salary structure for your organization, with some special considerations for international developing markets:

• Establish your compensation philosophy

• Gather market data

• Identify benchmark jobs

• Measure your market position

• Calculate the compa-ratio

• Check your budget

• Start allocating

• Final adjustments

• Management approval

• Communicate

Register yourself for this brainstorming session Now- Compensation Systems Explained: Essentials of Creating Pay Structures

Document Retention and Destruction What Human Resource Professionals Must Know

This topic will help you learn the legal requirements for document management policies and understand how to implement the practical considerations unique to their respective companies. Best practices will be emphasized, especially litigation avoidance and satisfying legal requirements.

Make sure you are in full compliance with your current document retention and destruction policies. Many employers lack a document management policy altogether, resulting in inconsistent document retention and destruction a sure fire path to litigation and spoliation claims and little to no reliable protection for confidential information. Another substantial number of employers rely on generic policies whose sources are unknown, are from a different industry, or rely on a different state’s laws, just to cite a few of a myriad of problems with generic policies. The enormity of creating a model policy unique to a specific employer creates a psychological barrier that hinders the development and implementation of a much needed document management policy.

Importance of Document Retention and Destruction

Record retention in the past was a mundane affair. File cabinets stuffed with paper served the purpose best. Today, new forms of information and communication storage as well as data retrieval systems are more prevalent than ever before.

Some of the major accounting firms have had bad publicity in the press for questionable record keeping and handling. Many other companies have shut down operations for the same reason. Records today are subjected to greater monitoring and regulation. However, appropriate record maintenance is necessary not only in the context of law but also from the perspective of efficient business functioning. 

The most critical thing to address in context of records is their safe maintenance. Lost records lead to loss in tax advantages, business opportunities, and time. In addition, businesses that do not keep their records safe may face difficulties in situations like hacker attack and fire breakout when recovery may be impossible.

Role of Human Resource Professionals

The key to document retention is the extensive training to human resource professionals in managing, organizing, and retaining key business information and records. The human resource professionals can make the right policies and put them in place for appropriate management of records. However, each and every employee must be guided by these policies with the adequate sense of responsibility towards safe record keeping.

Document Retention and Destruction: The Right Way

Document disposal is as important as its retention. It must be done in a right way. Business must know which records are to be retained and figure out the least time for which they must be retained. The trend is growing towards retaining documents for a longer time than it used to be in the past.

There are some records like corporate governance, minutes, bylaws, and shareholder agreements that must be permanently maintained and their copies must be with the business attorneys. There are other records like leases and agreements that must be kept safe at least until ten years after their expiry. However, intellectual property documents must be retained forever. The same goes for insurance policies since past claims can create issues many years later.

Click the link for more info or Register now- DocumentRetention and Destruction What Human Resource Professionals Must Know

Preparing a Proactive Root Cause Analysis with the Ishikawa Fishbone Tool

How to Use theFishbone Tool for Root Cause Analysis

Root cause analysis is a structured team process that assists in identifying underlying factors or causes of an adverse event or near-miss. Understanding the contributing factors or causes of a system failure can help develop actions that sustain the correction.

A cause and effect diagram, often called a “fishbone” diagram, can help in brainstorming to identify possible causes of a problem and in sorting ideas into useful categories. A fishbone diagram is a visual way to look at cause and effect. It is a more structured approach than some other tools available for brainstorming causes of a problem (e.g., the Five Whys tool). The problem or effect is displayed at the head or mouth of the fish. Possible contributing causes are listed on the smaller “bones” under various cause categories. A fishbone diagram can be helpful in identifying possible causes for a problem that might not otherwise be considered by directing the team to look at the categories and think of alternative causes. Include team members who have personal knowledge of the processes and systems involved in the problem or event to be investigated.

The Ishikawa Fishbone Diagram (IFD) is one of seven powerful Quality Management Tools (1. IFD, 2. Check Sheet, 3. Control Chart, 4. Histogram, 5. Pareto Chart, 6. Scatter Diagram, 7. Stratification - flow or run chart) that is typically used to solve problems within organizations. In this webinar, you will learn how to apply IFD’s to capture potential problems before they affect cost, quality, schedule, and customer satisfaction.

Fishbone Diagram Procedure

1) Agree on a problem statement (effect). Write it at the center right of the flipchart or whiteboard. Draw a box around it and draw a horizontal arrow running to it.

2) Identify the major factors and draw four or more branches off the large arrow to represent main categories of potential causes.

Service Industries (The 4 Ps):

•        Policies
•        Procedures
•        People
•        Plant/Technology

Manufacturing Industries (The 6 Ms):

•        Machines
•        Methods
•        Materials
•        Measurements
•        Mother Nature(Environment)
•        Manpower (People)

3) Brainstorm all the possible causes of the problem. Ask: “Why does this happen?” As each idea is given, the facilitator writes it as a branch from the appropriate category. Causes can be written in several places if they relate to several categories.

4) Again ask “why does this happen?” about each cause. Write sub–causes branching off the causes. Continue to ask “Why?” and generate deeper levels of causes. Layers of branches indicate causal relationships.

Why-Why Analysis (The 5 Whys):

It is a method of questioning that leads to the identification of the root cause(s) of a problem. A why-why is conducted to identify solutions to a problem that address it’s root cause(s), rather than taking actions that are merely band-aids, a why-why helps to identify how to really prevent the issue from happening again.

5) Analyze the diagram. By this stage there should be a diagram showing all the possible causes of your problem.

Register yourself for this brainstorming session now and get special group discounts on registration- Preparing a Proactive Root Cause Analysis withthe Ishikawa Fishbone Tool

Teaching your Front-line How to Ask BSA Questions?

Guidance to Front-Line Staff on How to Ask BSA Questions

Learn the responsibilities of front-line staff on how to respond for BSA questions. Register for the live webinar today.

Teaching your front line how to ask BSA question? This Bank Secrecy Act training will explain how to train your front line staff to ask BSA questions. It will cover Currency Transaction Report (CTR), Monetary Instrument Log (MIL) and Suspicious Activity Report (SAR) scenarios and questions and much more.

Front-line employees are your first line of defense against money laundering. But in too many cases they’re near the back of the line with regard to training. This webinar brings together experts who share practical tips and strategies for bringing compliance concepts down to the rank-and-file, protecting your institution in the process.

Learning Objectives:

• Establishing compliance training programs for new hires
• Creating ongoing education programs and performance metrics
• Developing independent testing of training effectiveness

Front-line Fundamentals of this fast-paced webinar is all about expertise and performance. Focusing on the key issues the front-line must manage effectively every day, Front-line Fundamentals, will heighten awareness, teach techniques and provide information concerning selling, service delivery and compliance follow-through.

You will learn how to stay alert for money laundering scams, understand the critical pieces to REG CC and BSA for the front-line, turn a complaint into an opportunity, manage difficult questions and people like a pro, convey in customer-friendly language the why’s and how’s associated with policies and regulations, quickly identify what products/services are a good match for your customer, improve your persuasion skills, master the art of referrals and do your part to increase investments, deposits and loans, increase your cross-selling ratios and tie the customer to your bank.

For more details please visit us at: Teaching your Front-line How to Ask BSA Questions?

New Guidelines from the EEOC in Handling Harassment Claims

New EEOC Focus on Harassment Claims

Dealing with sexual harassment claims is one of the most daunting tasks employers face.  It is even more daunting when the employer has to address those who are responsible for the company being in existence – its customers.  Now, the Equal Employment Opportunity Commission has recently issued new guidelines that set forth new ways in which the EEOC will investigate sexual harassment claims. Join expert Susan Desmond who will give a complete overview on The New EEOC focus on Harassment Claims and how to handle harassment charges.

The Equal Employment Opportunity Commission (EEOC) recently issued proposed guidance crystallizing the agency’s expectation that employers be proactive in eliminating workplace harassment.

Five core principles that the EEOC states have generally proven effective in preventing and addressing harassment:

•   Committed and engaged leadership

•   Consistent and demonstrated accountability 

•   Strong and comprehensive harassment policies

•   Trusted and accessible complaint procedures

•   Regular, interactive training tailored to the audience and organization

The employer is automatically liable for harassment by a supervisor that results in a negative employment action such as termination, failure to promote or hire, and loss of wages. If the supervisor's harassment results in a hostile work environment, the employer can avoid liability only if it can prove that: a) it reasonably tried to prevent and promptly correct the harassing behavior; and b) the employee unreasonably failed to take advantage of any preventive or corrective opportunities provided by the employer.

Prevention is the best tool to eliminate harassment in the workplace. Employers are encouraged to take appropriate steps to prevent and correct unlawful harassment. They should clearly communicate to employees that unwelcome harassing conduct will not be tolerated. They can do this by establishing an effective complaint or grievance process, providing anti-harassment training to their managers and employees, and taking immediate and appropriate action when an employee complains. Employers should strive to create an environment in which employees feel free to raise concerns and are confident that those concerns will be addressed.

Employees are encouraged to inform the harasser directly that the conduct is unwelcome and must stop. Employees should also report harassment to management at an early stage to prevent its escalation.

Register for this interactive webinar at a discounted price - New Guidelines from the EEOC in Handling Harassment Claims

2017 CMS Proposed Changes to the Discharge Planning Standards and the IMPACT Act

Guidance on Discharge Planning Standards and the IMPACT Act

In this session, our expert speaker Sue Dill Calloway RN, MSN, JD, will provide a better understanding on the impact of the CMS proposed changes to the hospital discharge planning standards and the Improving Medicare Post-Acute Care Transformation Act (IMPACT)Act.

The CMS hospital proposed changes to the discharge planning standards and the federal law called the IMPACT Act are of high importance to hospitals including critical access hospitals (CAH). While the CMS hospital proposed changes will result in more work for hospitals and hospitals need to start thinking about how they will comply with things such as: a) rewriting the transfer form, b) collection of five new data elements, c) changes to the discharge evaluation form to collect five required standardized assessment elements which require five things to be included in all discharge instructions.

Under the new changes CMS will require medication reconciliation upon discharge and information on side effects of new medication. This will affect not only hospitals but home health agencies, inpatient rehab, SNF, and LTC hospitals. Also, under the new requirements, discharge instructions and discharge summaries will be required to be sent to the physicians within 48 hours.

Session Features:

• Why the IMPACT Act was passed?

• Reporting of Quality Measures for Long-term care, SNF, inpatient rehab & home health

• 2016 CMS Discharge Planning proposed changes

• Who does the hospital discharge planning process apply to?

• 8 things to consider in evaluating the patient’s discharge needs

• RARE: Reducing Avoidable Re-admissions

• AHRQ Resources on hospital discharge and reducing readmission

• What’s in your discharge planning P&P

• The 5 things that you can’t miss in the discharge instructions

• What are the many things now required being included in the transfer form?

• Identify that the discharge summary and instructions will need to be sent to the primary care practitioner within 48 hours of discharge

• Five things that must be in the standardized assessment form as required by the federal IMPACT law

• Patient transfers and the 21 things you need to know

• Care transition tools

• Written discharge instructions

For more info attend this webinar- 2017 CMS Proposed Changes to the Discharge Planning Standards and the IMPACT Act

Live webinar on 18 May 2017 | Time: 11:30 AM PDT, 02:30 PM EDT | Duration: 90 Minutes.  If you cannot make it on the scheduled day, you can always buy our recorded session of the same anytime.

Microsoft Excel Data Validation Tools - Keep out Bad Data from the Start, Simplify Data Entry and Ensure Accuracy with this Powerful Feature

In this enlightening session, Excel expert Dennis Taylor will enumerate how you can control data entry by formulas, provide drop down lists that eliminate time-consuming and error-prone typing mistakes, control numeric data based on date and time constraints, and identify unwanted data by applying data validation rules on existing data by using Excel’s Data Validation tools.

Also explains how to implement a variety of techniques to create spreadsheets that are interactive, accurate, and user friendly. Learn easy ways to simplify data entry and understand how to control data input of other users. Save time and effort by minimizing spreadsheet maintenance.

Using Data Validation, one of the tools provided with Excel allows you to ensure that the data in your workbook is within specific bounds, and therefore of a higher quality than unchecked data. This tool is referred to as data validation, and it allows you to set the bounds applicable to your data. i.e; Make a list of the entries that restricts the values allowed in a cell, Create a prompt message explaining the kind of data allowed in a cell, Create messages that appear when incorrect data has been entered, Check for incorrect entries by using the Auditing toolbar, Set a range of numeric values that can be entered in a cell, Determine if an entry is valid based on calculation in another cell.

You will learn how to restrict cell content by forcing users to pick entries from a pick list, how to restrict cell content by value, text, or data/time, how to restrict cell content by formula, and how to use auditing tools to check the validity of existing data

This webinar will provide valuable assistance to nearly all Excel users - it is not industry specific, but is perhaps more widely used in banking, finance, and related fields, marketing, sales, Investments, Pharmacy, Accounts, Audit, Credit Unions and Mortgage.

Join this session for more info or Register now- Microsoft Excel Data Validation Tools - Keep out Bad Data from the Start, Simplify Data Entry and Ensure Accuracy with this Powerful Feature