CPE Catalog & Events

Unlock the full potential of Excel with our comprehensive training on shortcuts and formulas. This course is designed for CPAs and financial professionals who want to enhance their efficiency and accuracy in Excel. Learn how to navigate and utilize different versions of Excel, discover powerful new functions, and master the art of creating effective tables and automations. With practical examples and hands-on exercises, you'll transform your Excel skills, making your daily tasks quicker and more precise. Plus, benefit from insider tips and tricks drawn from the instructor's extensive real-world experience. Whether it's mastering keyboard shortcuts that save you time or applying formulas that simplify complex calculations, you'll gain practical knowledge that you can immediately apply in your work. This course isn't just about learning Excel; it's about learning to excel at Excel.

The Enhancing Audit Quality Initiative has identified inadequate or nonexistent audit documentation as one of the most significant issues facing the profession today. Over half of the engagements reviewed by the AICPA failed to meet the requirements of AU-C 230, highlighting a critical need for improvement. This course addresses common misconceptions about audit documentation and provides actionable strategies to overcome these deficiencies. Attendees will learn best practices to ensure compliance with professional standards, enhance audit quality, and mitigate risks associated with poor documentation. Whether you are an experienced professional or new to auditing, this course will help you strengthen your documentation practices and uphold the highest standards of the profession.  

Periodic FASB checkups are critical for accountants who deal with financial statements prepared in accordance with U.S. GAAP. This course introduces recent FASB pronouncements and revisits selected existing standards that are likely to be salient for private entities. This session also offers a preview of coming attractions by examining significant elements of the FASB's technical agenda.

Organizations that use primitive costing methods make predictable mistakes, allocating too much cost to easy, high-volume "gravy" products and too little cost to difficult, low-volume "dog" jobs,  putting an organization with inferior information at a significant competitive disadvantage.  The secret to being the “smart competitor” is learning how to deal with overhead.  This session will show you how to assign 16 key overhead categories.  Whether you work in a wholesale, retail, healthcare, service or manufacturing business, you will find this session invaluable.  Get your cost right, and you will be able to give the "dogs" to your competitors and keep the "gravy" for yourself.

The role of today's financial leader, including CFO, transcends traditional financial stewardship; it demands agility, innovation, crisis management, and strategic foresight. This seminar will discuss the new, multifaceted skills and insights needed to excel in the dynamic role of modern finance. Through a blend of theory, research, and practical exercises, participants will explore the diverse roles of a CFO as innovation champions, technology evangelists, crisis managers, and change agents - leveraging practical principles to drive organizational success. Financial leaders can adapt or be left behind. Whether you are a seasoned CFO or aspiring to step into a leadership position, this seminar will discuss the essential tools and insights to navigate the newer demands of financial managers with confidence and competence.

Do you ever get blank looks when you present your company's financial statements?  Does your board nod knowingly, during your presentation, but never seem to have any meaningful questions?  It could be that they have no idea what you are talking about and are just pretending to understand!  Learn how to connect with your CEO, board, fellow managers, and ordinary employees so they understand your message.

A discussion of the latest 2021/222 tax developments impacting individual taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

One of the most challenging skills for a manager or supervisor to master is delegation. This course will cover a variety of delegation-related topics and provide participants with the necessary knowledge and skills to delegate work and authority effectively.

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.

Fraud has not been conquered.  Although most organizations like to think, “it can’t happen to us,” the fact of the matter is that fraud can happen to any organization and its impact can be catastrophic.  Accountability professionals are the first line of defense against fraud. When fraud happens, management always turns to the accountability professional and either says (a) “this must be your fault,” or (b) “you were right; you warned us; help us make sure this cannot happen again.” Consequently, accountants, internal auditors, external auditors, fraud examiners, and risk management professionals need to develop the skills needed to prevent, detect, and deter fraud and need to be proactive in promoting and effecting organizational change. According to the Association of Certified Fraud Examiners’ (ACFE) 2024 Report to the Nations: The median loss per fraud case is $145,000; the average loss per fraud case is $1.7 million. 43% of frauds are discovered by tips, usually from employees. Asset misappropriation schemes are the most common (89%) but least costly ($120,000 median loss). Financial statement fraud schemes are the least common (5%) but most costly ($766,000 median loss). Corruption is the most common scheme in all global regions. Median losses for frauds by owners/executives ($459,000) were more than 7X GREATER than those carried out by employees ($60,000). 84% of fraudsters exhibited at least one behavioral red flag. Organizations that have implemented anti-fraud measures suffer significantly lower losses and find fraud much more quickly. These conclusions are alarming and should be a wake-up call for all business and government professionals. The impact of fraud is always devastating and can be catastrophic.  The 2025 Business Fraud Update is another fast-moving seminar that will provide a comprehensive look at the latest developments about fraud from the technical, legal, and operational perspectives and update participants on the most recent legal and regulatory developments in this important area of professional responsibility.   In addition, our panel of legal, accountability, and forensic experts will explain key steps and methods in conducting a successful fraud investigation: Establishing predicate for an investigation Gathering and preserving evidence Conducting interviews and obtaining confessions When to involve law enforcement professionals and regulators The CPA's Role Preparing an expert report Providing expert testimony Implementing corrective action plans

QuickBooks Online’s (QBO) market share continues to expand, and the Cloud-based accounting platform now dominates the small business market. Yet, most accounting and financial professionals have not participated in any formal training on the Cloud-based accounting service. Thus, they are unaware of many of the tool’s available features and do not work with QuickBooks Online as efficiently and effectively as they should. This course teaches you how to set up QBO and convert QuickBooks Desktop files into a QBO instance. You will learn how to process all types of transactions, including accounts payable, accounts receivable, bank feeds, inventory, and payroll. Further, you will learn how to implement appropriate internal controls and how to capitalize on advanced features such as workflow management and management reports. Join us in this session to learn how to set up QBO properly and take full advantage of all it offers while avoiding common errors and mistakes.

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 is tailored for business leaders and HR professionals who want to enhance their strategic management skills and create actionable plans for success. You’ll learn the overall strategic management process, how to develop both simplified and detailed business and strategic plans, and the crucial role of corporate culture, leadership, and staff development in driving or hindering strategic outcomes. Additionally, you’ll explore how to leverage ChatGPT (Generative AI) as a powerful tool to improve your performance as a key business partner to the management team, helping you make data-driven decisions and enhance organizational effectiveness.

This course explores the complex rules of installment sales, with a focus on their tax treatment and strategies to maximize the benefits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Portable Document Format (PDF) documents are everywhere! Yet few know how to work effectively with these documents. If you are interested in working more effectively and efficiently with PDFs, this session is for you. In this session, you will learn valuable tips you can use to assist you with creating, editing, and securing PDFs. You will also learn how to convert PDFs to fillable forms and secure PDFs, among other features. Don't miss this chance to learn ten PDF tips you need to know to increase your ROI on PDFs.

QuickBooks Desktop, Online, and Enterprise Solutions remain three of the most widely used accounting applications in use today. However, each platform continues to experience major changes across several fronts. Feature sets, licensing requirements, and price changes all impact users at unprecedented levels. Further, competition continues to emerge in the small business accounting battleground, adding confusion to the options existing QuickBooks and QuickBooks Online users may have. In this session, you will learn about many of the changes impacting QuickBooks Desktop, Online, and Enterprise users, and you can manage these changes for the benefit of your company or your clients.

Sustainability Accounting is now a recognized professional skill of increasing importance in larger organizations. It is the process of finding, measuring and managing the material metrics for sustainable performance and risk management. The goal is to bring these metrics into regular financial statements so leaders can act on them.  This course teaches Sustainability Accounting basics with example from the restaurant industry.   It is suitable for any professional or student who wants to learn fast about sustainability issues in specific industry sectors and how to integrate sustainability metrics into financial accounting and reporting.

With only a few months to go before the AICPA's Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, SAS 146, and SSAE 23 are required to be implemented, this course can help you meet the deadline. It focuses not simply on theory but on HOW to perform the steps involved. The Quality Management Suite of Standards must be implemented by December 15, 2025. The standards modernize the firm's approach to quality to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on many engagements. Beginning with performing a risk-based approach, the standards provide accounting firms with the ability to enhance their quality control by shifting their focus to a proactive approach (management) from a reactive approach (control). The results of the firm's risk assessment will form the basis of its new Quality Management document. This is not just a tweak of the old document but a more robust document that adds new requirements from the new standards. We will cover how to perform a risk assessment, including the key provisions of the standards, and how to effectively implement a monitoring plan. We will also review how the firm will evaluate its System of Quality Management beginning in 2026.

Accounting and financial reporting for construction contractors may be the most difficult area to be in compliance with the various standards. Also, construction engagements are, in many instances, more "dangerous" than most lines of business due to the many users of the financial statements. In this course, we will discuss why construction accounting and financial reporting are so complex and discuss the relationship between the contractor and the surety, both from an underwriting and claims perspective. We will also explore what the surety looks for in order to maximize potential bond credit.

Inventory observations are often a right of passage for audit staff. This course will cover the basics of auditing inventory, including the related audit assertions, risks, & threats to inventory. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through how to conduct a physical inventory observation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.