CPE Catalog & Events
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
Member Price: $99
Automation capabilities of Excel The “Get & Transform” Tool Using “Get & Transform” for flattening, splitting and combining data, unpivoting summarized data, and combining CSV exports
Nonprofit Internal Control - Practical Insights into Mitigating Financial Reporting, Compliance and Other Risks
-
Online
4.00 Credits
Member Price: $159
Recognizing the importance of each of the key components of a sound system of internal controls over financial reporting, regardless of a nonprofit entity's nature, size or complexity Understanding the critical role of information technology (IT) general and application controls to reliable financial reporting, even in less-complex IT environments Exercise in documenting an understanding of the design of internal controls for common classes of transactions for nonprofit entities Identifying and evaluating the sufficiency of key controls to satisfy control objectives Understanding the importance of verifying whether an understanding of the design of internal controls has actually been "implemented", and how to exactly go about doing that
Unlock the Power of AI with Copilot in Excel
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Introduction to Copilot in ExcelAutomating Tasks and Enhancing ProductivityAdvanced Data Insights with Copilot
The Radar Phenomenon
-
Online
1.00 Credits
Member Price: $59
Internal Controls Fraud Prevention Fraud Investigation
Performance Management
-
Online
1.00 Credits
Member Price: $59
Setting and resetting performance expectations On-the-spot counseling Addressing erratic performance Drafting and presenting performance appraisals
HR Investigations - Episode 3 - Gathering-Analyzing-Reporting
-
Online
1.00 Credits
Member Price: $59
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
Liquidity & Uncertainty Disclosures for Nonprofits
-
Online
2.00 Credits
Member Price: $109
Required disclosure related to liquidity and other significant uncertainties for fair presentation of financial statements Evaluating the need for going concern and other uncertainty disclosures in the current environment
What's Behind the Data?
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Ways in which data and information can be misleadingCommon pitfalls when encountering dataHow to re-evaluate the data to avoid those pitfalls
Deep Dive Into Common Auditing Deficiencies
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Review common deficiencies identified by the AICPA and state boards of accountancy.Feature discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment.Review of the areas of concern and how you can overcome them by employing best practices.
Depreciation and Capitalization Guide: Optimizing Business Assets
-
Online
4.00 Credits
Member Price: $159
Recent tax legislation, rules and developments related to capitalization and depreciation Capitalization of tangible property, including materials and supplies, building and improvements Small taxpayer safe harbor Section 179, including 2020 inflation adjustment Section 168(k) 100% bonus deduction Late bonus depreciation election Qualified improvement property
The Role of Internal Control in the Risk-Based Audit
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Specific matters auditors should consider when obtaining and documenting an understanding of the client's internal control systemDevelopment of a tailored audit approach that considers the potential reliance on internal controlsGuidance for establishing an adequate basis for reliance on internal controls of less formal, smaller clients
Ethics - Keeping the Good from Breaking Bad
-
Online
1.00 Credits
Member Price: $59
Ethical business behavior Ethical business decisions
The Controller Function - Elevating the Role
-
Online
1.50 Credits
Member Price: $79
Accounting Finance Auditing Business Development
An In-Depth Understanding of the Generation Skipping Transfer Tax
-
Online
2.00 Credits
Member Price: $79
Overview of the GST tax and its policy purpose Direct skips, taxable terminations, and taxable distributions Skip persons and treatment of trusts as skip persons Application of the GST exemption and inclusion ratio Timely, late, and retroactive GST allocations Formula-based exemption allocations Planning strategies for GST tax minimization Filing considerations for Forms 706 and 709
Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
Member Price: $109
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis
Google Gemini AI for Accountants
-
Online
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
Independence Requirements for CAAS Engagements
-
Online
2.00 Credits
Member Price: $109
CAAS Auditing & Accounting Yellowbook Ethics
Surgent's System and Organization Controls (SOC) Engagements
-
Online
2.00 Credits
Member Price: $99
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
Ethics Aren't for the Byrdes in Ozark
-
Online
1.00 Credits
Member Price: $59
Ethical business behavior Ethical business decisions Ethical management decisions Ethical decisions in human resource management
Private Company Simplified GAAP Alternatives
-
Online
2.00 Credits
Member Price: $109
Guidance, related to "plain vanilla" interest rate swaps that convert variable into fixed rate debt and other derivatives Guidance related to amortization and impairment of goodwill Guidance related to separately recognizing intangible assets from goodwill in a business combination Guidance related to lease accounting and revenue recognition options