CPE Catalog & Events
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
Obtaining an Understanding of Internal Control
-
Virtual
1.00 Credits
Various definitions and aspects of internal control, including separation of duties and safeguarding of assets Key aspects of internal control from various organizations, such as COSO, SEC, and PCAOB Factors to consider, for example, industry, regulation, and nature of the entity Risk assessment procedures, namely inquiry, analytical procedures, and observation and inspection, as well as brainstorming
Accounting for and Auditing Cryptocurrency & Digital Assets
-
Virtual
2.00 Credits
The major topics covered in this class include:Common applications related to initial recognition and measurement, subsequent measurement or derecognition, presentation, and disclosure of cryptocurrency and other digital assetsFeedback from the AICPA's Digital Assets Working Group intended to assist auditors with opining on these digital records
Individual Tax Update: Recent Developments
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:2025 Tax Provision SunsetsResidential Energy CreditVirtual currency reporting and Form 1099-DAStudent loansRecent individual taxpayer case rulings
Performing a Single Audit Under the Uniform Guidance
-
Virtual
8.00 Credits
Fundamentals of a compliance audit performed under the Uniform Guidance Identifying federal awards and major programs Pass-through entities and subrecipients Schedule of expenditure of federal awards (SEFA) Using the compliance supplement Uniform Guidance administrative requirements and cost principles Testing internal control over compliance Writing an audit finding and reporting requirements of a single audit
Surgent's Perplexing Financial and Economic Issues for the CFO/Controller
-
Virtual
8.00 Credits
Regulatory, fiscal, and monetary policies impact on the organization Dodd-Frank Bill and impact on financial reform Health insurance reform and the impact on the employer Managing risk in an uncertain economic climate
Walter Haig's AICPA Auditing Standards Update
-
Virtual
8.00 Credits
The major topics that will be covered in this class include:AICPA auditing standards issued during the 18-month period prior to the program that impact audits of Small- and Medium- sized entities (SMEs)The new SAS 145 risk assessment requirementsThe new SAS 134 as amended audit reportsHow to fulfill responsibility to detect fraud under AU-C Section 240How to help clients design, implement and maintain their internal controlsTroublesome areas in the audits of Small- and Medium-sized Entities (SMEs) as identified in peer reviews and litigationHow to perform profitable audits of Small- and medium-Sized Entities (SMEs)
Internal Control Changes for Remote Workers
-
Virtual
2.00 Credits
The major topics covered in this course include:The benefits and pitfalls of remote employees.How to maximize the value provided by distance workers.Policies, procedures, and control measures designed for a more geographically dispersed workforce.
Forensic Accounting: Investigating Divorce Cases
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The role of a forensic accountant in divorce proceedingsThe marketing of forensic accounting services to family law attorneysHow to conduct a financial investigationCommon areas to uncover hidden assets or incomeThe basic calculations in evaluating marital assetsTestifying in depositions and divorce court
Documenting Internal Control
-
Virtual
1.00 Credits
Documentation tools such as internal control questionnaires, narratives, flowcharts and control matrixes Auditor considerations for documenting internal controls in a risk assessment Documentation of an assessment of internal control
ChatGPT and Advanced Accounting Research
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The accounting research transformation: Comparing Google vs. AI methodologiesAI ecosystems and specialized models for accounting applicationsAdvanced prompt engineering techniques for financial and tax researchAI-powered search engines and deep research platforms for accounting professionals AI as an ideation and thinking partner for complex accounting problems Specialized accounting research tools and AI superstoresPersona priming and P&P stacking methodologies for optimal AI interactionsEthical considerations and limitations of AI in accounting researchThe compliance chess effect: AI's impact on tax planning and regulatory responseAI-driven automation for regulatory updates and compliance monitoring
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Virtual
2.00 Credits
Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations
Finding Errors in Excel Spreadsheets
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
Monthly Federal Tax Updates - April 2026
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Current individual tax issuesCurrent business entity tax issuesAny current tax legislation occurring during the periodOther issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues
Fraud, Controls & Ethics: Best Practices & Case Studies
-
Virtual
4.00 Credits
The major topics covered in this course include:Examination of actual fraudsDiscussion of internal controls that could have prevented fraudsContemplation of epiphanies for your own professional scenarios.The AICPA Code of Professional ConductOther elements of professional conduct and compliance with professional standards
The Ethics of Care in the Workplace
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Ethical Values and PrinciplesCompassionManaging ExpectationsRespect and HumilityAttribution Theory
