CPE Catalog & Events

Extracting data for richer insights You'll gain meaningful analysis techniques while working alongside an industry expert and knowledgeable instructor. This session begins with the GETPIVOTDATA function to enable report customization. It's a great starting point before moving on to more advanced techniques. Power Query introduction With its user-friendly interface, Power Query empowers Excel users to take the next step by enabling seamless data import and transformation. With Power Query, you will explore features, including: Getting and transforming data Loading data Managing columns Data source settings Layouts and parameters Visualizing with PivotCharts A well-designed chart can effectively illustrate data trends and comparisons. You'll learn how to create and customize PivotCharts to elevate your reports and make the data more accessible to others. *Session 4 is one of four individual sessions. Each session builds on the previous one, so consider watching all the sessions [Streamlined Excel Reporting Series](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series) to tackle real-world issues and create powerful workbooks.*

Budgets are the vehicle for allocating resources, measuring activities, and identifying needed changes and improvements. An organization's strategy is the primary driver of costs. To be effective, the budget must be linked to strategy and long-term plans. Numerous organizations have achieved a series of short-term targets (budgets) but failed longer term, demonstrating the lack of this necessary linkage. Forecasting, a critical part of any successful budgeting process, can be flawed by technical errors, organizational structure, or emotional forces. The establishment of a system to collect, process, and analyze big data can provide significant insights into the budgeting and forecasting process. An efficient system of incorporating big data and analytics into normal activities will improve management's decision-making. This brief program offers specific actions to improve your forecasting and budgeting activities. In addition, more advanced techniques are identified for the participant's further review, which can be applied throughout an organization. Good budgets effectively allocate resources, provide information for decision-making and serve as an early warning system for unforeseen events. A poor budgeting process fosters a false sense of security, provides inappropriate or inaccurate data, and reinforces the status quo. Budgets are about the organization's story, not just the raw numbers!

The course provides general information on proceedings that led to a grand jury indictment of television reality stars, Todd and Julie Chrisley. Participants learn how business decisions can lead to federal charges for conspiracy, bank fraud, wire fraud, and tax evasion. The grand jury also indicted the Chrisley's accountant, Peter Tarantino, on tax-related offenses. Participants learn how to develop resources and tools for effective detection and deterrence of federal crimes, and the learn the consequences that follow white-collar crime, including how responses can influence lengthy prison terms. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Spear phishing. Ransomware. Malware. Like the threats your business faces, the cybersecurity lexicon is constantly evolving. This comprehensive presentation imparts practical privacy and data security know-how and creates fluency with the latest terminology. Learn best practices for cybersecurity safety, as well as tailored training for those in positions responsible for implementing security policies. It is just as important to be diligent, safe, and well-versed in the attacks that we face in our personal lives.

As litigation becomes more complex, attorneys are relying more on accountants to serve as consulting experts or expert witnesses at trial. Serving as an expert witness is not as difficult as you might expect. Accounting experts educate lawyers and jurors on issues such as valuation, tax liability, and forensics. Learn how accountants become expert witnesses, the role they play during pre-litigation through to trial, and the techniques experts employ to avoid challenges from opposing counsel.

Mastering business transformation with key skills and strategies relevant to modern businesses You'll learn tools that will help you manage day-to-day business operations as well as manage changes, including: Budgeting and forecasting approaches Strategic planning and risk management frameworks Technologies that can improve productivity. Optimizing your business model and identify value drivers You'll also understand how to identify and innovate your business model and how to incorporate intangible value drivers into your capital asset strategy by Using hands-on strategies to define your business model and capital structure Learning techniques and models that will guide business model innovation Understanding the role of technology in innovation Leading your team effectively and ethically Additionally, you'll evaluate how to build a successful team and maintain an ethical tone at the top by discovering how to: Attract and retain top talent Adapt leadership styles to different situations Formulate strategies that promote an ethical culture

Whether your employees report in every day to the floor or from an off-site network, the success of your organization depends a great deal on the motivation they bring to the job. This program helps identify specific methods you can use to improve employee motivation. You'll learn how to use observation tools to find out what motivates your employees and you'll study classic motivational theories. The results will help you influence the behaviors of others and tweak your own behavior to improve your bottom line.

Given the opioid epidemic and the legalization of medical and recreational marijuana in a growing number of states, many employers are concerned about the impact drugs and alcohol may be having on the safety and security of their workplaces. Reasonable suspicion testing is among the best ways for employers to identify whether an employee is under the influence of drugs or alcohol while working. This webinar explores what managers and supervisors need to know to implement a Reasonable Suspicion Testing Policy.

Explore the intricacies of federal income taxation as it intertwines with rental real estate activities. This course delves into the calculation of rental income, understanding the nuances of deductions, and unraveling the complexities of passive activity loss rules. Whether it's mastering Schedule E or understanding Congress' intent behind tax laws, professionals will leave with an enriched understanding.

Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Accounting and finance professionals who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.

AI is now built into software that CPA firms already use, and the pressure to have a position on it keeps rising. For most small and midsize firms the question is not whether these tools matter, but how to engage with them on terms that fit a practice built on trust, confidentiality, and professional judgment. This course makes an evidence-based case that professional skepticism is an asset in technology decisions, provided it is aimed at the right target. Drawing on research in trust calibration, human and AI decision making, cognitive offloading, and professional identity, it examines why experienced professionals discount sound algorithmic advice, what that discounting costs in accuracy, and where reasonable caution turns into accidental delay. Participants locate their firm on the AI Trust and Usage Quadrant, apply five trust questions to vendor claims, and review bounded first steps designed to protect independent judgment during a pilot. The course is vendor neutral and recommends no product. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

AI is already being used in so many ways to aid business organizations in a wide array of ways. However, artificial intelligence is also being used by those seeking to steal or commit fraud to circumvent controls and mislead both people and systems working to keep fraud at bay. The use of AI for ill-intent is pervasive and difficult to detect which makes fighting defalcation attempts an even greater struggle. In this session we will look at some of the methods that are AI-centric which are being used to deceive and defraud. We will then dive deeper and explore ways to identify instances when AI is being used. Finally, we will look at control measures that can aid those working to fight AI driven fraud. If it is evident that artificial intelligence could be used as a weapon to harm you or your organization, you should strongly consider enrolling in 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.

Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

New to AI? Start here. This beginner-friendly course explains how generative AI works, what terms like "LLM" and "agentic AI" really mean, and how CPAs can safely put these tools to use. You'll leave with a solid understanding of AI fundamentals and how they apply to accounting, tax, and finance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Women finance leaders face challenges that traditional corporate training and mentoring rarely prepare them to overcome. For example, you've demonstrated yourself as an excellent tactician, you know how to get the job done, and do it very well on your own. Yet, what got you to your current level of success won't get you to the next level. It's time to change the way you think and operate in your role. You need to move from doer to leader. You're familiar with the saying that if you want to go fast, go alone, if you want to go far, go together. In this workshop, you'll learn key strategies that are unique and critical to women to be successful in their careers. These strategies will help you grow, expand and elevate yourself professionally. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

It is imperative that audit staff understand the fundamentals of expenses & payables. This course will cover the basics of auditing expenses, accrued liabilities, and other payables, including the related audit assertions, risks, & threats to the expenses & payables balances. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through some real-world examples. 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.

This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. 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 investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures, and address challenges within the year. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.