Webinars

While many users rely on VLOOKUP to return data from other locations in a worksheet, that’s not always the most efficient approach. In this comprehensive presentation, David reveals alternatives to VLOOKUP, including the HLOOKUP, INDEX and MATCH, XLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, IFNA, FILTER functions and more.

Excel expert David H. Ringstrom, CPA, focuses on the basics of using Excel pivot tables in this comprehensive presentation. Pivot tables empower you to easily create reports from complex data, simply by using your mouse. David explains how to initiate a pivot table from a list of data, expand and collapse pivot table elements, dig deeper into the numbers with the Report Filter command, and much more. As is the case with many features in Excel, pivot tables have nuances that can trip you up, so David points out traps and teaches you tricks to help ensure your reports are always accurate.

This 2 part webinar is designed for Call Report preparers, reviewers, or auditors that focus on the many loan-related schedules included within the Call Report.

Financial institutions increasingly relying on third-party providers to offer their products and services creates increased risk. This educational session provides best practices to help you develop a simple, yet comprehensive Vendor Management Program and a Model Risk Management Program.

When you attend this live presentation, you’ll learn how to implement multiple techniques to create spreadsheets that are interactive, accurate, and user friendly.

This course will give understandable, pertinent examples from various auditing disciplines to learn how to remedy the greatest roadblocks to clear thinking through writing. It will also show you how to cultivate a convincing, authoritative style. You will leave this webinar with excellent resources that you can continually turn to during intense, complex audit engagements.

The Call Report is a dynamic and ever-changing document in the realm of financial reporting. Over the past few years, we've been on a continuous journey of adaptation, carefully addressing and implementing extensive alterations and updates to this crucial report. The financial landscape is not static, and regulatory authorities regularly introduce modifications to ensure accurate and transparent reporting. As we look ahead, we acknowledge that the journey of change continues and we must continue to be proactive and adaptive to those changes

"It's ALL about the reporting" - I say hundreds of times a year when asked about policy and procedures on IRAs. Sometimes we fail to connect the frontline transactions to the end result, and therefore how it reports to the IRS. If we don't understand the transaction descriptions when we are coding an IRA transaction, there's a good chance it won't report correctly to the IRS - sometimes resulting in a letter and bill issued to the customer.

This webinar is designed for bankers seeking to gain an understanding of consolidation accounting and the preparation of a statement of cash flows.