CPE Catalog & Events

This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

For the past two decades the trend has been to move away from brick and mortar offices and have a greater number of people work or telecommute from home. Because of the upheaval caused by recent events, the rate of this move has been accelerated. This has and will continue to create control challenges and organizations must work to address these. Such things as moving from time based employee value to task completion based measurement and the ability to drive needed inter-company communication are just a sample of the issues with which entities must contend. This session looks at the benefits and pitfalls of workers that telecommute. It then discusses important risks and controls to consider as this trend continues and evolves in the business world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Unlock the full potential of your data with our cutting-edge course, "Create Visuals in Power BI to Successfully Analyze Data." Designed to span a focused, four-hour session, this course is your gateway to mastering the art of data visualization using the powerful tools of Microsoft Power BI Desktop and PowerBI.com. Whether you're a business professional, a budding data analyst, or simply someone interested in the world of data science, this course is tailored to enhance your skills in transforming raw data into visually stunning and insightful reports. Dive into the intuitive interfaces of Power BI Desktop and PowerBI.com, and learn to navigate these platforms with ease and confidence. The course is meticulously structured to provide you with demonstrations and practical knowledge. Starting with a comprehensive tour of the Power BI Desktop and PowerBI.com interfaces, you'll quickly move to the core of creating impactful visuals. Explore a wide array of available visuals and learn how to select the most effective ones for your data stories. Through detailed sessions on building interactivity into your visuals, you will discover how to create dynamic reports that not only captivate but also communicate effectively. This course will also guide you through the process of publishing your reports on PowerBI.com, ensuring that your insights reach their intended audience with the right impact. By the end of this transformative journey, you will be adept at leveraging the full capabilities of Power BI. Your newfound ability to create interactive, engaging, and informative visual reports will make you an indispensable asset in any data-driven decision-making process. Embrace this opportunity to elevate your professional profile, enhance your analytical capabilities, and become a sought-after expert in the field of data visualization. Join us for "Create Visuals in Power BI to Successfully Analyze Data" and step into the future of data analysis with confidence and skill. 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 highlights when to use Form 433-A or 433-B, along with documents needed to effectively submit an Offer in Compromise (OIC) or Installments Agreement. Settling tax debts is an important part of the IRS collection process, this course helps guide taxpayer representatives through the process so they may efficiently complete these necessary forms. 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 will start with a review of the impact of the 2024 Compliance Supplement on Single Audits, as well as, the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. 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 "new abnormal" COVID environment, waves of changes are pushing at each of us from all sides and forcing us to adapt. What works? What fails? How can we adapt faster? This facilitated discussion covers the topic from both the human capital viewpoint and from the operational side of the Manager's desk. We will build the skills and processes needed to manage others through change - either co-workers or clients.

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. Tax practitioners advising their business 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.

Implementing ASU No. 2016-02, Leases (Topic 842) is sure to have a major impact on your balance sheet and potentially on your business as well. This course is a one-stop shop for what you need to know about the now-effective changes to the lease accounting guidance. In this course, we will review how to measure the lease liability and right-of-use asset that will now be recorded on the balance sheet for all leases. We will also tackle the tricky issues of accounting for lease modifications and other lease remeasurement events as well as address the other major provisions of ASC 842, such as disclosures and transition. We will also review the income statement treatment of lease expense for all leases for both lessees and lessors and discuss recent FASB implementation guidance. Lastly, the course will cover all recent updates to the originally issued guidance in Topic 842, including that related to discount rates. With Topic 842's effective date here, now is the time to get up to speed on this complex new standard.

Owners of S corporations and partnerships are subject to numerous limitations on pass-through losses, each with unique rules, applications, and complexities. With the increase in popularity of pass-through business entities, it is essential for CPAs to understand the complexities and interactions of these pass-through loss limitations.

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

Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk, and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Most financial leaders would agree that budgeting is easy when business and the economy are stable. When revenues and expenses are expected to remain the same, the process becomes merely an exercise in carrying over what was done before to the current year. However, what happens when we are not sure about how the market will react to our product? What happens when the competitive landscape changes? In this course, we will discuss budgeting techniques and considerations when business lacks stability. Through a combination of theory and real-world examples, we will explore how to build flexibility into our budget - so that it can inform and drive decision-making when we don't quite know what is ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Until recently, a percentage of organizations discounted the risk related to external fraud attempts. Most were only concerned with protecting physical assets such as inventory or fixed assets. However, because of the many highly publicized corporate hacking events, such as the ones that affected the Colonial Pipeline and JBS Meats, more attention is being paid to external fraud risk of all types. In this session, we look at what is included in a definition of external fraud and then delve into specific control issues that can give rise to increased risk. We then discuss measures that organizations can employ to help reduce exposure to external attacks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

*** Save 15% on this event when you use the code SUMMER15 at checkout ***In this session we will tackle pressing issues at a "need to know" level and then discuss the practical implications. You will come away armed with the "big picture." Preparedness is half the battle, so do not miss this critical briefing.

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.

Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The taxation of real estate is tricky. Taxpayers can own real estate in a number of different ways, including direct and indirect investments. There are numerous exceptions to being classified as a rental activity. How do you know if someone is a real estate professional? In this course, we will explore all these issues and many more. Through real-world examples and discussion, this course will delve into exceptions to rental status, qualifications for material participation, and requirements for active status. Additionally, we will cover the QBI and Section 1237 safe harbors and touch on some planning ideas related to depreciation recapture.