Webinars

As if IRA beneficiary payout options weren't confusing enough, the last 3 years have brought turmoil to the IRA world with the IRS flip-flopping on how and when beneficiaries should take death distributions after the IRA owner dies. The SECURE Act created three categories of beneficiaries to determine what payout options are available to each category. It's almost like you need a GPS to follow this crazy beneficiary distribution trail.

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.

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

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.

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.

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.

Our upcoming 2-hour webinar is designed to equip participants with invaluable insights into the ever-changing regulatory and accounting landscape. We’ll delve into recent shifts and explore proposed changes slated for implementation in 2024. Moreover, to ensure utmost relevance, any emerging regulatory matters will be seamlessly integrated into the agenda. This ensures that our training remains highly pertinent for the June 30, 2024 reporting period and going forward.

This unique new training program gives your consumer lending-focused employees the tools they need to verify key client information, understand consumer regulations, underwrite the loan, and follow up to minimize fraud. The program emphasizes the competencies needed to review and analyze consumer lending requests.