CPE Catalog & Events
Mastering the Excel Lookup Functions
-
TBD
0.0 Credits
Member Price: $89
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: Cryptocurrency Transactions: Navigating Federal Tax Rules
-
TBD
1.0 Credits
Member Price: $39
Review existing reporting rules Broker reporting requirements and Form 1099-DA Reporting crypto transactions Basis Safe Harbor Illustrative example
ACPEN: Emotional Intelligence for Professionals: Mastering the Human Side of Success
-
TBD
1.0 Credits
Member Price: $39
Emotions Relationships Emotional Intelligence Communication
ACPEN: Behind the Rx: Demystifying Pharmacy Benefit Management and Creating Transparency
-
TBD
2.0 Credits
Member Price: $89
PBM
ACPEN: K2’s Taking Another Look At PDFs
-
TBD
2.0 Credits
Member Price: $89
Understanding the Portable Document Format Identifying tools you can use to work with PDFs Collaborating using PDFs Creating, distributing, and collecting fillable PDF forms Using PDFs to enhance security
ACPEN: Common Sense CFO: Balance Sheet Issues Walk through to Understand and Build Value
-
TBD
2.0 Credits
Member Price: $89
Typical accounting issues that impact the balance sheet Where are the hidden issues in unrecorded liabilities? What are unrecorded assets and why they matter? Identification of and resolution of balance sheet challenges and changes Communicating to your audience and stakeholders
ACPEN: Accounting Update in a Post COVID-19 World
-
TBD
2.0 Credits
Member Price: $89
Risk assessment Government assistance Pandemic-related accounting pronouncements Learning to be an auditor in a pandemic environment Financial statement disclosures Exploring liquidity options
Common Financial Statement Disclosures
-
TBD
0.0 Credits
Member Price: $89
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
Surgent's Incredible Leadership Transformations in Accounting - Ways to Improve Leadership and Communication
-
TBD
2.0 Credits
Member Price: $99
Explore the tenets of exemplary leadership which are requirements for highly effective leaders who achieve results and are respected by team members, peers, and other leaders Review key practices that recognize and build on leadership strengths to create a team environment that is productive, profitable, strengthens team members’ morale, and fosters positive energy in the work climate Examine SMART goals to inspire teams to tackle tough challenges and help team members reach and exceed their potential Review conflict management techniques to minimize negative attitudes and foster win/win resolutions for team members
Surgent's Critical Issues Involving Taxation of Construction Contractors
-
TBD
4.0 Credits
Member Price: $159
The impact of recent legislation on the construction industry (including the OBBBA) How to qualify for the small contractor exemption and its advantages for the taxpayer Options available to small contractors regarding taxation of long-term contracts How the choice of entity impacts taxation of contractors How AMT impacts the construction industry IRC §460 and large contractors How uninstalled materials impact taxation of contractors Look-back rules Using the 10 percent method to allow certain contractors to defer recognizing taxable income Critical tax planning strategies for contractors
Al Capone to Cybercrime: The Journey of IRS Special Agents
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to IRS Criminal Investigation (CI): Overview of its mission, role, and significance in maintaining tax compliance.Historical Evolution: From its inception in 1919 to its current role, highlighting key milestones and notable cases.Investigative Techniques and Tools: Detailed look at the methods and technologies used by CI agents to uncover financial crimes.Importance of IRS CI: Discussion on the impact of CI’s work on tax compliance, public confidence, and the broader financial system.Training of CI Agents: Insight into the rigorous training programs at FLETC and ongoing professional development.Process of Investigations: Step-by-step breakdown of how tax fraud and money laundering cases are initiated, investigated, and prosecuted.
ACPEN: K2’s Excel Essentials For Staff Accountants
-
TBD
8.0 Credits
Member Price: $250
Best practices for creating and working with Excel workbooks Effectively using Excel functions when creating formulas The importance of PivotTables in modern reporting environments Best practices for formatting your workbooks
2026/27 Not-for-Profit GAAP Update
-
TBD
0.0 Credits
Member Price: $55
The major topics that will be covered in this course include:Recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline.The International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025.
IRS Penalties and Abatements
-
TBD
2.0 Credits
Member Price: $89
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
Surgent's Guide and Update to Compilations, Reviews, and Preparations
-
TBD
4.0 Credits
Member Price: $159
SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services – 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26, Quality Management for an Engagement Conducted in Accordance with Statements on Standards for Accounting and Review Services SSARS No. 27, Applicability of AR-C Section 70 to Financial Statements Prepared as Part of a Consulting Services Engagement Sample comprehensive engagement work programs for preparation, compilation, and review engagements
Common Deficiencies in SSARS Engagements
-
TBD
0.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Frequent problem areas in preparation, compilation, and review engagementsThe root causes of noncompliancePractical approaches firms can use to improve consistency, documentation, and overall engagement performance
ACPEN: Ethics Aren't for the Byrdes in Ozark
-
TBD
1.0 Credits
Member Price: $39
Ethical business behavior Ethical business decisions Ethical management decisions Ethical decisions in human resource management
ACPEN: 1065 – Understanding Partnerships Tax Returns
-
TBD
2.0 Credits
Member Price: $89
Partnership taxation Different types of partnerships Tax obligations of partners Role of the partnership agreement in tax reporting Filing deadlines of Form 1065
ACPEN: Global Internal Audit Standards (GIAS) Domain III - Part 2
-
TBD
1.0 Credits
Member Price: $89
Internal Audit Internal Controls GIAS Institute of Internal Auditors Standards Accounting
ACPEN: International Tax Treaties
-
TBD
2.0 Credits
Member Price: $89
Tax treaties Tax impact of cross-border transactions