CPE Catalog & Events
Mastering the Excel Lookup Functions
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
ACPEN: K2's Dynamic Arrays In Excel
-
TBD
1.0 Credits
Member Price: $39
Differentiating between dynamic arrays and traditional Excel formulas Identifying which functions support dynamic arrays Using dynamic arrays to link data from external data sources
ACPEN: K2’s Better Reporting With QuickBooks Online
-
TBD
1.0 Credits
Member Price: $39
The types of reports available in QuickBooks Online, by subscription level Customizing reports to meet your needs Spreadsheet Sync in QuickBooks Online Advanced
ACPEN: How to Make Difficult People Disappear...Without Breaking the Law
-
TBD
1.0 Credits
Member Price: $39
Conflict Management Interpersonal Relationships Personality Styles
ACPEN: K2's Ten Questions To Ask Your IT Team
-
TBD
1.0 Credits
Member Price: $39
Ten Strategic Question Frameworks for Technology Assessment Cybersecurity and Infrastructure Oversight Through Targeted Dialogue Cloud Governance and Remote Work Technology Evaluation
ACPEN: A Guide to Sampling - Part 1
-
TBD
2.0 Credits
Member Price: $89
Auditing Yellowbook
ACPEN: Considerations of Fraud
-
TBD
2.0 Credits
Member Price: $89
AU-C 240 Auditing Yellowbook
Supervision/Management Competencies: An Ethical Approach
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this course include:Overview of Virtue EthicsMilgram and Zimbardo case studiesNavigating the transition from "Buddy to Boss"Self-Awareness and Regard for OthersSetting Standards and Analyzing PerformanceUnconscious BiasCommunication Skills
Surgent's Unconscious Bias in the Workplace
-
TBD
2.0 Credits
Member Price: $99
Introduction to Unconscious Bias The “5 Things To Know” Framework Schemas and Mental Shortcuts Types of Unconscious Bias Bias in Action: Workplace Impacts Microaggressions and Language The Four Stages of Competence Strategies for Change Tools and Resources
Forgotten Managerial Accounting Tools for CPAs
-
TBD
0.0 Credits
Member Price: $89
The major topics covered in this class include:Target profit analysisBreak-even analysisRelevant costs and decision-makingStandard costs and variancesActivity-based costingSegment reporting and analysis
Navigating IRS Collections: The Collection Process
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of the IRS collection process.Taxpayer rights and the Taxpayer Bill of Rights.Collection due process and appeals.Installment agreements and offers in compromise.Wage garnishments, levies, and liens.Penalties and interest.
ACPEN: Maximizing the Tax Benefits of an Installment Sale
-
TBD
1.0 Credits
Member Price: $39
Installment sale treatment eligibility When to elect out of installment sale treatment Installment sales of business assets Installment sale default and the rules for personal property vs real property Depreciation recapture
ACPEN: Clear, Kind, and Accountable: A Leader’s Guide to Boundaries, Coaching, and Real Conversations
-
TBD
1.0 Credits
Member Price: $39
Conflict Management Difficult Conversations Psychological Safety
ACPEN: Partnership/LLC Taxation: Understanding Tax Basis Capital Accounts
-
TBD
2.0 Credits
Member Price: $89
Discussion of the impact of the Section 199A flow-through entities deduction on partnerships and their partners The meaning of a "tax basis capital account" - how do the financial accounting and tax capital accounts differ from one another How to determine a partner's share of the partnership's liabilities Distinguishing "recourse" loans from "nonrecourse" loans What are "qualified nonrecourse financing" & loans and how they affect partners Section 704 "built-in gain or loss" & ules and how they impact Schedule K-1 reporting Section 465 "at risk" rules and how they impact Schedule K-1 reporting
Exploring Internal Controls That Could Have Prevented Frauds
-
TBD
0.0 Credits
Member Price: $89
The major topics covered in this class include:Examination of actual fraudsDiscussion of internal controls that could have prevented the fraudsContemplation of epiphanies for your own professional scenarios
ACPEN: Wired Differently - An Introduction to Neurodivergence
-
TBD
1.0 Credits
Member Price: $39
Neurodivergence Diversity Inclusion
Workforce Transformation and Talent Management in 2025
-
TBD
1.0 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: Cost and Pricing Models: Boost Your Bottom Line
-
TBD
2.0 Credits
Member Price: $89
Cost Accounting Activity-based Costing
Tax Implications of Retirement Plan Distributions
-
TBD
1.0 Credits
Member Price: $55
The major topics that will be covered in this course include:Required minimum distributions for a deceased’s heirs2025 retirement plan contribution limitsRequired minimum distributions and contributions to charityKey provisions of Secure Act 2.0
ACPEN: Transforming Strategic & Financial Management with ChatGPT - Insights for CPAs, CFOs and Controllers
-
TBD
2.0 Credits
Member Price: $89
Recognize the variety of ChatGPT uses in accounting. Determine how to use ChatGPT. Identify how ChatGPT improves customer, vendor, and industry research. Recognize how ChatGPT aids in financial benchmarking. Identify how ChatGPT can assist in financial analysis, budgeting and forecasting.