CPE Catalog & Events
Advanced Tax Planning S Corporations - Tax Staff Essentials
-
Virtual
8.00 Credits
-Basis in S corporation stock -Distributions -Compensation planning -Qualified subchapter S subsidiaries -Liquidations, reorganizations and redemptions -Estate planning and the use of trusts -Section 199A
The 10 Must Know Excel Features
-
Virtual
2.00 Credits
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.
Finance Business Partnering: A Roadmap to Strategic Influence
-
Virtual
1.00 Credits
The session is organized into five sections addressing the following key topics: 1. The Evolution of the Finance role 2. Defining Business Partnering 3. Building Relationships 4. Business Acumen 5. Strategic Thinking and Problem Solving
Google Gemini AI for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Google Gemini Quick StartGemini Standalone ChatbotMobile AppGemini integration with:WorkspaceGmailDocsSheetsSlidesUser Tips
Profitability Pricing: Boost your Bottom Line
-
Online
2.00 Credits
Competitive bids Achieving target profitability
Surgent's Critical Conversations
-
Virtual
2.00 Credits
High stakes conversations where the goal or outcome is paramount A Critical Conversation Worksheet to use as a tool Self-assessment of interpersonal approaches on a continuum from aggressive to silent The stories: mine and yours — are they the same? Contrast statements for ensuring a shared understanding Building confidence in conducting a Critical Conversation
Surgent's Features and Benefits of SEP IRAs and SIMPLE IRAs
-
Virtual
2.00 Credits
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 More Money at the End of the Month: Strategic Ways to Improve Cash Flow
-
Virtual
2.00 Credits
How to optimize cash flow Qualitative evaluations: core earnings and sustainable growth Quantitative evaluations: liquidity ratios Increasing customer base vs. payment terms Business cycle and cash Behavioral finance biases Managing head count Other potential areas of excess cost
Surgent's What CPAs Should Know About Trust Instruments
-
Virtual
2.00 Credits
Legal definitions & principals involving estates & trusts Basic principles regarding property ownership Types of trusts commonly used Trust accounting fundamentals Certain clauses that are important to understand Formula valuation clauses Requirements for a trust to be a qualified designated beneficiary of an IRA Using IRD to fund charitable bequests
Surgent's International Tax Challenges and Opportunities for U.S. Filers
-
Virtual
3.00 Credits
Residency status for U.S. federal income tax purposes Key provisions of U.S. income tax treaties Overview of the taxation of income from foreign entities Understanding Foreign Tax Credit Identifying foreign-source and U.S.-source income Foreign earned income and housing exclusion Foreign informational form filing requirements
Leadershift: Drive Results Through Ethical Performance Mgmnt
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:How Inspirational leadership is the foundation that ethically drives results.Simplify the complex: Walk through the Results Model and discover practical how-to examples of execution.Hacks for getting great results with specific examples you can leverage in your business:The How: Empower your people to feel like an owner, managing difficult conversations well, leading with empathy and what that looks like, how it should feel, motivational coaching techniques to get your employee relationships back on track, and unleashing the power of appreciation and gratitude.The What: Powerful score-carding, transformational goal-setting conversations, and positive accountable follow- up.
ACPEN Signature 2025: Financial Statement Preparation: Compilation and Review Update
-
Online
8.00 Credits
Ethics Update Preparation Engagements Compilation Engagements Review Engagements Hot GAAP Topics New Quality Management Standards
PPP Fraud and Financial Professionals
-
Virtual
2.00 Credits
The major topics covered in this class include:Ethical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
K2's Getting Started With Artificial Intelligence
-
Online
2.00 Credits
Understanding AI tools available today Creating accounts in AI platforms Querying data from AI platforms Customizing your AI subscriptions
Building Your Personal Net Worth: Invest in Your Future
-
Online
2.00 Credits
Why people who appear wealthy may be living paycheck to paycheck Why a millionaire may be living in the ordinary house next door Early and mid-career strategies for accumulating wealth Where and how to invest your money Why fees and commissions should concern you Strategies for buying stocks, mutual funds and ETFs
The Ethics of Care in the Workplace
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Ethical Values and PrinciplesCompassionManaging ExpectationsRespect and HumilityAttribution Theory
Will Your Ethics Be Burned by Burnout?
-
Virtual
2.00 Credits
The major topics covered in this class include:Explore the effects of crisis and burnout on ethical decision-makingDefine the stressors, pressures, and biases that can lead good people to make less than optimal choicesDiscuss ways to offset the pressures, ways to reduce stress on ourselves and on our team, and ways to support our teamsLearn how to recognize when an individual or an organization is heading in the wrong direction and how to stop sliding down the slippery slope
Operations Level Internal Control
-
Virtual
4.00 Credits
The major topics covered in this course include:An overview of controls that drive proceduresConsiderations for procedural control developmentUnderstanding and controlling risk that arises when organizations change
When Leadership Fails
-
Online
2.00 Credits
Who’s responsible The importance of policies and procedures The development, implementation and monitoring of internal controls There is no excuse Who steals The Tone At the Top and the Big Monkey Theory
CPAs and Addictions: Finding Hope and Healing
-
Online
2.00 Credits
Prevalence of substance abuse and depression among CPAs compared to the general population Factors that cause CPAs to be particularly susceptible to drug and alcohol abuse and mental health issues Identifying reasons why CPAs are reluctant to seek help Resources available for CPAs seeking help Support role that friends, loved ones and colleagues can play AICPA Code of Professional Conduct
