Professional Development and Event Catalog
This will generate a PDF of the current filtered catalog
Surgent's Use the Data Model to Build More Powerful PivotTables
Monday, Apr. 19 1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
More Dates
Just Ask Why - Searching for Answers: Generating Solutions
Monday, Apr. 19 1:00pm - 4:34pm
Online
4.00 Credits
Member Price: $149
See more dates
Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect.
More Dates
Fraud, Controls and Ethics: Best Practices and Case Studies
Monday, Apr. 19 1:00pm - 5:00pm
Online
4.00 Credits
Member Price: $149
See more dates
This course explores actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters from achieving their nefarious acts. Then we will switch gears to an interactive, case-based discussion that asks participants to reach their own conclusions by analyzing facts in concert with the AICPA Code of Professional Conduct and other sources of ethical guidance. This course ultimately provides practical, action-oriented insight that can be implemented by accounting professionals in both public practice and industry. This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.
More Dates
AI in Action: Your First Steps to Smart Adoption
Monday, Apr. 19 1:30pm - 2:30pm
Online
1.00 Credits
Member Price: $49
See more dates
This session is your practical introduction to AI in the workplace. Designed for professionals in any function from Finance to HR to Marketing and Operations, this course breaks down the AI journey into clear, actionable steps. You'll discover easy-to-use tools, see real-world examples, and leave ready to take your first confident steps toward using AI to save time, boost creativity, and make smarter decisions. Whether you're new to AI or just looking to get started effectively, this session helps you move from curiosity to confident action in just one hour.
More Dates
Smart Formula Selection in Excel: What to Use When
Monday, Apr. 19 1:30pm - 3:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Excel gives you multiple ways to solve the same problem - but which formula is the right one? This course teaches a decision-based approach to function selection, helping you confidently choose between similar and competing functions. Through real-world examples and side-by-side comparisons, you'll learn when IFS or SWITCH is cleaner than nested IFs, how SUMPRODUCT can help with complex summarizing data, how to use LET in place of defined names, and much more. Ideal for professionals who want to make smarter, faster formula choices that are easier to maintain and audit. 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
Global Internal Audit Standards (GIAS) Domain II – Part 2
Monday, Apr. 19 2:00pm - 3:48pm
Online
2.00 Credits
Member Price: $89
See more dates
The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service
More Dates
Becoming Conflict Competent
Monday, Apr. 19 2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. 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 Social Security: Dispelling Common Myths with Essential Truths
Monday, Apr. 19 2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $119
See more dates
For roughly 90% of American retirees, Social Security income will be the foundation of their retirement income. Yet, many are ill-prepared and lack understanding of the critical aspects of making an informed claiming decision. Further challenged to separate fact from fiction, consumers crave accurate information from knowledgeable professionals to make the most out of these coveted monthly benefits. This course dispels common myths about Social Security that lead to confusion and replaces them with the truth to an empowered retirement. Help your clients navigate their claiming age decisions with greater confidence, equipped with the essential truths they should consider before pushing the Social Security "on" button.
More Dates
The CFO Who Went to Prison
Monday, Apr. 19 2:00pm - 4:00pm
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
Surgent's Advising a Client Regarding the Tax Consequences Associated with Buying or Selling a Business
Monday, Apr. 19 2:00pm - 5:00pm
Online
3.00 Credits
Member Price: $149
See more dates
Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Accounting and finance professionals who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.
More Dates
Achieving Balance in Work and Life - Part 2
Monday, Apr. 19 2:00pm - 5:37pm
Online
4.00 Credits
Member Price: $149
See more dates
In trying to achieve life balance, various internal and external obstacles arise. In this course we will look at these obstacles and provide specific ways to overcome them. In addition, we will look at how to excel in every area of your life including your relationships, finances, sense of purpose, level of happiness, and your physical health and leisure time pursuits. You will leave this course with powerful methods and a specific plan to move forward in your life in a balanced, healthy, and productive manner. Don't forget to take Part 1 of this amazing course.
More Dates
Excel Essentials for Today’s Accountant: How To Become an Expert in One Day
Monday, Apr. 19 2:00pm - 5:42pm
Online
4.00 Credits
Member Price: $149
See more dates
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information and dive into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.
More Dates
Forensic Accounting: Finding Hidden Treasure in Tax Returns
Monday, Apr. 19 2:00pm - 6:00pm
Online
4.00 Credits
Member Price: $149
See more dates
Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. 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
What's Behind the Data?
Monday, Apr. 19 2:30pm - 4:30pm
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
Internal Control Frameworks for Single Audit
Monday, Apr. 19 3:00pm - 3:57pm
Online
1.00 Credits
Member Price: $39
See more dates
The Uniform Guidance identifies COSO and the Green Book as best practices for internal controls in governmental audits. This course provides a comprehensive review of the COSO framework, including its 2013 update, and explores its application to the Green Book. Attendees will learn to recall the five components and 17 principles of internal control, understand the benefits of adopting internal control frameworks, and recognize the rationale behind the COSO 2013 update and its impact on auditing practices. Additionally, the course will cover how to leverage Part 6 of the Compliance Supplement to effectively document internal controls.
More Dates
2026/27 Single Audit Update
Monday, Apr. 19 3:00pm - 4:00pm
Online
1.00 Credits
Member Price: $39
See more dates
Stay current on significant developments affecting Single Audits with this focused update on recent regulatory and professional guidance. This course reviews the 2024 Uniform Guidance overhaul, including the increase in the Single Audit threshold to $1 million and other changes impacting audit planning and execution. The course also examines Appendix B of the 2025 GAS/Single Audit Guide issued by the AICPA, highlighting updates that affect audit efficiency and compliance considerations. In addition, participants will receive updates on recent guidance issued through Office of Management and Budget (OMB) memoranda, as well as reporting-related changes, including the transition from the Federal Audit Clearinghouse's prior systems to SAM.gov-based reporting. This course is designed to help auditors understand how these developments affect Single Audit requirements and what to watch for as expectations continue to evolve.
More Dates
The Hardest Ethical Dilemma! Why Revenge Will Always Backfire, featuring Bob Mims and Don Minges
Monday, Apr. 19 3:00pm - 4:06pm
Online
1.00 Credits
Member Price: $39
See more dates
We believe in fairness. When others do wrong, and their action hurts us - the natural reaction is to fight back and seek retribution. Simple human nature and we are all human. We want fairness and want to fight back, but this is one of the toughest ethical dilemmas we all face. What should we do and what we do are not always the same. What if being nice, or specifically being a positive best version of yourself, makes you a more effective leader? Ethical leadership is effective leadership. That’s what Dr. Cohen, noted psychologist, transformational speaker, executive coach, and author of Be The Sun, Not The Salt, has been teaching organizations to do for years. Dr. Cohen’s work is based on scientific studies of human behavior broken down into simple, easily digestible pillars structured around the Heliotropic Effect. In this webcast we will discuss Dr. Cohen’s path to this work, what the Heliotropic Effect is, and how Be The Sun, Not The Salt is the perfect reminder to Do More of That every day.
More Dates
Section 199A Compliance: Rules and Reporting After OBBA
Monday, Apr. 19 3:00pm - 4:54pm
Online
2.00 Credits
Member Price: $89
See more dates
Section 199A compliance has evolved after OBBA — and so have the risks of getting it wrong. From revised definitions of qualified business income to updated reporting obligations, practitioners must navigate nuanced guidance affecting partnerships, S corporations, and sole proprietorships. Walk away with practical tools, compliance checklists, and calculation frameworks you can apply immediately.
More Dates
Business Tax Update: OBBA and Recent Developments
Monday, Apr. 19 3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $89
See more dates
A discussion of the latest tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts. 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
K2's Choosing Your CPA Firm Tech Stack
Monday, Apr. 19 3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $89
See more dates
In today's fast-evolving landscape, CPA firms face a flood of new tools promising efficiency and innovation. This course helps practitioners assess the real return on investment (ROI) from their technology stack, &-comparing suite-based solutions with best-in-breed applications and examining the latest Agentic AI and Generative AI offerings. Attendees will learn how to evaluate productivity, integration, and strategic alignment to maximize firm performance. Whether upgrading your stack or validating your current tools, this session offers practical insights for tech-savvy decision-making and smarter technology investments tailored to the unique needs of accounting professionals.