CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
ACPEN: K2’s Data Analytics For Accountants And Auditors
-
Online
4.00 Credits
Understanding the importance of data analytics in modern business environments Generating and interpreting data analytics using everyday applications such as Microsoft Excel and Microsoft's Power BI platform Using regression analysis to create and validate forecasts and projections
Surgent's Annual Accounting and Auditing Update
-
Virtual
8.00 Credits
Recently issued FASB Accounting Standards Updates, PCC Update, and items on the FASB’s Technical Agenda Recently issued ASUs covering derivatives, credit losses under ASC 326, government grants, and expense disaggregation FASB Final PIR Report for Leases (Topic 842) Statement on Quality Management Standards: SQMS 1, SQMS 2, and SQMS 3 Proposed SAS on the auditor’s responsibility relating to fraud Recently issued SASs and other AICPA activity Recently issued PCAOB standards and SEC rulemaking activities Other important A&A practice matters
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)
Advanced ChatGPT for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to ChatGPT and its Applications in Accounting.Custom Instructions (CI) for Persistent Context in Financial Conversations.Analyzing Financial Statements and News Releases using ChatGPT.Exploring Business Opportunities through Hyper-Local and Sectoral Analysis.Advanced Data Analysis for Financial Comparisons and Capital Asset Audits.Image Analysis for Asset, Space, and User Interface Design.Voice Interaction with ChatGPT for Enhanced User Experience and Accessibility.
Money Laundering Awareness for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Money laundering overviewRole of tax examiners and auditorsTax return examinationPre-audit indicatorsAudit flagsReal estate issuesCash indicatorsInternational trade signalsLoan considerationsProfessional service provider concernsMoney laundering and ethics
ACPEN: HR Investigations – Episode 1 – Introduction-Assessing-Planning
-
Online
1.00 Credits
Investigation terminology Assessment skills Investigative methodology
ACPEN: Reclaiming Your Energy - 3 Keys to Control Your Chaos and Boost Resilience
-
Online
1.00 Credits
Leadership Professional Development Time Management
ACPEN: From Numbers to Narrative: Effectively Presenting Your Budget and Reporting
-
Online
2.00 Credits
Identifying the ‘Big Picture’ and your role in effective communication Communicating so others can understand us Understanding a presentation’s anatomy? Tips and tricks for budget presentations
ACPEN: Cash Flow Clarity: Effectively Communicate Cash Flows for your Board and C-Suite
-
Online
2.00 Credits
The importance and structure of the cash flow statement Understanding operating, investing, and financing activities Presenting the statement using the "Sources and Uses" approach How to tell the business story through cash flows and alternative reporting methods Identifying key drivers of cash and liquidity Bridging the gap between accrual accounting and understanding cash Communicating effectively with CEOs, boards, and non-financial stakeholders
Surgent's Ethical Considerations for CPAs
-
Virtual
0.00 Credits
Auditor independence and its importance to the public accounting profession Common threats to auditor independence AICPA’s framework for assessing conflicts of interest Unique threats related to non-attest services to attest clients Common safeguards to help assure compliance with relevant rules and regulations
ACPEN: S Corporation Essentials: Review & Update
-
Online
4.00 Credits
Recent tax legislation, rules, and developments impacting S-corporations S corporation shareholder basis in stock and debt S corporation open account debt Limitation of deduction of losses AAA and distributions
ACPEN: Expand Your Analytical Toolbox More Tools for Success
-
Online
4.00 Credits
5 step valuation process 2 specific valuation approaches The Gordon Model 10 thoughts on banker selection Rating your bank 10 hints for keeping your toolbox full
ACPEN: K2’s Implementing Internal Controls In QuickBooks Online Environments
-
Online
4.00 Credits
Critical risks in QBO environments Internal control options that can mitigate risk to prudently acceptable levels Enabling alternative control measures to improve internal controls in QuickBooks environments
Microsoft Teams for CPAs: Unlocking Its Full Potential
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Best practices for organizing your teams and channelsUnderstanding the role of Teams and SharePoint integrationUsing Teams to communicate and collaborate externally with clientsTips and tricks for managing conversations in TeamsLeveraging Microsoft Copilot AI in Teams
ACPEN: How to Make Difficult People Disappear...Without Breaking the Law
-
Online
1.00 Credits
Conflict Management Interpersonal Relationships Personality Styles
ACPEN: Key Tax Issues for Individual Taxpayers
-
Online
2.00 Credits
"Tax-mageddon" – the all-important impending expiration/extension/renewal of the TCJA Recent legislative, judicial, and IRS developments impacting individual taxpayers 2025 Tax rates and inflation-adjusted figures Cryptocurrency reporting and new Form 1099-DA Form 1099-K and previously unreported income Other recent legislative developments impacting individual taxpayers
Individual Tax Update: OBBA and Recent Developments
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Legislation impacting individual taxpayersThe One Big Beautiful Bill ActExtenders legislation updateChild tax and dependent care creditsSection 199A deductionCapital gains and lossesRental real estateOther passive activities losses
Introduction to Governmental Budgeting
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The basics of governmental budgeting.Common steps and timeline of the budget process.What, when and how we should be monitoring the budget throughout the year.How long-term budgets fit in with the annual budget process.
ACPEN: The Power of a Good Story!
-
Online
4.00 Credits
The 3 elements of storytelling 3 real world examples 10 thoughts for the road
