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
Numbers to Narrative: Storytelling in Business Communication
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Role of narrative in professional communicationSituation–complication–resolution frameworkNarrative arcs in business contextsIntegrating data within a structured storyDefining tension and resolution logicallyMaintaining accuracy while improving clarityApplication of storytelling framework to a workplace scenario
ACPEN: Emerging Risks and Resilience - How Accounting and Finance are Leading the Way - Part 3: Blockchain and Financial Risks
-
Webinar
1.20 Credits
Member Price: $39
HR Talent Blockchain Corporate Social Responsibility Financial Exposure Currency
ACPEN: Liquidity & Uncertainty Disclosures for Nonprofits
-
Webinar
2.00 Credits
Member Price: $89
Required disclosure related to liquidity and other significant uncertainties for fair presentation of financial statements Evaluating the need for going concern and other uncertainty disclosures in the current environment
ACPEN: Viewing A&A Through the Eyes of a Tax Practitioner
-
Webinar
2.00 Credits
Member Price: $89
The role of financial reporting for a myriad of users Fundamentals concepts Special Purpose Frameworks Financial statement analysis Cross-functional collaboration
Risk Wrangling: Surviving the Modern Business Rodeo
-
Webinar
1.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Risk is the common thread in an evolving landscapeRisk assessmentResponding to assessed risksAuditing standardsOther insights from AICPA guidanceFraud considerationsThe role of analyticsFinancial reporting considerationsRisk mitigation
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Webinar
2.00 Credits
Member Price: $89
GETPIVOTDATA Text Files and Power Query Data Preparation PivotCharts
ACPEN: S Corporation Checkup: Tax Issues & Forms Reporting
-
Webinar
4.00 Credits
Member Price: $149
Discuss the calculation of basis when the entity is formed including the impact of contributed property Explain the importance of shareholder loans to the entity Uses a comprehensive example to illustrate the mechanics of the basis determination process Schedules K-2 and K-3 Discuss how basis is impacted by distributions of corporation property Explain how basis is impacted by sale/or liquidation of the S corporation interest S corporation losses and how they impact Form 1040 Schedule E reporting Show how to get from the Schedule K-1 information to the basis calculations Comprehensive example to illustrate the mechanics of the basis determination process
Business Tax Update: OBBA and Recent Developments
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Recent legislation impacting business taxpayersThe One Big Beautiful Bill ActExtenders legislation updateMeals and entertainment expense reportingPartnership and S corporation updateIncome and deductions
ACPEN: Tricks and Treats to Avoid Litigation
-
Webinar
1.00 Credits
Member Price: $39
Key concepts of effective employee relations Balancing employee and employer rights Handling employee complaints Addressing personality & attitude problems
Workforce Transformation and Talent Management in 2025
-
Webinar
1.00 Credits
Member Price: $55
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Understanding why the traditional pyramid structure is failing firms The inverted pentagon framework and its talent retention advantages Impact of technology and AI on entry-level accounting roles The 6 Ps of Business Model Transformation implementation Accelerating specialized skills acquisition in your workforce Effective knowledge transfer through mentorship and job rotation Technology-driven training and development strategies Best practices from other industries for workforce transformation Building and retaining specialized middle layers of expertise Strategic pricing models to support the pentagon structure
ACPEN: How to Audit Prepaid Expenses
-
Webinar
2.00 Credits
Member Price: $89
Pre-paid Expenses Auditing Yellowbook
ACPEN: Emerging Risks and Resilience - How Accounting and Finance are Leading the Way - Part 4: Managing Supply Chain Risks, Data Analytics, and
-
Webinar
2.00 Credits
Member Price: $89
Third-party risks Supply chain Data analytics Risk management Operational resilience
ACPEN: Internal Controls That May Have Prevented Fraud
-
Webinar
2.00 Credits
Member Price: $89
Understand what factors allowed certain frauds to occur Recognize what internal controls may have prevented the frauds Consider application of these lessons to circumstances you encounter in your professional endeavors
ACPEN: Mergers and Acquisitions: Complete Guide to Relevant Issues
-
Webinar
2.00 Credits
Member Price: $89
Taxable asset acquisitions vs. non-taxable stock/equity acquisitions What happens in an asset acquisition What happens in a stock or equity acquisition 338 and 336 elections Basics of 382 Basics of 280G Earnouts and contingent payments Assumed liabilities Acquired reserves Acquired deferred revenue Treatment of transaction costs Basics of mixed entity transactions, examples such as: C-Corp buys an interest in a partnership C-Corp buys an S-Corp C-Corp buys an interest in an LLC (lots of possibilities here) S-Corp buys a partnership S-Corp buys a C-Corp S-Corp buys an interest in an LLC Partnership acquisitions of various entity types Very basic overview of tax-free re-organizations High level overview of entity formations High level overview of entity liquidations or termination
ACPEN: K2's AI: Real Tools, Real Results
-
Webinar
2.00 Credits
Member Price: $89
Practical AI tools and applications in accounting and finance Implementation strategies and ethical considerations Measuring results and ROI from AI adoption
ACPEN: K2's Tech Tuneup Tips
-
Webinar
2.00 Credits
Member Price: $89
Technology Tuneup Mindset. Identifying small technology changes that deliver outsized productivity and reliability gains Workstation and Device Optimization. Improving performance, stability, and usability of desktops, laptops, and mobile devices Software and Application Efficiency. Leveraging built-in features, reducing tool overlap, and improving day-to-day application usage Workflow and Collaboration Improvements. Streamlining email, file management, task visibility, and team collaboration
Microsoft 365 for CPAs: Unlocking Hidden Productivity Tools
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Round robin review of lesser known M365 appsReduce / eliminate internal email communications with Teams and SharePointCollaborate on spreadsheet and documents with your colleagues in real timeGet control of your appointment schedule with the Bookings appTap the full potential of OneNote as your primary repository for notes, correspondence and moreReplace email attachments with secure file sharing linksDocument business processes with the Stream appLeverage the power of AI in M365 with Copilot
Surgent's Exploring Business Valuation Fundamentals
-
Webinar
2.00 Credits
Member Price: $119
What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models
ACPEN: Taxation of Judgements and Settlements
-
Webinar
2.40 Credits
Member Price: $99
Types of damages or remedies that can be awarded or agreed upon pursuant to litigation. Review of the Internal Revenue Code and regulations governing the taxation of various types of litigation payments. Suggestions for drafting pleadings or settlement agreements.