CPE Catalog & Events
Surgent's Use the Data Model to Build More Powerful PivotTables
Creating a data model/Power Pivot Building PivotTables from multiple tables Creating Measures Using named sets
Webcast: ACPEN: 2026/27 Governmental Auditing Update: Yellow Book & Uniform Guidance
2024 Yellow Book revisions and implementation updates Quality management and key audit role changes GAO implementation delay and audit planning implications Green Book updates and internal control considerations 2024 Uniform Guidance overhaul Single Audit requirement updates AICPA GAS/Single Audit Guide (Appendix B) changes
Webcast: Form 1041 Advanced Series Part 1: Why Complex Trusts Are Complicated 26-27
How to Identify a Complex Trust and the Complications that Arise with Complex Trusts The Importance of Recognizing the Tier System used by Complex Trusts The Advantages and Requirements of the 65-day Rule Special Issues Related to the Charitable Contribution Deduction Use of a Checklist for Complex Trusts
Webcast: Form 706 Preparation Part 3: Reporting Deductions 26-27
How to Identify a Complex Trust and the Complications that Arise with Complex Trusts The Importance of Recognizing the Tier System used by Complex Trusts The Advantages and Requirements of the 65-day Rule Special Issues Related to the Charitable Contribution Deduction Use of a Checklist for Complex Trusts
Webcast: ACPEN: Avoiding Legal Liability and Peer Review Deficiencies in Nonaudit Services, Including Bookkeeping and Preparing Financial Statement
Differentiating risks faced when performing nonaudit services, such as reviews, compilations, preparing financial statements, bookkeeping, tax return preparation, and similar Best practices for preventing quality control concerns that could lead to peer review deficiencies or malpractice claims Establishing an understanding with the client to minimize misunderstandings as to the nature and scope of engagements Explain situations when independence should be appropriately safeguarded when performing nonattest services
Webcast: Financial Statement Analysis for Managers 26-27
Pros/cons of ratio analysis Cash flow analysis Operating leverage vs. financial leverage Effective financial performance measures
Webcast: Tax Aspects of Stock Investing 26-27
Active and passive investing Dividend-paying stocks, value stocks, and the net investment income tax Favorable capital gain strategies and the netting process Exchange-traded funds (ETFs), stock options, and straddles
Webcast: The ACFE Report to the Nations 26-27
Results of the study Red-flags in fraud How fraud is perpetrated How fraud is discovered Methods of minimizing fraud
Webcast: ACPEN: Conducting Human Resource Investigations
Research Analysis Interviewing Documenting Reporting Results
Webcast: ACPEN: Risk Assessment of IT Systems
Overview of SAS 145 Risk assessment requirements Role of IT in audit planning Understanding IT environments Identifying IT risks Areas of concern in IT systems Impact of IT risks on the audit
Surgent's Excel Shortcuts for Accountants
Explore the function that sums better than the SUM function Discover a variety of time-saving features, functions, and techniques Learn the workaround to a major Excel pitfall
Surgent's Section 754 Step-Up in Basis: Understanding the Tax Issues for Partnerships and LLCs
How and why a partnership makes a 754 election The effect of the 754 election when an interest in a partnership is sold or inherited How the 754 election applies when a partnership makes a distribution of property to one or more of its partners How to make the 754 basis adjustment
Webcast: Form 1041 Advanced Series Part 2: Cash & Property Distribution Issues 26-27
Calculating DNI & the Distribution Deduction Determining Types of Distributions and Whether a Distribution "Carries Out" DNI In-Kind Distributions & the Impact on the Distribution Deduction Depreciation and the Distribution of In-Kind Property Distributions that Result in "Kenan Gain" Funding a Pecuniary Bequest with Depreciated Property IRC Sec. 643(e)
Webcast: Form 706 Preparation Part 4: GST Schedule R, Form 8971, Payments & Credits 26-27
Generation-Skipping Transfer Tax, Schedule R, including election statements and integration with the marital deduction Foreign Death Tax Credit, Schedule P and Prior Transfer Credit, Schedule Q Qualified Conservation Easements, Schedule U Making Sec. 6166 election and using Graegin loans
Webcast: ACPEN: The FASB Conceptual Framework
Purpose and structure of the FASB Conceptual Framework Recognition and derecognition criteria Measurement concepts and approaches Qualitative characteristics of useful financial information Elements of financial statements Footnote disclosure requirements Relationship between the framework and standard-setting Practical application of the framework in accounting decisions
Surgent's Communicating Financial Results to Stakeholders: A Guide for Client Advisory Services
Communicating financial results The role of the accountant in communication The challenges accountants face in communication Creating better awareness of a company’s financials Behavioral biases of stakeholders Tips for staying on-point in communication Case study
Surgent's Leveraging AI for Data Analytics in Accounting
Transforming data analytics with AI Understanding the impact of AI on data analytics processes How AI enhances data accuracy, efficiency, and decision-making AI tools and techniques for data analysis Overview of AI-powered data analytics tools Techniques for improving data analysis accuracy and efficiency with AI Integrating AI into existing data analytics workflows Case studies on AI implementations for data analytics Success stories of AI-driven data analytics in accounting Challenges and lessons learned from AI integration Measuring the ROI of AI in data analytics Developing AI-powered data analytics skills Hands-on lab sessions using AI tools (e.g., ChatGPT, Excel) Practical exercises in filtering, sorting, summarizing, and visualizing data Applying AI insights to optimize data-driven decision making in accounting
Webcast: ACPEN: Achieving Balance in Work and Life - Part 2
Why we get off balance and how to overcome those tendencies Methods that turbo charge motivation, health and happiness The power of culture and friends to affect our lives The importance of clear intention in order to effect change that lasts
Webcast: ACPEN: Internal Audit: Keys to Managing an Effective Function
Role of today's internal audit leadership Building effective relationships with management and Audit Committee Keys to staffing and training internal audit The synergy of internal audit with other processes and close
Surgent's Forms 7217 and 7203
Tax treatment of partnership distributions to partners of cash and property other than cash Basis of property received in a partnership distribution Executive Order 14219 withdrawing the IRS’s new regulations regarding basis shifting Organization and structure of the new Form 7217 Who must file Form 7203 Determining the S corporation shareholder’s initial basis in his or her stock Basis limitations on partnership losses and deductions Organization and structure of Form 7203 — understanding the three parts of Form 7203 Filing criteria for Form 7203 Calculating an S corporation shareholder’s share of S corporation deductions and credits Understanding stock and debt basis