Skip to main content

CPE Catalog & Events

All Events 10141 Centennial Events 0 Conferences 2 GWSCPA Originals 9 On Demand 534 Section Meetings 5 Webinars 9597

Showing 10141 All Events Results

Taking Advantage of Array Formulas in Excel

-

Virtual

2.00 Credits

The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants:  This section teaches how simplify the use of static values called Array Constants

Ethical Performance Management

-

Virtual

2.00 Credits

The major topics covered in this class include:Definition and Benefits of Ethical Performance ManagementSetting Standards/Goal settingPreparing and Conducting the Appraisal InterviewLegal Considerations in Performance ManagementAvoiding Rater BiasFeedback and Coaching

How AI Fits into the Accounting World

-

Virtual

2.00 Credits

The major topics that will be covered in this course include:An overview of AI constructs.How artificial intelligence is being used by accountants today.Accounting-centric AI developments on the horizon.

Lessons on Fraud Prevention from Sam Bankman-Fried's Crypto

-

Virtual

2.00 Credits

Major topics covered in this course include:What starts a government investigation for white-collar crime?What is an indictment?What is extradition?What are pre-trial proceedings?What is a mitigation strategy?What is a plea agreement?What is discovery in a criminal case?What factors influence a sentence in a white-collar crime?What collateral consequences follow for people convicted of business-related crime?

More Money: Strategic Ways to Improve Cash Flow

-

Virtual

4.00 Credits

The major topics that will be covered in this class include:How do I optimize cash flow?Qualitative Evaluations – Core Earnings & Sustainable GrowthQuantitative Evaluations – Liquidity RatiosIncreasing Customer Base vs. Payment TermsBusiness Cycle & CashInvesting Company CashWhat keeps companies from becoming streamlined?Behavioral Finance BiasesInformation Processing BiasesEmotional BiasesDealing with Behavioral Biases

Fraud Busters: Controls to Prevent & Detect Fraud

-

Virtual

2.00 Credits

The major topics that will be covered in this course include:Fraud motivators - the fraud triangle, typical profiles of fraud perpetratorsRevisiting the basics of controls - design vs effectiveness, preventative vs. detectiveEntity-wide controls and how they can assist in fraud deterrenceSpecific fraud types and the controls that could prevent and detect them

Navigating the AI Landscape?: An Introduction to Generative AI and ChatGPT for Accounting Professionals?

-

Virtual

1.50 Credits

Practical examples of productivity improvements using ChatGPT Live demonstration of ChatGPT

Basic Individual Taxation Course

-

Virtual

2.00 Credits

The major topics covered in this class include:Defining Federal Income TaxesComputing federal income tax liabilityCalculating adjusted gross incomeDefining Qualifying ChildDetermining filing statusCalculating the Kiddie TaxStandard deductionTax Rates for ordinary income, capital gains, and qualified dividend incomeCash v. Accrual MethodFiling deadlines and obtaining extensions

Selected Ethics Topics - 2024 - 2025

-

Virtual

2.00 Credits

The major topics that will be covered in this course include:Stay in compliance with recent ethics standards changes that impact your practice.Learn about key regulatory changes and initiatives impacting CPAs and the future of the profession.Discuss emerging issues and standard-setting activity that could affect your practice in the future. Explore practical applications of the standards and hear about common practice issues and challenges. Examples include private equity, technology, tax planning, audit quality, regulatory enforcement and standard-setting environment.Learn how failure to follow the standards can result in unwanted regulatory actions and publicity.

Surgent's Ethics for the Industry Accountant

-

Virtual

4.00 Credits

What are ethics? Why study ethics? Ethical responsibilities of CPAs Professional code of ethics and conduct AICPA Codification – updated Ethical dilemmas CPA vision Real disciplinary cases to illustrate critical points

Surgent's Top Ten Questions from Partnership Clients Regarding the Section 754 Election

-

Virtual

4.00 Credits

How does a partner compute his or her basis in a partnership? What is the difference between a partner’s inside and outside basis? What is the difference between a partner’s capital account and partner’s outside basis? How does Section 732(d) impact the buyer of a partnership interest? How does a partnership report a Section 754 election on the partnership’s tax return? How does a partnership make a Section 754 election? How does a partnership make a Section 743(b) adjustment? How does a partnership make a Section 734(b) adjustment? How is a Section 743(b) adjustment or Section 734(b) adjustment allocated to the assets of a partnership? How is a Section 743(b) adjustment allocated within the class of ordinary income property and capital gain property?

Reviewing Partnership Tax Returns: What Are You Missing?

-

Virtual

4.00 Credits

Common errors made involving the following: Form 1065 Schedules K and K-1 Schedules M-1 and M-2 Calculating recourse and nonrecourse liabilities Partner inside and outside basis Partner's capital account analysis Sections 704(b), 704(c), 721, 722, 732(b), 734(b), 737, 743(b)

AHI: Accounting Data Analytics

-

Virtual

2.00 Credits

Accounting Data Analytics

CFO & Controller Critical Skills: Budgeting & Forecasting

-

Virtual

2.00 Credits

The major topics that will be covered in this course include:Overview of budgeting toolsOverview of difference between budgeting and forecastingExamples of various budgeting and forecasting techniques

Money Laundering 101 for CPAs

-

Virtual

4.00 Credits

The major topics covered in this class include:The theory of money launderingCommon money laundering statutesExamples from court cases of money laundering statutesCommon occurrences with CPAsPossible money laundering transactionsApplying the money laundering statutes in real life scenarios

Determining Reasonable Compensation for Owner Employees

-

Virtual

1.00 Credits

The major topics covered in this class include:An analytical framework for analyzing and opining on reasonable replacement compensation for owner-employees of closely held businesses and professional practices in the context of tax planning, compliance, management consulting and business appraisal assignmentsExecutive compensation components, including the valuation of non-qualified plans and restricted stock units

Individual Tax Update: Recent Developments

-

Virtual

2.00 Credits

The major topics that will be covered in this class include:2025 Tax Provision SunsetsResidential Energy CreditVirtual currency reporting and Form 1099-DAStudent loansRecent individual taxpayer case rulings

Surgent's Nuts & Bolts of Cryptocurrency Taxation

-

Virtual

2.00 Credits

What is blockchain technology? How do you buy crypto? How do you store crypto? Use cases of cryptocurrency Blockchain technology  Use cases of cryptocurrency Tax overview How taxes work for cryptocurrency investors How taxes work for cryptocurrency mining Taxation of other transactions Foreign reporting requirements and crypto How to use a tool like CoinTracker to calculate capital gains and losses New developments in the space Tax planning opportunities  Why do accountants need to care?

Accounting for the Gig Economy

-

Virtual

2.00 Credits

The major topics that will be covered in this course include:Characteristics unique to the gig economyIndependent contractor and employee classification considerationsRecordkeeping considerations for independent contractorsAccounting and reporting issues for gig economy participantsAudit and attestation for clients who participate in the gig economyTax and regulatory considerationsThe CPA as a trusted advisor for independent contractors

Ethics: Giving Thanks - How to Master the Art of Gratitude

-

Virtual

2.00 Credits

We'll explore what gratitude is and how expressions of it can vary from culture to culture. We'll also unpack several ways you can regularly say "thank you" to valued clients and colleagues, and we'll examine methods for evaluating gratitude in prospective and current employees.