CPE Catalog & Events

An in-depth coverage of ASC Topic 842, Leases . Leasing is popular among corporations for needs including office space and equipment. Since ASC Topic 842, Leases has been adopted by most entities, it is time to review the topic, including any recently issued updates. Excerpts from publicly traded companies' recent disclosures on Leases are also examined.

This course provides a concise overview of Claude and its growing role as an AI-powered productivity, analysis, and workflow platform for accounting professionals. Participants will learn how Claude differs from traditional search engines, spreadsheets, and chatbots, and how it can be used to accelerate drafting, research, document review, data analysis, and client communications while maintaining professional skepticism and accountability. The course explores practical prompting techniques, document and spreadsheet analysis, projects, artifacts, connectors, Microsoft 365 integrations, automation capabilities, and emerging AI workflows. Special emphasis is placed on confidentiality, privacy, ethics, verification, and professional judgment. By the end of the course, participants will understand how to integrate Claude into their daily accounting workflows to improve efficiency, strengthen decision-making, and support higher-value advisory services. The course is based on the Claude platform ecosystem, including Chat, Projects, Artifacts, Connectors, Microsoft Office integrations, Voice Mode, Design, Code, and Cowork capabilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

What makes a business valuable? Who determines value? What are the key factors that make businesses valuable? In this course, we explore the different ways to value a business. We will apply foundational valuation and corporate finance concepts to real world examples in an effort to see what makes up an investment's price.

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.

As financial leaders, CPAs are often tasked with managing organizational risk. In this respect, the supplier relationship can be a tricky one. It is often one of the more familiar and comfortable business relationships we have, yet it may also be the one that presents the most significant risk to our company. In this course, we will explore how to manage the supplier relationship from onboarding to termination. Through case studies and best practices, we will discuss how to continue being a good partner to our suppliers while also understanding where potential risks exist. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Realistic Excel training for skill development Shifting from manual inputs to automated formulas in Excel can help enhance data efficiency. Understanding that Excel can handle date and text values broadens the potential to improve efficiency when managing data in Excel. This webcast will focus on the following essential functions: EOMONTH MONTH and YEAR DATE CONCAT SUMIFS with CONCAT Practical hands-on Excel learning exercises taught by a highly engaging expert In this webcast, you'll develop your skills and implement Excel techniques that will boost the effectiveness of conditional summing functions using comparison operators. Additionally, you'll gain in-depth knowledge of the following: Adding helper columns Distinguishing key function differences Combining values *Session 7 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 [Session 8: Dynamic headers, mapping tables and error check] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-8--dynamic-headers-mapping-tables-and-error-check) to further prepare to tackle real-world issues and build powerful workbooks.*

Is that business jet, RV, yacht or luxury automobile really deductible? This course tackles the tricky terrain of listed property depreciation, helping tax professionals navigate IRC 280F with confidence and clarity. Whether your client is flying high, cruising the coast, or hitting the highway, this session will help you determine what qualifies, what doesn't, and how to keep the IRS at bay. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

AI is already being used in so many ways to aid business organizations in a wide array of ways. However, artificial intelligence is also being used by those seeking to steal or commit fraud to circumvent controls and mislead both people and systems working to keep fraud at bay. The use of AI for ill-intent is pervasive and difficult to detect which makes fighting defalcation attempts an even greater struggle. In this session we will look at some of the methods that are AI-centric which are being used to deceive and defraud. We will then dive deeper and explore ways to identify instances when AI is being used. Finally, we will look at control measures that can aid those working to fight AI driven fraud. If it is evident that artificial intelligence could be used as a weapon to harm you or your organization, you should strongly consider enrolling in this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

New personal financial planning strategies are emerging due to passage of the One Big Beautiful Bill and evolving personal goals in difficult economic and legal environments. Drawn from recent publications and government directives, this course reviews the latest financial strategies and planning changes from the past year in insurance, investments, tax, estate and retirement, including Social Security and Medicare. Additionally, Randy covers estate and tax planning strategies that enable practitioners to better serve clients by allowing them to take advantage of new opportunities.

If you're ready to move beyond Excel's fundamental features, participate in K2's Advanced Excel. This course will teach you about collaboration options, security techniques, tables, data models, PivotTables, and advanced formulas.

An in-depth coverage of ASC Topic 842, Leases . Leasing is popular among corporations for needs including office space and equipment. Since ASC Topic 842, Leases has been adopted by most entities, it is time to review the topic, including any recently issued updates. Excerpts from publicly traded companies' recent disclosures on Leases are also examined.

This course provides a concise overview of agentic artificial intelligence and its emerging role in audit and assurance. Participants will examine how AI agents differ from traditional generative AI by planning tasks, using software tools, taking actions, and completing multi-step workflows with limited human intervention. The course explores current audit applications, including substantive procedures, confirmations, risk assessment, disclosure testing, and continuous monitoring, while addressing new risks involving autonomy, permissions, prompt injection, multi-agent systems, and accountability. Participants will also examine regulatory developments, professional standards, controls, evidence requirements, ethics, liability, and the strategic implications of agentic AI for audit firms. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.

Do you want to build stronger relationships with your clients, improve client retention, and drive growth in your practice? This course delves into the essential strategies for effective client management in today's competitive landscape. Client relationships, like any relationship, can be challenging to manage. Miscommunication, differing work styles, and unrealistic expectations are some of the challenges accounting and finance professionals routinely encounter. However, when accounting clients and members of your team are on the same page, client loyalty and profitability improve while conflict is minimized. This webinar explores proven strategies to improve relationships between accounting and finance professionals and their clients.

This comprehensive annual update brings together key accounting and auditing developments affecting accountants and auditors across industries. The course combines recent standard-setting activity issued by the Financial Accounting Standards Board with major audit and attestation updates from the AICPA, providing a well-rounded view of changes impacting financial reporting and engagement performance. Participants will begin with an overview of recently issued and upcoming Accounting Standards Updates (ASUs), including standards effective for December 31, 2026 year-ends for public companies, private entities, and not-for-profit organizations. The course also highlights issued ASUs with future effective dates and provides high-level insight into recent exposure drafts to support implementation planning. The course then shifts to auditing and attestation developments, including the next phase of quality management with a focus on monitoring and remediation requirements. Participants will also review recent and proposed standards affecting audit, attestation, and consulting engagements, including SSAE No. 24, SSARS No. 26, exposure drafts related to confirmations and fraud, and SAS No. 149 addressing group audits. Designed for preparers, auditors, and firm professionals, this course helps participants understand how recent accounting and auditing changes intersect-and what to watch for as standards and expectations continue to evolve. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Be the go-to person on financial statement compilation and preparation engagements. Specifically designed for those performing preparation and compilation engagements, this course will provide you with a hands-on application for performing preparation and compilation engagements under AR-C Section 70 and 80, respectively. You will learn the ins and outs of relevant sections of the SSARS related to preparation and compilation engagements with a focus on how recently issued updates to SSARS No. 21 impact these engagements. More importantly, you will be provided practical examples and illustrations to help you effectively and efficiently perform those engagements, including a detailed discussion of the reporting requirements under AR-C 80 related to compilation engagement. Lastly, the course will review recent peer review feedback on these types of engagements, highlighting areas where you can improve engagement quality.

Arguably the most discussed topics to come out of the One Big Beautiful Bill Act (OBBBA) are the taxation of tips and overtime. Practitioners need to understand these provisions now, as they are effective for 2025 tax returns. This program provides practitioners with the background currently available to advise clients regarding these two important tax developments. Both employers and employees need to understand these timely changes to taxation.

Microsoft 365 is one of the most widely used business applications software suites used in business today. Microsoft Copilot is the generative AI application that is integrated directly into the Microsoft 365 ecosystem. If your firm or business is a Microsoft 365 user, this course will teach you how to use Copilot AI to optimize the use of your Microsoft 365 apps. This course will provide a comprehensive review and demonstration of how to put Microsoft Copilot AI to work for you and your clients. It is designed as a "hands-on" course that facilitates following along with the presenter to apply the features of Microsoft Copilot on your computer. Practice files will be provided so that you don't have to expose your confidential data. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This Florida Board of Accountancy-approved ethics course, developed by the Florida Institute of CPAs (FICPA), provides CPAs with a comprehensive understanding of their ethical and professional responsibilities. Designed for CPAs in various professional roles and industries, this course explores ethical principles, regulatory requirements and emerging issues affecting the profession. Participants will gain insight into the Florida Statutes (Chapters 455 & 473) and Florida Administrative Code (FAC) (61H1), AICPA’s Code of Professional Conduct and general ethical behavior.  The course includes discussions on professional integrity, independence, objectivity, conflicts of interest fraud detection and prevention, compliance requirements, and equipping CPAs with the knowledge needed to navigate ethical dilemmas while maintaining public trust. This course meets the biennial ethics CPE requirement for Florida licensed CPA’s.