CPE Catalog & Events
PPP Fraud and Financial Professionals
-
Virtual
2.00 Credits
The major topics covered in this class include:Ethical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
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
Create Measures in Power BI that Define Your Metrics
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
Professional Ethical Considerations for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Core principles of any Code of Professional Conduct applicable to all CPAs, including conflicts of interest, preparing and reporting information, competence, confidential information, and moreThe importance of maintaining independence for CPAs in public practice, especially when also performing nonattest services for the attest client Comparing and contrasting various ethical standards, including those promulgated by the AICPA, PCAOB, and international bodies
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
CFO Solutions to IRS Problems
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The authority of IRS in assessing and collecting taxes.The common misconceptions when dealing with IRS.Common questionable actions by business owners.How to prepare for an IRS audit.The seven options in IRS collections.Possible criminal tax violations by CFOs and small business owners.
The Ethic of Teamwork
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Virtue ethicsTeam dynamicsCharacteristics of highly effective teamsMeeting managementTeam communicationDecision making
Implementing an AI-Enabled Marketing Strategy for Your Firm
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Module 1: Introduction to AI in Marketing The Basics of AI – Concepts and TerminologyModule 2: Leveraging AI Tools and Technologies Overview of AI Tools for MarketingModule 3: Practical Strategies for AI Integration Integrating AI into Your Marketing WorkflowModule 4: Measuring AI-Driven Marketing Effectiveness Key Metrics for Assessing AI-Driven CampaignsModule 5: Real-Life Case Studies and Success Stories Case Studies of Firms Successfully Using AI in MarketingModule 6: Developing Your AI-Enabled Marketing Strategy Creating a Custom AI Marketing Strategy
Ethical AI Practices for CPAs: Ensuring Responsible Use
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Understanding ethical implications of AIData privacy and security considerationsCompliance with regulations and professional standardsDeveloping ethical AI policies and procedures
Taxation of Property Transactions - Tax Staff Essentials
-
Virtual
4.00 Credits
Sections 1231, 1245, and 1250 Depreciation recapture Capital gains and losses Nonrecognition transactions
Guide Strategy, Attract Investments with Financial Forecasts
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Financial Statement ForecastingOverview of the importance and benefits of forecasting for strategic planning and investment attraction.The Forecasting Process: Steps to project future income, expenses, and resources using historical data and market trends.Analyzing Historical Data: Methods for leveraging past financial data to inform future projections.Incorporating Market Trends: How to integrate market insights into financial forecasts.Forecasting Profitability: Techniques for predicting future earnings and their implications for budgeting, cash flow management, and investment planning.Forecasting the Balance Sheet: Approaches for predicting future financial positions, including growth potential, solvency, and capital structure
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.
Surgent's Exploring Business Valuation Fundamentals
-
Virtual
2.00 Credits
What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models
The Role of Internal Control in the Risk-Based Audit
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Specific matters auditors should consider when obtaining and documenting an understanding of the client's internal control systemDevelopment of a tailored audit approach that considers the potential reliance on internal controlsGuidance for establishing an adequate basis for reliance on internal controls of less formal, smaller clients
Will Your Ethics Be Burned by Burnout?
-
Virtual
2.00 Credits
The major topics covered in this class include:Explore the effects of crisis and burnout on ethical decision-makingDefine the stressors, pressures, and biases that can lead good people to make less than optimal choicesDiscuss ways to offset the pressures, ways to reduce stress on ourselves and on our team, and ways to support our teamsLearn how to recognize when an individual or an organization is heading in the wrong direction and how to stop sliding down the slippery slope
The 10 Must Know Excel Features
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
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
IRS Penalties and Abatements
-
Virtual
2.00 Credits
The major topics covered in this class include:Various types of penalties: Accuracy related, fraud, understatement of valuation, reporting requirement, failure to pay, and pay or deposit penaltiesRules on waiver of penalties and interestsVarious forms and procedures for requesting reliefFirst Time Abatement: Requirements and proceduresHow an individual taxpayer qualifies for Reasonable Cause abatementProcedures for requesting refund of paid penaltiesAvailable administrative options
How to Start a CFO Service
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:What business owners really want from a CFO/business advisory service (it's not what you think).How to determine if you're qualified to provide CFO/business advisory services.Why now is the right time to be providing CFO/business advisory services.How to get new clients to your practice and how to approach existing clients.Why clients need you and why you need them.How much you should be charging for this type of service.How to provide a CFO/business advisory service in the most efficient way possible.
Integrity, Objectivity and Judgment: Values in Action
-
Virtual
1.00 Credits
The major topics covered in this class include:AICPA Code of Conduct: Integrity and ObjectivityCase Study: Mortgage crisis of 2007-2010Case Study: World Com
