CPE Catalog & Events

This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The enforceability of non-compete agreements in the U.S. is in flux. While the FTC's proposed ban is on hold pending legal proceedings, existing state laws continue to govern the validity of non-compete clauses. Some states, like California, Oklahoma, and North Dakota, prohibit non-compete agreements, while others enforce them under certain conditions. Although state laws vary, non-competes are often used to protect the creation and development of corporate goodwill, customer relationships, and specialized training, among others. Today, employees are more likely to be asked to sign non-compete agreements as a condition of employment. Non-compete agreements are also a common component of a business sale agreement. This program surveys non-compete agreements from all angles, including the current state of play regarding the usefulness and enforceability of agreements going forward. Whether you advise individual clients or work for an employer, this course provides an understanding of common issues that arise in the negotiation and enforcement of non-competes.

Don't just wing it when you can soar! To catch the eye of resource providers and fulfill the needs of leadership, it is essential that not-for-profits prepare financial statements which excel. This course will empower you with the knowledge of not-for-profit accounting and reporting to surpass the expectations of financial statement users. Over 15 focused exercises are included to illustrate and refine today's best practices in not-for-profit accounting and reporting.

Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

With only a few months to go before the AICPA's Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, SAS 146, and SSAE 23 are required to be implemented, this course can help you meet the deadline. It focuses not simply on theory but on HOW to perform the steps involved. The Quality Management Suite of Standards must be implemented by December 15, 2025. The standards modernize the firm's approach to quality to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on many engagements. Beginning with performing a risk-based approach, the standards provide accounting firms with the ability to enhance their quality control by shifting their focus to a proactive approach (management) from a reactive approach (control). The results of the firm's risk assessment will form the basis of its new Quality Management document. This is not just a tweak of the old document but a more robust document that adds new requirements from the new standards. We will cover how to perform a risk assessment, including the key provisions of the standards, and how to effectively implement a monitoring plan. We will also review how the firm will evaluate its System of Quality Management beginning in 2026.

In an era defined by rapid change and uncertainty, effective leadership requires more than just managing teams; it demands the courage to disrupt and innovate. This course is your blueprint for transforming potential chaos into a strategic advantage and is designed for leaders at all levels-whether you're a seasoned CEO, an ambitious small business owner, or an individual contributor aspiring to influence greater change. You'll gain the insights and tools needed to not only adapt to change but to lead it effectively and confidently. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The course provides a concise overview of how accountants can use ChatGPT to assist with communications involving intricate and often sensitive topics that require a deep understanding of both financial principles and human resource policies. These conversations can range from budgeting and compensation to ethical considerations and regulatory compliance. The course also explores the use of ChatGPT in crafting clear, accurate, and empathetic responses to complex queries related to financial audits, tax planning, and employee benefits. It emphasizes the importance of balancing technical financial knowledge with effective communication skills to address diverse stakeholders' needs in various scenarios, from internal team discussions to client consultations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many accountants desire to have a quick overview of only the most current issues in accounting and financial reporting. This course will provide an executive summary of the most important changes in U.S. GAAP. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Sometimes the vernacular of accounting seems more challenging than technical aspects. This session offers suggestions for translating the foreign language of taxation into tangible terms for non-accountants. We explore techniques for simplifying the complexity of taxation terminology. This course will equip you with tools for demystifying tax technicalities so you can help clients and other non-tax professionals grasp fundamental concepts. 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, accountants will discover how to double their firm's revenue through CFO and advisory services. Many accounting firm owners are stuck in what we call The Accountant's Trap. It's where the firm owner is trapped working for low fees, dealing with high-demanding clients, all the while being burnt out on compliance and transactional work. To make matters worse, these firm owners can't raise their fees because there is always another accountant or bookkeeper willing to do the work for less -- not to mention all the tech companies trying to get into our space. Does this sound familiar? If so, this webinar is for you. This course is for any practice owner looking to transform their practice - and double their revenue - by offering a productized CFO/Advisory service. We'll cover the systems you need to transform your practice and the services you should offer to double your firm's revenue. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course focuses on the most common aspects and tax implications of Limited Liability Companies and S Corporations. It will further compare forms of entities, along with corporate formalities compliance issues of each entity type. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. Highlights of entity specific tax forms will be discussed, as well as accountable plans, taxable fringe benefits, officer reasonable compensation, estate planning, business continuation planning and audit strategies. Schedules K-1, K-2, K-3, and effectively connected income will be reviewed in this course as well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

FASB ASC 842, *Leases*, standards decoded By learning essential information about lease accounting requirements, you'll understand the core principles of the standards and how to apply them. You'll explore topics, such as: Identification Recognition Measurement Presentation and disclosure requirements Deliberate application of lessee accounting model You'll also learn about classifying leases, the amortization of the right-of-use asset, and the interest on a lease liability. Additional topics include: Short-term leases Purchase options Variable lease payments Sale and leaseback transactions Leveraged leases

If you use Outlook on a daily basis to process your email, chances are pretty good that you are missing out on a lot of opportunities to improve your efficiency in composing, processing and organizing your messages. There are many different features in Outlook that often get overlooked, even though we are working in the app all day, every day. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will review numerous tips and features to improve your productivity in Outlook. You will learn many time-saving, practical ways to improve the quality of your email message. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many leaders in business organizations of all sizes view the system of Internal Control almost purely as a protective security measure. A well-designed internal control system can and will drive all entity objectives which includes successful operations. This session uses information gathered from years of creating internal control systems as well as concepts from well-respected authoritative pronouncements and frameworks to illustrate the power of a strong and well supported control system as well as actions that can help establish such a system. Those that work with internal controls who are tasked with developing ways to improve operation level capabilities should strongly consider 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.

Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Learn practical strategies to increase revenue generation using AI-driven ideation methods. This course provides a concise overview of cutting-edge artificial intelligence tools and methodologies that enable professionals to transform innovative ideas into sustainable revenue streams. Through a practical, hands-on approach, participants will explore various AI platforms and workflows that streamline the process of creating digital assets, content, and products. The course emphasizes real-world applications and demonstrates how to leverage AI technology to diversify service offerings and generate new income sources. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The FASB has released a Proposed Accounting Standards Update addressing Disaggregation of Income Statement expenses (Subtopic 220-40). The extent of disclosures that will be required is such that one should be aware of. This new proposal entails much more detail than current requirements for public business entities.

Even though the current transfer tax exemption is extremely high to the point that few decedents have a federal estate tax liability, administering an estate is a burden for many family members. In many cases, the family members will look to their professional advisors for help in estate planning and administering an estate. The purpose of this program is to discuss those issues that practitioners with clients involved in estate planning administration need to know to advise those clients. Lack of planning and preparedness in estate issues can cost the heirs time and money upon a decedent's death.