CPE Catalog & Events
Complete Guide to Analyze Data with Excel PivotTables
-
Webinar
4.00 Credits
Member Price: $149
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.
ACPEN: Looking at the AICPA’s “Non-authoritative Guidance” From an Ethics Perspective
-
Webinar
2.00 Credits
Member Price: $79
When and How are AICPA Pronouncements “Authoritative”? Authoritative Ethical Pronouncements What is “Nonauthoritative” Guidance? Nonauthoritative Guidance in the AICPA Online Ethics Library A Closer Look at: Nonattest Services A Closer Look at: NOCLAR Case Analysis: Hale v. State Farm Mut. Auto. Ins. Co. Conclusion
Ethics, Tax Practice & Understanding Circular 230
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Importance of ethics in tax practiceOverview of Circular 230 and its application to tax practitionersCommon ethical violations and penaltiesProcedures to promote compliance with ethical standardsReal-life scenarios illustrating ethical decision-making in tax preparationCircular 230 provisions related to tax return preparation and representationBest practices for maintaining professional integrity and compliance
Surgent's Key Partnership and S Corporation Tax Planning Strategies
-
Webinar
4.00 Credits
Member Price: $159
Timely coverage of breaking tax legislation Tax consequences of retiring partners seeking liquidating distributions/redemptions and S corporation shareholders seeking the redemption of their shares At-risk and passive activity loss considerations Basis planning Related party transactions: making them work Income splitting and shifting with family can create considerable benefits Sale of ownership interest and NIIT considerations
ACPEN: Is Activity-Based Costing the Right Tool for Your Organization?
-
Webinar
2.00 Credits
Member Price: $89
ABC versus traditional costing First-stage allocation Determining predetermined overhead rates Second-stage allocation Activity-based reporting Activity-based management
ACPEN: K2’s Microsoft Copilot, Including Agentic AI
-
Webinar
2.00 Credits
Member Price: $89
Incorporating Copilot with Excel, Word, PowerPoint, and Outlook Using Copilot to automate routine tasks and assignments Integrating Copilot with agentic AI Identifying key privacy and security features in Copilot Understanding and deploying agentic AI
ACPEN: Fraud and Financial Distortion: What May Be Hiding Behind the Numbers
-
Webinar
2.00 Credits
Member Price: $89
Translating Financial Statements Back Into Operational Reality The Operational Plausibility Test Analytical Metrics That Reveal Hidden Distortion Common Operational Red Flags Case Studies: When Operations and Financial Results Don’t Match Practical Questions Every Financial Professional Should Ask
ACPEN: K2's Productivity Life Hacks
-
Webinar
2.00 Credits
Member Price: $89
Using a Streamdeck for push button integration and automation Using tools such as Clockify or Rescue Time to gain insight on Easily install applications using Ninite on your Windows 10/11 device Improve data sharing between applications with Zapier, Power Automate, and others Connecting to multiple communication applications (e.g., Teams, Slack, etc.) at once with Rambox Using inbox rules and filters to automatically categorize and prioritize email
ACPEN: Strategic CFO – Strategic Risk Management
-
Webinar
2.00 Credits
Member Price: $89
Overview of Enterprise Risk Management (ERM) and COSO standards Evolution of COSO and why it matters today Governance, culture, and board oversight of risk Defining risk appetite and linking it to strategy Identifying, assessing, and prioritizing risks Risk responses: avoid, reduce, share, and accept Black swan events and managing uncertainty Communicating and reporting risk across the organization
Google Gemini AI for Accountants
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Google Gemini Quick StartGemini Standalone ChatbotMobile AppGemini integration with:WorkspaceGmailDocsSheetsSlidesUser Tips
Mastering Partnership Basis: Inside and Outside Basis
-
Webinar
2.00 Credits
Member Price: $89
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.
ACPEN: Inventory Observation - Cretaceous Conservatory Simulation
-
Webinar
3.00 Credits
Member Price: $109
Obsservation Auditing
ACPEN: The Preparation of Form 706 - Line-by-Line
-
Webinar
3.00 Credits
Member Price: $109
Overview of Form 706 and estate tax fundamentals Gross estate valuation and inclusion rules Deductions, credits, and tax computation Portability election and its implications Filing deadlines and procedural requirements Common issues and IRS audit triggers Legislative changes affecting estate taxation
ACPEN: The Role of Internal Control in the Risk-Based Audit
-
Webinar
4.00 Credits
Member Price: $149
Specific matters auditors should consider when obtaining and documenting an understanding of the client's internal control system Development of a tailored audit approach that considers the potential reliance on internal controls Guidance for establishing an adequate basis for reliance on internal controls of less formal, smaller clients
Accounting for the Gig Economy
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Characteristics unique to the gig economyIndependent contractor and employee classification considerationsRecordkeeping considerations for independent contractorsAccounting and reporting issues for gig economy participantsAudit and attestation for clients who participate in the gig economyTax and regulatory considerationsThe CPA as a trusted advisor for independent contractors
ACPEN: HR Investigations – Episode 3 – Gathering-Analyzing-Reporting
-
Webinar
1.00 Credits
Member Price: $39
Documentary evidence gathering and analysis Site visits Surveillance Analysis by comparison and contrast Analysis by quantifying and connecting Analysis by identifying patterns Written reports Testifying
ACPEN: The Controllership Series: The Controller's Role in Artificial Intelligence
-
Webinar
1.40 Credits
Member Price: $39
Accounting Finance
ACPEN: Analytical Procedures for Nonprofits
-
Webinar
2.00 Credits
Member Price: $89
How to leverage preliminary and substantive analytic procedures to improve the effectiveness and efficiency of financial statement audits The required elements of a substantive analytic procedures to address detection risk Tips and traps of applying an analytic approach to satisfy audit objectives Explaining the usefulness of analyzing diverse trends and ratios in a nonprofit environment to meet the needs of various financial statement users Common ratios and trends to assess liquidity, operating efficiency, leverage, and more
ACPEN: Tax Depreciation: How to Optimize Deductions
-
Webinar
2.00 Credits
Member Price: $89
Recent tax legislation and developments related to depreciation and capitalization Eligible property for Section 179 and Section 168(k) Section 179 deduction and its use to depreciate real property Section 168(k) deduction and its use to depreciate real property Disposition of segments of real property Exchanges of tangible personal property after repeal of the like-kind exchange rules
ACPEN: Deep Dive into Quality Management
-
Webinar
2.00 Credits
Member Price: $89
Quality management standards for CPA firms SQMS 1 and SQMS 2 requirements Engagement-level standards (SAS 146, SAS 145, SSARS 26, SSAE 23) Post-implementation evaluation of quality management systems Monitoring and remediation responsibilities Auditor responsibilities under SAS 146