CPE & Event Calendar

PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.

In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Sarbanes Oxley Act (SOX) continues to pose challenges with compliance. Companies must continue to evaluate whether they have designed and implemented an adequate system of internal controls over financial reporting (ICFR). This course will address the best practices that ensure an effective and efficient approach to SOX compliance. 

Financial professionals are expected to do more than report numbers-they must explain them in ways others understand and trust. This session focuses on improving financial communication by addressing financial literacy gaps, simplifying complex accounting concepts, and building compelling narratives around data. Participants will learn how to use stories, visuals, and language effectively to communicate strategy, performance, and risk. Through examples and interactive discussion, this session helps CPAs and CFOs become clearer, more confident communicators in both live and virtual environments. Also, some video clips will be used to add to the learning materials and research. Don't worry, they are pretty entertaining.

In recent history, even the most prestigious CPA firms have had ethical lapses and oversights that have cost them both financially and, at that moment, clouded their brand. This course will review the AICPA code of ethics for both accounting and tax practitioners and encourage you to examine your firm's policies and choices relative to those standards and common sense through thought-provoking and sometimes humorous Q&A and case studies.

Audits conducted under the Uniform Guidance for Federal Awards continue to be among the most challenging audit engagements as the number of federally funded programs for not-for-profit organizations continues to increase. This course will provide you with what you need to know to prepare for Single Audits conducted during 2026, including performing the compliance audit and auditor reporting responsibilities.

SSARS 21 significantly changed the way CPA services are being offered. There is still confusion about CPA responsibilities and procedures. The course will discuss differences between bookkeeping, preparation and compilation engagements and how they differ. It will also discuss financial statement frameworks and how they influence the engagement as well as analytical procedures in review engagements.

Targets can be a powerful catalyst for remarkable achievements - from landing humans on the moon to eradicating smallpox and repairing the ozone layer. However, poorly designed targets can have severe consequences, potentially leading to executive imprisonment, corporate collapse, or even loss of life. This course uses real-world examples and case studies to guide you through a practical, step-by-step process for crafting robust, effective, and credible targets for your organization. You'll learn how to harness the positive potential of targets whilst avoiding the pitfalls that can derail even the most well-intentioned performance initiatives.

A chain is only as strong as its weakest link.  The same theory applies to departmental performance—the overall result is only as strong as its weakest contributor.  Leave our interactive and entertaining session with insight for developing and sustaining the best team you can possibly assemble.  The four elements in this process are (1) development, (2) leadership, (3) hiring and (4) environment.  Discuss how to effectively use these elements in your creation of an outstanding organization. Discover the power of the 10 Attributes for Leadership Success and the negative impact of Leadership’s Fatal 13. Above all, learn how to combine these four elements as a successful catalyst for sustained high-quality output and results.  

Participants will go over the changes on preparation, compilation and review engagements using SSARS rules, followed by a general overview of how to perform these services. This interactive workshop is designed for practitioners in small and medium-sized CPA firms and will include a lecture with generous time for questions and case studies.

This session reviews the three elements of fraud, how fraudsters think, how proper internal controls can prevent and detect fraud, and the red flags to look for to identify fraud. It looks at Radar O'Reilly, one of the most beloved characters of the TV show M*A*S*H. He was trusted by his boss to run the administrative side of the US Army medical unit. Were there red flags all around Radar? Did he have the opportunity to steal? Was he a fraudster? We'll find out? Attendees learn to recognize the traits of this type fraudster that are present in many organization. Case studies of various Radars are included.

Environmental, Social, and Governance (ESG) reporting has become an increasingly important area of focus for standard setters, regulators, and stakeholders. This course provides an overview of how ESG considerations intersect with accounting and attestation services, with attention to developments affecting both preparers and assurance providers. Participants will review current ESG-related initiatives and projects underway at the Financial Accounting Standards Board, Governmental Accounting Standards Board, and the AICPA. The course also explores the types of services CPAs may provide in connection with ESG reporting, including advisory and attestation engagements, and discusses how these engagements differ in scope and responsibility. Designed for CPAs seeking to understand the evolving ESG landscape, this course helps participants recognize where ESG fits within existing professional standards and how CPAs can support organizations seeking credibility and assurance over ESG information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

This program provides in-depth coverage of SAS 145, a major standard that helps auditors enhance risk assessment procedures through improved techniques for identifying and assessing risks of material misstatement. This session is essential for CPAs that perform audits. The discussion will also be insightful for auditees and other professionals who want to maintain awareness of current auditing guidance.

Many clients are asking their advisors about Trump Accounts, one of the most anticipated yet misunderstood provisions of the One Big Beautiful Bill Act (OBBBA). This program will provide practitioners with the background to be able to advise their clients regarding how Trump Accounts operate. The course will also discuss the comparison between Trump Accounts and other accounts, such as 529 Plans and Roth IRAs. In addition, coverage will be provided on how the pilot program will function to give $1,000 to newborns.

Many accounting and finance practitioners have had difficulty understanding and applying the One Big Beautiful Bill Act (OBBBA). Accounting and finance practitioners are still confused and challenged by many of the new and extended tax provisions that the OBBBA delivered. Mastering these crucial provisions requires multiple exposures to these challenging tax changes. This program is a four-hour review and analysis of the most important changes from the OBBBA that impact both individual and business taxpayers. This course affords accounting and finance practitioners an opportunity to gain a broader, deeper understanding of this wide-ranging set of new tax rules, to grasp what is new and what is a continuance of prior rules, and to develop deeper planning insights into the many changes that the OBBBA contains. To the extent that the Treasury has provided guidance relating to OBBBA changes, we will discuss that guidance. We will also point out areas where Treasury guidance would be useful and areas where guidance is expected.

In a competitive market, every company is looking for anyway to differentiate themselves from their competition. While we often look to new markets and data for a competitive advantage, ethics can be the factor that makes the biggest difference to customers, employees, and the public at large. Using surveys, research, case studies, and examples, this course will explore why the CPA credential and the AICPA Code of Professional Conduct is so different. We will discuss why CPA's are in a unique position of trust and how this can put their companies ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

Risk-based factors are becoming exponentially important considerations for accountants in both public practice and industry. We examine the nature of risks for today’s enterprises while exploring the role of internal controls for mitigating business risks. We also explore SAS 145 and other guidance aimed at risk considerations for professional engagements. Public and private accountants will enhance their capabilities for assessing and addressing risks faced by today’s organizations.

Artificial Intelligence is no longer a future concept; it is a current necessity. This session provides a practical roadmap for practitioners to leverage AI safely and effectively. We move from a survey of available tools (from free apps to specialized software) to a deep dive into the ethical guardrails required to protect client data and maintain professional standards. Participants will leave with a playbook of real-world use cases that can be implemented immediately.