Business Management & Organization

Mastering XLOOKUP: Modern Lookup Techniques in Excel (LITE23/27)

XLOOKUP has become Excel’s premier lookup function, replacing many of the limitations of VLOOKUP and HLOOKUP while introducing capabilities that were previously difficult or impossible to achieve. In this practical session, CPA and author of Microsoft 365 Excel for Dummies David Ringstrom demonstrates how to use XLOOKUP confidently to retrieve information, solve common lookup challenges, and build more reliable spreadsheets.

You’ll learn how to choose the appropriate match mode, replace older lookup functions, look up values in any direction, perform approximate and multi-criteria lookups, and troubleshoot common errors. Throughout the session, David explains not only how each technique works, but also when it provides the greatest advantage in real-world accounting and business scenarios.
Topics covered:
• Understanding XLOOKUP’s match modes and replacing older lookup functions.
• Looking up values to the left, horizontally, and by approximate or partial matches.
• Performing multi-criteria lookups and handling common lookup errors.
• Using XLOOKUP in Excel Tables and returning multiple values with a single formula.
• Choosing modern lookup techniques that simplify spreadsheet design and maintenance.

5 Productive Excel Features for Accountants (LITE22/27)

Microsoft Excel contains hundreds of commands, but only a handful can dramatically improve the way accountants organize, summarize, and analyze data. In this fast-paced session, CPA and author of Microsoft 365 Excel for Dummies David Ringstrom demonstrates five of his favorite Excel productivity features that can help you work more efficiently and avoid common spreadsheet frustrations.
You’ll learn how to filter data more quickly, transform ordinary lists into dynamic Excel Tables, summarize thousands of rows with PivotTables, retrieve information with XLOOKUP, and create interactive reports with slicers. Rather than simply demonstrating commands, David explains when each feature is most valuable so you can confidently apply these techniques to your own spreadsheets.

Topics covered:
• Filtering data quickly with keyboard shortcuts and custom Quick Access Toolbar buttons.
• Converting lists into Excel Tables for dynamic filtering, totals, and automatic expansion.
• Creating and customizing PivotTables to summarize large datasets.
• Filtering Excel Tables visually with slicers.
• Replacing older lookup functions with XLOOKUP, including returning multiple columns with a single formula.

How to Be a Better CFO (LIMG01/27)

Gone are the days in which the CFO was just in charge of keeping the books. Today’s CFOs are involved in all parts of a company’s operations. Utilizing case studies, research, and discussion questions, this course will explore how to look at topics such as picking out the best retirement plan, managing remote employees, strategic forecasting, and managing the budgeting process through the lens of a CFO.

Ethical & Compliant AI Use for Professional Services Firms (LIET15/26)

Ethical & Compliant AI Use for Professional Services Firms – AI isn’t just a productivity tool—it’s a professional risk surface. This course provides CPAs with a practical framework for using AI responsibly, ethically, and in compliance with professional standards, helping firms leverage AI’s benefits without compromising client confidentiality, trust, or regulatory obligations. 

Human Approach to AI in the Workplace: Strategies to Help Ensure Adoption (LIOT12/26)

AI is transforming the workplace, but its success depends on how leaders guide its adoption. This presentation explores the current state of AI across U.S. industries and its impact on productivity, hiring and employee experience, as well as the critical role of leadership in driving responsible implementation. Learn strategies for closing skills gaps, engaging teams and balancing innovation with empathy—while safeguarding privacy and minimizing risk. Whether your organization is starting its AI journey or scaling initiatives, this session offers actionable insights to build a future-ready workforce and help ensure AI complements—not replaces—the human element.

Tax Planning Using South Carolina Textile Mill, Abandon Building, Historic and LIHTC Tax Credits (LITX73/26)

This presentation explores the South Carolina Property Rehabilitation and Housing Tax Credits programs and its benefits for property owners, developers, South Carolina taxpayers, and the community. Specifically, it will cover the SC Historic Rehabilitation Tax Credit, SC Abandoned Building Tax Credit, and SC Abandoned Mill Tax Credit as well as complimentary tax and community programs specific to property rehabilitation. 

…

Seeing Beyond the Numbers (LIMG09/26)

Financial statements are a crucial window into the daily operations and overall health of a company. They reveal the strengths and weaknesses that define the organization’s financial standing. However, the interpretation of financial statements can vary widely depending on the user’s perspective. This course is designed to help you refine your financial statement analysis skills and gain insights that will enable you to better understand and communicate your company’s financial performance. Discussion Leader: David Peters

More Money at the End of the Month – Strategic Ways to Improve Cash Flow (LIMG08/26)

Cash flow management is often the most important task of any CFO or financial leader. Regardless of whether one works in start-ups or established companies, non-profit or for-profit entities, cash flow makes our organizations run. Have you ever wondered whether you are optimizing your company’s cash flow? In this course, we will explore how to improve your company’s cash flow using analysis and financial theories in the context of real-world situations.  Discussion Leader: David Peters

A Controller’s Guide to Assessing the Risk of Your Organization (LIMG07/26)

Part of being a CFO or Controller is protecting the assets of the organization and managing risk. While many financial leaders feel comfortable with the strategic aspect of this task, finding the right insurance coverages can leave one feeling out of their element. This course will focus on three common business policies – the package policy, the business & property policy, and the cyber policy. Through case studies and illustrative examples, we will explore what these policies cover, as well as what they don’t cover. We will also discuss how to have more productive conversations with outside insurance brokers.