Professional Development and Event Catalog
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.
More Dates
Surgent's Current Issues in Accounting and Auditing: An Annual Update
9:00am - 12:30pm
Online
4.00 Credits
Member Price: $159
See more dates
Designed for accounting, auditing, and attestation practitioners at all levels in public accounting and business and industry, this course provides a detailed review of the multitude of FASB and AICPA standards and reports issued over the past few years, including a discussion of the FASB's Stage 3 PIR report on ASC 606. It also provides an overview of recent PCAOB inspection report findings and SEC rulemaking activity. Through hands-on examples and illustrations, this course will help you apply the guidance in practice. We further discuss other important A&A practice matters to be aware of, including an update on the quality management standards and soon-to-be-effective requirements for engagement quality reviews.
More Dates
Building Security and Efficiency with Internal Control
9:00am - 5:00pm
Online
8.00 Credits
Member Price: $239
See more dates
A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider this session. 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: Giving Thanks - How to Master the Art of Gratitude
9:30am - 11:30am
Online
2.00 Credits
Member Price: $89
See more dates
How grateful are you? In this critically important webinar, we will explore exactly what gratitude is and why it is a crucial component of your work as a CPA. Even if you believe you're already a deeply grateful person, you'll still learn some new strategies for expressing gratitude effectively. Forbes Contributor Bruce Weinstein, The Ethics Guy, will show you how to use LinkedIn in a novel way to say "thank you." You'll also find better and worse ways of letting clients, team members, family members and friends know that you care about them. You'll understand why gratitude is a matter of ethics and not merely etiquette. Finally, you'll discover how to use questions about gratitude in job interviews and performance reviews. Why not hire and promote people who are not only knowledgeable and skilled but also grateful? You will be thankful for having taken this valuable webinar! 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
Fundamentals of Form 1040 - Business
9:30am - 1:30pm
Online
4.00 Credits
Member Price: $149
See more dates
This course builds on the foundational knowledge from Part 1, Fundamentals of the 1040 - Core Concepts. It expands into business income taxation and additional reporting requirements. Participants will learn how to accurately report self-employment income, income from pass-through entities on Form 1040. This course covers Schedule C, Schedule E, and essential forms such as Form 7203 and Form 7217 to ensure accurate tax preparation for clients with business activities. 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
Forgotten Managerial Accounting Tools for CPAs
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $89
See more dates
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! 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
Partnership/LLC Taxation: Tax Basis Capital Accounts
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $89
See more dates
This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.