CPE Catalog & Events

This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Bryan L. Smith, CPA.CITP, CISA

More Dates

Audit Reporting Advanced Concepts - Understanding the Impact of General Audit Procedures on Disclosures and Audit Report Modifications will provide guidance for properly altering financial statements and audit reports for certain complex transactions and events that are often uncovered through general audit procedures, such as subsequent testing, reviewing minutes, and more. Each set of financial statements and auditor's report thereon must properly address the unique circumstances of the specific reporting entity's circumstances. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for audit reporting and general audit procedures. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jennifer F. Louis, CPA

More Dates

Please join us for a discussion on like-kind exchanges (LKE), known as one of the last great tax legal "shelters" available to those buying and selling real property. We cover the basic structure of a LKE, and ways a taxpayer can utilize qualified third-party intermediaries (QI), and tenancy-in-common structures including Delaware Statutory Trusts (DST). We also explore creative solutions to sticky situations a taxpayer may find itself in obtaining replacement property. This course is ideal for CPAs, EAs, lawyers, real estate professionals, accountants or other tax professionals. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Allison M. McLeod, LL.M., CPA

More Dates

Award winning discussion leader Mark Hugh discusses both nexus basics and new developments in the dynamic, ever changing world of state income and sales tax nexus. This valuable course answers your frequently asked questions, reviews key factors in examining potential nexus consequences, takes a tour through the rules in states comprising 50% of the US, and identifies free, online multistate resources.  Speaker - Mark Hugh

More Dates

The presentation includes an in-depth discussion of the when the Forms 1065 and 1120S, Schedules K-2 and K-3 must be completed, as well as important developments for filing 2021 flow-through entity tax forms and other recent developments impacting both partnership and S corporation entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Steven C. Dilley, CPA, JD, PhD

More Dates

Working as a financial professional is an accomplishment that offers the potential for a good salary with long-term growth. Despite being a sought-after career, studies show that being overworked is the greatest source of anxiety and dissatisfaction among financial professionals. Left unchecked, a life centered exclusively around the demands of work can be both physically and emotionally detrimental. Establishing a work-life balance is difficult in any profession, yet financial professionals confront unique challenges that make this goal seem even more elusive. Technology results in being "always on," with no true time to disconnect and genuinely enjoy family, exercise, or hobbies. Lack of balance comes with costs, including poor health and lower productivity. Why are some professionals able to establish a successful balance between career demands and family while others are not? How are some firms able to achieve both high employee satisfaction and strong productivity? This webinar looks at research, surveys, and simple anecdotal information to provide a better understanding of how to achieve a realistic work-life balance in the modern world. We also discuss the tax consequences that arise when professionals seek balance by working from home in one state while their employer is located in a different state.

More Dates

If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Tom Wilson

More Dates

In this course, we will share tips and tricks for working remotely.  You will learn what to do/what not to do in a virtual working environment, strategies for leading teams remotely, employee engagement ideas, and techniques and tools for teleworking. Speaker - Kelly Simants

More Dates

This course will review the Accounting Standard Updates issued by the FASB that impact nonprofit entities. We will also look at the work of the Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Melisa F. Galasso, CPA

More Dates

Having sufficient assets to live a comfortable and secure retirement is one of the concerns that many people face. This concern cannot be resolved without having a solid retirement plan. In this course, we will discuss the fundamentals of IRAs, stating the rules related to contributions and distributions and highlighting the effect of the recent tax law changes on the planning process. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - David Peters

Governmental Accounting 101, is a 2 hour webcast that takes the participant of a whirlwind tour of governmental accounting basics, focusing on wetting the participant’s appetite for more.  This session will be the first of a series of webcasts, with each subsequent webcast delving deeper and deeper into the governmental accounting basics.  Speaker - Frank Crawford, Christopher Pembrook

More Dates

Trusts are not cookie-cutter documents. In fact, they can be rather unwieldy, especially in explaining the functions to a client and then having the client comply with the trust terms. This course delves into best practices. Given common scenarios, what are the best trusts to use? And how can the client be best protected?

More Dates

Many organizations are successful as they create a system of internal controls, however some fail to properly implement the measures that are established. Moreover, entities regularly neglect the important process of testing, monitoring, and updating control procedures, which weakens the entire internal control structure. This session provides an overview of control creation methods and discusses ways to successfully implement policies and procedures. Additionally, it includes an array of control maintenance checklists that participants can take and adapt to their organization as they work to improve policies and procedures. Finally, it provides an understanding of the need for dynamic, fluid controls that adapt to changes in business tools and methods. Participants that take this course will have a strengthened ability to implement and maintain an internal control system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Karl Egnatoff, CPA.CITP

More Dates

The employer-employee relationship strains both sides in uncertain times, and businesses need CPAs, controllers, and other advisors to provide understanding of the complex legal, tax, and health care issues associated with all aspects of employment. This course provides in-depth coverage of this critical area. It will be updated and supplemented throughout the year to cover breaking developments.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA

More Dates

This course will explore some of the most essential tools for measuring financial and operational success, as well as improving results. Appendices will be provided to give students hands-on applicable materials that can be utilized after completion of the course.

More Dates

In this cutting-edge course, participants will gain a deep understanding of how to leverage ChatGPT, OpenAI's powerful language model, to innovate and enhance business advisory services in the accounting sector. The course integrates theory and practice, demonstrating how various enterprise evaluation methodologies can be applied in conjunction with ChatGPT for increased business analysis efficiency, profitability, and growth. It also provides hands-on training for implementing these techniques in real-world scenarios. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Garrett Wasny, MA, CMC, CITP/FIBP

More Dates

Loans, rental agreements, business combinations – what do these all have in common? They all have the potential of creating a related party transaction.  This program presents a detailed analysis of the financial accounting rules for transactions with related parties, as well as compares and contrasts those rules with the AICPA financial reporting framework for small and medium-sized entities. Speaker - Steven Dilley, CPA, JD, PhD

The COVID-19 pandemic has altered corporate and public accounting in ways we could never have imagined. This broad-based course will discuss accounting and auditing implications that have arisen as a result of the pandemic. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Chris Harper, CPA

More Dates

This program covers three topics: the Department of Labor's changes in overtime rules, the Federal Trade Commission's ban on most non-compete agreements, and the Department of Labor's new rules relating to differentiating between employees and independent contractors under the Fair Labor Standards Act (FLSA). Understanding these new changes will allow accounting and finance professionals to discuss these important business law changes with their clients.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA

More Dates

This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Allison M. Henry, CPA, CGMA

More Dates