CPE Catalog & Events
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.
ChatGPT Bootcamp for CPAs with John Higgins
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Review the history of ChatGPTTour of the ChatGPT app and how to use itSetting up a ChatGPT account (free & premium)Variety of hands-on case study examples for accounting, finance and taxA look under the hood at how ChatGPT worksCaution - how to avoid risks in using ChatGPTA look into the future potential for AI in business
Walkin', Talkin', Lookin' & Listenin' - Or Things Most of Us Don't Do Well
-
Online
2.00 Credits
The importance of making yourself available How to start a conversation and what to NOT talk about The art of how to listen When you don’t understand what they just said Don’t fool by equivocations when they respond to a question Materiality and perception
Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
Online
2.00 Credits
Understanding the modern finance and accounting organization chart GAAP accounting changes Why so many changes? The speed of change and complexity Accepting reality Recognizing and fixing the top five accounting problems and errors Leases Revenue Management estimates Why is strategy necessary? What is strategy? The two keys to strategy? Why do some financial leaders lack strategic skills? Balancing strategy with our day-to-day roles
Everyday Ethics at Work: Don't be the Next News Story!
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Discuss ethics from an every-day real-world perspectiveHow to prevent an ethical lapse that can turn your business into the next news story
The Ethical Management of Conflict
-
Virtual
2.00 Credits
The major topics covered in this class include:Professionalism, Conflict and EthicsSources and approaches to conflictManaging Conflict from the Inside: Awareness of human tendencies, human emotions, and gossipGuidelines for managing conflict collaboratively
Taxation of Judgements and Settlements
-
Online
2.40 Credits
Types of damages or remedies that can be awarded or agreed upon pursuant to litigation. Review of the Internal Revenue Code and regulations governing the taxation of various types of litigation payments. Suggestions for drafting pleadings or settlement agreements.
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
Introduction to Ethics & Professional Skepticism
-
Online
2.00 Credits
Code of Ethics for Professional Accountants Yellowbook Auditing
Ethics: IRS Criminal Investigations: Key Lessons for Accountants
-
Virtual
2.00 Credits
Snapshot of IRS Criminal InvestigationsGeneral tax fraudAbusive tax schemesRefund fraudEmployment tax fraudIdentity theftData compromisesMoney launderingPublic corruptionCorporate fraudGeneral fraudsCyber crimesGlobal tax and economic crimesNarcotics, counter-terrorism and transnational organized crimeSelected Field Office Case Files from Across USNew EnglandMiddle AtlanticEast NorthCentralWest North CentralSouth AtlanticEast South Central West South CentralMountainPacificHow accountants can add value to their operations by aiding law enforcement and fighting economic crime
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 Guide to Calculating S Corporation Shareholder Stock and Loan Basis
-
Virtual
2.00 Credits
Introduction to Form 7203 Introduction to the calculation of stock basis Introduction to the calculation of loan basis Taxable and nontaxable S corporation distributions to shareholders The election to reduce basis by deductible losses and expenses before reducing basis by nondeductible expenses
Surgent's Successfully Completing an Income Tax Return for a Trust or Estate -- Form 1041
-
Virtual
2.00 Credits
Passive activity rules for trusts including the NIIT The different types of trusts for income tax purposes (e.g. simple, complex, grantor, charitable) The critical categorization of income (taxable income vs. fiduciary accounting income) Distributable net income (DNI) and how it works The “Tier” Rules The Separate Share Rule IRC 663(b) “65-Day” Rule IRC §691(c) Deduction QSST and EBST elections How to treat excess deductions on termination Grantor trust rules and how they impact planning and return preparation The income tax side of Domestic Asset Protection Trusts
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
Surgent's Understanding Partnership Taxation: Types of Basis, Contributions, and Distributions
-
Virtual
4.00 Credits
Three different types of basis Contributions of property IRC 704(b) – Capital Accounts and Special Allocations Contributions of property and debt Contributions of services IRS Notice 2020-43
Becoming Conflict Competent
-
Virtual
2.00 Credits
Major topics covered in this course include:Levels of conflictStrategies to de-escalate conflictDistinction between miscommunication and conflictResponses to conflictTactics to address, rather than avoid, conflict
Surgent's Navigating Your Client Through the IRS Appeals Process
-
Virtual
4.00 Credits
Preparing a valid Appeals Protest for small case requests when tax, penalties, and interest for each period are $25,000 or less Writing and filing a Formal Protest, including required information Alternative Dispute Resolution options available to clients Negotiation and time limitations Preparing and submitting a Tax Court petition to preserve a client’s rights
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
Understanding Internal Control Constructs
-
Virtual
4.00 Credits
The major topics covered in this course include:Underlying concepts of internal controlThe importance of control measure interdependency
Getting Comfortable with Being Uncomfortable
-
Virtual
2.00 Credits
Diversity Unconscious Bias Emerging Technologies Talent Management
