Professional Development and Event Catalog
K2's Advanced Excel
Wednesday, Jul. 29 10:00am - 6:00pm
Online
8.00 Credits
Member Price: $324
Elevate your Excel expertise with K2's Advanced Excel program! This laptop-friendly course is designed for experienced Excel users who are ready to take their skills to the next level. In this session, you will master critical advanced Excel skills in six key areas: 1. Collaborating seamlessly with other users and securing your workbooks 2. Utilizing tables to analyze and report data efficiently 3. Integrating and manipulating data from external sources with ease 4. Creating and auditing complex formulas 5. Harnessing advanced data analysis tools for deeper insights 6. Employing visualization techniques to communicate information effectively Drawing from over thirty years of experience in delivering Excel training to accountants and business professionals, this program is packed with relevant, real-world examples that reinforce the topics presented. Don't miss this opportunity to become more efficient and proficient in Microsoft Excel, the go-to tool for accounting and financial professionals. This course covers advanced Excel topics that are essential for business success. Participate in this session to elevate and transform your Excel skills!
Untying the Knot: Taxes and Divorce
Wednesday, Jul. 29 10:00am - 6:00pm
Online
8.00 Credits
Member Price: $239
See more dates
Description: Divorce brings emotional and financial challenges and navigating the tax implications can be one of the most complex aspects. This in-depth, 8-credit webinar, Untying the Knot: Taxes and Divorce, is designed to equip tax professionals with the knowledge and strategies needed to guide clients through the intricate tax issues that arise during and after divorce. What You'll Learn: This comprehensive session will cover critical topics, including: - Filing Status: Determining the correct filing status during and after divorce. - Qualified Domestic Relations Orders (QDROs): Tax implications of dividing retirement accounts. - Back Taxes: Strategies for addressing unpaid tax liabilities during and after divorce. - Offers-in-Compromise & Installment Agreements: Resolving tax debts with the IRS. - Currently-Not-Collectible Status: Understanding when and how to use this option. - Innocent Spouse & Injured Spouse Relief: Protecting clients from unfair tax liabilities. - Lien Discharges & Subordinations: Managing IRS liens on property during divorce. - Reasonable Compensation: Evaluating fair compensation in divorce-related business valuations. - Case Studies: Explore unusual and complex tax issues in divorce through real-world examples. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Leveraging ChatGPT for Innovative Business Advisory Services
Wednesday, Jul. 29 10:30am - 12:30pm
Online
2.00 Credits
Member Price: $89
See more dates
In this cutting-edge course, participants will gain a deep understanding of how to leverage ChatGPT, OpenAI's powerful language model, to innovate and enhance business advisory services in the accounting sector. The course integrates theory and practice, demonstrating how various enterprise evaluation methodologies can be applied in conjunction with ChatGPT for increased business analysis efficiency, profitability, and growth. It also provides hands-on training for implementing these techniques in real-world scenarios. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Unlock the Power of AI with Copilot in Excel
Wednesday, Jul. 29 11:30am - 1:30pm
Online
2.00 Credits
Member Price: $89
See more dates
In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
The Best Individual Income Tax Update Course by Surgent
Wednesday, Jul. 29 11:30am - 7:30pm
Online
8.00 Credits
Member Price: $299
See more dates
This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that will serve their ever-evolving needs. This course is continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BFTU.
More Dates
2026/27 Not-for-Profit GAAP Update
Wednesday, Jul. 29 12:00pm - 1:00pm
Online
1.00 Credits
Member Price: $55
See more dates
Stay current on the latest accounting developments affecting not-for-profit organizations with this timely GAAP update. This course reviews recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline. The course also introduces the International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025. Participants will gain perspective on the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. This course is designed to help practitioners, financial leaders, and auditors of not-for-profit organizations understand both current GAAP requirements and emerging global developments shaping the future of nonprofit financial reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Ethics and Technology for CPAs
Wednesday, Jul. 29 12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Explore the ethical principles included in the Code of Professional Conduct that address the emerging practice issues created by new technologies. Consider how technologies may impact audit quality and the integrity of the financial systems, and whether they create a need for CPAs to adjust their skill sets to address those challenges. Look at the potential ethical challenges created by the data related to privacy, security, and its application. Discuss the changes being proposed to address emerging ethics challenges. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
The CFO Who Went to Prison
Wednesday, Jul. 29 12:30pm - 2:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Joshua, a CFO from Chicago, did not go to prison for stealing the $2 million in liquid cash he had access to on a daily basis. Instead, Joshua ended up in prison by rationalizing that he was entitled to a few small perks of the profession. This course explores Joshua's story and covers how and why executives with high annual incomes make short-sighted decisions that can cost them their job and freedom. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
AICPA's New SSTS #4 - New Ethics Standard for Tax Resolution
Wednesday, Jul. 29 1:00pm - 2:00pm
Online
1.00 Credits
Member Price: $55
See more dates
This 1-hour course is designed for CPAs and EAs who want to stay ahead in the ever-evolving field of tax resolution. Dive into the latest updates to the AICPA Statements on Standards for Tax Services (SSTS) #4 and explore their practical implications for your practice. Through real-world examples and case studies, you'll gain a deeper understanding of how to navigate ethical challenges while maintaining compliance with professional standards. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Top 10 Celebrity Estate Mistakes and How to Avoid Them
Wednesday, Jul. 29 1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
This course uses the lives of the rich and famous as a template to better understand the realm of estate planning. With stories ripped from the headlines, we will examine pitfalls and best practices. Did you know that Prince died without a will, opening the door for 45 people claiming to be his beneficiaries? Or that Michael Jackson was not careful in properly funding his trust, leading to delays and legal battles in the administration of his estate? Even Abraham Lincoln, it turns out, did not have a will. In discussing an array of celebrities, from Jackie Kennedy, Joan Rivers, Jimi Hendrix, and Whitney Houston to Aretha Franklin, Barry White, Leona Helmsley, and Florence Griffith Joyner, the course is designed as an enjoyable learning experience with tips for all levels of expertise. We may not have their fame or fortune, but we can certainly walk the red carpet when it comes to estate planning.
More Dates
Surgent's Mastering Accounting for Income Taxes
Wednesday, Jul. 29 1:00pm - 4:30pm
Online
4.00 Credits
Member Price: $159
See more dates
Since its inception nearly 30 years ago, many have continued to struggle with applying the current model for accounting for income taxes, ASC 740. But this does not have to be you. This course will provide you with the basic knowledge necessary to understand the complexities of this challenging topic. Through discussions and the use of exercises, this course will analyze the authoritative literature to provide a thorough understanding of such topics as deferred taxes, income tax expense, uncertain tax positions, and other classification and disclosure requirements. We will also explore some specialized areas of income tax accounting, such as intraperiod allocations of income tax expense, global minimum tax developments, and the financial reporting impact of the One Big Beautiful Bill Act (OBBBA) signed into law in July 2025, and review finalized and emerging updates to ASC 740, including expanded disclosure requirements under ASU 2023-09. In summary, this course is the place to be to enhance your accounting for income taxes IQ.
More Dates
Complete Guide to Analyze Data with Excel PivotTables
Wednesday, Jul. 29 1:00pm - 5:00pm
Online
4.00 Credits
Member Price: $149
See more dates
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
AI and Accounting in Retail
Wednesday, Jul. 29 2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $89
See more dates
This course provides a concise overview of how artificial intelligence (AI) is transforming financial strategies, tax compliance, and audit practices in the global retail industry. As retailers deploy AI to personalize customer experiences, automate inventory, and optimize pricing, accounting professionals must adapt to new challenges in data integrity, regulatory compliance, and financial reporting. Drawing on real-world case studies from retail giants and small businesses alike, this course explores how AI technologies intersect with accounting workflows and outlines strategies to maintain accuracy, trust, and control in an AI-driven marketplace. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Business Writing: Professional & Effective Emails
Wednesday, Jul. 29 2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Good writing is good business. Studies show that the average business worker receives 121 emails per day. That's a lot of emails. Are your emails effective? Are they being read? Are they professional and tone-smart? In this course, you will learn techniques and skills to get your emails to stand out and improve their effectiveness and professionalism.
More Dates
What's Behind the Data?
Wednesday, Jul. 29 2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $89
See more dates
We are bombarded with information continually. So how do we determine what is valid and what isn't? This course points out common pitfalls inherent in data interpretation and gives practical tips to overcome those pitfalls by using real life examples. The course incorporates information from key thought leaders including Adam Grant, Alex Edmans, and Hans Rosling. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Agentic AI for CPAs: Automate Workflows with Intelligence
Wednesday, Jul. 29 3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $89
See more dates
The newest evolution of AI technology is Agentic AI. This technology enables you to deploy AI agents to take action on your behalf and execute tasks. Agentic AI is the key enabler to using AI technology to automate your workflows. Learning how to take advantage of AI agents provides a substantial competitive advantage. This course will teach you the fundamentals of agentic AI and how you can put them to work in your firm or business. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Improve Spreadsheets by Building Controls in Excel
Wednesday, Jul. 29 3:30pm - 5:30pm
Online
2.00 Credits
Member Price: $89
See more dates
In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
How to Audit Inventory
Wednesday, Jul. 29 4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Inventory observations are often a right of passage for audit staff. This course will cover the basics of auditing inventory, including the related audit assertions, risks, & threats to inventory. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through how to conduct a physical inventory observation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Schedule K-1: What Is It and What Do I Do with It?
Thursday, Jul. 30 9:00am - 11:00am
Online
2.00 Credits
Member Price: $89
See more dates
This seminar offers a practical and in-depth exploration of IRS Schedule K-1, a critical reporting document issued to taxpayers with interests in pass-through entities such as Partnerships, S Corporations, and Estates or Trusts. Participants will gain a clear understanding of how to interpret and accurately report Schedule K-1 data on Form 1040, with emphasis on common income, deduction, and credit items. The course also demystifies the Qualified Business Income (QBI) Deduction, including eligibility criteria, reporting mechanics, and integration with K-1 data. Key compliance topics-such as basis and loss limitations, material participation rules, and passive activity considerations-will be addressed through practical examples. In addition, attendees will be briefed on recent developments affecting Schedules K-2 and K-3, ensuring they are equipped to navigate evolving international reporting requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Government and Nonprofit Frauds and Controls to Stop Them
Thursday, Jul. 30 9:00am - 12:30pm
Online
4.00 Credits
Member Price: $159
See more dates
The cost of fraud, dearly paid by governments and nonprofits, is too severe to not learn from past experiences. This course examines real-world fraud cases to uncover the lessons they provide and translate them into practical, preventive controls. Using a highly illustrative and innovative format, the course engages participants with over 15 focused exercises designed to build a strong working knowledge of fraud risks and effective anti-fraud controls. Whether you are an auditor or an industry professional, you'll gain actionable strategies to strengthen oversight, reduce vulnerabilities, and safeguard your organization.