CPE + Events Catalog

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

Audit Reporting Fundamentals - Introducing Core Concepts in the Audited Financial Statement Drafting and Issuance Process will provide tips and techniques necessary for issuing and reporting on high-quality financial statements prepared under any applicable financial reporting framework. The ultimate objective of a financial statement audit is to issue an auditor's report. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for drafting and issuing audit reports. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Environmental, social, and governance (ESG) has become an area of increasing focus. ESG reporting includes a broad spectrum of quantitative and qualitative information. Interested parties seek to understand the effects of relevant ESG matters on an entity's business strategy, cash flows, financial position, and financial performance. This course will focus on the impact of ESG-related matters on the fair preparation of financial statements and related disclosures, and the related financial statement audit considerations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

This is a continuing part of our series on forensic accounting. Within this segment we discuss the concepts that are part of computer forensics known as cryptology. The term cryptography is from Ancient Greek and means “hidden secret”. It is the practice and study of techniques for secure communications in the presence of adversarial behavior. Cryptography is about constructing and analyzing protocols that prevent third parties or the public from reading private messages. Cryptography starts with secrets. Various aspects in information security such as data confidentiality, data integrity, authentication and non-repudiation (where a statement’s author cannot successfully dispute its authorship) are central to modern cryptography.

Job titles for individuals can vary in different organizations even though the work is the same. This webinar is designed for the individual whose role is to oversee the work of others. This webinar includes an overview of Aristotle's virtue ethics and its application to the responsibility and privilege of developing employees to be their best and for the success of the organization. We will also address issues such as going from "buddy to boss", how to manage if you are newly assigned to an existing employee that was previously supervised by someone else, and critical skill sets necessary for supervisory/managerial positions. 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 main elements of financial education and will help accounting and finance professionals guide their clients, and their clients' children, through a personalized teaching roadmap. Clients with wealth face questions about how to teach their children about money to raise financially capable children. Often, their first contact is to their accounting and financial professionals, so it is important to be able to provide a framework to help teach clients how to prepare their children for life with privilege. This course is designed for all practitioners who want to help their clients navigate the process of teaching the next generation about personal finances. Because every family and child are different, it is critical to develop a specific plan for each client, and likely each child and grandchild. By working with their clients' descendants, accounting and finance professionals not only build rapport and trust but also get to know the children and grandchildren, building firm value and long-term connection.

Required minimum distributions (RMDs) must begin for the year in which the account owner reaches age 72 - later if they were born in 1951. RMDs must also be taken from inherited accounts, and the process for determining RMDs for these accounts is more complex than those that apply to RMDs for non-inherited accounts. Failure to comply with the RMD rules will result in the account owner owing the IRS an excess accumulation penalty on any RMD shortfall. Interested parties must understand the compliance requirements that apply to RMDs to be able to assist in ensuring that penalties are avoided. Additionally, the recent changes that affect RMDs must be considered when advising clients about their RMD obligations.

One of the most talked about emerging technologies that has the potential to significantly disrupt the accounting profession is blockchain. This course is designed to bring you up to speed on what this revolutionary technology is all about. You will learn about the concepts, nomenclature, technology and potential applications related to blockchain. This will prepare you to participate in conversations about blockchain technology with your colleagues, peers and others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Data security is a front-of-mind topic for most businesses because the risk and cost statistics are sobering. Each of us is in the crosshairs because a typical internet-connected computer faces a cyberattack every 39 seconds. Businesses of all sizes should be cognizant of the ethical issues that must be considered when planning their approach to privacy and data security. In this webinar, we will explore both the risks we have traditionally faced in the workplace personally, as well as the novel set of data privacy threats and compliance challenge issues employers face with a remote and mobile workforce.

Managerial accounting provides economic and financial information for managers and other internal users. Managerial and Financial Accounting have similarities and differences. Each field of accounting deals with the economic events of a business. Both managerial and financial accounting require that a company’s economic events be quantified and communicated to interested parties. This another course in our series on the controller’s role. The controller’s role encompasses many traditional functions. Within this segment of our controllership series, we discuss the area of managerial accounting and the basic concepts that surround this discipline as it primarily relates to cost accounting issues.  

It is no secret that accounting firms, like many other organizations, have begun launching operations in the metaverse. For those unsure, the metaverse is a digital or virtual space where participants simulate a host of activities ranging from shopping to entertainment and business transactions. Why wouldn't accounting firms and other professionals want to get in early on this new frontier? All types of businesses have begun purchasing and setting up shop in this new virtual world. These are no small endeavors - professionals are creating business plans to operate successfully in the virtual world that started off originally as a niche format for gamers. Accounting firms are starting to announce their acquisition of virtual real estate, and some are paying a premium to obtain prime locations. To operate successfully in the metaverse, professionals need to understand the environment and the rules of the game. This course provides an introduction to the metaverse and an overview of opportunities, risks and rewards for professionals who wish to stay relevant in the ever-expanding virtual world. Participants will walk away with an understanding of where we are in this rapidly developing space, plus gain insights on how to establish a presence or advise clients who wish to explore metaverse opportunities.

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment.  Isn’t it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

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.

It's clear that remote work is here to stay. Are you doing everything you can to make remote work work for you? In this course, we'll explore what you can do to set your firm and your remote hires up for success at each step in the process from preparing to hire, the hiring process itself, onboarding and retaining your new team member. We will explore the key policies and procedures you should have in place, and the leadership approaches needed to engage and retain your remote or hybrid team members.

Today’s economy and all of the digital enhancements have impacted the way companies engage with their customers as well as how the company manages their internal practices. The business control function needs to keep pace. The rising importance of analytical capability is critical when defining the role of the modern controller. Execution of analytics can vary but there are still key questions that must be asked. What are the options and what we need to understand to decide the best way forward? This course focuses on the value that can be brought by the Controller when becoming involved with data analytics powered by technology and also Big Data. The digitized world we live in has made it important for the Controller function to evolve and take on this advanced task.  

This course provides a high-level overview and introduction into the world of the forensic accountant. Most accountants have an understanding of the concept of fraud and how it impacts companies, but many individuals do not have a full comprehension of the variance in the work performed by a forensic accountant versus a typical management accountant.   This course is meant for those individuals interested in understanding the variances in the job tasks and responsibilities of forensic accountants versus typical financial or management accountants. Forensic accountants or auditors take a unique focus on performing their work.  Typically, when a person with forensic experience is called in to examine financial records, it is due to suspicion of fraud, evaluation of assets, or even to track down fundamentally incorrect accounting – intentional or not. As fraud continues to raise its head in business processes, forensic accountants are discovering new and unique ways to identify, examine, and support their hypotheses and investigative techniques.  The work performed by a forensic specialist can be interesting and full of potential potholes if evidence isn’t examined according to proper protocols and standards.  

This course will dive into the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus. 

The course provides a concise overview of the most common conduct and ethical issues faced by IRS employees. This is based on an internal IRS directive entitled "Plain Talk About Ethics and Conduct". The document provides guidance to IRS staff at all levels on the agency's ethical standards. All IRS employees are subject to the Office of Government Ethics (OGE) Standards of Ethical Conduct. The OGE Standards, which are applicable to all executive branch employees, are uniform ethics regulations covering such topics as gifts between employees, conflicts of interest, appearances of a lack of impartiality, and outside employment. Participants will walk away with an increased situational awareness of the ethical requirements of IRS employees, and how practitioners can avert or prevent any potential ethical problems before they occur when communicating or interacting with IRS officials at any level. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Managing a hybrid workforce can be challenging, but successfully leading your hybrid or remote team will improve retention and productivity and open up many possibilities for growth and expansion. Where can your leadership evolve to be effective with your remote team?