CPE Catalog & Events
Complete Guide to Analyze Data with Excel PivotTables
-
Online
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.
Cryptocurrency Transactions: Navigating Federal Tax Rules
-
Online
1.00 Credits
Member Price: $59
Review existing reporting rules Broker reporting requirements and Form 1099-DA Reporting crypto transactions Basis Safe Harbor Illustrative example
Walkin', Talkin', Lookin' & Listenin' - Or Things Most of Us Don't Do Well
-
Online
2.00 Credits
Member Price: $109
The importance of making yourself available How to start a conversation and what to NOT talk about The art of how to listen When you don’t understand what they just said Don’t fool by equivocations when they respond to a question Materiality and perception
Advanced Cost Accounting: Eliminate Calculation Distortions
-
Online
2.00 Credits
Member Price: $109
Cost Accounting
Fiduciary Accounting: Fundamentals & Rules
-
Online
2.00 Credits
Member Price: $109
Fundamentals of fiduciary accounting Uniform Principal and Income Act Mandatory and discretionary allocations and adjustments Address the trustees ability to override the fallback rules Review the contents of a proper set of trust accounting statements
Building a Better Budget in a Time of Uncertainty
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting
Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 2 (Cryptology)
-
Online
1.00 Credits
Member Price: $59
Effective Communication Skills
-
Online
1.00 Credits
Member Price: $59
Communication Confidence Leadership
What's Changing in Risk Assessment
-
Online
2.00 Credits
Member Price: $109
Auditing Yellowbook
2025 Not-for-Profit GAAP Update
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Accounting Standard Updates issued by the FASB.Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on.
Partnership Essentials: Tax Basis Capital Accounts
-
Online
2.00 Credits
Member Price: $109
Importance of tax basis capital accounts Reporting negative tax basis Tax accounting for property contributed to a partnership Effect of the Ceiling Rule Allocation of depreciation to partners Alternative and Remedial Methods Effect on financial capital accounts Form 1065, Schedule K-1
Surgent's Features and Benefits of SEP IRAs and SIMPLE IRAs
-
Online
2.00 Credits
Member Price: $99
The new Roth SEP IRAs and Roth SIMPLE IRAs created under SECURE Act 2.0 Key factors for choosing a retirement plan for a small business Key questions an advisor must ask a small business owner to help determine which retirement plan is suitable for their business Key questions an advisor must ask a small business owner to help ensure compliance with applicable rules and regulations How SEP and SIMPLE IRAs benefit the small business owner How SEP and SIMPLE IRAs benefit employees of small businesses The tax benefits that help to offset the cost of employer contributions How to determine which business is eligible to adopt a SIMPLE IRA or SEP IRA How to determine which employees must be covered
Surgent's Stock vs. Asset Acquisitions of C Corporations
-
Online
2.00 Credits
Member Price: $99
Advantages and disadvantages to buyer and seller of an asset acquisition and a stock acquisition Tax treatment of consulting agreements and covenants not to compete Sale of personal goodwill associated with an asset acquisition Tax consequences associated with a stock acquisition and an asset acquisition Acquisitive reorganizations Non-tax issues that must be considered when a corporation is acquired
The Preparation of Form 709 - Line-by-Line
-
Online
2.00 Credits
Member Price: $109
Gift tax fundamentals and exclusions Completing Form 709 accurately Gift-splitting and its tax implications Lifetime exemption and GSTT considerations Valuation of gifted assets Common filing mistakes and IRS audits Updates on new legislation impacting gift taxation
Surgent's Update on Recent AICPA Standard Setting: Staying Current in a Changing Environment
-
Online
4.00 Credits
Member Price: $159
AICPA hot topics and standard setting initiatives Discussion of suite of nine integrated SASs effective for years ended December 31, 2021 Discussion of the standard on audit evidence effective for years ended December 31, 2022 Discussion of the standard on auditing accounting estimates and disclosures effective as of December 31, 2023 Discussion of the two standards on use of specialists and information from a pricing service, and the newly updated risk assessment standard effective for years ended December 31, 2023 Discussion of standards that are effective beginning in 2025, including those dealing with client acceptance and questions asked of the predecessor auditor, the partner’s responsibility for engagement quality, group audits, conforming changes to compliance auditing, and more
Overcome Your Obstacles to Abundance
-
Online
4.00 Credits
Member Price: $159
How to know your specific obstacles to becoming rich Why people use poor marketing and investment strategies, and how to overcome such limitations The most effective marketing methods, and how to implement them The power of being super motivated, and 3 methods to keep you motivated long term towards your goals Having a vision for your business and life that will keep you on the right track
S Corporations: Calculating Shareholder Basis
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Discuss the calculation of basis when the entity is formed including the impact of contributed propertyExplain the importance of shareholder loans to the entityUses a comprehensive example to illustrate the mechanics of the basis determination processSchedule K-1 Basis and Form 7203Discuss how basis is impacted by distributions of corporation propertyExplain how basis is impacted by sale/or liquidation of the S corporation interestDiscuss how S corporation losses impact Form 1040 Schedule E reportingShow how to get from the Schedule K-1 information to the basis calculations
Surgent's Achieving High Levels of Compliance and Customer Service in Your Organization
-
Online
4.00 Credits
Member Price: $159
Why customer service is not just having nice people; it is truly serving the customer Analysis of the value of the customer to compare it to various costs creating an ROI How to develop a compliance program that adds value to the customer A hard look at several companies and industries that have mastered the dual objectives How recent developments have affected compliance and customer service
Financial Acumen for Today's HR Leader
-
Online
2.00 Credits
Member Price: $59
Financial Statement Insight Trend Analysis Financial Benchmarks
Why Auditors Fail To Detect Fraud
-
Online
2.00 Credits
Member Price: $109
Reasons auditors fail to detect fraud Willful Ignorance SAS No. 82 Additional documentation How and who to talk to Determining the Tone At the Top How to Determining Intent If you expect it, you will see it