CPE + Events Catalog
2026-27 OSCPA-Select™ CPE Courses Now Available!
Browse CPE by Field of Study, and use the Format/Type filter to narrow by In-Person, Webcast, Bundles or On-Demand.
K2's Excel PivotTables for Accountants (4 hours - morning) - Webcast
-
Online
4.0 Credits
Member Price: $195
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables - including grouping options for fiscal periods - and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.
K2’s Implementing Internal Controls In QuickBooks Environments (4 hours - morning) - Webcast
-
Online
4.0 Credits
Member Price: $195
The QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications small businesses use. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions. In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. While many believe that QuickBooks-based organizations will forever face weak internal control structures, participating in this session will teach you how QuickBooks-based businesses can benefit from strong internal controls.
K2's Business Intelligence, Featuring Microsoft's Power BI Tools - Webcast
-
Online
8.0 Credits
Member Price: $315
Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today's business climate. Increasingly, organizations of all sizes are seeking to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools - from Excel add-ins to dedicated solutions such as Power BI - now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently. This program will teach you to implement "do-it-yourself business intelligence" using a variety of techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft's Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.
SAS 145 - Risk Assessment (1 hour)
-
Online
1.0 Credits
Member Price: $39
SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. This audit standard amends AU-C 315, making many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315.
Controls to Secure the Growing Digital Footprint (4 hours)
-
Online
4.0 Credits
Member Price: $149
The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
A Guide to Sampling - Part 1 (2 hours)
-
Online
2.0 Credits
Member Price: $79
Sampling is often identified as a common audit deficiency in peer review. This course will review when is sampling applicable and basics of planning a sample. We'll then focus on the application of sampling in financial statement audits with a look at sampling for substantive procedures. We'll look at the use of monetary unit sampling and tools that can be leveraged to reduce bias in sampling.
2025 A&A Update With Technology Implementation (4 hours)
-
Online
4.0 Credits
Member Price: $149
Stay informed and prepared with this comprehensive annual update on the latest developments in accounting and auditing. We'll begin with a deep dive into the Accounting Standards Updates (ASUs) effective in 2025, followed by insights from the FAF's 2024 PCC Review and an overview of FASB's Invitation to Comment - Agenda Consultation, which will shape the future of accounting standards. On the auditing side, we'll tackle the essential changes in quality management standards that firms must implement by the end of 2025. The session will also highlight common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB). Join us to gain practical insights and actionable takeaways to navigate these updates with confidence. Finally, we will close the course by exploring the audit technology adoption process to help transform resistance into resilience as the industry embraces new technologies. We will learn how to overcome common barriers to deliver a successful implementation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Communicating in a Virtual and Live Environment - Numbers Matter But So Do Words (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
People fear presenting more than they do “death”. Communicating numbers is a scary proposition to overcome for both the presenter and the recipients. This course is designed to enhance the communication skills of CPAs and CFOs by emphasizing the importance of understanding and mastering the facts before delivering any presentation, understand the key elements of presenting a narrative, and provide examples to engage live and virtual teams in effective numbers presenting. The goal is to equip financial professionals with the tools needed to overcome fears and provide the best practices research on all types of presentations-from communicating complex financial information effectively to conducting a casual virtual meeting. This is a fun session intended to be interactive with participation either live, virtual or both.
More Dates
Fraud Busters: Controls to Prevent & Detect Fraud (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
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.
More Dates
Internal Controls for Small and Medium-Sized Entities (1 hour)
-
Online
1.0 Credits
Member Price: $39
This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities. We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.
Risk Assessment Under SAS No. 145: The Key to Audit Quality? (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
The AICPA has identified risk assessment as an area of focus for its Enhancing Audit Quality Initiative as deficiencies in auditor's risk assessment procedures continue to be a common issue identified in peer review. SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was written to improve the quality of risk-based audits. While key concepts do not fundamentally change, the standard works to clarify and enhance certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and hopefully overall enhance audit quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Global Internal Audit Standards (GIAS) Domain IV - Part 1 (2.4 hours)
-
Online
2.4 Credits
Member Price: $79
See more dates
The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service
More Dates
Accounting & Auditing for Cryptocurrency (1 hour)
-
Online
1.0 Credits
Member Price: $39
Bitcoin and crypto have been in the news recently for a variety of reasons. This course will cover the basics of accounting and auditing for cryptocurrency, including recent standard setting by the FASB as well as a look at the AICPA's Accounting for and Auditing of Digital Assets practice aid.
Global Internal Audit Standards (GIAS) Domain IV - Part 2 (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service
More Dates
Transforming Strategic & Financial Management with ChatGPT - Insights for CPAs, CFOs and Controllers (2.2 hours)
-
Online
2.2 Credits
Member Price: $79
See more dates
"Transforming Strategic & Financial Management with ChatGPT: Insights for CPAs, CFOs, and Controllers" is a comprehensive 2-hour CPE course designed by Jim Lindell of Thorsten Consulting Group, Inc. This course delves into the revolutionary impact of ChatGPT on financial and strategic management, offering a blend of theoretical insights and practical applications tailored for financial professionals. Through an exploration of ChatGPT's capabilities in research, communication enhancement, benchmarking, risk analysis, and more, participants will learn how to leverage this advanced AI technology to streamline operations, enhance decision-making, and foster innovation in their practices. The course not only highlights the current applications but also provides a glimpse into the future of AI in financial management, encouraging professionals to embrace technology for competitive advantage.
More Dates
Forgotten Managerial Accounting Tools for CPAs (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Auditing For Fraud (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Auditors are required by Generally Accepted Auditing Standards to perform audit procedures to determine if the financial statements are materially misstated due to error OR FRAUD. Unfortunately, in the past the profession has focused on misstatements due to errors and largely ignored to possibility of misstatements due to fraud. While SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit sets forth the procedures that auditors are required to perform in each audit to determine if the financial statements are materially misstated due to fraud, this program presents a practical approach to making such a determination. It’s not a substitute for the requirements in SAS 122, AU 240, but rather an informal supplement to the standard with some common-sense procedures which are designed from my over 30 plus years of directing fraud investigations. After attending this session, you will more than likely never look at a financial statement audit the same way.
More Dates
The Controller Function - Cash and Investments (1.4 hours)
-
Online
1.4 Credits
Member Price: $39
See more dates
This course corresponds to our Controllership series. This course is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we discuss the area of cash and investments and explore how the controller can move these responsibilities into more of a strategic role. In today’s world, the role of cash management is often a pivotal role in the organization. In economically difficult times, controllers may find that they spend a great deal of their time on understanding and managing the organizations' cash position. This is certainly important and, in some areas, can be seen as a staple of the lifeblood of the organization’s ongoing viability. This course takes a look at some of the typical objectives involved in cash management and then evaluates how those objectives can be further stretched into strategic pillars of the organization.
More Dates
Avoiding Legal Liability and Peer Review Deficiencies in Nonaudit Services, Including Bookkeeping and Preparing Financial Statements (4 hour
-
Online
4.0 Credits
Member Price: $129
See more dates
The majority of peer review deficiencies and malpractice claims result from nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns.
More Dates
Fraud, Controls & Ethics: Best Practices & Case Studies (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course explores actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters from achieving their nefarious acts. Then we will switch gears to an interactive, case-based discussion that asks participants to reach their own conclusions by analyzing facts in concert with the AICPA Code of Professional Conduct and other sources of ethical guidance. This course ultimately provides practical, action-oriented insight that can be implemented by accounting professionals in both public practice and industry. This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.