CPE Catalog & Events
Streamlined Excel Reporting Series Session 2: Working with PivotTables
-
Virtual
2.00 Credits
Report type comparison Customizing PivotTable options Format and design options Calculated fields and items Multiple value fields
What's Going on at the AICPA (2025)
-
Online
6.00 Credits
EBP Audits Auditing AICPA
Recruit. Retain. Engage. Mastering LinkedIn for HR Success
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:How to pro-actively find, identify, and connect with new candidates from various sources within LinkedIn.Best practices for organically attracting candidates to your company and team.Strategic talent networking opportunities.Essential considerations of employee advocacy and brand building using LinkedIn.Retention strategies such as promoting a positive work environment, and expanding employee recognition and engagement strategies.
Money Laundering 101 for CPAs
-
Virtual
4.00 Credits
The major topics covered in this class include:The theory of money launderingCommon money laundering statutesExamples from court cases of money laundering statutesCommon occurrences with CPAsPossible money laundering transactionsApplying the money laundering statutes in real life scenarios
Addressing Common Documentation Deficiencies
-
Online
2.00 Credits
AU-C 230 Auditing Yellowbook
FASB Update and Review
-
Online
2.00 Credits
FASB updates that will affect near-term reporting Future topics that may soon be addressed by the FASB
Common Sense CFO: Crisis Management, Innovation, and Other Expectations Put on CFOs
-
Online
2.00 Credits
Championing the role of innovation in the workplace Crisis management What does it mean? What is our role? The roles we take on and differences between the roles we are assigned? Current and future trends and expectations for financial leaders and CFOs Top ten crucial skills for 2035 from the Far Side’s wisdom
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
Surgent's The Art of Delegation: Strategies for Improving Your Skills
-
Virtual
2.00 Credits
What is delegation? Why is delegation important? When and to whom should tasks be assigned? How can you delegate effectively? How do you deal with problems and issues when they arise?
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
Internal Control - Testing for Operating Effectiveness
-
Virtual
2.00 Credits
The major topics covered in this class include:Generally accepted audit requirements related to testing controls for operating effectivenessIdentifying key controls that may prove effective and efficient to test in a control reliance strategyResponses when deviations are discovered when evaluating the design or operating effectiveness of internal controlLeveraging audit evidence available for Service Organization Control (SOC1) ReportsGeneral computer control considerations when evaluating the design and operating effectiveness of internal control over financial reporting
Installment sales: Maximize Tax Benefits and Stay Compliant
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Installment sale treatment eligibilityWhen to elect out of installment sale treatmentInstallment sale of business assetsInstallment sale default and the rules for personal property versus real propertyInstallment sales and depreciation recapture
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
Surgent's Guide to the AICPA Quality Management Standards
-
Virtual
2.00 Credits
Quality management standards SAS 146, SSARS No. 26, and SSAE 23 Risk assessment, which forms the basis of the SQM Monitoring and evaluating the SQM
Surgent's Construction Contractors: Accounting and Financial Reporting Issues
-
Virtual
4.00 Credits
Overall landscape of the construction industry GAAP and recent changes affecting the construction industry The Revenue Recognition Standard and its impact on the construction industry The unique relationship between the contractor and the surety The lease FASB ASC and its impact on the construction industry
How to Audit Inventory
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Auditing Inventory.Related Audit assertions, risks, and threats to inventory.Substantive auditing procedures that staff should perform.
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
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
Complete Guide to Analyze Data with Excel PivotTables
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
Disrupt to Dominate: Mastering Change Leadership
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The urgency of leading change now & the steps in leading changeThe power of crafting a vision that encourages buy-inThe art and science of building strong partnershipsAccelerating change through relationship networksCommunication strategies for changeEstablishing a feedback culture for successful changeManaging self in times of changeCase studies and real-world scenarios
