CPE Catalog & Events
Surgent's Accountability and Action
-
Webinar
4.00 Credits
Member Price: $159
Defining three critical elements: responsibility, empowerment and accountability, and how they work together to create results Designing and using clear agreements that provide clarity Skills for holding yourself and others accountable for results, no matter what Knowing where you are in the accountability game... what you do/don’t do well
Complete Guide to Analyze Data with Excel PivotTables
-
Webinar
4.00 Credits
Member Price: $149
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.
Financial Statement Presentation, Disclosure, and Analysis
-
Webinar
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:U.S. GAAP and Special purpose frameworksForm and content of financial statements: Balance sheets; Income statements; Statements of cash flows; Retained earnings and/or owners’ equity statements; Comprehensive income; Supplementary informationComparative vs. single-period financial statementsSufficiency of disclosuresIllustrative disclosures frequently encountered in small-to-medium reporting entitiesIndustry-specific nuancesPurposes of financial statement analysis Trend analysis and vertical & horizontal analysisSimple and multivariate regressionAnalysis of metricsAssessment of liquidity, solvency, and profitabilityUsing data visualizationsThe role of qualitative factors
Leverage PowerBI.com to Create Data Analysis for Others
-
Webinar
2.00 Credits
Member Price: $89
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.
Tax Update: "One Big Beautiful Bill"
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Individual Taxation: Child Tax Credit expansion and additional senior deduction SALT cap extensionIncome & Adjustments: Tip income exclusion, overtime relief, educator expensesEducation Incentives: Student loan discharge, 529 plan expansion, new “TRUMP Accounts”Business Taxation: Bonus depreciation, 199A expansion, interest deduction limitsEstate & Gift Tax: Increased exemption threshold, charitable deduction changesCompliance & Reporting: 1099-K, 1099-NEC and 1099-MISC threshold changes
Forensic Accounting: Investigating Divorce Cases
-
Webinar
4.00 Credits
Member Price: $149
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
Internal Control - Testing for Operating Effectiveness
-
Webinar
2.00 Credits
Member Price: $89
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
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Webinar
2.00 Credits
Member Price: $99
Automation capabilities of Excel The “Get & Transform” Tool Using “Get & Transform” for flattening, splitting and combining data, unpivoting summarized data, and combining CSV exports
Multi Year Failure to File: Getting into Compliance
-
Webinar
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:Process-from client onboarding and transcript analysis.Risk assessment, ethical considerations, and resolution strategies.Manage cases involving individuals, married couples, businesses, payroll taxes, and S corporations.Real-world examples, IRS references, and best practices are integrated throughout to ensure confidence and compliance.
Todd and Julie Chrisley Go to Prison
-
Webinar
2.00 Credits
Member Price: $89
Major topics covered in this course include:What is bank fraud?What is wire fraud?Role of financial service professionals in combating tax evasion and white-collar crimeRed flags indicating of white-collar crimesImportance of knowing customersCriminal justice proceedingsRelationship between victim impact and sentencingRelationship between loss amounts and sentencing
AI & Accounting in Manufacturing
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Intelligent automation and dark factoriesPredictive maintenance and real-time cost trackingAI-enabled financial reporting and dashboardsContinuous auditing and anomaly detectionTax compliance automation and transfer pricing AIData governance and cybersecurity in financial systemsWorkforce reskilling and AI-augmented financial roles
Monthly Federal Tax Updates - April 2027
-
Webinar
2.00 Credits
Member Price: $89
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
Surgent's Purchase and Sale of a Residence: Critical Tax Issues
-
Webinar
2.00 Credits
Member Price: $99
General rules relating to the sale of a residence under § 121 Sale of a taxpayer’s main home Qualifying for a partial exclusion of gain on the sale of a home How a taxpayer meets the residence requirement Meeting the look-back requirement Separated, divorced, and widowed taxpayers Work-related moves and unforeseeable events Inherited homes and homes received in a divorce Impact of business or rental use of home on the gain exclusion Reporting gain or loss on the sale of a home
Ethical Intelligence: Global Case Studies & Standards 26-27
-
Webinar
4.00 Credits
Member Price: $175
Ethical Responsibilities for CPAs AICPA Code of Professional Conduct PCAOB Independence & Ethics Sarbanes—Oxley Act Circular 230 Foreign Corrupt Practices Act Whistleblower & Reporting Duties (incl. Dodd-Frank) California State Board Ethics & Enforcement Data Privacy & Confidentiality (CCPA/CPRA)
Surgent's Ethical Considerations for the CPA
-
Webinar
4.00 Credits
Member Price: $159
Examine the CPA's role in today's economy Compare similarities and differences between individual and business ethics Explore the link between ethics, integrity and scruples Discuss the basic attributes of ethics and professional conduct Review the history of the CPA profession and the CPA's requirement to adhere to ethics policies and codes of conduct Review the AICPA's Code of Professional Conduct and a CPA's responsibilities to the public, clients and colleagues Discuss the common rules and statutes faced daily in the CPA profession. Case studies may also be utilized to present potential ethical dilemmas CPAs may face during their careers Review CPA Independence violations by current legal case examples
Mastering Partnership Basis: Inside and Outside Basis
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Explain the use of both "inside" and "outside” basis determination.How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property.Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis.Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest.Comprehensive example to illustrate the mechanics of the basis determination process.
Written Information Security Plans
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Introduction to the Gramm-Leach-Bliley Act and its impact on data security.Circular 230 compliance and due diligence for practitioners.AICPA Statements of Standards relevant to WISP requirements.Key components of a Written Information Security Plan.Training requirements for employees, staff, and contractors.Practical guidance for drafting and implementing a WISP.FTC enforcement of data security standards for PTIN holders.Best practices for maintaining and updating WISP compliance.
Common Financial Statement Disclosures
-
Webinar
2.00 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
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups
-
Webinar
2.00 Credits
Member Price: $89
Excel shortcuts Conditional summing Removing duplicate values VLOOKUP function
Fraud & Embezzlement: Case Studies from the Trenches
-
Webinar
0.00 Credits
Member Price: $89
The major topics that will be covered in this class include:How organizations can find themselves defrauded due to lax oversight and weak internal controls.How the existence of the "trusted advisor" creates situations where CPAs can drop their professional skepticism.Illustrations of the issues companies should look for in preventing fraud and embezzlement.