CPE + Events Catalog
View or download your copy of The Resource today!
Surgent's Excel Budgeting Ideas (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.
More Dates
K2's Excel Essentials for Staff Accountants - Webcast
-
Online
8.0 Credits
Member Price: $315
See more dates
Staff accountants have specific needs when working with Excel. Unfortunately, their existing Excel knowledge often does not meet these needs. Chief among these are summarizing data quickly and accurately, generating accurate and aesthetically pleasing reports, and creating accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills to maximize efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting centric examples to reinforce key learning points. In this session, you will learn in a "laptop-friendly" environment, and participants will have access to all the demonstration files. In sum, this seminar is a "must" for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.
More Dates
Surgent's Advanced Critical Tax Issues for S Corporations
-
Online
8.0 Credits
Member Price: $279
See more dates
This course goes beyond the basics and addresses important practical issues that an experienced practitioner must know. Even if you have attended other S corporation courses, you will learn something new in this course.
More Dates
Everyday Ethics at Work: Don't be the Next News Story! (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
When asked, most people would say they are an ethical person. So why is it that every month there are reports of ethical breaches at major companies? The concept of ethics is easy to understand, easy to talk about, but incredibly hard to implement on a consistent basis. In this course, we will discuss current ethical issues, and walk-through a nine-step ethical decision-making model. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
How SAS Nos. 134-145 Improve Risk-Based Audits (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in SAS Nos. 134-145. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Advanced Staff Tax Training: Individual 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
This course will elevate your individual income tax preparation skills and knowledge. It will help you go beyond the basics and will help you provide superior service to your clients. We will cover topics including taxation of investments, reporting of partnership and S-corporation income, net investment income tax, calculation of self-employment taxes, household employer taxes, social security taxation, basic retirement planning opportunities and Alternative Minimum Tax (AMT). In addition, we will also do a review of loss limitations and much more.
More Dates
Pension and Profit-Sharing Plan Strategies 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
Whether saving for retirement, reducing taxes, or combining the two, pension and profit-sharing plan strategies are your go-to solution. Get up to speed with the recently enacted SECURE Act 2.0 and learn the rules of the game. Discover the type of plan documents that work best for your clients, how to terminate a plan, different retirement plans you can choose from, contribution & deduction limits, reporting & disclosure rules, Form 5500 & participant communication requirements, and even how to do in-plan Roth conversions. Get ready to make retirement planning for your clients a breeze!
More Dates
SSARS Codification: Preparation, Compilation and Review 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
This course covers SSARS requirements for preparing, compiling and reviewing financial statements through SSARS 26. With SSARS 21, the AICPA Accounting and Review Services Committee (ARSC) introduced the Preparation service to SSARS and rewrote the Compilation and Review Standards in a clarified format. SSARS 22 and 23 made minor modifications to SSARS 21. SSARS 24 and 25 made substantive modifications to the SSARS, mainly when performing review engagements. SSARS 26 updates the SSARS with conforming changes made necessary by the new Quality Management standards.
More Dates
Titans Annual Federal Tax Planning Individual Update 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
Dive into an in-depth analysis of this year's pivotal changes in Federal and California tax law. Discover the latest legislation and stay informed on crucial IRS and FTB guidance. We cover key developments from the IRS, FTB, and courts, providing essential compliance and planning lessons gleaned from recent rulings. Prepare for the tax season by thoroughly reviewing due diligence considerations relevant to all new laws. Titans of Tax 2025 Lineup: Titans of Tax Mid-Year Update 2025 Titans Annual Federal Tax Planning Individual Update 25-26 Titans Annual Federal Tax Planning: Business & Estate Update 25-26
More Dates
Get started with Power BI (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check (3.5 hours)
-
Online
3.5 Credits
Member Price: $175
See more dates
Relevant Excel methods for accounting experts In Excel, there are several opportunities to apply features, functions and methods to build a dynamic workbook. In this hands-on demonstration of several Excel skills, you'll review the following topics through engaging expert-led instruction: Dynamic headers Horizontal reports Mapping Tables Data Validation Excel error checking skill development Designed with time for you to work along with the facilitator, this webcast examines the importance of automating reporting workbooks in Excel. You will review various topics, including: Horizontal or crosstab reports Mapping tables and how they are the key to unlocking major efficiency gains. Data validation in digital reports Error Check *Session 8 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching other parts of the bundle. [Excel for Accounting Professionals Webcast Series] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-webcast-series-bundle) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Tax Talks: December 2025 (1.5 hours)
-
Online
1.5 Credits
Member Price: $55
See more dates
Join the Team from Hochman, Salkin, Toscher, & Perez for a LIVE tax-based series with a new topic at each Session. Past conversations have included crypto tax compliance, BBA Partnerships, Federal and State Residency issues, Partnership examinations, Form 8300, and more. Check back regularly for topics, and be sure to register for them all. June 2025 August 2025 November 2025 December 2025 January 2026 April 2026
More Dates
Integrate ChatGPT into Your Client Advisory Services-Updated (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Disrupt to Dominate: Mastering Change Leadership (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
In an era defined by rapid change and uncertainty, effective leadership requires more than just managing teams; it demands the courage to disrupt and innovate. This course is your blueprint for transforming potential chaos into a strategic advantage and is designed for leaders at all levels-whether you're a seasoned CEO, an ambitious small business owner, or an individual contributor aspiring to influence greater change. You'll gain the insights and tools needed to not only adapt to change but to lead it effectively and confidently. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Invest in Your Mental Health and Avoid Burnout (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
For the ambitious female finance professional, working hard and going above and beyond are necessary for success. Sadly, taking time to care for themselves can be seen as counter-productive to meeting their career goals. Over ninety percent of women executives are feeling significantly higher levels of stress that they attribute to increased responsibilities and priorities outside the workplace compared to life before the pandemic. Burnout is a syndrome resulting from chronic workplace stress that causes exhaustion, negativity toward one's job and reduced professional efficacy. It has become so pervasive that it's now recognized as an occupational phenomenon by the World Health Organization. To reignite your enthusiasm at work, you don't necessarily need to find a new job or time for a spa day or bubble bath. You need concrete strategies to invest in your mental health without compromising your ability to rise to the next level in your career. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Ethical Intelligence for Artificial Intelligence (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Organizations and individuals enticed by the siren song of artificial intelligence cannot ignore ethical considerations. Professionals must consider accuracy of information, data privacy, independence, source citations, organizational policies, security, data retention, and other ethical matters. This course discusses ethical issues associated with the utilization of AI in a professional setting and provides suggested best practices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Excel Shortcuts for Accountants (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.
More Dates
Surgent's Forms 7217 and 7203 (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
IRS Form 7217 is an IRS tax form required for partners receiving distributions of property from partnerships. Starting for tax years beginning in 2024, a partner who receives property from a partnership must file Form 7217 with his or her annual income tax return. Form 7217 is filed by any partner receiving a distribution of property from a partnership to report the basis of the distributed property, including any basis adjustment to such property as required by Section 732(a)(2) or (b). This new IRS form is part of the IRS's general concern regarding basis shifting in favor of high marginal tax rate related partners. Form 7217 is now required and details the types of property distributed, the aggregate basis, and the allocation of basis to the distributed property. Form 7203 is designed to assist in tracking an S corporation shareholder's stock and debt basis. Form 7203 is a significant improvement from the worksheets the IRS provided formerly and over time will serve to help partners and partnerships keep track of their stock and debt basis. The course covers the structure and organization of Form 7203 as well as how an S corporation shareholder's stock and debt basis are calculated.
More Dates
Surgent's Mastering Accounting for Income Taxes (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
Since its inception nearly 30 years ago, many have continued to struggle with applying the current model for accounting for income taxes, ASC 740. But this does not have to be you. This course will provide you with the basic knowledge necessary to understand the complexities of this challenging topic. Through discussions and use of exercises, this course will analyze the authoritative literature to provide a thorough understanding of such topics as deferred taxes, income tax expense, uncertain tax positions and other classification and disclosure requirements related to income taxes. We will also explore some specialized areas of income tax accounting, such as intra-period allocations of income tax expense and accounting for changes in tax laws and rates, and we will review proposed updates to ASC 740 disclosures on which the FASB is contemplating. In summary, this course is the place to be to enhance your accounting for income taxes IQ.
More Dates
Surgent's Tax Planning for Rental Real Estate (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
The taxation of real estate is tricky. Taxpayers can own real estate in a number of different ways, including direct and indirect investments. There are numerous exceptions to being classified as a rental activity. How do you know if someone is a real estate professional? In this course, we will explore all these issues and many more. Through real-world examples and discussion, this course will delve into exceptions to rental status, qualifications for material participation, and requirements for active status. Additionally, we will cover the QBI and Section 1237 safe harbors and touch on some planning ideas related to depreciation recapture.