CPE Catalog & Events
This will generate a PDF of the current filtered catalog
NotebookLM Use Cases for Accountants
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:NotebookLM fundamentals: notebooks, sources, prompts, and outputsTurning financial PDFs into searchable, conversational knowledge basesAudit and assurance use cases: workpaper synthesis and issue trackingTax and regulatory research: comparing guidance across sourcesCross-referencing: tracing claims back to documents for defensibilityDrafting deliverables: memos, client notes, and executive summariesRisk controls: confidentiality, data handling, and “trust-but-verify” habits
The 10 Must Know Excel Features
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
ACPEN: Internal Control Frameworks for Single Audit
-
TBD
1.0 Credits
Member Price: $39
COSO 2013 Update Yellowbook Accounting
ACPEN: Be the Sun, Not the Salt, featuring Harry Cohen and John Daly
-
TBD
1.0 Credits
Member Price: $39
What is the Heliotropic Effect? Be the Six Sun Pearls. Today is a good day to do good Be the bright spot in the room Be your own sun Do the next right thing Pet peeves bite Knowing isn't doing
ACPEN: Ethical Situations – What to do When?, featuring Allison McLeod and Don Minges
-
TBD
1.0 Credits
Member Price: $39
Intentions versus results. Is using the ‘Threats Based Approach’ always the best? What is, “The clean hands rule,” and how does it apply to Ethics? Situations where Ethics is not black-and-white.
ACPEN: Performance Management - Hiring to Retiring
-
TBD
1.2 Credits
Member Price: $39
Employee Engagement Recruiting/Staffing Talent Management Employee Relations
ACPEN: The Controllership Series - The Future Role of the Controller Part 2
-
TBD
1.5 Credits
Member Price: $79
Accounting and Finance
ACPEN: K2's Stop Wasting Time In Excel
-
TBD
2.0 Credits
Member Price: $89
New Excel features that can enhance your efficiency, accuracy, and productivity Legacy Excel features that can save you time Options for integrating AI into Excel Data manipulation features in Excel
ACPEN: SAS 145: Modern Risk-Based Auditing
-
TBD
2.0 Credits
Member Price: $89
Introducing SAS 145 Revisiting audit risk Risk assessment in the SAS 145 Era Analyzing SAS 145 Documentation requirements
ACPEN: Internal Controls That May Have Prevented Fraud
-
TBD
2.0 Credits
Member Price: $89
Understand what factors allowed certain frauds to occur Recognize what internal controls may have prevented the frauds Consider application of these lessons to circumstances you encounter in your professional endeavors
ACPEN: Mergers and Acquisitions: Complete Guide to Relevant Issues
-
TBD
2.0 Credits
Member Price: $89
Taxable asset acquisitions vs. non-taxable stock/equity acquisitions What happens in an asset acquisition What happens in a stock or equity acquisition 338 and 336 elections Basics of 382 Basics of 280G Earnouts and contingent payments Assumed liabilities Acquired reserves Acquired deferred revenue Treatment of transaction costs Basics of mixed entity transactions, examples such as: C-Corp buys an interest in a partnership C-Corp buys an S-Corp C-Corp buys an interest in an LLC (lots of possibilities here) S-Corp buys a partnership S-Corp buys a C-Corp S-Corp buys an interest in an LLC Partnership acquisitions of various entity types Very basic overview of tax-free re-organizations High level overview of entity formations High level overview of entity liquidations or termination
ACPEN: K2's Optimizing Your CAS and Advisory Tech Stack
-
TBD
2.0 Credits
Member Price: $89
CAS overview to understand the service offerings, client needs, and market opportunities Selecting technology tools in CAS for accounting, workflow, and client collaboration Designing Service Delivery Models that are scalable and efficient processes for CAS Managing client relationships and setting expectations to deliver consistent value
ACPEN: Mergers & Acquisitions: Tips and Speed Bumps to Avoid
-
TBD
2.0 Credits
Member Price: $89
Making strategic acquisitions Identifying potential acquisition candidates Alternatives to M&A Identifying and understanding organizational culture Understanding the keys to effective and efficient due diligence Planning and executing an effective integration Key considerations
ACPEN: Strategic CFO – Developing Strategy and the Why
-
TBD
2.0 Credits
Member Price: $89
What strategy really means and who is involved in developing it Common reasons strategic plans fail and how to avoid them Cost leadership, differentiation, and niche strategies Using metrics, KPIs, and the Balanced Scorecard to measure success The role of non-financial drivers in financial performance Benchmarking and competitive analysis Aligning mission, culture, and strategy Case discussions on strategy execution and performance measurement
Accounting for and Auditing Cryptocurrency & Digital Assets
-
TBD
0.0 Credits
Member Price: $89
The major topics covered in this class include:Common applications related to initial recognition and measurement, subsequent measurement or derecognition, presentation, and disclosure of cryptocurrency and other digital assetsFeedback from the AICPA's Digital Assets Working Group intended to assist auditors with opining on these digital records
Surgent's Employee vs. Independent Contractor: Achieving Success in a Worker Classification Audit
-
TBD
2.0 Credits
Member Price: $99
The 20 common law factors in a worker classification audit that are used to distinguish an employee from an independent contractor How disgruntled independent contractors can use IRS Form 8919 against a former employer When and how to use §530 as a defense in worker classification audits What is "industry practice" for §530 purposes Common sense steps that will avoid the recharacterization of workers treated as independent contractors to employees The IRS’s Voluntary Classification Settlement Program — advantages and disadvantages The DOL Final Rule
Surgent's Guide to the AICPA Quality Management Standards
-
TBD
2.0 Credits
Member Price: $99
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
ACPEN: Avoiding Peer Review Deficiencies and Professional Liability in Public Accounting
-
TBD
4.0 Credits
Member Price: $149
Differentiating risks faced when performing various levels of professional services, such as audits, 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
ACPEN: Fiduciary Accounting & Tax Planning for Estates & Trusts
-
TBD
4.0 Credits
Member Price: $149
Fundamentals of fiduciary accounting Uniform Principal and Income Act Discretionary Power to Adjust Allocations between principal and income Trust accounting 3.8% Net Investment Income Form 1041 - Schedule I Section 645 Election Simple or complex trusts
ACPEN: Navigating Mergers & Acquisitions with AI: The Future of Deals
-
TBD
4.0 Credits
Member Price: $149
Strategic Reasons for Mergers & Acquisitions Establishing Acquisition Principles and Target Criteria Business Valuation in the M&A Process Structuring the Transaction and Negotiating the Deal Conducting Effective Due Diligence Post-Transaction Integration and Deal Success