CPE Catalog & Events
Surgent's Excel Shortcuts for Accountants
-
Virtual
2.00 Credits
Explore the function that sums better than the SUM function Discover a variety of time-saving features, functions, and techniques Learn the workaround to a major Excel pitfall
Surgent's The Risks and Benefits of ChatGPT and Artificial Intelligence
-
Virtual
2.00 Credits
What are AI tools? Where are we with AI tool development? What is ChatGPT? ChatGPT – what kind of queries are possible? Copyright and intellectual property issues Benefits of AI tools Concerns with AI tools Impact on business use of AI Policy on AI tools
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
Conducting a Remote Audit
-
Virtual
4.00 Credits
Leveraging the benefits of remote auditing Managing the team, client, and audit process remotely Identifying engagement-wide procedures from client acceptance through report issuance when remote auditing Understanding narrow-topic considerations when remote auditing
Controls to Secure the Growing Digital Footprint
-
Virtual
4.00 Credits
The major topics covered in this course include:Securing individual documentsProtecting information resident in the CloudSecuring data stored on or accessed by mobile devices
Exploring Internal Controls That Could Have Prevented Frauds
-
Virtual
2.00 Credits
The major topics covered in this class include:Examination of actual fraudsDiscussion of internal controls that could have prevented the fraudsContemplation of epiphanies for your own professional scenarios
Surgent's Select Estate and Life Planning Issues for the Middle-Income Client
-
Virtual
4.00 Credits
Changes to the lifetime estate tax exemption in light of proposed regulations SECURE 2.0 updates More than 20 documents that should be reviewed that are neither a will nor trust Provisions you need in a will Trusts and other arrangements for children Durable powers of attorney for healthcare and for financial matters Realistic retirement goals Developments relative to estate tax, and the implications for planning
Money Laundering 101 for CPAs
-
Virtual
4.00 Credits
The major topics covered in this class include:The theory of money launderingCommon money laundering statutesExamples from court cases of money laundering statutesCommon occurrences with CPAsPossible money laundering transactionsApplying the money laundering statutes in real life scenarios
Leveraging Analytical Procedures to the Fullest on Audits - Case Studies in Strengthening Audit Evidence
-
Online
2.00 Credits
How well-designed analytic procedures enhance audit quality Elements of strong analytic procedures Selecting the proper analytic, and altering the strength for the intended purpose Evaluating the data used in generating expectations Improving documentation, including evaluating sufficiency and appropriateness of the audit evidence obtained
FASB Update and Review
-
Online
2.00 Credits
FASB updates that will affect near-term reporting Future topics that may soon be addressed by the FASB
Surgent's Introduction to Required Minimum Distributions
-
Virtual
2.00 Credits
How SECURE Act 1.0 and SECURE Act 2.0 changed the RMD rules What is an RMD? Who is subject to RMDs? The types of accounts subject to RMDs How to calculate an RMD How to determine if a distribution can be an RMD How to determine which life expectancy table must be used when calculating an RMD The rollover and transfer rules during an RMD year IRS penalties for non-compliance with RMD regulations Applying RMD strategies to different plan types When RMDs can and cannot be aggregated How to correct an RMD shortfall How to get a waiver of the excise tax on an RMD failure The tax implication of an RMD How to donate an RMD tax-free How to determine the RMD rules that apply to a beneficiary
Ethics - A Line in the Sand; Implications for Daily Business
-
Online
4.20 Credits
Recognize the underlying drivers of individual ethical behavior Identify the relationship between ethics and integrity Highlight ethical trends in businesses throughout the world Review high profile ethics lapses in recent years
Build a Data Model for Analysis in Power BI
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Data Modeling Essentials: Understanding the core concepts of data modeling in Power BI, including integration of various data sources.Building Relationships: Techniques to establish and manage relationships between different data sets.Calculated Columns and Basic DAX Measures: Introduction to DAX (Data Analysis Expressions) and its application in creating calculated columns and basic measures.Calculated Columns vs Measures: Insights into when to use calculated columns and when to opt for measures.Explicit vs Implicit Measures: Understanding the difference and appropriate application of explicit and implicit measures in data analysis.Hierarchies in Data: Creating and utilizing hierarchies to enhance data analysis and reporting.Using Pivot Tables to Validate Measures: Practical skills in using pivot tables within Power BI to validate and refine measures.
Was It Fraud or Just Poor Audit Quality?
-
Online
1.60 Credits
Financial statement manipulation Ethics enforcement process Auditor conflicts of interest
Leadershift Ethics: Things Must Change!
-
Virtual
2.00 Credits
The major topics covered in this course include:The litmus test for all of your decisions and actionsEthical principles when managing through changePressures that threaten ethical change managementCase studies of what can go sideways when ethics are not part of every stage of changeWinning strategies for ethical self-regulation
Surgent's Data Security: Best Practices to Protect Your Business and Yourself
-
Virtual
1.00 Credits
Ethical duty to safeguard employee, client, and litigant data Common threats, including phishing, ransomware, and bad password management Security management of business and personal electronic devices Best practices for creating and securing passwords Insight into how our personal information is exploited in our daily lives
Introduction to Forensic Accounting
-
Online
1.80 Credits
Forensic Accounting Accounting Auditing Finance
Shortcuts that Excel Users Love
-
Virtual
2.00 Credits
The major topics covered in this course include:The power of keyboard shortcutsOft used features with more capability than meets the eyeNew helpful featuresNote: This session is taught using Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Virtual
2.00 Credits
Creating a data model/Power Pivot Building PivotTables from multiple tables Creating Measures Using named sets
Using AI to Instantly Transform Ideas into Revenue Streams
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:AI-powered ideation and opportunity identification techniquesDigital asset creation workflows using generative AI toolsAudio and video content generation using AI avatars and synthesisE-commerce integration and product development strategiesAI-driven presentation and visual content creationSocial media content optimization and distributionMulti-format content transformation (articles, songs, comics, storyboards)