The presentation leads off with disaster recovery techniques, followed by using lookup functions such as VLOOKUP, MATCH/INDEX, and XLOOKUP. The presentation then moves on to using Power Query to automate report clean-up and analysis, and then finishes out with using Excel's Solver feature to identify two or more transaction amounts that add up to a specific total.
Webinars
Accounting/Reporting
Great slideshows don't need to take a lot of time and effort! Learn some essential PowerPoint tips and tricks to help you effectively present any type of information to every type of audience with more ease.
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.
Stay ahead of 3Q 2025 regulatory changes! Stay confident and stay compliant.
This course addresses financial statements the way a branch banker would in the process of their work.
This program will step you through the best practices of hiring for the right fit. Being intentional about training managers and supervisors on the hiring process is key to creating stellar teams.
This 2-part webinar will discuss the requirements for a financial institution when management is required to assess risk and the effectiveness of the institution’s system of internal controls over financial reporting. Enterprise risk management will be covered to provide participants with an overview of this very important risk management function.
In this comprehensive webinar, Excel expert David Ringstrom, CPA, shares applicable Excel fundamentals that will enable accounting professionals to achieve their goals.
Do you find it difficult to decipher which call report loan code to use? Are you unsure which line-item to place loan income in? Are you placing your residential mortgage loans into the correct “bucket” for risk weighting? If you have ever wondered or had the same questions and concerns, then this is the workshop for you!
Fulfill your credit union training needs with webinars
We offer over 100+ webinars per year for credit unions and 300+ webinars for banks covering topics such as compliance, employee development, coaching, BSA/AML, lending, TRID, as well as trending hot topics like pandemic preparedness, the Cares Act, regulation updates and much more! Delivered by respected financial services industry experts, our webinars are timely, relevant and always engaging.
