CPE Catalog & Events
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
Devious Ethics: Avoiding Snakes in Suits
-
Online
2.00 Credits
Member Price: $109
Discuss psychopathy's symptoms Review accounting professional ethics standards for dealing with a boss, co-worker or client who is breaking the rules Look at precautions you should take when considering a new boss or employee Help identify someone who might con you or your company
Communicate Financial Concepts to Non-Accountants
-
Online
2.00 Credits
Member Price: $109
The math literacy barrier The financial literacy barrier What to say and how to say it Communicating ideas graphically
Mergers and Acquisitions: Complete Guide to Relevant Issues
-
Online
2.00 Credits
Member Price: $109
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
A Culture of Regulatory Ethics: A Competitive Advantage
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Does it pay for a company to have strong ethics?Can you measure the financial impact of ethics?Does ethics make a difference in financial performance?Can ethics be used as a competitive advantage?What sets the CPA designation apart?AICPA Code of Professional Conduct & the Conceptual Framework ApproachEthics as a marketing toolPersonalizing your Code of EthicsFour building blocks of ethical cultureWhat influences employee behavior?Ethical researchBuilding trust in organizationsMaintaining objectivity in difficult situations
Construction Contractors: Auditing Considerations
-
Online
4.00 Credits
Member Price: $225
Auditing contractor accounting and revenue from contracts with customers Planning and risk assessment for construction contractors Key internal controls Substantive procedures for long-term contractors
The Original Secure Act and Secure Act 2.0 Retirement Planning Strategies
-
Online
4.00 Credits
Member Price: $159
Mandatory Automatic Enrollment Credit For Small Employer Pension Plan Startup Costs Enhancement Of The Saver’s Credit Increase In Starting Age For RMDs Indexing IRA Catch-Up Higher Catch-Up Limit Age 61, 62, 63, And 64 Student Loan Payments As Elective Deferrals For Matching Contributions Start Up Credit Costs For Employers Joining An Existing Plan Financial Incentives For Contributing To a Plan Withdrawals For Certain Emergency Expenses SIMPLE Plan changes Starter 401(K) Plans Sec 529 Plan To Roth Rollovers Emergency Savings Accounts Enhancement of 403(B) Plans Qualified Charitable Distributions to Split Interest Entity Retirement Savings Lost and Found
Everyday Ethics at Work: Don't be the Next News Story!
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Discuss ethics from an every-day real-world perspectiveHow to prevent an ethical lapse that can turn your business into the next news story
Linking Risk Management to Strategy
-
Online
1.00 Credits
Member Price: $75
Enterprise risk management Strategic planning Key challenges organizations face The finance professional's expanding role Black Swan events
Advanced Excel: Hidden Secrets and Gems
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models
Depreciating & Expensing Business Assets
-
Online
2.00 Credits
Member Price: $109
Recent tax legislation, rules and developments related to capitalization and depreciation Qualified improvement property Section 179, including inflation adjustments Section 168(k) 100% bonus deduction Depreciation of automobiles, including new luxury auto limits Rev. Proc. 87-57 and MACRS ADS depreciation for electing farm and real estate business Update on recent developments
Surgent's Understanding Non-Compete Agreements
-
Online
2.00 Credits
Member Price: $99
Review of the current legal and regulatory framework surrounding non-compete agreements Enforcement of non-compete agreements from the employer’s perspective Opposing enforcement of non-compete agreements from the employee’s perspective Understanding reasonable geographic scope and time limitations for non-compete agreements Understanding key issues that arise during enforcement and opposition to enforcement of non-compete agreements
The Big Beautiful Bill: Tax Reform 2025 and What's Ahead
-
Online
4.00 Credits
Member Price: $129
Extension of individual TCJA provisions Expansion of IRC Section 199A Bonus depreciation and Section 179 updates Changes to the standard deduction and personal exemptions Child tax credit revisions Business interest deduction limits Estate and gift tax thresholds International tax changes and foreign surtax provisions Creation of Trump Accounts and expansion of 529 plans 1099 reporting threshold changes and other administrative updates
Ethics: Avoiding the Slippery Slope of Ethical Pressures
-
Online
4.00 Credits
Member Price: $225
Benefits of ethical behavior Six steps to creating and maintaining an ethical culture Example of unethical behavior in ethical companies
Surgent's Best Practices in Not-for-Profit Accounting and Reporting
-
Online
4.00 Credits
Member Price: $159
The key requirements, options, and best practices seen in each of the basic financial statements Today’s core accounting and reporting requirements related to contributions and how to effectively and efficiently apply them How to analyze and incorporate the needs of financial statement users into a not-for-profit’s financial statements and disclosures
How Fraud Can Affect Smaller Organizations
-
Online
4.00 Credits
Member Price: $149
The major topics included in this course include:The reasons for fraudFraudulent acts that are initiated against smaller organizationsMethods to stop fraud attempts against small businesses
Cash Management: Strategies for Long-Term Success
-
Online
2.00 Credits
Member Price: $109
Developing short-term cash flow projections How do we assure adequate cash availability without having idle cash? Take advantage of your bank’s cash management services Working capital loans Controlled disbursement accounts Sweep accounts and other short-term investments ACH transactions Direct transfers Lock boxes Credit and collections Reconciliation frequency Managing cash short-falls
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
Member Price: $89
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
Surgent's Guide to the AICPA Quality Management Standards
-
Online
2.00 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
Disrupt to Dominate: Mastering Change Leadership
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The urgency of leading change now & the steps in leading changeThe power of crafting a vision that encourages buy-inThe art and science of building strong partnershipsAccelerating change through relationship networksCommunication strategies for changeEstablishing a feedback culture for successful changeManaging self in times of changeCase studies and real-world scenarios