CPE Catalog & Events
Complete Guide to Analyze Data with Excel PivotTables
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
NotebookLM Use Cases for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:NotebookLM fundamentals: notebooks, sources, prompts, and outputsTurning financial PDFs into searchable, conversational knowledge basesAudit and assurance use cases: workpaper synthesis and issue trackingTax and regulatory research: comparing guidance across sourcesCross-referencing: tracing claims back to documents for defensibilityDrafting deliverables: memos, client notes, and executive summariesRisk controls: confidentiality, data handling, and “trust-but-verify” habits
ACPEN: Emotional Intelligence for Professionals: Mastering the Human Side of Success
-
Online
1.00 Credits
Emotions Relationships Emotional Intelligence Communication
ACPEN: K2’s Advanced Topics In Power BI
-
Online
2.00 Credits
Creating formulas in Power BI with Data Analysis Expressions Adding Key Performance Indicators to your Power BI reports and dashboards Managing security in Power BI Publishing your reports and dashboards to Apps and Content Packs for easy sharing with other team members
Smarter Tax Services with Artificial Intelligence (AI) Tools
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of AI technology and how it worksIdentify where AI can be incorporated into tax research, planning, and compliance servicesDiscover new opportunities to enhance your client advisory tax services with AI toolsReview the market of emerging and AI enhanced tax software toolsLearn about the newest generation of AI enable 1040 source document collection and organizer applicationsReview specific use cases for generative AI tools (e.g. ChatGPT, Microsoft Copilot) in your tax services
ACPEN: S Corporation Essentials: Review & Update
-
Online
4.00 Credits
Recent tax legislation, rules, and developments impacting S-corporations S corporation shareholder basis in stock and debt S corporation open account debt Limitation of deduction of losses AAA and distributions
ACPEN: Clear, Kind, and Accountable: A Leader’s Guide to Boundaries, Coaching, and Real Conversations
-
Online
1.00 Credits
Conflict Management Difficult Conversations Psychological Safety
A Working Parent's Guide to Prioritizing Mental Wellness
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Challenging Cultural Expectations and Managing Stress: Explore the impact of societal pressures and develop strategies to counter unrealistic expectations while managing stress effectively.Prioritizing Self-Care and Physical Well-Being: Learn the importance of self-care, including sleep, exercise, relaxation, and setting boundaries, as well as understanding the critical connection between physical and mental health.Seeking Support and Building Resilience: Recognize when to seek help -whether through therapy, friends, or family- and develop skills to build resilience, create flexible work arrangements, and identify when additional support, such as professional intervention, is needed.
ACPEN: The FASB Conceptual Framework
-
Online
2.00 Credits
Purpose and structure of the FASB Conceptual Framework Recognition and derecognition criteria Measurement concepts and approaches Qualitative characteristics of useful financial information Elements of financial statements Footnote disclosure requirements Relationship between the framework and standard-setting Practical application of the framework in accounting decisions
Beyond the Basics: Financial Ratios You Might Be Overlooking
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Understanding Cost Behavior and Its Impact on Decision-MakingContribution Margin and Break-Even AnalysisMargin of Safety and Its Role in Risk ManagementOperating Leverage and Financial SensitivityAnalyzing Asset Turnover for Operational EfficiencyCash Conversion Cycle and Working Capital InsightsFree Cash Flow Yield as a Valuation Tool
ACPEN: Functional Approach to Employee Benefits
-
Online
1.50 Credits
Benefits Benefits Communications Total Rewards
Corporate Storytelling in Financial Reporting
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Purpose of Management Commentary (IFRS): Understanding the foundational objectivesPurpose of MD&A (AAP): SEC-mandated narrative disclosure requirementsHistorical Context: Past and present frameworks and the limitationsRecent Revisions: Key enhancements and ESG integrationPractical Examples: Real-world applications and improvementsConvergence & Guidance: Frameworks, comparisons, and implementation
ACPEN: Avoiding Peer Review Deficiencies and Professional Liability in Public Accounting
-
Online
4.00 Credits
Differentiating risks faced when performing various levels of professional services, such as audits, reviews, compilations, preparing financial statements, bookkeeping, tax return preparation, and similar Best practices for preventing quality control concerns that could lead to peer review deficiencies or malpractice claims Establishing an understanding with the client to minimize misunderstandings as to the nature and scope of engagements Explain situations when independence should be appropriately safeguarded when performing nonattest services
ACPEN: Federal Tax Update – Individual & Business Current Developments
-
Online
8.00 Credits
Discuss the most recent individual and business income tax legislation passed to date Walk through major tax changes to corporations, partnerships and/or individuals and any changes to the income tax forms and other related schedules Review numerous business income tax provisions including but not limited to the 20% qualified business income (QBI) deduction; changes to NOLs, §461(l) business loss limitations, §163(j) business interest deduction limitations, accounting method changes, depreciation, retirement plans, fringe benefits and entertainment expenses Brush up on the individual and business income tax rates (e.g., income tax rates, capital gain tax rates, self-employment tax and alternative minimum tax (AMT), 3.8% net investment income tax) Discuss other individual income tax topics and changes to filing status, personal exemptions, itemized deductions, exclusions from income, adjustments to income and income tax credits (e.g., child tax credit and dependent care credit) Walk through the NEW final required minimum distribution (RMD) regulations Review other important IRS audit areas such as basis and at-risk limitations for S shareholders and partners, passive activity losses and real estate professionals and self-employment taxes
Mastering Partnership Basis: Inside and Outside Basis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Explain the use of both "inside" and "outside” basis determination.How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property.Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis.Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest.Comprehensive example to illustrate the mechanics of the basis determination process.
Microsoft 365 for CPAs: Unlocking Hidden Productivity Tools
-
Virtual
2.00 Credits
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
ACPEN: Third Party Verification (Comfort) Requests- What Are Options for Responding and How to Determine Which Professional Standards to Apply?
-
Online
2.00 Credits
Common third party verification requests Differentiating the allowable options for responding to requests for comfort, including SSARS, SAS and SSAE engagements Critical elements of professional standards that may apply to nonattest and attest services performed Establishing an understanding with the client regarding the nature and scope of services
ACPEN: Tax Practice Ethical Challenges and Circular 230
-
Online
2.00 Credits
Circular 230 (IRS) rules for conducting a "best" tax practice How to avoid tax return preparation penalties Recent developments impacting today's tax practice Review of tax return preparer's registration rules Explanation of the revised AICPA Code of Professional Conduct Contingent fees
Compilation, Preparation and Review Basics and Peer Reviews
-
Virtual
2.00 Credits
The major topics covered in this class include:Basic requirements included in AR-C Section 60, General Principles; AR-C Section 70, Preparation of Financial Statements; AR-C Section 80, Compilation Engagements; and AR-C Section 90, Review of Financial Statements.New requirements included in SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions.Common peer review findings.Practice tips for high-quality engagements.
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Virtual
0.00 Credits
Automation capabilities of Excel The “Get & Transform” Tool Using “Get & Transform” for flattening, splitting and combining data, unpivoting summarized data, and combining CSV exports
