Professional Development and Event Catalog
Surgent's Elder Fraud
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $119
See more dates
When we leave our jobs, we also leave the protection our employer provides us with regards to internet and Wi-Fi security. Hired people may be able to help with the newest applications, but they may not understand the security risks posed. This session will cover some basic information about cybersecurity weaknesses and some of the scams that target older, retired people. Many times, the perpetrator is someone close and someone who we think we can trust. In this course, you will learn some basic tools to protect against those who wish to perpetrate fraud.
More Dates
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $99
See more dates
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
More Dates
Understanding and Creating an Internal Control System
10:00am - 6:00pm
Online
8.00 Credits
Member Price: $239
See more dates
Successful organizations, both large and small, must understand the importance of effective internal controls and be able to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. The material highlights some of the reasons that measures are needed and it also provides an overview of control creation methods. Finally, it discusses ways to successfully implement the developed policies and procedures. Participants that take this course will gain a well-rounded understanding of internal control procedures of all types. 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: Property, Plant, and Equipment
10:30am - 12:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Property, Plant, & Equipment is often one of the largest balances on the financial statements. This course will cover the foundation of auditing PP&E, including the related audit assertions, risks, & threats to the PP&E balance. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through some 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
AI Lessons Learned for Accountants
12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $89
See more dates
This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. 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 New and Expanded Tax Benefits Associated with Section 1202 – Qualified Small Business Stock
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
This program reviews and analyzes the important changes made by the One Big Beautiful Bill Act (OBBBA) to qualified small business stock (QSBS) covered under Section 1202. Effective for stock issued after July 4, 2025, there are important changes that make Section 1202 much more appealing to clients willing to run the risks associated with doing business as a C corporation. These enhanced provisions could potentially lead to exclusion of capital gains if very strict compliance rules are followed. Section 1202 application is particularly attractive for start-ups and entrepreneurial endeavors. For taxpayers willing to confront the technical challenges of this provision, Section 1202 may produce impressive tax advantages.
More Dates
Surgent's Use the Data Model to Build More Powerful PivotTables
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
Fraud, Controls and Ethics: Best Practices and Case Studies
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
Smart Formula Selection in Excel: What to Use When
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
Becoming Conflict Competent
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
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
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
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
Forensic Accounting: Finding Hidden Treasure in Tax Returns
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?
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
Business Tax Update: OBBA and Recent Developments
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
Introduction to Governmental Budgeting
3:30pm - 5:30pm
Online
2.00 Credits
Member Price: $89
See more dates
The introduction to governmental budgeting course is an overview of the typical timeline and process a government uses when creating their annual budget. Topics covered include the basics of governmental budgeting, establishing priorities for the budget, the common steps and timeline of the budget process, what, when and how we should be monitoring the budget throughout the year, and how long-term budgets fit in with the annual budget process. 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 Based Leadership for Women
4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Glantz and Associates is pleased to offer "Ethics Based Leadership for Women," a webinar designed to empower any woman who wishes to consider the privileges, responsibilities and challenges of holding leadership positions. We believe that leadership and ethics are intrinsically connected and will explore women in leadership through an ethics-based lens. The reality is, despite women representing approximately half of our world's population, they are significantly underrepresented in the workforce and most notably in leadership positions. In fact, not only do women have to cross more hurdles to advance into leadership positions, but when they do, they are burning out at a much faster rate than their male counterparts. In this course, we will discuss both the external societal barriers as well as the internal barriers that sabotage women from moving into leadership positions. We will examine common believes ("I should be nice," "I am an imposter", etc.) as well as behaviors that can hold women back and then offer suggestions for moving forward. We will provide tools to enhance one's self-awareness, create openings for self-reflection as well as provide opportunities to take on new perspectives. 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
Corporate Storytelling in Financial Reporting
9:00am - 10:00am
Online
1.00 Credits
Member Price: $55
See more dates
Developments in the Management Commentary and MD&A Narrative reporting is entering a new era-one that moves beyond compliance checklists to focus on cohesive, decision-useful communication. This seminar examines the evolution of corporate narrative reporting through the revised 2025 IFRS Practice Statement 1: Management Commentary and the U.S. GAAP-based MD&A under SEC Regulation S-K, with key comparisons to help practitioners understand how each framework supports investor-focused disclosure. Using real-world examples and excerpts from the actual annual report of an IFRS reporting company, this seminar highlights how the revised Management Commentary guidance aims to improve the quality, relevance, and connectivity of narrative insights. Participants will explore its emphasis on strategy, risks, sustainability factors (ESG), key performance indicators (KPIs), and the integration of financial and non-financial information. The session also analyzes the modernization efforts in U.S. MD&A, including principles-based guidance, reduction of boilerplate disclosures, and expanded expectations for entity-specific analysis and trend-based insights. Through a comparative approach, participants learn how both frameworks are converging around common principles: enhanced connectivity, balanced presentation, entity-specific content, and alignment of strategy, performance, risk, and value creation. This practical seminar provides accounting, finance, and business professionals with the knowledge needed for better understanding the management commentary and MD&A. 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
Governmental Accounting and Auditing Group Meeting (Virtual)
9:00am - 10:00am
Online
0.00 Credits
See more dates
The Governmental Accounting and Auditing Committee meets to discuss developments, new regulations, and compliance issues in the field of governmental accounting and auditing. Group members include both public sector finance professionals and those who serve them in public accounting. Members also assist with planning the governmental accounting and auditing track at our MEGA Accounting and Auditing Conference held in June. A meeting agenda will be sent one week prior to the meeting date.This will be a virtual meeting via Zoom meetings. If you register for this meeting via our website, please see https://www.ctcpas.org/my-cpe/upcoming to launch the Zoom meeting.