CPE Catalog & Events

At the end of this module, participants will be able to differentiate between different forms of broad-based employee ownership and understand the role of the Employee Ownership Advisor.  This course is offered in partnership with Project Equity.

At the end of this module, participants will be able to comprehend the structure, purpose, and key features of ESOPs, evaluate the tax advantages and legal considerations associated with them, and analyze the governance and other important details of ESOPs.  This course is offered in partnership with Project Equity.

At the end of this module, participants will be able to comprehend the structure, purpose, and key features of ESOPs, evaluate the tax advantages and legal considerations associated with them, and analyze the governance and other important details of ESOPs.  This course is offered in partnership with Project Equity.

At the end of this module, participants will be able to comprehend the structure, purpose, and key features of ESOPs, evaluate the tax advantages and legal considerations associated with them, and analyze the governance and other important details of ESOPs.  This course is offered in partnership with Project Equity.

At the end of this module, participants will be able to assess the potential benefits of employee ownership for their business clients, apply criteria to recommend the most suitable employee ownership form considering costs, timelines, and resources, utilize financial analysis techniques to evaluate debt capacity in employee-owned businesses, measure the impact of employee ownership on company performance, and effectively communicate the financial advantages of employee ownership to clients. This course is offered in partnership with Project Equity.

At the end of this module, participants will be able to comprehend the lending prerequisites, evaluate the significance of personal guarantees, navigate the submission process, explore various funding sources, and identify the types of financing required for partial or partial onramp to full conversion in employee-owned businesses. This course is offered in partnership with Project Equity.

At the end of this module, participants will be able to ensure adherence to compliance and legal obligations concerning employee ownership, navigate the documentation and regulatory filings specific to different employee ownership forms, and establish mechanisms for maintaining ongoing legal compliance in employee-owned businesses. This course is offered in partnership with Project Equity.

At the end of this module, participants will be able to create a comprehensive implementation plan for employee ownership, incorporating strategies for investing in education and fostering a supportive organizational culture, effectively communicating the transition process to employees and stakeholders, and providing continuous support and guidance to businesses operating under employee ownership. This course is offered in partnership with Project Equity.

Corporate clients concerned with succession planning and stock compensation often have heard about Employee Stock Ownership Plans (ESOPs). You will learn the fundamentals of what an ESOP really is, the tax advantages for corporations and the shareholders, and the benefits for employees. We will compare and contrast C corporation versus S corporation ESOPs.

While accounting and the practice of law are separate professions, the accountant must be conversant with essential legal concepts. Modern accounting practice requires familiarity with corporate legal structure, business entities, partnership operations, contracts, property rights, employment law, divorce, consumer protection, will & trusts, and even bankruptcy law. This course explores these specific areas with an emphasis on business and accounting issues. This informal and clear guide to the basic concepts of business law provides accountants with an excellent review of legal concepts that arise in any tax professional's practice. The attendees will gain the ability to recognize and discuss general legal concepts with both client and their counsel. Knowledge is power and nowhere is that truer than in the field law. To gain such a working knowledge of law, readily understandable explanations are given to essential and related business law subjects. The accountant is guided through the complex maze of literally hundreds of legal principles from acceptance to zoning.

"Just the facts, ma'am; just the estate planning facts." Designed to give a quick overview of estate planning essentials, this course surveys wills, living trusts, gifts, marital property, and probate avoidance. Will and trust types are examined in the context of general estate and gift taxation. Designed to eliminate estate problems and death taxes, the emphasis is on practical, cost-effective solutions. Talk about having it all in an overview course, there is even a quick review of immediate postmortem death tax planning and filling out Form 706.

Estate planning is when tomorrow becomes today! As a result of recent legislation, estate planning has been made surprisingly simple. This mini-course surveys wills, living trusts, gifts, insurance, marital property, and probate avoidance. The will and trust forms are explored along with living wills, durable powers of attorney, and nominations of conservator.

A comprehensive guide to estate planning and the taxation of trusts.

Explore the ethical implications of using generative AI. This course addresses potential risks and dilemmas, providing guidelines to ensure responsible and compliant integration. Learn how to balance innovation with ethical obligations to maintain trust and integrity.

Are you a perfectionist? If so, you're in good company. 92% of professional leaders see their work impacted by perfectionistic tendencies. Additionally, 99% of accountants say they have experienced or are experiencing burnout.  We can't easily control external factors; the industry's pipeline deficit and intense demands of tax and busy seasons. However, perfectionism is something we do have control over and it's not to be dismissed or overlooked. When driven to perfection, accountants work even longer hours and feel overly self-critical. In this one-hour workshop, discover how perfectionism drives you to exhaustion and how to prevent burnout while still delivering high-quality work. 

What do you do when a setting, shortcut or command isn't available in Excel? Well, you create a macro, of course. Macros allow Excel users to extend the capabilities of Excel and create shortcuts and commands. In this session, you will use the recorder to create a macro that applies a built-in format setting. You will then write a macro in the visual basic editor to provide a shortcut to a popular Excel function. The course will also cover how to add macros to the Quick Access Toolbar so you can easily execute them in the future. Presented in Excel for Windows.   Note: Items presented may not be available in all Excel versions, including Excel for Mac, iPad or web.   The webcast was originally broadcast on May 3, 2016. Note: There is a minimum passing rate of 70% for this course.

This session continues the discussion about external data and digs into the details for retrieving data from other sources. Pull data from an Access database using Microsoft Query; learn how to retrieve data from simple text files; and prepare data for use with Excel. This session concludes by examining several data visualization tools in Excel, including PivotCharts. This is part 10 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

The Excel Power User series is designed to help improve your Excel proficiency and enable you to get your Excel tasks done more quickly. In the first session, we'll cover the fundamental features that help build a solid foundation. We'll continue to integrate these features as we proceed throughout the series. This is part 1 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Cover fundamental functions, concepts and techniques that provide a firm foundation for our workbooks. Continue to integrate these items as we proceed throughout the series. This is part 2 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Explore six important Excel functions that enable us to automate a variety of tasks, as well as continue to integrate these functions as we proceed throughout the series. This is part 3 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data