CPE Catalog & Events
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Webinar
2.00 Credits
Member Price: $99
Creating a data model/Power Pivot Building PivotTables from multiple tables Creating Measures Using named sets
Viewing A&A Through the Eyes of a Tax Practitioner
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:The role of financial reporting for a myriad of usersFundamentals conceptsSpecial Purpose FrameworksFinancial statement analysisCross-functional collaboration
ACPEN: Just Ask Why - Searching for Answers: Generating Solutions
-
Webinar
4.00 Credits
Member Price: $149
The basic benefits of why The 5-15 report Curiosity and creativity
Fraud, Controls & Ethics: Best Practices & Case Studies
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this course include:Examination of actual fraudsDiscussion of internal controls that could have prevented fraudsContemplation of epiphanies for your own professional scenarios.The AICPA Code of Professional ConductOther elements of professional conduct and compliance with professional standards
AI in Action: Your First Steps to Smart Adoption
-
Webinar
1.00 Credits
Member Price: $49
Understand the three stages of AI adoption and where you are today. Practical AI Tools in action (e.g., LLM Models, AI workflows, AI Agents). Quick Wins agnostic of function: How AI can support daily tasks. Your 30-Day AI Plan: Practical guide to help you define areas to apply AI immediately. Confidence to Experiment: Tips to overcome fear and start building momentum in your team.
Smart Formula Selection in Excel: What to Use When
-
Webinar
2.00 Credits
Member Price: $89
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
Controls to Secure the Growing Digital Footprint
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this course include:Securing individual documentsProtecting information resident in the CloudSecuring data stored on or accessed by mobile devices
ACPEN: The Value of Conflict
-
Webinar
1.00 Credits
Member Price: $39
Conflict resolution
ACPEN: Global Internal Audit Standards (GIAS) Domain II – Part 2
-
Webinar
2.00 Credits
Member Price: $89
Internal Audit Standards GIAS Accounting Internal Controls
Becoming Conflict Competent
-
Webinar
2.00 Credits
Member Price: $89
Major topics covered in this course include:Levels of conflictStrategies to de-escalate conflictDistinction between miscommunication and conflictResponses to conflictTactics to address, rather than avoid, conflict
Surgent's Social Security: Dispelling Common Myths with Essential Truths
-
Webinar
2.00 Credits
Member Price: $119
Will Social Security be there for me? How is my benefit calculated? Can I claim my benefit and work too? When do I stop paying Social Security taxes? Why does my government pension cause my benefits to be reduced? Can I claim spousal benefits now and my own later? What is my breakeven? Can I claim benefits from my ex-spouse? What do you mean I may pay taxes on my income benefits? … and more!
The CFO Who Went to Prison
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:The importance of valuesIdentifying successEthical dilemmasMitigation strategiesCreating tools to help make better decisionsPersonal accountability strategies
Surgent's Advising a Client Regarding the Tax Consequences Associated with Buying or Selling a Business
-
Webinar
3.00 Credits
Member Price: $149
Due diligence checklist items Asset sales and stock sales and their attendant results to buyers and sellers Section 1060 and the residual method Selling sole proprietorships, partnerships, and corporations Consequences of making a Section 754 election with adjustments under Sections 743(b) and 734(b) Section 338 and Section 338(h)(10) elections Allocating some of the purchase price of a business to personal goodwill Partnership distributions to retiring partners under Section 736(a) and 736(b) Consulting agreements and employment agreements as between buyers and sellers Advantages of a C corporation having Section 1202 stock
ACPEN: Achieving Balance in Work and Life - Part 2
-
Webinar
4.00 Credits
Member Price: $149
Why we get off balance and how to overcome those tendencies Methods that turbo charge motivation, health and happiness The power of culture and friends to affect our lives The importance of clear intention in order to effect change that lasts
ACPEN: Excel Essentials for Today’s Accountant: How To Become an Expert in One Day
-
Webinar
4.00 Credits
Member Price: $149
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis Awareness of advanced functions Creative methods for data manipulation Using intellectual curiosity and professional skepticism to develop a problem-solving mentality Real-life examples of innovative ways to analyze and report data with Excel Using Excel to perform e-mail merges Enhance creativity in your approach to developing Excel models Computer software and application
ACPEN: Real Estate Tax Issues: Passive Activity, Self-Rental and Section 199A
-
Webinar
4.00 Credits
Member Price: $149
Integration of the real estate professional rules with reporting on Form 1040, Schedule E Real estate professionals and indirectly owned (partnerships, S corporations) entity's reporting on Form 1040 How "real estate business" is interpreted under the Section 199A rules and how it integrates with the passive activity rules Real estate professionals and the Form 8582 (Passive Activities) How to make the "grouping" election for passive activities and the flow-through deduction Definition of self-rental property - both for Sections 199A and 469 Reporting using Form 1040, Schedule E, page 1 and 2 Self-rental property and the Form 8582 (passive activity)
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The rules of IRS disclosure of tax informationUnderstanding the role of IRS transcriptsInterpreting the actions of the IRS in transcriptsFOIA requestsAnalyzing tax information and returns for financial leads
What's Behind the Data?
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Ways in which data and information can be misleadingCommon pitfalls when encountering dataHow to re-evaluate the data to avoid those pitfalls
ACPEN: Internal Control Frameworks for Single Audit
-
Webinar
1.00 Credits
Member Price: $39
COSO 2013 Update Yellowbook Accounting
ACPEN: 2026/27 Single Audit Update
-
Webinar
1.00 Credits
Member Price: $39
2024 Uniform Guidance overhaul Increase in Single Audit threshold to $1 million Audit planning and execution impacts 2025 AICPA GAS/Single Audit Guide (Appendix B) updates Audit efficiency and compliance considerations