Training

Topics Covered

• Does the rule apply to your institution?
• How can you ease the stress of implementing the new rule?
• What is the scope of Section 1071?
• What 21 data fields are required?
• What resources and staffing will you need to implement the rule?
• How will your compliance, CRA, and lending programs need to adapt?

Benefits of Certification

• Protect your organization from potential legal liability
• Help colleagues who request leaves
• Expand your professional knowledge and propel your career
• Prove your knowledge with a certificate

What You Will Learn

• Introduction to and Overview of the Bank Secrecy Act (BSA)
• BSA Reporting Requirements
• Patriot Act I– Controls
• Patriot Act II– Controls Continued
• Program Level Expectations and/or Requirements

Five Sessions Include:

• Creating Workbooks
• Basic Formulas and Functions
• Formatting
• Tables and Charts
• Date and Text Functions

What You'll Learn:

• Five ways to create an Excel workbook in less time
• How to navigate the workbook
• The quickest way to select data
• Entering text and numbers
• Copying, cutting, pasting, and moving data
• Saving workbooks to multiple formats

What You'll Learn:

• Basic formulas
• Order of operations
• Basic functions (SUM, COUNT, AVERAGE, etc.)
• AutoSum
• Absolute vs. relative references

What You'll Learn:

• Formatting worksheets
• Easy ways to copy formats
• Using styles
• Conditional formatting

Topics Covered

• Why are banks and credit unions subject to affirmative action obligations?
• What are your compliance obligations under current laws and regulations?
• What differs for banks and credit unions with 50 or more employees?
• What specific steps do the Section 503 and VEVRAA rules require?
• What are the risks of failing to comply with affirmative action rules?
• Which banks does OFCCP audit and why?

What You'll Learn:

• Using lists and tables
• Creating charts
• Formatting charts
• Modifying charts

What You Will Learn

• What caused Silicon Valley Bank to collapse?
• What decisions did SVB make long ago that led to this point?
• What actions in the week leading to the collapse exacerbated the situation?
• How did technical factors play a role in SVB’s crash?
• Does your institution face the same risks as SVB?
• What are the biggest long-term lessons from this incident?
• What steps should you take immediately to keep your institution solvent?
• Will regulators assess risk differently in light of the SVB collapse?

What You'll Learn:

• Absolute vs. relative references (continued)
• Date functions (with commonly used examples)
• Text functions
• How to lock your cells to protect functions

Topics Covered:

• What specific FMLA policy changes must you make for 2023?
• What year-end steps should you take now?
• Is your organization entitled to any tax credits for 2022?
• When is COVID-19 a reason for taking FMLA leave?
• How should you administer intermittent leave?
• When are you required to engage in the ADA interactive process?
• How should you request employee medical information?