Implementing a Risk Management Program - Handbook, Risk Appetite and Risk Culture
Fred Vacelet
60 Min
Product Id: 705115
This training program will review a few ways to ensure that a financial institution reviews things from the start and consistently, in setting up a risk management framework that allows the bank to focus on its strategy rather than mere compliance.
Modeling the Critical Monthly Cash Flow Forecast - Building a Can't Miss Template
Joe Weil
100 Min
Product Id: 704995
From calculating DSO and DSI and planning for seasonal adjustments to using Excel date arithmetic to schedule payables, receivables and cash flow, this training program will assist attendees in effectively constructing the monthly cash flow forecast using Excel.
The IRS is Coming: How to Prepare for the New IRS Partnership Audit Rules
Travis A Greaves,T Joshua Wu
60 Min
Product Id: 705112
The new IRS partnership audit rules require all partnership and LLCs taxed as partnerships to amend their partnership agreement and take action now. In this training program, attendees will learn how these rules impact your business and your clients. The session will discuss IRS issues with TEFRA (Tax Equity and Fiscal Responsibility Act) and detail the concepts and terms in the Bipartisan Budget Act.
SBA: Projecting Cash Flow - Best Practices and Evaluation Techniques
Charles H Green
60 Min
Product Id: 705106
This training program will help attendees recognize the risks of failing to thoroughly vet the information received from a business loan applicant that project future revenues, profits and cash flows. Attendees will also learn to track cash through a business operation, dissect the cash cycle of the operation, and comply with SBA standards concerning expected cash flow attributes of loan applicants.
High Risk Transaction Case Studies
Heidi Lee
90 Min
Product Id: 705175
This training program will help attendees understand how the Interagency Appraisal and Evaluation Guidelines define HRTs (high risk transactions). It will also discuss best practices for checking your bank transaction risk process and offer ideas for improving your bank’s process for assessing and handling HRTs. Attendees will learn more about the regulatory impact of a HCRE transaction and the limited exemptions for ADC loans.
Exploring Excel: Logic Formulas - IF, AND, OR, and Beyond
David H Ringstrom
90 Min
Product Id: 705092
This training program will help attendees recall how to avoid complex IF statements and apply the COUNTIF function to determine the number of times an item appears on a list. It will also demonstrate several key Excel features such as applying the IFNA function in Excel 2013 and later; applying alternatives to the IF function, such as IFS, CHOOSE, VLOOKUP, and others; the ISNA function vs. the IFERROR function, and much more.
Unveiling MS Office Application Suite 2016
Mitzi Katz
90 Min
Product Id: 705030
This training program will explore several new functionalities within the MS Office suite. For example, did you know Word 2013 can open PDF files directly? Charting has been revamped throughout the Office products, especially in Excel. This Excel webinar will serve as a quick start to learn the new features.
AICPA'S Financial Reporting Framework for Small and Medium Size Entities
Candace Leuck
90 Min
Product Id: 705141
Accountants and other financial professionals who deal with privately held entities wishing to reduce the cost and reporting burden that exists with reporting using generally accepted accounting principles should become familiar with the AICPA’s (American Institute of CPAs) recently developed accrual basis framework of accounting. This training program will deconstruct AICPA's financial reporting framework for small and medium size entities.
Exploring Excel: The Pros and Cons of Linked Excel Workbooks
David H Ringstrom
90 Min
Product Id: 705050
This excel work book webinar will showcase how to link excel to word documents, databases, web pages, how to fix broken links, improve integrity of workbooks. Learning how to break links to other workbooks and data sources. Handouts and sample workbook with steps.
Regulation E - The Basics and Error Resolution
Donna K Olheiser
90 Min
Product Id: 705178
Financial institutions have responsibilities and liabilities under Regulation E for consumer accounts when there are unauthorized transactions. However, the consumer account holder has some liability too. This webinar training will explore the limits of liability and help attendees understand who is liable for what amount, aided with real-life scenarios.
How to Establish an Effective Internal Control System
David Sanders
90 Min
Product Id: 705133
This webinar will enhance participants’ knowledge by detailing the elements of internal controls. Internal controls are a key part of any organization's continued growth, performance and success. With fraud at an all-time high, a well-designed internal control structure will enhance operations by improving your department's over all security and effectiveness.
Workers Comp Basics and Safety - How to Select a Service and Provider
Rob J Thurston
60 Min
Product Id: 705147
This Workers Comp training program will explore Workers Comp basics and safety and highlight best practices to select a service and provider. It will discuss list cost-effective strategies for safety and how to research, design and administer WC.
Overhauling Outdated Credit Decisioning: Understanding and Best Practices
David Peterson
60 Min
Product Id: 705187
In this training program, attendees will learn the 9 regulations governing payments risk and KYC/KYCC in which you may be out of compliance, as part of the process to overhaul outdated credit decisioning.
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.
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.
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.
PMP - Requirement Validation and Gathering for Fortune 500 Companies
Kevin Chenoweth
90 Min
Product Id: 705129
This training program will deconstruct how to define requirements management and change process. It will also offer a clear understanding of the role of requirements in the project life cycle, the role of requirements in the business case, and the role of stakeholders in requirements definition.
ACH Origination - The Rules for Setting Exposure Limits
Donna K Olheiser
90 Min
Product Id: 705098
This training program will review criteria needed to evaluate Originators and perform proper due diligence and describe details on the different types of ACH risk – focus being on credit risk for purposes of setting exposure limits. It will also outline the rules and evaluation process for setting exposure limits for all Originators and overview FFIEC guidance regarding risk in the ACH network.
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.
Small Business Lending: Understanding Financial Metrics - Minimize Conflicts
Charles H Green
100 Min
Product Id: 705105
This webinar training will identify challenges to small business lending through the lens of macro economic realities and help in understanding the scope of the marketplace. Attendees will gain a clear overview of the principal risk factors that are present with all small businesses and determine whether they might be overcome.