CPE Catalog & Events
Smart Formula Selection in Excel: What to Use When
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to Strategic Formula Use:Why choosing the right formula matters: clarity, performance, and maintenanceCommon traps: overusing IF, defaulting to familiar tools, ignoring modern functionsHow Excel offers multiple ways to solve the same problem and how to pick wiselyConditional Logic and Branching Tools:IFS vs SWITCH vs nested IF: comparing readability and structureWhen to simplify logic and how to avoid nested nightmaresSummarizing Data:SUMIFS vs SUMPRODUCT: multiple conditions, weighted sums, totalsFiltering and Output Control:FILTER vs IF + INDEX: dynamic data extraction with vs without Excel 365Trade-offs in backward compatibility and ease of useCustom Output and Decision Trees:CHOOSE vs SWITCH vs LOOKUP: logic trees and category mappingEmbedded Variables and Reusability:LET vs named ranges: clarity and efficiency for long formulasUsing LAMBDA with LET to create custom functionsSimplifying and documenting complex calculationsBest Practices for Formula Selection:Criteria for deciding: readability, flexibility, future maintenanceTips for avoiding overengineering and formula bloat
ACPEN: Leading Up: The Superpower Every Ascending Leader Needs
-
Online
2.00 Credits
The consequences of upward leadership failure. Building credibility with your boss, Serving multiple bosses. Making the business case for your ideas.
ACPEN: Preparation, Compilation and Review Engagements
-
Online
2.00 Credits
Auditing Yellowbook
2026/27 AICPA Regulatory Ethics Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Update on ethics and independence developments from the AICPA Professional Ethics Executive Committee (PEEC)Recent developments shaping ethical requirements for the professionProposed and ongoing projects on PEEC's agenda
ACPEN: The Commonsense Approach to Auditing for Fraud
-
Online
3.00 Credits
Occupational Fraud Professional Skepticism Fraud Indicators Error vs. Fraud Fraud Risk Fraud Hypothesis Development Fraud Intent
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Discuss the impact of the Section 199A flow-through entities deduction on partnerships and their partnersThe meaning of a "tax basis capital account"How the financial accounting and tax capital accounts differ from one anotherDetermine a partner's share of the partnership's liabilitiesDistinguish "recourse" loans from "nonrecourse" loansWhat are "qualified nonrecourse financing" loans and how they affect partnersSection 704 "built-in gain or loss" rules and how they impact Schedule K-1 reportingSection 4655 "at risk" rules and how they impact Schedule K-1 reporting
Executive Presence, Personal Brand: Structure Your Narrative
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Components of executive presenceAudience-centered elevator pitch structureProfessional value proposition frameworkStructuring a concise executive biographyAligning personal narrative with organizational valueCommon pitfalls in professional self-presentationApplication and refinement exercise
ACPEN: Leading Risk Management Practices in a Dynamic Risk Environment - Part 2
-
Online
1.20 Credits
Risk Management
ACPEN: Conflicts of Interest: Dealing With Ethical Dilemmas in Business and Industry
-
Online
2.00 Credits
Do conflicts of interest matter? Are we aware of common conflicts of interest? What does the Code of Professional Conduct require? How to recognize Conflicts of Interest? Ethical issues regarding competence and gifts and entertainment Trade-offs involved in dealing with conflicts of interest? Suggestions on how to avoid conflicts of interest.
Analyzing Financial Statements
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Balance sheet analysisIncome statement analysisCash flow statement analysisClues in the notes and MD&AIndustry nuances
ChatGPT and Advanced Financial Analysis for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Financial Modeling with ChatGPT IntegrationAdvanced Ratio Analysis TechniquesRisk Assessment and Scenario AnalysisValuation Methods and ChatGPT ApplicationsUtilizing Performance Metrics in Financial AnalysisData Analysis and Interpretation with AIInvestment Analysis Enhanced by ChatGPT
Integrate ChatGPT into Your Client Advisory Services-Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:ChatGPT and generative AI technology primerBuilding your generative AI vocabularyDig deeper into your engagement research to develop a higher quality advisory servicePolish your client reporting with the help of ChatGPTDeveloping your ChatGPT client advisory servicesStart with client education. You don’t need to be a technical expert to be an educatorUse AI to help your clients automate their workflows / business processesBuild better spreadsheets with ChatGPT and ExcelHelp your clients identify, evaluate and select applications for their business
Surgent's Ethical Considerations for the CPA
-
Virtual
0.00 Credits
Examine the CPA's role in today's economy Compare similarities and differences between individual and business ethics Explore the link between ethics, integrity and scruples Discuss the basic attributes of ethics and professional conduct Review the history of the CPA profession and the CPA's requirement to adhere to ethics policies and codes of conduct Review the AICPA's Code of Professional Conduct and a CPA's responsibilities to the public, clients and colleagues Discuss the common rules and statutes faced daily in the CPA profession. Case studies may also be utilized to present potential ethical dilemmas CPAs may face during their careers Review CPA Independence violations by current legal case examples
Surgent's A Complete Guide to the Yellow Book
-
Virtual
0.00 Credits
Circumstances requiring auditors to follow the Yellow Book (Government Auditing Standards or GAGAS) Relationship of Yellow Book requirements to GAAS and single audit requirements Auditor qualifications under the Yellow Book: independence, CPE, peer review, and related requirements The Yellow Book requirements related to the performance of and reporting on a financial audit Identifying and reporting findings under the Yellow Book The Yellow Book requirements related to attestation engagements (examinations, reviews, and agreed-upon procedures) and performance audits
Surgent's Form 1040 Return Review Boot Camp for New and Experienced Reviewers
-
Virtual
8.00 Credits
Key provisions of the recent HR 1, One Big Beautiful Bill Act, have been incorpoated throughout the course Review an error-prone "staff-prepared" Form 1040 from client-provided information. Where do you start? Get to know your client and ask the questions Several new reporting issues for the reviewer to consider, including the main credit provisions as enacted under the American Rescue Plan What are common errors preparers make and what are the areas generating malpractice claims? The importance of engagement letters, questionnaires, and §7216 permission statement Initial administrative groundwork Identifying organizing issues in the tax return to be reviewed Avoiding “willful blindness.” Handling ethical and moral dilemmas Efficient review of certain advanced issues for income, adjustments, deductions, and credits Effective procedures for delinquent clients, filing past-due tax returns First-time client issues requiring extra scrutiny Multiple checklists of efficient procedures to identify potential issues on a 1040 return Listing of schedules for staff to prepare to make a review easier, including basis issues for 1040 clients Reconciling time pressure with thoroughness and quality control Professionals acting professionally
The Best Federal Tax Update Course by Surgent
-
Virtual
8.00 Credits
Comprehensive coverage of the One Big Beautiful Bill Act Review of key components of President Trump's tax bill, including a tip income exemption, overtime pay relief, Social Security tax exemption, auto loan interest deductibility, SALT deduction modifications, a lower corporate tax rate, restoration of 100% bonus depreciation, immediate R&D expensing, and permanent extension of select TCJA provisions Tariff policy and implementation - analyze the use of tariffs as a fiscal and trade policy tool Digital assets and tax implications - understand the new Form 1099-DA for reporting digital asset transactions, along with updated IRS guidance on cryptocurrencies, NFTs, and broker responsibilities Artificial intelligence - discover how AI and generative tools are transforming tax practices, as well as how the IRS is leveraging AI to enhance audit selection Form 1099-K reporting requirements - understand the evolving IRS thresholds and rules for third-party payment platforms Sale of Passthrough Entity Interests and Net Investment Income Tax - analyze the tax implications of selling interests in passthrough entities, including relevant examples, and how the Net Investment Income Tax (NIIT) applies to these transactions The Gig Economy - examine key tax implications for gig workers, including Independent Contractor vs. Employee classification challenges, reporting responsibilities, and the impact of the 2024 Department of Labor Final Rule on worker status Timely coverage of breaking tax legislation Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates, retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Untying the Knot: Taxes & Divorce
-
Virtual
8.00 Credits
The major topics that will be covered in this course include: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.
ACPEN: Investment Scam Losses: How to Get Deductions
-
Online
1.00 Credits
Categorization of various scams The keys to deductibility Review of the client's required actions to allow deductibility Disclosures and forms reporting required for deductibility “Tales from the Front” – practice issues CPAs are dealing with in these extraordinary situations
ACPEN: Neurodiversity & Productivity. Include More Minds to Make the Most of Your Time
-
Online
1.00 Credits
Neurodiversity Productivity Leadership Management Communication Inclusion Culture Empathy
ACPEN: Applying the New Expected Credit Loss Model
-
Online
2.00 Credits
Principles behind the new expectation credit loss model Acceptable methods for evaluating expected credit loss for certain financial instruments Enhanced disclosure requirements common for nonpublic entities
