CPE Catalog & Events

Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

To properly account for estates and non-grantor trusts, an advisor must understand the statutory requirements to account, the proper classification of revenue and expenses in a chart of account and the importance of provisions in the estate planning document. Additionally, the differences and similarities to fiduciary taxation must be understood. ?Be sure to register for all four parts: Fiduciary Accounting Part 1: Fiduciary Duty Basics & Authority Fiduciary Accounting Part 2: Tools, Rules and Relationship to Tax Fiduciary Accounting Part 3: Special Accounting Elections & Distributions from Entities Fiduciary Accounting Part 4: The New Frontier (Total Return Trusts)

Part of the technical competence of most experienced tax practitioners is the ability to advise owners of S corporations and partnerships or multiple-member LLCs treated as partnerships regarding the tax rules that apply when these entities liquidate. Entity liquidations do not occur every day; but they do occur, and often at very critical times in the business life of the entity and its owners. All tax practitioners should be able to advise their clients about the tax issues associated with client businesses that go out of existence and liquidate. This program explains the tax consequences associated with liquidating S corporations, partnerships, and multiple-member limited liability companies treated as partnerships.

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.

When putting together a financial plan, it is important to remember that the tax situation of the business and the individual are often intertwined. Therefore, decisions about entity type are vitally important. Practitioners need to understand not only how different entities are taxed, but also which taxes will have the greatest impact on the individual owner. In this course, we will explore when self-employment taxes apply to business income, as well as some of the lesser-known taxes that apply to flow-through entities. We will even explore when a PTE election could be helpful to a small business owner.

The life cycle of the small business can be summed up in three segments: 1) starting the business; 2) operating the business; and 3) getting out of the business. This course focuses on getting out of the business. The most elusive element of owning a small business can be finding the proper exit strategy. This course is designed to provide the business consulting practitioner with tools and concepts to advise the small business owner and assist them in developing the right exit strategy. The course covers exit strategies related to third-party sales and succession planning within a family.

Understand the basics of remote auditing and how it can be used in your engagements Remote auditing has become increasingly popular in recent years. Learn how to apply auditing standards to real-life examples of remote auditing in this all-new webcast. Join us to explore ways to overcome the challenges of remote auditing and conduct efficient engagements for your clients.

How to properly account for and audit digital records is increasingly gathering importance as more entities have cryptocurrency and other digital assets on their financial statements. This course will address common questions, risks, and challenges evolving in this area. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Microsoft Teams is one of the most popular tools for communication, collaboration, and knowledge sharing. If you use Microsoft Teams in your practice or business, this is a "must attend" course. You will learn everything you need to know to optimize the features of Teams and maximize your productivity. We will cover everything from how to effectively design your teams and channels configuration. How to utilize all the Teams features for posting conversations and working with your Office documents, PDF files and more. You will leave this course with the skills to master all the features of Teams! 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 begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. 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 offers an in-depth exploration of the "vision" capabilities of ChatGPT specifically tailored for accountants. The session demonstrates how artificial intelligence can interpret and analyze visual content to revolutionize financial management. The curriculum covers a wide range of applications, from understanding GPT Vision and its unique benefits to leveraging aerial and street view imagery for comprehensive financial analysis. Through detailed case studies, participants will learn how to access and utilize GPT Vision effectively, incorporating it into tasks like data visualization, text and object recognition from images, and the use of descriptive, diagnostic, predictive, and prescriptive (DDPP) analysis methods to enhance decision-making processes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session will explore key aspects of getting more satisfaction out of the work you choose to do and how to find greater balance between the demands of work and other lifestyle choices in an ever more complex and changing world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Harnessing the potential of PivotTables Whether you're just starting out or seeking to improve your Excel expertise, PivotTables are versatile and powerful tools for data analysis. This course delivers a well-organized method for effectively understanding and using PivotTables through: Practicing fundamentals with a leading expert in financial modeling Creating and using sample datasets Building PivotTables from the ground up Innovative possibilities for presenting data The core functionality of PivotTables for financial professionals is the ability to transform large datasets into meaningful summaries. By reorganizing data from a spreadsheet, PivotTables allows you to: Extract key information and identify trends quickly Simplify the process of analyzing data Reduce the time spent on repetitive tasks *Session 1 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 2: Working with PivotTables] (https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series-session-2-working-with-pivottables) to tackle real-world issues and create powerful workbooks.*

With the AICPA's heightened focus on enhancing audit quality, increased oversight of the peer review process and the auditor's overall responsibility to provide high quality services, the focus on compliance with professional standards has never been greater. Add to that the requirement to implement the revised risk assessment standards (SAS 145) and it's easy to see why it's more important than ever to ensure that auditors have a good understanding of the requirements and comply with documentation standards. Recent peer reviews have indicated that auditors are often failing to perform and/or document certain critical components of an audit such as the auditor's assessment of risk and linking the results of the assessment to substantive procedures performed. In addition, auditors are not adequately documenting their consideration of fraud, expectations in analytical procedures and the appropriate level of work needed to understand an entity's internal control. The AICPA issued its Quality Management Standards in 2022. Firms are required to implement the standards by December 15, 2025. And the firm's evaluation of the System of Quality Management is required within one year after that. This is not just a matter of tweaking the firm's existing QM document, the standard requires a risk assessment process to identify risk. The objective of the course is to provide the insights necessary to help auditors and accountants improve not just the quality of their work but also the perception of the accounting profession as a whole. We will focus on the most significant items resulting in deficiencies identified in the peer review process. We will also discuss the applicable audit standards, documentation requirements, and best practices. We will address the new QM standards.

Planning may be one of the most important assignments of the finance professional; however, it is often accomplished in a way that can harm the organization. In many cases, huge sums are spent only to have a planning document developed that does not serve to bring the company together, but rather causes internal division. In some situations the budget can actually harm both productivity and alignment. This course is designed to bring planning, budgeting, and forecasting together into one fully aligned process that is easier, more efficient, and fully engages all parts of the organization. Rather than the plan being owned by the finance department, it is owned and followed by everyone from the CEO to the entry-level employee.

Fraud activities can be executed from within an organization, by parties outside an entity, or by both. Importantly, as the business world becomes more technological, the way fraud is carried out is changing. There must be an increased focus on understanding where new fraud vulnerabilities exist. In this session, we delve into the reasons that both internal and external intentional defalcations take place. The material discusses the new ways fraud is being actuated and looks at the factors driving those that undertake fraud. We spend time examining measures that can be implemented in order to stop fraud via the deployment of added security across the enterprise. 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 is designed as a comprehensive guide to the core concepts of trust and estate income tax preparation. The course explains the common terminology and complicated income tax rules of estates and trusts, fiduciary accounting, and an introduction to or refresher on preparing Form 1041. This practical, over 300-page manual is an excellent reference source for your practice, which begins with quite simple cases. Building upon that base throughout the manual, the course ends with two complicated preparation cases, one trust and one estate, each with filled-in forms.

Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Just like competitive salaries, flexible work options are table stakes for top talent. With COVID-19, many teams have had to convert overnight to fully remote. But how do you lead in an environment where pants are optional? And what does it look like to lead someone who is more of a vendor than an employee? Using lessons learned, this session will explore the 4 Ps (Purpose, People, Platforms, and Processes) to effectively lead a remote and even gig economy team.