CPE Catalog
Chronological events are listed below the Featured events.
We are pleased to offer live CPE seminars throughout the year. These are virtual presentations with a live instructor allowing for live interaction. These seminars are listed in the Seminars tab below.
Elder Fraud
-
Online
2.00 Credits
Member Price: $119
When we leave our jobs, we also leave the protection our employer provides us with regards to internet and Wi-Fi security. Hired people may be able to help with the newest applications, but they may not understand the security risks posed. This session will cover some basic information about cybersecurity weaknesses and some of the scams that target older, retired people. Many times, the perpetrator is someone close and someone who we think we can trust. In this course, you will learn some basic tools to protect against those who wish to perpetrate fraud.
Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online
2.00 Credits
Member Price: $99
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.
New and Expanded Tax Benefits Associated with Section 1202 - Qualified Small Business Stock
-
Online
2.00 Credits
Member Price: $99
This program reviews and analyzes the important changes made by the One Big Beautiful Bill Act (OBBBA) to qualified small business stock (QSBS) covered under Section 1202. Effective for stock issued after July 4, 2025, there are important changes that make Section 1202 much more appealing to clients willing to run the risks associated with doing business as a C corporation. These enhanced provisions could potentially lead to exclusion of capital gains if very strict compliance rules are followed. Section 1202 application is particularly attractive for start-ups and entrepreneurial endeavors. For taxpayers willing to confront the technical challenges of this provision, Section 1202 may produce impressive tax advantages.
Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
Member Price: $99
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
Social Security: Dispelling Common Myths with Essential Truths
-
Online
2.00 Credits
Member Price: $119
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.
Advising a Client Regarding the Tax Consequences Associated with Buying or Selling a Business
-
Online
3.00 Credits
Member Price: $149
Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Accounting and finance professionals who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.
Current Issues in Accounting and Auditing: An Annual Update
-
Online
4.00 Credits
Member Price: $159
Designed for accounting, auditing, and attestation practitioners at all levels in public accounting and business and industry, this course provides a detailed review of the multitude of FASB and AICPA standards and reports issued over the past few years, including a discussion of the FASB's Stage 3 PIR report on ASC 606. It also provides an overview of recent PCAOB inspection report findings and SEC rulemaking activity. Through hands-on examples and illustrations, this course will help you apply the guidance in practice. We further discuss other important A&A practice matters to be aware of, including an update on the quality management standards and soon-to-be-effective requirements for engagement quality reviews.
Anatomy of a Ransomware Event and Incident Response
-
Online
2.00 Credits
Member Price: $99
The past two years have ushered in an explosion of ransomware attacks affecting businesses and individuals. Many of us read or hear about these attacks, but there is little understanding of how they occur, how a response is undertaken, and how the chances of experiencing one can be reduced. Join us to learn about these topics so you can be prepared with the best response and the knowledge to avoid common mistakes in a ransomware event.
Business Writing: Professional & Effective Emails
-
Online
2.00 Credits
Member Price: $99
Good writing is good business. Studies show that the average business worker receives 121 emails per day. That's a lot of emails. Are your emails effective? Are they being read? Are they professional and tone-smart? In this course, you will learn techniques and skills to get your emails to stand out and improve their effectiveness and professionalism.
Business Law for Small Business Owners
-
Online
4.00 Credits
Member Price: $159
One of the most intimidating aspects of going into business for yourself is compliance. Tax, employment, and regulatory laws are difficult to navigate, so it often falls on the CPA to know the basics in these areas to help their clients avoid costly litigation. In this course, we will cover basic compliance areas for small business owners. We will look at the main elements of a contract, taxation of entity types, worker classification, property law, and many of the other areas that are often overwhelming for small business owners. By being able to speak to these issues, practitioners will be able to add value and help their small business owner clients grow and thrive.
Making Sense of Essential OBBBA Provisions
-
Online
2.00 Credits
Member Price: $119
When clients ask questions about the impact of new tax legislation embodied in OBBBA, it is important that accounting and finance practitioners can reply with accurate and relevant planning strategies. This program prepares accounting and finance practitioners with the knowledge and insights to help their clients apply the new law to their advantage. This program is an introduction and review of some of these critical changes and their impact on individual and business taxpayers. By taking this program, accounting and finance practitioners will have a broader, deeper understanding of many of the OBBBA changes that impact their clients. This course is a two-hour review and analysis of what we consider some of the most important changes from the OBBBA impacting clients and perhaps their businesses.
Real Estate for Accounting and Finance Professionals
-
Online
2.00 Credits
Member Price: $119
Explore the intricacies of federal income taxation as it intertwines with rental real estate activities. This course delves into the calculation of rental income, understanding the nuances of deductions, and unraveling the complexities of passive activity loss rules. Whether it's mastering Schedule E or understanding Congress' intent behind tax laws, professionals will leave with an enriched understanding.
Unconscious Bias for Managers, Supervisors, and Executives
-
Online
2.00 Credits
Member Price: $99
Understanding unconscious bias is key to creating an inclusive workplace and to making the best business decisions. This course explores the concept of unconscious bias, the science behind it, and how it can affect the way employers hire, evaluate, and treat employees. We will also discuss strategies employers can use to reduce unconscious bias and create a more inclusive workplace.
Controller/CFO Update: Hot Topics Facing Today's Financial Professional
-
Online
4.00 Credits
Member Price: $159
In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand, they need the best skills to motivate, manage, and lead people. Being pigeonholed into one area or another is neither good for career building nor good for the organization. We'll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations.
Ethics for the Industry Accountant
-
Online
4.00 Credits
Member Price: $159
While ethics training is required by many states, the true value of the CPA license is in understanding how critically important ethical behavior is to one another, our customers, our firms, and the public. This course will explore the basic tenets of ethical behavior and use case studies to explore ethical dilemmas in various companies and organizations with a focus on dilemmas that may face CPAs in the industry.
How to Effectively Represent Clients Under IRS Audit
-
Online
2.00 Credits
Member Price: $99
Increased funding resulting from the enactment of the Inflation Reduction Act will allow the IRS to target many more wealthy individuals and large businesses for audit. These efforts will become more intense over the next several years as the IRS employs artificial intelligence in more of its audits. This program discusses how and when the IRS's energized audit efforts will result in more audits of taxpayers and what attendees need to know to effectively represent clients that the IRS audits.
Virtual Currency: Keeping Up with the Tax Code
-
Online
2.00 Credits
Member Price: $119
Whether you are an experienced veteran or new to the industry, one of the toughest parts of being a tax practitioner is keeping up with all of the changes in tax legislation. This course takes a look at recent changes to tax law from a practitioner perspective. In this session, we will explore the nuances of virtual currency and the new Form 8300 reporting requirements.
Excel Shortcuts for Accountants
-
Online
2.00 Credits
Member Price: $99
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.
The Road Ahead: Critical OBBBA Changes Impacting Accounting and Finance Professionals
-
Online
2.00 Credits
Member Price: $119
It is important for accounting and finance practitioners to help their clients understand and apply the many new provisions of OBBBA. Many of these changes are effective for the 2025 tax year and beyond. This program is an introduction to and review of some of these critical changes and their impact on taxpayers. This program is a two-hour review and analysis of what we consider some of the most current and important changes from the OBBBA. If you want the latest OBBBA information to relay to your clients, this course is for you.
Top 20 Questions Advisors Ask About the SECURE Acts and Other IRA Rules
-
Online
2.00 Credits
Member Price: $99
Advisors often ask clarifying questions as they increasingly gain an understanding of new and existing tax laws that govern IRAs. Some provisions see more questions than others due to their complexity, popularity, and level of impact on tax benefits. This course focuses on the top 20 of these questions and on SECURE Act 1.0, SECURE Act 2.0, and other hot topics. This course aims to help the advisor provide clients with the correct responses based on their IRA profiles.