Training

What You'll Learn

• What is ChatGPT? How does it work?
• How can you access ChatGPT?
• What prompts work best for generating and summarizing text?
• What questions should you ask ChatGPT?
• How can you get the most accurate results?
• How can you use ChatGPT for various industries and applications?

What You'll Learn:

• How can ChatGPT revolutionize Excel workflows?
• How can ChatGPT assist in creating complex formulas?
• What steps can you take to streamline table creation?
• How does ChatGPT work with Excel VBA?
• What benefits does ChatGPT offer for Excel Power Query?
• What are the best practices for using ChatGPT with Excel effectively?

What You'll Learn

• How can ChatGPT help with management responsibilities?
• Is ChatGPT useful for compliance and legal support?
• What risks and legal concerns should you avoid?
• Who owns the intellectual property of the content ChatGPT generates?
• What should you consider when using AI to write communications?
• How can you demonstrate that AI cannot replace you?

What You'll Learn

• How can artificial intelligence help you prepare for a difficult conversation?
• How does role-playing with ChatGPT work?
• What prompts can you use to get the guidance you need?
• Can ChatGPT provide a script you can follow?
• How can you adapt language, tone, and approach for your situation?
• How can AI tools help with follow-up after a conversation?

What You'll Learn

• When to use PivotTables
• What you should know before you create a PivotTable
• Creating a PivotTable
• Formatting PivotTables
• Customizing PivotTable formatting
• Sorting and filtering PivotTables
• Changing PivotTable calculations
• Creating PivotCharts
• Sharing PivotTables and charts in PowerPoint, Word, and other apps
• Filtering with interactive slicer tools
• Power tips, tricks, and shortcuts

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'll Learn

• What creditors are subject to the rule?
• Which transactions are covered?
• Which transactions are specifically excluded?
• What data points must you collect?
• What are the data reporting requirements?
• How must you prepare well before the mandatory compliance date?

Topics Covered

• Initial Due Diligence and Risk Rating
• Sales Validation
• Ongoing Due Diligence and Account Monitoring
• FinCEN Reporting

Benefits of Certification

• Earn two valuable certifications that demonstrate your expertise
• Align employee rewards with organizational success
• Attract and retain top talent despite inflation and a hot job market
• Communicate compensation strategies to management and employees

Benefits of Certification

• Align employee rewards with organizational success
• Attract and retain top talent
• Communicate compensation strategies to management and employees
• Demonstrate your knowledge as a compensation expert
• Earn a prestigious certification

Benefits of Certification

• Hear practical solutions and best practices from an industry expert
• Manage your institution’s BSA/AML program while minimizing risks
• Demonstrate to regulators that your institution is serious about its responsibilities
• Advance your career

Five Sessions Include:

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