Skip to main content

CPE Catalog & Events

All Events 12673 Centennial Events 1 Conferences 3 GWSCPA Originals 9 On Demand 550 Section Meetings 2 Webinars 12117

Showing 4161-4180 of 12673 Results (Page 209 of 634)

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: Cryptocurrency Transactions: Navigating Federal Tax Rules

-

Online

1.00 Credits

Review existing reporting rules Broker reporting requirements and Form 1099-DA Reporting crypto transactions Basis Safe Harbor Illustrative example

Common Financial Statement Disclosures

-

Virtual

2.00 Credits

The major topics covered in this class include:General disclosures about the entity and its environmentCommon critical information useful to financial statement readers for making economic decisionsExplain results of operations through information that supplements the face financial statements

Surgent's Incredible Leadership Transformations in Accounting - Ways to Improve Leadership and Communication

-

Virtual

1.00 Credits

Explore the tenets of exemplary leadership which are requirements for highly effective leaders who achieve results and are respected by team members, peers, and other leaders Review key practices that recognize and build on leadership strengths to create a team environment that is productive, profitable, strengthens team members’ morale, and fosters positive energy in the work climate Examine SMART goals to inspire teams to tackle tough challenges and help team members reach and exceed their potential Review conflict management techniques to minimize negative attitudes and foster win/win resolutions for team members

Surgent's Critical Issues Involving Taxation of Construction Contractors

-

Virtual

4.00 Credits

The impact of recent legislation on the construction industry (including the OBBBA) How to qualify for the small contractor exemption and its advantages for the taxpayer Options available to small contractors regarding taxation of long-term contracts How the choice of entity impacts taxation of contractors How AMT impacts the construction industry IRC §460 and large contractors How uninstalled materials impact taxation of contractors Look-back rules Using the 10 percent method to allow certain contractors to defer recognizing taxable income Critical tax planning strategies for contractors

ACPEN: K2’s Excel Essentials For Staff Accountants

-

Online

8.00 Credits

Best practices for creating and working with Excel workbooks Effectively using Excel functions when creating formulas The importance of PivotTables in modern reporting environments Best practices for formatting your workbooks

2026/27 Not-for-Profit GAAP Update

-

Virtual

1.00 Credits

The major topics that will be covered in this course include:Recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline.The International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025. 

Surgent's Guide and Update to Compilations, Reviews, and Preparations

-

Virtual

4.00 Credits

SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services – 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26, Quality Management for an Engagement Conducted in Accordance with Statements on Standards for Accounting and Review Services SSARS No. 27, Applicability of AR-C Section 70 to Financial Statements Prepared as Part of a Consulting Services Engagement Sample comprehensive engagement work programs for preparation, compilation, and review engagements

Common Deficiencies in SSARS Engagements

-

Virtual

4.00 Credits

The major topics that will be covered in this course include:Frequent problem areas in preparation, compilation, and review engagementsThe root causes of noncompliancePractical approaches firms can use to improve consistency, documentation, and overall engagement performance

ACPEN: International Cross Border Transactions

-

Online

2.20 Credits

International cross border transactions.    Decrease an entities effective tax rate.  IRS audit risk 

The AI Revolution in 2026: What CPAs Should Know

-

Virtual

2.00 Credits

The major topics that will be covered in this course include:State of AI technology in 2026: capabilities, limits, and vendor solutions landscapeEssential terminology: models, training data, prompts, agents, guardrails, and moreCPA use cases: accounting, tax, advisory, and moreRisk management and data governance: data privacy, bias, accuracy, documentationWhat’s next: near-term trends and how to evaluate new tools

CPA to CFO: Essential Competencies for Finance Leaders

-

Virtual

1.00 Credits

To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Top competencies hiring executives seek in CFO candidates based on survey of 320+ CEOs and recruiters Critical thinking frameworks and strategy creation techniques for financial leadership Forward-looking financial skills including capital management, forecasting, and funding strategies Industry-specific requirements for high-growth companies and nonprofit organizations Practical career development strategies to build CFO-ready competencies

ACPEN: Generation Intelligence: Navigating the Generational Divide

-

Online

1.00 Credits

Generations

ACPEN: AICPA Statements on Standards for Tax Services: Ethical Considerations

-

Online

2.00 Credits

Review of the new AICPA Statement on Standards for Tax Services Reorganization of SSTS by type of work performed Discuss new standards on data protection, reliance on tools and representation of tax clients before taxing authorities

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.

Supporting Mental Wellness to Thrive in Work and Life

-

Virtual

2.00 Credits

The major topics that will be covered in this course include:Understanding Mental Wellness: Explore how the brain functions and the connection between mental and physical wellness. Learn how stress impacts brain health and overall well-being.Practical Strategies for Balanced Living: Discover techniques for improving sleep, nutrition, and physical activity to support mental wellness. Learn the importance of setting boundaries, fostering open communication, and building meaningful connections.Recognizing and Managing Support Needs: Identify when to seek additional support and learn how to integrate self-care practices that promote sustainable mental and emotional health.

ACPEN: HR Investigations – Episode 1 – Introduction-Assessing-Planning

-

Online

1.00 Credits

Investigation terminology Assessment skills Investigative methodology

Generative AI Strategy for Accountants

-

Virtual

2.00 Credits

The major topics that will be covered in this course include:Evolution and current state of AI technologies in accountingDevelopment of comprehensive AI usage policies and guidelinesImplementation frameworks for integrating AI into accounting workflowsStrategic approaches to AI-driven process automation and optimizationMethods for identifying and capitalizing on AI opportunitiesBest practices for human-AI collaboration in accountingRisk management and ethical considerations for AI implementation

Tax Implications of Retirement Plan Distributions

-

Virtual

1.00 Credits

The major topics that will be covered in this course include:Required minimum distributions for a deceased’s heirs2025 retirement plan contribution limitsRequired minimum distributions and contributions to charityKey provisions of Secure Act 2.0

ACPEN: Decoding Medical Plan Structures: Fully Insured vs. Self-Funded

-

Online

1.50 Credits

Benefits Medical Plan Types