CPE Catalog & Events
Create Visuals in Power BI to Successfully Analyze Data
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Tour of the Power BI Desktop Interface: Understand the layout, tools, and features of Power BI Desktop.Tour of PowerBI.com Interface: Familiarize with the online environment of Power BI for report creation.Importing Power Pivot Data Model: Understand how to integrate Power Pivot models into Power BI for more complex data analysis.Building Visuals: Learn the step-by-step process to create compelling visuals and understand the importance of visual context in data storytelling.Review of Available Visuals: Explore the variety of visuals available in Power BI and their appropriate applications.Power BI Desktop Features: Delve into the advanced features of Power BI Desktop, enhancing data manipulation and visualization capabilities.Building Interactivity into Visuals: Learn to create dynamic and interactive reports that engage and inform.Publishing Reports to PowerBI.com: Gain skills in uploading and managing reports on PowerBI.com for wider access and collaboration.
Navigating IRS Collections: Overview of Form 433 & OIC
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of the IRS collection process and enforcement actions.Initial notices, taxpayer rights, and IRS timelines.When to use Forms 433-A or 433-B and required documentation.Offer in Compromise (OIC): criteria, process, and practical considerations.Payment options: installment agreements, partial payment plans, and OIC.Advising clients on IRS collections and avoiding penalties.Compliance strategies for minimizing tax liabilities.Real-world scenarios and examples for tax debt resolution.
2025 Single Audit Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Review of the impact of the 2024 Compliance Supplement on Single AuditsReview of the changes to the Uniform GuidanceReview of common audit deficiencies found in Single Audits
Ethical Performance Management
-
Virtual
2.00 Credits
The major topics covered in this class include:Definition and Benefits of Ethical Performance ManagementSetting Standards/Goal settingPreparing and Conducting the Appraisal InterviewLegal Considerations in Performance ManagementAvoiding Rater BiasFeedback and Coaching
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
Ethics of AI: A CPA's Guide
-
Virtual
2.00 Credits
The major subjects that will be covered in this course include:A primer on AI technology applications in the accounting professionEthical dilemmas that originate from the use of AI by CPAsPractical guidelines for using AI technology ethicallyStep by step guide for creating an AI usage policy for your organizationReview of a variety of reference materials to assist you in using AI ethically
The Next Step Series: Avoiding Ulcers in the "New Abnormal World"
-
Virtual
1.00 Credits
Attendees will examine how change affects critical thinking, how it can create opportunities for fraud, and how it hurts a high-performing culture. Then, we will review tools that have a positive effect on anticipating change and maintaining an adaptive mindset into the future. Finally, we will strategize how to break negative communication and conflict patterns that can damage high-performing teams. The overall goal is an adaptable, resilient workforce that is comfortable with continuous change, and a personal style of behavioral flexibility. Specific case studies are shared that reinforce the learning objectives.
SEC Case Studies: Ethical Dilemmas in Finance and Accounting
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Ethics and Ethical DilemmasEthical Codes and Professional StandardsFraud and the Fraud TriangleEthical Decision-Making ModelsFinancial Statement Manipulation TacticsCash Flow and Key Metrics Misrepresentations
Surgent's Stock vs. Asset Acquisitions of C Corporations
-
Virtual
2.00 Credits
Advantages and disadvantages to buyer and seller of an asset acquisition and a stock acquisition Tax treatment of consulting agreements and covenants not to compete Sale of personal goodwill associated with an asset acquisition Tax consequences associated with a stock acquisition and an asset acquisition Acquisitive reorganizations Non-tax issues that must be considered when a corporation is acquired
Surgent's Examining ASC 842, Leases: More Than Meets the Eye
-
Virtual
4.00 Credits
ASU No. 2016-02, Leases (Topic 842) Overall lease accounting guidance Lessor Accounting 101 Lessee Accounting 101 Detailed review of accounting by lessees and lessors Sale and leaseback transactions Transition guidance Other operational issues Recently issued updates to the lease accounting guidance FASB guidance on accounting for COVID-19-related rent concessions Feedback from the public company adoption of Topic 842
Surgent's Four Tiers of Loss Limitations: A Guide to the Rules for Pass-Through Entities
-
Virtual
4.00 Credits
The Inflation Reduction Act of 2022 Tier 1: Basis limitations for S corporation shareholders and partners Tier 2: Section 465 at-risk limitations for S corporation shareholders and partners, including the impact of debt, indemnities, guarantees, and shareholder/partner agreements Tier 3: Section 469 passive loss limitations and exceptions to the limitations Tier 4: The excess business loss limitation of the Tax Cuts and Jobs Act of 2017 (new §461(l)), American Rescue Plan Act, and Inflation Reduction Act
Estate & Trust Primer - Tax Staff Essentials
-
Virtual
4.00 Credits
Types of trusts Trustee powers Recognition and realization of income Elements of an estate Taxation of trusts and estates Basic concepts of estate planning
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
Ethical Intelligence for Artificial Intelligence
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Benefits and pitfalls of artificial intelligence in the accounting professionSelecting and utilizing artificial intelligence resourcesApplying professional skepticism to resultsMaintaining independence while utilizing artificial intelligenceUpholding client confidentialityData security and retentionCitation of sources and related reporting considerationsApplication of the AICPA Code of Professional ConductEthical considerations when crafting policies and establishing best practices
Building a Better Budget in a Time of Uncertainty
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting
Fraud & Embezzlement: Case Studies from the Trenches
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:How organizations can find themselves defrauded due to lax oversight and weak internal controls.How the existence of the "trusted advisor" creates situations where CPAs can drop their professional skepticism.Illustrations of the issues companies should look for in preventing fraud and embezzlement.
Love it or Leave It: Engagement and Retention at Work
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Ethical Values and Engagement and RetentionEnhancing Employee engagementStrategic/Intentional Actions to Enhance RetentionGeneration X
Steps to Stop External Fraud
-
Virtual
2.00 Credits
The major topics covered in this course include:Types of external fraudConsiderations as organizations work to reduce fraud riskExternal fraud and known parties/External fraud unknown perpetrators
Taking Advantage of Array Formulas in Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants: This section teaches how simplify the use of static values called Array Constants
Ethics: IRS Behavioral Insights for Accountants
-
Virtual
2.00 Credits
Behavioral insights (BI) PrimerHow and why BI are used by the IRSIRS and individual decision-makingIRS and environmental and design considerationsIRS and social normsIRS "top of mind" issues BI and Implementation of tax reform legislation BI and private debt collectionBI and online taxpayer accountsBI and taxpayer rights in "real" vs. "unreal" auditsBI and the tax-exempt approval processBI and passport renewal and revocationHow to use BI to more mindfully interact with the IRS to improve outcomes
