CPE Catalog & Events
The 10 Must Know Excel Features
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
ACPEN: Don't Be Spooked: Mastering Conflict Resolution
-
TBD
1.0 Credits
Member Price: $39
Employee relations Conflict resolution
Overcoming Tech Adoption Challenges in CPA Firms
-
TBD
0.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: Five critical technology adoption challenges facing CPA firms today Digital maturity assessment models and implementation frameworks AI integration strategies for tax, audit, and advisory services Cybersecurity considerations and risk management protocols Case studies of successful technology transformations in accounting firms
ACPEN: Emerging Risks and Resilience - How Accountants and Finance are Leading the Way - Part 2 Technology Disruption, Artificial Intelligence an
-
TBD
1.6 Credits
Member Price: $79
Artificial Intelligence Emerging Risks for Acccountants and Finance Cybersecurity Risks
ACPEN: State Tax Nexus: Frequently Awkward Questions
-
TBD
2.0 Credits
Member Price: $89
Frequently asked questions about income tax and sales tax nexus New developments Key factors in reviewing potential nexus consequences Nexus road trip to eight large states Tax impacts of remote work Free, multistate resources
ChatGPT and Advanced Financial Analysis for Accountants
-
TBD
0.0 Credits
Member Price: $89
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
Ethics in the Real World 26-27
-
TBD
4.0 Credits
Member Price: $175
Why model codes of ethics fail The science behind organizations "Ethical DNA" Understanding the psychology behind "Tone at the Top" The interaction between critical thinking and ethics Breaking myths about motivation related to decision-making Ethical decision-making under pressure Are ethics and morals "fixed" or can we learn to improve
Comprehensive Pass-Through Owners” Basis and Distribution Rules 26-27
-
TBD
8.0 Credits
Member Price: $329
Understand the four loss limitation rules applied on the owner's individual income tax return (i.e., basis, at-risk, passive, and excess business loss limitations) Determine how to calculate an owners" initial tax basis of his pass-through entity Learn how to correctly make annual adjustments to a pass-through owners" tax basis Identify what constitutes a debt basis for an S corporation shareholder Learn the tax ramifications of repaying loans to S corporation shareholders
K2's Excel PivotTables For Accountants 26-27
-
TBD
8.0 Credits
Member Price: $329
PivotTable fundamentals, including Recommended PivotTables and the six elements of PivotTables Formatting PivotTables Advanced PivotTable techniques and options, including consolidation PivotTables, Power Pivot, and Power Query Analytical techniques available in PivotTables
Retirement Advising: Accumulation and Decumulation Strategies 26-27
-
TBD
8.0 Credits
Member Price: $329
The downside of traditional retirement asset accumulation strategies Threats to a successful retirement Holistic retirement planning: how personal goals integrate with tax, estate, risk, and investment management principles Matching investment assets with the appropriate retirement plan and distribution strategy Review recent legislation, including the changes for seniors in the One Big Beautiful Bill and the provisions of the SECURE Acts, and how they will impact retirement planning
CFO Solutions to IRS Problems
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:The authority of IRS in assessing and collecting taxes.The common misconceptions when dealing with IRS.Common questionable actions by business owners.How to prepare for an IRS audit.The seven options in IRS collections.Possible criminal tax violations by CFOs and small business owners.
Executive Presence, Personal Brand: Structure Your Narrative
-
TBD
1.0 Credits
Member Price: $55
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: Embracing Neurodiversity in the Workplace
-
TBD
1.0 Credits
Member Price: $39
Neurodiversity
ACPEN: Emerging Risks and Resilience - How Accounting and Finance are Leading the Way - Part 3: Blockchain and Financial Risks
-
TBD
1.2 Credits
Member Price: $39
HR Talent Blockchain Corporate Social Responsibility Financial Exposure Currency
ACPEN: Resolving Ethical Dilemmas—You Make the Call
-
TBD
1.5 Credits
Member Price: $79
Ethical frameworks Threats and safeguards to objectivity and independence
ACPEN: Global Internal Audit Standards (GIAS) Domain V - Part 2
-
TBD
1.0 Credits
Member Price: $89
Internal audit Standards Institute of Internal Auditors GIAS IPPF
ACPEN: Scared Straight: White Collar Crime and Beyond
-
TBD
2.0 Credits
Member Price: $89
Fraud Prevention Accounting Business Ethics
ACPEN: K2’s CRM – The Ultimate Business Automation Tool
-
TBD
2.0 Credits
Member Price: $89
Overview of CRM functionalities tailored to accounting, including customizations and integrations Integrated tools that leverage CRM data for automating tasks and improving efficiency Strategies for successfully adopting a CRM platform and solutions to overcome common challenges
ACPEN: Big Picture Mega-Trends, Big Data, and World We Now Face
-
TBD
2.0 Credits
Member Price: $89
On-going world economic trends Demographic changes and their impact on the economy Global technology influences Post Covid workplace Big data understanding and where is it going Learn to adapt to changing situations
ACPEN: Independence Requirements for Auditors
-
TBD
2.0 Credits
Member Price: $89
AICPA Code of Professional Conduct independence requirements Core independence principles for CPAs in public practice Common independence risk areas PEEC ethics interpretations affecting independence Real-world application of independence guidance Practical compliance and implementation strategies Independence considerations in attest engagements