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: Tricks and Treats to Avoid Litigation
-
Online
1.00 Credits
Key concepts of effective employee relations Balancing employee and employer rights Handling employee complaints Addressing personality & attitude problems
Internal Control - Testing for Operating Effectiveness
-
Virtual
2.00 Credits
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
How to Build a Custom AI Chatbot and GPT in Plain English
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Fundamentals of GPT Builder and AI agent customization techniquesIntegration of specialized knowledge bases and domain-specific expertiseSecurity and privacy considerations in AI chatbot deploymentCustom GPT development without coding expertiseImplementation of AI agents for customer support and workflow automationMulti-bot interactions and content creation strategiesBest practices for maintaining and scaling AI assistants
ACPEN: S Corporations – Overview
-
Online
2.00 Credits
Overview of S Corporation election and compliance requirements Comparison of S Corporations with other business entities Preparing Form 2553 and addressing late filing relief Shareholder stock and debt basis considerations Form 1120S and Schedule K-1: key aspects and reporting requirements Officer reasonable compensation requirements and IRS audit strategies Introduction to Schedules K-2 and K-3 Compliance with corporate formalities and taxable fringe benefits
Surgent's Choosing the Right Business Entity
-
Virtual
2.00 Credits
Why businesses operate as C corporations Why businesses operate as pass-through entities Adopting C corporation status Why businesses choose S corporation status. Tax and business situations that impact entity selection.
Surgent's Understanding Partnership Taxation: PTE Elections, 754 Elections, and Selling a Partnership Interest
-
Virtual
2.00 Credits
Notice 2020-75: PTE elections What is a 754 election? What if a 754 election is not in effect? Tax implications of a partnership interest sale on the seller Look-through provisions
Ethics: Critical Thinking, Case Studies and Fraud
-
Virtual
4.00 Credits
AICPA Code of Professional Conduct CPA responsibilities and AU-C 315 The new AICPA Ethics Codification Disciplinary cases and actions CPA Vision Seminal events The impact of ethical and unethical conduct on our profession
ACPEN: Grow Your Business from Within – Striking the Right Balance Between a CPA Firm's Financial, People, and Client Success
-
Online
8.00 Credits
How to become a value-added business advisor to successfully grow the firm from within Best practices for leveraging engagement team discussions to better understand the entity and its environment, identify risk of material misstatement, and provide value-added business advice in audit and other attest services Critical traits of a thinking auditor, tips for stretching yourself beyond the basics Tips for value pricing and other ways to improve a CPA firm's financial success Managing change and promoting creative thinking Choosing between varying levels of client service
Public Procurement Basics: Protecting the People's Money
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Guidelines and requirements that will help lead you to public procurement success.Guidance on how governments can meet complicated procurement needs.Best practices to protect public and Federal funds.
Surgent's Applying ASC 820: The Basics of Fair Value Accounting
-
Virtual
4.00 Credits
Applicability of the use of ASC 820 The “exit price” approach Examples of market, cost, and income approaches to estimating fair value Use of Level 1, 2, and 3 inputs in determining fair value
Microsoft 365 Application Lightning Round Review-Updated
-
Virtual
1.00 Credits
The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps
ACPEN: Leases Accounting under Topic 842 – Answers to FAQ After Implementation
-
Online
2.00 Credits
Alternatives to adopting Topic 842 Short-term lease and related-party leasing arrangements Identifying lease agreements under the new rules Proper treatment of lease incentives, leasehold improvements, and lease modifications
Surgent's Reasonable Suspicion
-
Virtual
0.00 Credits
The psychosocial, physiological, and behavioral aspects of drug and alcohol abuse in the workplace The impact of drug and alcohol abuse on workplace safety The possible connection between performance issues and drug or alcohol abuse The role of documentation in reasonable suspicion testing Confidentiality concerns in the testing process
ACPEN: Internal Control Best Practices
-
Online
2.00 Credits
Auditing Yellowbook
ACPEN: Keys of SOC Reports - Following SSAE 18 Requirements
-
Online
2.00 Credits
Move from SAS 70 and SSAE 16 to SSAE 18 Types of Service Organizations SOC 1 Engagements Control Objectives Reporting SOC 1 and SOC 2 Reporting SOC 3 Reports Preparing for SOC Engagement SOC Comparisons
Common Financial Statement Disclosures
-
Virtual
2.00 Credits
The major topics covered in this class include:General disclosures about the entity and its environmentCommon critical information useful to financial statement readers for making economic decisionsExplain results of operations through information that supplements the face financial statements
How Much Are Your Ethics Worth?
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Understanding ethicsAvailable tools to aid in ethical decision makingThe role of bias in making ethical decisionsApplication through case studies
Self-Rental Real Estate: Passive Activity & Section 199A
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Definition of self-rental property - both for Sections 199A and 469Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2Form 8582 (passive activity)The flow-through entity grouping electionIllustrative examples and consequences of failing to comply with the reporting standardsSelf-rental property and "former passive activities" rules
Surgent's The CMA’s Guide to Project Management
-
Virtual
1.00 Credits
Establishing a system: identifying forces that support the status quo; setting milestones and goals; the role of the CMA Necessary first steps: set a framework for the project’s activities; identify needed resources; obtain support; decide on a structure; establish a team for a specific project; identify necessary team skill sets Project evaluation: analytical tools, strategic evaluation; sources of risk Maintaining focus: monitoring and measuring results; keeping to the project’s scope Avoiding frequent traps: sunk costs; financing pitfalls; project creep; tunnel vision; failure to integrate the team’s work internally and/or the final project with the remaining organization Introduction and examples of analytical tools throughout the session: mapping; CPM; Gantt charts; benchmarking; Pareto analysis; PESTLE analysis; valuation techniques; post-completion evaluations
