CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Virtual
2.00 Credits
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: Multiply Your Time: Tame Your To-Do List and Fight Distractions So You Can Get The Right Things Done
-
Online
1.00 Credits
Personal Productivity Optimizing Performance Reducing Stress Managing Time Improving Results Personal Development Self Leadership Self Awareness
ACPEN: Tax Procedure
-
Online
2.00 Credits
Filing a tax return IRS audit RS Appeals Collections and litigation at courts of original jurisdiction
Ethics without Fear for Accounting and Finance Professionals
-
Virtual
2.00 Credits
Case studies that clarify the challenges of making appropriate ethical decisions in the fast-paced modern organizational world A frank discussion of how to decide between a teaching moment rather than a termination moment when bad decisions are made. Applying the structure of understanding ethical dilemmas, and then applying the nine-step resolution process to arrive at a fair and consistent decision.
Surgent's Tax and Advisory with Agentic AI
-
Virtual
0.00 Credits
Agent use in transfer pricing, tax compliance automation, and M&A due diligence Examples of agent deployment in global accounting firms Regulatory frameworks Governance and controls for autonomous tax tools Strategic advisory with agent-based scenario planning
ACPEN: Preparing and Reviewing Workpapers – Essential Tips for Avoiding Deficient Audit and Other Attest Engagements
-
Online
8.00 Credits
Best practices for documenting complex and subjective procedures and conclusions, such as estimates, substantive analytic procedures, etc. that impact the nature and extent of audit documentation needed to support audit conclusions Discussing the financial statement audit risk concept, including how proper application better ensures a higher quality audit Tips for an efficient workpaper review process that complies with relevant standards Understanding the quality control standards and guidance related to a CPA firm’s responsibilities for its system of quality control Explain the importance of establishing, applying, and monitoring quality control policies and procedures related to audit documentation
Ethics: Giving Thanks - How to Master the Art of Gratitude
-
Virtual
2.00 Credits
We'll explore what gratitude is and how expressions of it can vary from culture to culture. We'll also unpack several ways you can regularly say "thank you" to valued clients and colleagues, and we'll examine methods for evaluating gratitude in prospective and current employees.
ACPEN: Considerations of Fraud
-
Online
2.00 Credits
AU-C 240 Auditing Yellowbook
ACPEN: Section 199A Compliance: Rules and Reporting After OBBA
-
Online
2.00 Credits
A deep-dive look at the Section 199A flow-through entities deduction Calculation of qualified business income Application to rental real estate - "safe harbor" rule and aggregation rules Self-rental rule for 199A compared to self-rental rule for passive activities Differing impact on the sole proprietorship, partnerships and S corporations Forms reporting in Form 8995 and Form 8995-A Section 199A flowchart
Agentic AI for CPAs: Automate Workflows with Intelligence
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Agentic AI concepts and terminologyCase studies for using AI agents in accounting, finance, and tax servicesStep by step demonstration of creating and deploying an AI agentIntroduction to Microsoft Copilot Studio agent builderDeveloping your AI agent deployment strategy
Surgent's System and Organization Controls (SOC) Engagements
-
Virtual
0.00 Credits
Purpose and organization of the Trust Services Criteria Management assertions specific to different SOC engagement types Intended users of SOC 1®, SOC 2®, and SOC 3® reports Determination and use of materiality in SOC engagements Criteria for considering a vendor as a subservice organization Inclusive vs. carve-out method for subservice organizations Service commitments and system requirements in SOC 2® engagements Appropriate form and content of SOC reports
ACPEN: Taxation of Business Entities
-
Online
2.50 Credits
Types of business entities (Sole proprietorship, Partnership, Corporation, Limited Liability Company and Limited Liability Partnership) Considerations in choosing a business entity, including taxes, limited liability protection, management & control, funding options & opportunities, tax consequences for the owners and the business. Future tax considerations that will impact various business entities.
ChatGPT and Advanced Financial Analysis for Accountants
-
Virtual
2.00 Credits
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
ACPEN: Cryptocurrencies for the CFO: Explaining Blockchain
-
Online
2.00 Credits
What is money? What are digital assets? Understanding the what, why, and how of cryptocurrencies Understanding the what, why, and how of blockchain NFT’s (Non-Fungible Tokens), their role and impact Explaining the crypto language
ACPEN: Partnership/LLC Taxation: Understanding Tax Basis Capital Accounts
-
Online
2.00 Credits
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
Resistance to Resilience: Strive for Tech Change Acceptance
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Resistance to resilience in embracing new technologiesOvercoming barriers and ensuring successful implementationCutting-edge audit technologies, including AI, data analytics, and automationInsights into the Technology Acceptance Model (TAM)
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
Get started with Power BI
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Overview of the Power BI Tools: Introduction to the Power BI ecosystem, including Excel’s Power BI features (Power Pivot and Power Query) and standalone tools (Power BI Desktop, Power BI Service, Power BI Report Builder and Power BI Report Server).Tour of the Tools: Introduction to the interfaces of Power Pivot, Power Query, Power BI Desktop and Power BI Services.Comparative Analysis: Understand the strengths and limitations of Excel’s Power BI features versus standalone Power BI tools.Strategic decision-making on when to use each tool for optimal efficiency and accuracy in data analysis tasks.
Current Nonprofit Fraud Trends
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Best practices for fraud prevention and detection.Common fraud schemes in nonprofit including cash misappropriation; payroll fraud; vendor fraud; falsified billings; improper use of credit cards or purchase cards; the redirection of cash and non-cash contributions; personal use of assets; the redirection of grant benefits; other grant related fraud; travel and expense reporting fraud; and much more!
Microsoft Copilot Deep Dive Hands-on Bootcamp for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Getting started with Microsoft CopilotTour of the Copilot app and how to use itVariety of hands-on case study examples for accounting, finance and taxProtecting your data privacy in Microsoft CopilotAdvanced Microsoft Copilot features reviewIntegration with Microsoft 365 apps
