CPE Catalog & Events
Leverage PowerBI.com to Create Data Analysis for Others
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Tour of the PowerBI.com Interface: An in-depth walkthrough of the PowerBI.com environment, focusing on user interface elements, navigation, and customization.PowerBI.com Concepts: Fundamental concepts of PowerBI.com, including its architecture, data handling capabilities, and integration features.Connecting to Data: Techniques for connecting various data sources to PowerBI.com, ensuring seamless data integration and synchronization.Visualizations and Dashboards: Creating impactful visualizations and assembling informative dashboards to present data compellingly.Q&A Feature: Explore the interactive Q&A feature to derive insights through natural language queries.Sharing Datasets, Reports, Dashboards: Best practices for sharing datasets, reports, and dashboards with different audiences so they can leverage your data analysis work.Creating Apps: Learn how to package reports and dashboards into apps for easy distribution and consumption.
ACPEN: HR Investigations – Episode 3 – Gathering-Analyzing-Reporting
-
Online
1.00 Credits
Documentary evidence gathering and analysis Site visits Surveillance Analysis by comparison and contrast Analysis by quantifying and connecting Analysis by identifying patterns Written reports Testifying
ACPEN: Rethinking Your Customers to Maximize Profitability: Identifying the Right Clients
-
Online
2.00 Credits
Who is your customer? What is solution-based planning for customer value? Recognizing internal customers (e.g., departments served by finance) Exploring profitability differences between customers with similar revenue Creating and sustaining a customer value pyramid
Profiles in Fraud
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Real life fraudsters: what they did, how they got away with it, how they finally were caughtProfiles: the characteristics the fraud perpetrators have in commonTechniques to prevent and deter these common schemes
ACPEN: Common Yellow Book & Single Audit Deficiencies
-
Online
4.00 Credits
Common peer review deficiencies in Yellow Book engagements Common peer review deficiencies in Single Audit engagements Yellow Book requirements (independence, CPE, reporting) Single Audit compliance requirements Internal controls over compliance Compliance testing and major program determination Root causes of audit deficiencies and prevention strategies
CPA to CFO: Essential Competencies for Finance Leaders
-
Virtual
1.00 Credits
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Top competencies hiring executives seek in CFO candidates based on survey of 320+ CEOs and recruiters Critical thinking frameworks and strategy creation techniques for financial leadership Forward-looking financial skills including capital management, forecasting, and funding strategies Industry-specific requirements for high-growth companies and nonprofit organizations Practical career development strategies to build CFO-ready competencies
ACPEN: The Role of Internal Audit in Operational Audits
-
Online
2.00 Credits
The important role of operational audits Best practices for designing and performing operational audits Identifying causes of operational issues and risk exposures Developing solutions to enhance the operational performance of business activities, processes, and resourced deployed across the organization Delivering clear, transparent, and objective audit reports to convey critical information
What's Going on at the GASB (2026/27)
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Recent pronouncements issued by the Governmental Accounting Standards Board (GASB)GASB Statement No. 103 (financial reporting model)GASB Statement No. 104 (disclosures for capital assets)cGASB Statement No. 105 (subsequent events)Active GASB exposure drafts and ongoing projects
Surgent's Buying and Selling a Business: Tax and Structuring Overview
-
Virtual
4.00 Credits
An overview of the beginning of the process and documents for preliminary tax planning Recognizing the need for due diligence in acquisitions, including checklists of important points Deemed asset sales – §338 and §338(h)(10) The impact of the §197 amortizable intangibles regulations on the acquisition and disposition of a business Allocating purchase price for tax advantage Planning to avoid double taxation under the repeal of the General Utilities doctrine Special problems and opportunities when an S corporation is the buyer or seller Installment sale and interest issues Avoiding tax pitfalls and recognizing tax planning opportunities Unique issues in buying and selling LLC/partnership interests Impact of the net investment income tax (NIIT) and the §199A pass-through deduction on the tax due on the sale of a pass-through entity Individually owned goodwill
Surgent's Guide to Payroll Taxes and 1099 Issues
-
Virtual
4.00 Credits
Statutory employees, independent contractors, and possible changes to §530 relief Using SS-8 Payroll Tax Penalties -- Who is a responsible person? Forms W-2, 1099, 1099-NEC, SS-8, W-4, 941, and Form 940 reporting/deposit requirements and due dates Understanding payroll tax responsibilities in the gig economy
Surgent's Advanced Individual Income Tax Return Issues
-
Virtual
8.00 Credits
New issues for the current year tax return and §199A Installment sales — understanding the complicated issues Form 8582: Passive losses with carryovers — Complicated case with filled-in forms Puts, calls, straddling, and unusual investments — Understanding the tax laws and reporting them correctly on the tax return Capital gain and loss issues — The problem with proper reporting of installment sales issues; capital gains and losses; when is a stock worthless; and much more... At-risk rules: What a return preparer really needs to know Passive loss issues — You cannot just trust your software. What to watch out for and the questions you need your clients to answer in order to do it right! Incentive and nonqualified stock options — Reporting; key strategies for planning; dealing with the alternative minimum tax Alternative minimum tax — Understanding it; planning strategies to avoid it; using the minimum tax credit; explaining it to a client Form 6251: Detailed calculation example
Tax Fundamentals of LLCs and Partnerships - Tax Staff Essentials
-
Virtual
8.00 Credits
Basic tax structure of partnerships and LLCs Check-the-box elections to be taxed as a partnership Partnership distributions Compensatory payments to partners At-risk and passive activity limits Profit and loss allocations: general rules and restrictions
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Virtual
8.00 Credits
Discussion of key individual provisions of the One Big Beautiful Bill Act, such as TCJA provisions made permanent, new tip income deduction, new overtime pay deduction, Trump accounts, and the expanded SALT cap Comprehensive coverage of business provisions of the One Big Beautiful Bill Act, including but not limited to: Bonus Depreciation made permanent Increased §179 deduction Changes to §174 R&E Expenditures Changes to §163(j) Form 1099/1099-K changes Qualified Small Business Stock Exclusion Excess Business Loss Limitation Section 1244 Small Business Stock and Section 1202 Qualified Small Business Stock treatment and applicability Principles and considerations for nonresident withholding, composite payments, and passthrough entity taxes Partnership Distributions, Form 7217, and S Corporation Redemptions Thinking beyond §163(j) -- Interest Allocation Rules, Original Issue Discount, Applicable High Yield Discount Obligations, Convertible Corporate Debt Instruments, and Debt-Financed Distributions Timely coverage of breaking tax legislation Selected Practice and Reporting Issues: What’s new? A review of recent cases and tax law changes and IRS guidance affecting S corporations, partnerships, limited liability companies, and limited liability partnerships Decentralized Autonomous Organizations (DAOs)
Start From Trust: An Evidence-Based Approach to AI Adoption
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Why one visible machine error collapses trust while identical human error does not, and what that asymmetry costs firms in both directionsWhere small and midsize firms actually stand on AI adoption, and why a firm that has not adopted broadly is not automatically behindCalibrated trust: the difference between misuse (overtrust), disuse (undertrust), and trust matched to what a tool actually does wellThe five-stop adoption spectrum: paralysis, accidental delay, informed caution, responsible piloting, and reckless adoptionThe AI Trust and Usage Quadrant: four firm postures and the next step each one impliesGoverned versus unstructured AI use, and why staff already bringing their own tools makes abstention a decision rather than an optionWhat the evidence says about human and AI combinations, and the two task questions that predict whether a tool will help or hurtReading vendor claims: the gap between a demo and production, and why fluent explanations increase acceptance of wrong answersFive trust questions to ask any AI vendor: permission, uncertainty, audit trail, explainability, and change controlThe NIST AI Risk Management Framework trustworthiness characteristics as a technical backboneThree vulnerabilities that current firm financial performance can conceal: client expectations, talent, and deferred learningCognitive offloading and skill retention: what firms lose by waiting, and the conditions under which offloading frees capacity insteadFive actions a firm can take this week, and four evidence-based rollout rules for a first pilot
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.
Microsoft Outlook "Must Know" Email Tips
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Using Quick Parts to streamline message composition.Eliminating inefficient back and forth appointment scheduling with the Bookings app.Using category codes and contacts to send bulk emails.Sending emails to Teams and OneNote.Organizing your inbox with custom views, rules and folders.Mastering the search tools to find emails quickly.Review of key option settings to maximize email productivity.
Finance and Innovation: Reinvent Your Organization and Dept.
-
Virtual
8.00 Credits
The major topics that will be covered in this course include:What is innovation?The different forms of innovation, e.g., sustaining and disruptive.The five discovery skills needed to be innovative?The value of why we need to find ways to say, “Yes!” How to change your processes, rules and departments to be more innovative? Lessons learned from innovative businesses with examples.How does innovation happen and how to make innovation stick?The need to improvise and embrace broad experiences.
ACPEN: Introduction to Governmental Accounting
-
Online
2.00 Credits
Foundational principles of governmental accounting Fund accounting concepts Modified accrual basis of accounting Governmental fund financial statements Government-wide financial statements Component units in governmental reporting
ACPEN: The Many Faces of Fraud
-
Online
2.00 Credits
Fraud Indicators Fraud Patterns Client Operations Transaction Analysis Independent Verification Fraud Recognition
Advanced Excel for Staff - Build Reports and Analyze Data
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Building Reports Workflow: Understand the steps for creating professional and functional reports.Gather and Organize Data: Learn best practices for compiling and cleaning data for accurate analysis.Set Calculations and Key Metrics: Apply formulas and functions to calculate meaningful insights. Format and Structure Report: Use formatting tools to create visually appealing and structured reports.Review and Validate: Verify data accuracy and troubleshoot potential errors.Share the Report: Learn methods for distributing reports effectively within your organization.
