CPE Catalog & Events

Excel gives you multiple ways to solve the same problem, but which formula is the right one? This course teaches a decision-based approach to function selection, helping you confidently choose between similar and competing functions. Through real-world examples and side-by-side comparisons, you'll learn when IFS or SWITCH is cleaner than nested IFs, how SUMPRODUCT can help with complex summarizing data, how to use LET in place of defined names, and much more. This course is ideal for professionals who want to make smarter, faster formula choices that are easier to maintain and audit.

Social Security seems poised for changes in benefits and eligibility age. The leading edge of the baby boomer generation has already reached retirement age. Financial and tax planners can expect increased demand for strategies that dovetail Social Security with other retirement and estate planning objectives. This course provides tax and financial planning professionals with both the background information on the Social Security system and the strategies clients will need in dealing with Social Security, and the myriad other related retirement planning issues.

Social Security seems poised for changes in benefits and eligibility age. The leading edge of the baby boomer generation has already reached retirement age. Financial and tax planners can expect increased demand for strategies that dovetail Social Security with other retirement and estate planning objectives. This course provides tax and financial planning professionals with both the background information on the Social Security system and the strategies clients will need in dealing with Social Security, and the myriad other related retirement planning issues.

For roughly 90% of American retirees, Social Security income will be the foundation of their retirement income. Yet, many are ill-prepared and lack understanding of the critical aspects of making an informed claiming decision. Further challenged to separate fact from fiction, consumers crave accurate information from knowledgeable professionals to make the most out of these coveted monthly benefits. This course dispels common myths about Social Security that lead to confusion and replaces them with the truth to an empowered retirement. Help your clients navigate their claiming age decisions with greater confidence, equipped with the essential truths they should consider before pushing the Social Security "on" button.

A business conducted as a C corporation can be purchased through an asset acquisition or a stock acquisition. In an asset acquisition, the buyer purchases the business by purchasing the assets that make up the C corporation's ongoing business. In a stock acquisition, the buyer purchases the stock of the C corporation that owns all or a majority of the business assets. The seller and the buyer are usually at odds over how to structure the acquisition. Accounting and finance professionals advising their clients should be fully conversant in the tax rules that apply to stock and asset acquisitions. Discussing and explaining those rules is the focus of this course.

As the population of the United States ages, tax practitioners will be asked to advise their individual clients with respect to when they should begin to take Social Security benefits. This program will provide you with the background to knowledgeably discuss the benefit options available to Social Security beneficiaries and the alternative payment options available to married couples, dependents, a surviving spouse, and a divorced individual.

The life cycle of the small business can be summed up in three segments: 1) starting the business; 2) operating the business; and 3) getting out of the business. This course focuses on getting out of the business. The most elusive element of owning a small business can be finding the proper exit strategy. This course is designed to provide the business consulting practitioner with tools and concepts to advise the small business owner and assist them in developing the right exit strategy. The course covers exit strategies related to third-party sales and succession planning within a family.

The life cycle of the small business can be summed up in three segments: 1) starting the business; 2) operating the business; and 3) getting out of the business. This course focuses on getting out of the business. The most elusive element of owning a small business can be finding the proper exit strategy. This course is designed to provide the business consulting practitioner with tools and concepts to advise the small business owner and assist them in developing the right exit strategy. The course covers exit strategies related to third-party sales and succession planning within a family.

In today's interconnected world, safeguarding information systems is crucial. This course will provide a comprehensive understanding of SOC engagements, exploring the types of reports (SOC 1®, SOC 2®, and SOC 3®) and the related management assertions. The use of the reports for internal controls over financial reporting (ICFR) and operations and compliance will be analyzed. This course equips accounting professionals with the knowledge to effectively lead in compliance reporting.

This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel.

When real property is sold for a gain, we always try to find ways to defer recognizing income so it won't be necessary to send a check to Uncle Sam. There are two provisions within the Internal Revenue Code that allow the taxpayer to defer recognition of immediate taxable gain in the year of sale: installment sales and like-kind exchanges. Knowing how and when to utilize these provisions makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals which could impact the future of these two provisions. Please Note: due to overlap with the INS2 and LKE2 courses, customers should not take ISL4 if one or both of these other courses has already been taken.

When real property is sold for a gain, we always try to find ways to defer recognizing income so it won't be necessary to send a check to Uncle Sam. There are two provisions within the Internal Revenue Code that allow the taxpayer to defer recognition of immediate taxable gain in the year of sale: installment sales and like-kind exchanges. Knowing how and when to utilize these provisions makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals which could impact the future of these two provisions. Please Note: due to overlap with the INS2 and LKE2 courses, customers should not take ISL4 if one or both of these other courses has already been taken.

When real property is sold for a gain, we always try to find ways to defer recognizing income so that it won't be necessary to send a check to Uncle Sam. There is a provision within the Internal Revenue Code that allows the taxpayer to defer recognition of immediate taxable gain in the year of sale known as a "like-kind exchange." Knowing how and when to utilize this provision makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals that could impact the future of this provision.

When real property is sold for a gain, we always try to find ways to defer recognizing income so that it won't be necessary to send a check to Uncle Sam. There is a provision within the Internal Revenue Code that allows the taxpayer to defer recognition of immediate taxable gain in the year of sale known as a "like-kind exchange." Knowing how and when to utilize this provision makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals that could impact the future of this provision. Please Note: due to overlap with the ISL4 course, customers should not take both.

This course examines how agentic AI is revolutionizing tax compliance, planning, and advisory services. Participants will explore real-world deployments by leading firms such as EY, which has developed agents that handle millions of global tax transactions. The course also delves into cross-border compliance issues, transfer pricing automation, and emerging advisory models powered by agent-led simulations. Risks related to bias, unauthorized practice, and data privacy will be addressed, with guidance on aligning autonomous operations with professional and regulatory standards. CPAs must understand these advancements to ensure tax compliance, manage client expectations, and mitigate professional liability risks when providing agent-assisted advisory services.

The purpose of this course is to provide a practical and in-depth analysis of the significant tax planning advantages and strategies related to owning a principal residence for use as a home office and/or vacation home for upper-income taxpayers.

This program focuses on two parts of Subchapter K, partnership distributions and sales of partnership interests - topics that tax practitioners are often asked about by clients. Tax practitioners are called upon to advise both the partnership which makes distributions and the partners receiving the distributions regarding the tax consequences of these transactions. Additionally, tax practitioners will be deeply involved in decisions regarding the sale and purchase of a partnership interest. These topics are thoroughly covered in this program. The presenters also discuss several types of partnership distributions and the tax rules relating to them, as well as analyze the tax rules relating to the sale of a partnership interest. Tax practitioners will be given an in-depth analysis of these complex topics, so that they can effectively answer their clients' questions.

Today's workforce looks a lot different than it used to. With more people working from home and across state lines, employers must examine withholding and unemployment laws in a new light. In this course, we will examine tried and true rules in this area and examine statutes that are still developing. Using real-life examples and discussion, we will examine state laws on reciprocity and residency requirements. We will also look at what to do when state laws are silent or conflict on a particular issue so you can keep your clients in compliance and be well-prepared for the questions that will come your way in these ever-changing times.

Today's workforce looks a lot different than it used to. With more people working from home and across state lines, employers must examine withholding and unemployment laws in a new light. In this course, we will examine tried and true rules in this area and examine statutes that are still developing. Using real-life examples and discussion, we will examine state laws on reciprocity and residency requirements. We will also look at what to do when state laws are silent or conflict on a particular issue so you can keep your clients in compliance and be well-prepared for the questions that will come your way in these ever-changing times.

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.