CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
Member Price: $89
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
Performing Preparation, Compilation and Review Engagements
-
Online
2.00 Credits
Member Price: $89
Engagement objectives Performance requirements and standards Documentation Differences between compilation and preparation engagements Engagement criteria Changes in level of service
Finance and Innovation: Reinvent Your Department and Company 26-27
-
Online
0.00 Credits
Member Price: $329
• How innovation happens • Innovation metrics and how to report on innovation efforts • How the use of technology and other simple techniques can foster and sustain innovation
Preparation, Compilations and Reviews—A Practical Workshop 26-27
-
Online
8.00 Credits
Member Price: $329
• Preparation • Compilations • Reviews
Strategy, Risk and Finance: Why We Do What We Do 26-27
-
Online
4.00 Credits
Member Price: $329
• Why do most strategic plans fail" • Why so many formerly strong organizations have failed • Why most organizations have a poor strategic plan and how to correct this • The many risks that must be addressed: Financial risk, execution risk, commercial, business, and strategic risks as well as commonly overlooked risks • How Behavioral Economics will help address the risk
Introduction to Ethics & Professional Skepticism
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:The Code of Ethics for Professional Accountants.The pressures, opportunities, and rationalizations that lead to instances of fraud. Interactive examples to illustrate various scenarios of noncompliance during engagements.
Ethics, AI, and Music: What Every CPA Must Know
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include: Four key aspects of artificial intelligence that are relevant to CPAs: machine learning, generative AI, large language models, and GPT.The role that five powerful principles—the principles of ethical intelligence—play in using AI the right way. Short, focused writing exercises (30 seconds each) designed to deepen understanding of the topic. Real-world case studies about the use of AI in music as well as accountingAnswers to several crucial questions about how to use artificial intelligence with ethical intelligence.
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
Internal Control - Testing for Operating Effectiveness
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Generally accepted audit requirements related to testing controls for operating effectivenessIdentifying key controls that may prove effective and efficient to test in a control reliance strategyResponses when deviations are discovered when evaluating the design or operating effectiveness of internal controlLeveraging audit evidence available for Service Organization Control (SOC1) ReportsGeneral computer control considerations when evaluating the design and operating effectiveness of internal control over financial reporting
Applying AI in A&A: Creating Effective Prompts
-
Online
1.00 Credits
Member Price: $49
Leveraging artificial intelligence in A&A Writing effective prompts. How an effective prompt improves results. Examples of effectively written prompts.
Internal Controls Over Compliance vs Compliance
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Testing internal ControlsAlign internal controls with specific compliance requirementsThe misidentification of controls and the confusion between compliance and control processes
Supervision/Management Competencies: An Ethical Approach
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Overview of Virtue EthicsMilgram and Zimbardo case studiesNavigating the transition from "Buddy to Boss"Self-Awareness and Regard for OthersSetting Standards and Analyzing PerformanceUnconscious BiasCommunication Skills
Surgent's Introduction to Charitable Gifting for Individual Taxpayers
-
Online
2.00 Credits
Member Price: $119
Fundamentals of charitable gifting Income and estate tax considerations for charitable giving Charitable deduction rules and limitations Structuring charitable contributions for maximum tax efficiency Advanced charitable gifting techniques Compliance and documentation requirements
Surgent's Guide and Update to Compilations, Reviews, and Preparations
-
Online
4.00 Credits
Member Price: $159
SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services – 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26, Quality Management for an Engagement Conducted in Accordance with Statements on Standards for Accounting and Review Services SSARS No. 27, Applicability of AR-C Section 70 to Financial Statements Prepared as Part of a Consulting Services Engagement Sample comprehensive engagement work programs for preparation, compilation, and review engagements
Fundamentals of Form 1040 -- Individual
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Form 1040 essentials: filing requirements, due dates, and key schedulesFiling status, dependency rules, and taxable income sources (wages, investment income)Adjustments to income, deductions and tax credits (standard vs. itemized deductions, EITC, Child Tax Credit, Education Credits)Preparer due diligence, Circular 230 compliance and taxpayer rightsIRS cybersecurity considerations and best practices for taxpayer data securityLegislative updates
Preparation, Compilation, and Review Engagements: Update and Review
-
Online
4.00 Credits
Member Price: $139
Overview of preparation, compilation, and review guidance Accounting and reporting issues Current practice issues Common deficiencies in peer reviews Current and future standard-setting projects
Exercise Your Ethics: Techniques to Improve Ethical Response
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Explore research for common answers to "what does ethics mean to you?" and examine whether those are valid.Identify common ethical barriers - reflecting the latest from the ACFE Report to the Nations.Discover ways to improve ethical response.Practice, using practical advice from leading thinkers in ethics.
How AI Is Automating Internal Control
-
Online
4.00 Credits
Member Price: $149
The major topics covered in this class include:An explanation of Artificial Intelligence (AI).Specific ways AI is replacing human cognition. What is on the internal control horizon related to AI and other technologies.
Surgent’s Weekly Expert Hour
-
Online
1.00 Credits
Member Price: $59
Each week’s topics will change based on the most critical issues affecting financial professionals
Navigating IRS Collections: The Collection Process
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of the IRS collection process.Taxpayer rights and the Taxpayer Bill of Rights.Collection due process and appeals.Installment agreements and offers in compromise.Wage garnishments, levies, and liens.Penalties and interest.