Training Doyens

OVERVIEW Learning how to use efficiently use Excel isso critical in many of today’s office jobs. Many people know the basics of Excel. This webinar will show you how to use some of the advanced functions of Excel to really help get the most out of your data be more efficient, and get the information that you are looking for. WHY SHOULD YOU ATTEND This webinar is for someone who uses Microsoft Excel on a regular basis, and wants to be more efficient in using the program, or who wants to get more out of it. Power Map for Excel AREAS COVERED IF, including the nested if, the AND, and the OR functions for more complicated If statements. Vlookup Hlookup Sumif and Sumifs Countif and Countifs Averageif and averageifs Match and Index WHO WILL BENEFIT Business owners CEO's / CFO's / CTO's Managers of all levels Anybody with large amounts of data Anybody who uses Microsoft Access/Excel on a regular basis, and wants to be more efficient and

OVERVIEW There are numerous external and internal forces and factors that have an impact on organizations.  Increasingly this list includes the strategic, tactical, and legal activities of managing their human capital. Like the management of their financial capital, effective management of organizations’ human capital plays a critical role in determining their success. And like the benefits of financial audits, HR audits provide management with a method of determining whether human capital is effectively used, where human capital is incorrectly – or unlawfully — used, and how to improve human capital return on investment.  HR audits are designed to help organizationsfocus their attention on their human resource management practices, policies, procedures, processes, and outcomes by providing them with a structured and systematic series of questions about key compliance, risk management, internal auditing, and human resource management issues.  As an auditing process, HR audits ar

OVERVIEW Money laundering continues to be a national concern.  High levels of drug-related activity and violence have drawn additional attention.  Terrorist activities need to be considered as well.  Perpetrators have adapted to banks’ efforts so banks cannot combat the money laundering with yesterday’s methods. Software is widely installed to identify specific patterns and “unusual” transactions.  But the launderers know this and are constantly striving to create new patterns where their transactions are designed not to be flagged.  Like in a game of chess, the advantage goes to the side that thinks the most moves ahead. WHY SHOULD YOU ATTEND Many people with AML responsibilities willwork with only a few confirmed cases in money laundering in their career .   Few will setup or substantially redesign more than one AML program.  Jim’s work has included projects in AML investigation, AML prevention, AML regulatory compliance, and detection systems.  He was a member of a Justice D

OVERVIEW Learn what you need to know to avoid making a big and costly mistake! Are you aware of the legal definitions andimplications of sexual harassment? Do you understand the impact that the latest court decisions have had on sexual harassment claims? Do you have a plan for training your staff in how to avoid violating laws relating to sexual harassment? Are you willing to risk losing substantial sums of money from lawsuits and other penalties you may incur as the result of sexual harassment claims? If you answered no to any of these questions, then you want to be sure to join us! Sexual Harassment for Managers WHY SHOULD YOU ATTEND Are you unsure of how to define “sexual harassment”? Does it concern you that, according to the Bureau of Labor Statistics, the average cost to settle a sexual harassment claim are over $500,000? Could your team perform better knowing the definition of sexual harassment and how to avoid it? Would you like to be able to avoid costly

OVERVIEW Workplace Violence is more than justheadlines… it hurts your people and your bottom line, with lost time, turnover,lawsuits and enforcement actions . For Supervisors and Managers the Number One cause of death and serious injury is Workplace Violence. An average related lawsuit award is $3MM. The average settlement is $600K. Can you afford not to know the risks and remedies WHY SHOULD YOU ATTEND Workplace violence continues to emerge as an important issue in business and employers need to take the lead in prevention and mitigation efforts.  Violence in the workplace can originate from many sources, opportunistic criminals, customers, vendors, current and former employees and domestic violence spilling over into the work place. OSHA does not have a specific requirement mandating employers to protect their employees from on the job violence.  It is also true that after a violent incident OSHA will levy fines and enforcement actions using the “General Obligation Clause” t

OVERVIEW This agile project management course provides the participant with a step by step guideline for converting a traditional audit shop into the expected risk based audit organization. Because of the layered approach to the presentation, even those audit shops that wish to retain some of the successful practices of the past can accommodate the future by layering in pieces of the agile risk based process thereby tailoring their own shops to more effectively meet the needs of their organization. COSO and regulators, as well as the IIA are all focused on helping auditors become more flexible and risk based. Agile Audit Process WHY SHOULD YOU ATTEND Many audit shops struggle with contributing in today’s COSO and Risk Based environment. Movement from traditional audit practices to risk based processes has been difficult and time consuming. This Webinar eliminates the confusion and provides a clear pathway to meeting today’s high standards and in turn, motivate the audit