CPE Catalog & Events
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
Ethics, AI, and Music: What Every CPA Must Know
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include: Four key aspects of artificial intelligence that are relevant to CPAs: machine learning, generative AI, large language models, and GPT.The role that five powerful principles—the principles of ethical intelligence—play in using AI the right way. Short, focused writing exercises (30 seconds each) designed to deepen understanding of the topic. Real-world case studies about the use of AI in music as well as accountingAnswers to several crucial questions about how to use artificial intelligence with ethical intelligence.
ACPEN: Inventory Accounting GAAP, Software and Recognizing Variances
-
Webinar
2.00 Credits
Member Price: $89
Inventory accounting GAAP Methods for dealing with variances
ACPEN: Assessing Independence Under Yellow Book
-
Webinar
1.00 Credits
Member Price: $39
GAO Yellowbook Ethics
2026/27 Not-for-Profit GAAP Update
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline.The International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025.
ACPEN: K2’s Innovative Strategy And IT Governance
-
Webinar
1.00 Credits
Member Price: $39
Technology evaluation frameworks and selection processes Change management strategies for technology implementation Techniques to increase user adoption, learning, and engagement
ACPEN: Profitability Pricing: Boost your Bottom Line
-
Webinar
2.00 Credits
Member Price: $89
Competitive bids Achieving target profitability
ACPEN: Resolve Ethical Conflicts: Do the Right Thing and Keep Your Job
-
Webinar
2.00 Credits
Member Price: $89
Ethics Resolving Conflict
Ethics: Giving Thanks - How to Master the Art of Gratitude
-
Webinar
2.00 Credits
Member Price: $89
We'll explore what gratitude is and how expressions of it can vary from culture to culture. We'll also unpack several ways you can regularly say "thank you" to valued clients and colleagues, and we'll examine methods for evaluating gratitude in prospective and current employees.
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
Reviewing Individual Tax Returns: What Are You Missing?
-
Webinar
4.00 Credits
Member Price: $139
Qualified business income deduction Temporary senior deduction State and local tax deduction Hobby losses Self-employment health insurance Business startup costs Depreciation Schedule C issues Like-kind exchanges
Building Security and Efficiency With Internal Control
-
Webinar
8.00 Credits
Member Price: $239
The major topics covered in this course include:An overview of control frameworks and conceptsStrategic considerations that can be incorporated into control developmentUnderstanding and controlling risk that arises when organizations change or choose not toThe COSO Internal Control Framework and the COSO ERM Framework
The Best Federal Tax Update Course by Surgent
-
Webinar
8.00 Credits
Member Price: $299
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
The Ethic of Recruitment and Selection
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this course include:Discussion of ethical and effective recruiting strategiesSelection processes that foster diversity and inclusionHow to increase talent pools to ensure hiring success
Forensic Accounting: Investigating Divorce Cases
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The role of a forensic accountant in divorce proceedingsThe marketing of forensic accounting services to family law attorneysHow to conduct a financial investigationCommon areas to uncover hidden assets or incomeThe basic calculations in evaluating marital assetsTestifying in depositions and divorce court
How AI Is Automating Internal Control
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this class include:An explanation of Artificial Intelligence (AI).Specific ways AI is replacing human cognition. What is on the internal control horizon related to AI and other technologies.
ACPEN: Empowering HR Pros' Thriving in 2025 and Beyond
-
Webinar
1.00 Credits
Member Price: $39
Human Resources Business Strategy Wellbeing Professional Development
ACPEN: New Tips and Overtime Tax Rules: Compliance and Best Practices
-
Webinar
1.00 Credits
Member Price: $39
Updated OBBA guidance on tip reporting and allocation Qualifying tip requirements Self-employment and qualified tips Employer and employee tax responsibilities for tipped wages Overtime pay deduction Tip and overtime information returns
ACPEN: Safety Synergy: Uniting Elements for a Secure Workplace
-
Webinar
1.20 Credits
Member Price: $39
How to evaluate physical security Increase situational awareness Simple De-escalation techniques Mental Health awareness Safe Termination Strategy Active Shooter Response Overview
ACPEN: Was It Fraud or Just Poor Audit Quality?
-
Webinar
1.60 Credits
Member Price: $79
Financial statement manipulation Ethics enforcement process Auditor conflicts of interest