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 Advanced Excel - Webcast
-
Online
8.0 Credits
Member Price: $315
Elevate your Excel expertise with K2's Advanced Excel program! This laptop-friendly course is designed for experienced Excel users who are ready to take their skills to the next level. In this session, you will master critical advanced Excel skills in six key areas: Collaborating seamlessly with other users and securing your workbooks Utilizing tables to analyze and report data efficiently Integrating and manipulating data from external sources with ease Creating and auditing complex formulas Harnessing advanced data analysis tools for deeper insights Employing visualization techniques to communicate information effectively Drawing from over thirty years of experience in delivering Excel training to accountants and business professionals, this program is packed with relevant, real-world examples that reinforce the topics presented. Don't miss this opportunity to become more efficient and proficient in Microsoft Excel, the go-to tool for accounting and financial professionals. This course covers advanced Excel topics that are essential for business success. Participate in this session to elevate and transform your Excel skills!
Financial Statement Disclosures: A Guide for Small and Medium-Sized Businesses (4 hours - afternoon) - Webcast
-
Online
4.0 Credits
Member Price: $195
A clear and concise set of proper financial statement disclosures can make or break an entity's financial statements. Such disclosures are no longer simply additional information provided by a business; they can be complex in nature and difficult to both prepare and understand, especially for small and medium-sized businesses. Oftentimes financial statement users will first turn to the notes in the financial statements in order to get a feel for where the business and its numbers might be heading, so these disclosures need to be well-written and follow applicable standards. This course will focus on key balance sheet and income statement disclosure as well as accounting standards related to the two largest standard updates in years, revenue (ASC 606) and leases (ASC 842), accounting policies, changes in accounting estimates and errors, subsequent events, going concern, and related party disclosures. The course will use illustrations, examples based on private company financial statements disclosures, and real-world excerpts from financial statements to provide you with a hands-on feel for the disclosure requirements across a number of accounting standards.
K2's Better Reporting with QuickBooks Online (2 hours - afternoon) - Webcast
-
Online
2.0 Credits
Member Price: $95
Presently, over seven million businesses use QuickBooks Online. However, these businesses often struggle to get the reports they need. In some cases, they are limited because of their chosen subscription. However, necessary reports are available in other cases, yet users do not know how to access them. Join us in this session to learn about better reporting options in QuickBooks Online. In this session, you will learn how to create and customize your reports in QuickBooks Online. You will learn about Standard, Custom, and Management reports. You will also learn about the new Spreadsheet Sync tool that allows you to create customized reports, including multi-company reports in Excel. If you use QuickBooks Online and want to improve reporting, this session is for you!
K2's Small Business Internal Controls, Security, and Fraud Prevention and Detection - Webcast
-
Online
8.0 Credits
Member Price: $315
Internal controls are more important than ever, and their importance increases daily. However, internal controls present a challenge for many smaller organizations. This program will teach you how to evaluate, develop, and implement an effective internal control structure in a small business environment. You will identify how to assess risk in smaller organizations and implement preventive, detective, deterrent, and compensating controls to mitigate these risks, even without proper segregation of duties. Additionally, participating in this program will teach you technology-focused techniques for preventing and detecting fraud and securing information systems and sensitive data. For small organizations, maintaining an effective system of internal controls presents a significant challenge. Realistically, implementing many theoretical concepts surrounding internal controls may sometimes be impossible. Consequently, many internal control structures foster an environment where too much risk exists. This factor and uncontrolled information systems can often lead to disastrous results. Participate in this program to learn the necessary insights and tools to design, implement, and monitor small organizations' internal controls, security, and anti-fraud measures.
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.
Surgent's Current Issues in Accounting and Auditing: An Annual Update (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
Designed for accounting, auditing, and attestation practitioners at all levels in public accounting and business and industry, this course provides a detailed review of the multitude of FASB and AICPA standards and reports issued over the past few years, including a discussion of the FASB's Stage 3 PIR report on ASC 606. It also provides an overview of recent PCAOB inspection report findings and SEC rulemaking activity. Through hands-on examples and illustrations, this course will help you apply the guidance in practice. We further discuss other important A&A practice matters to be aware of, including an update on the quality management standards and soon-to-be-effective requirements for engagement quality reviews.
More Dates
The Controllership Series - The Controllers Role in Financial Forecasting (1.5 hours)
-
Online
1.5 Credits
Member Price: $59
See more dates
Financial forecasting is an important part of any successful business. It enables businesses to plan for the future and anticipate scenarios based on strategy. The controller helps forecast financials by calculating future revenue and income streams. In recent years, corporate finance has undergone many dramatic changes due to the growth of a number of high-tech tools. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years To maximize performance, Controllers must be aware of how the FC position is changing, and how they must adjust to these changes. There are many types and methods of financial forecasting. This course will review the most prevalent forecasts and relative methods being used.
More Dates
2025 Accounting & Auditing Update for Small Businesses (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
For many small businesses, the standards issued by the FASB may have little to no effect as they impact topics that do not reflect the type of transactions that these entities most frequently experience. This class will focus on the Accounting Standards Updates (ASUs) that are most likely to impact small businesses with a focus on ASUs initiated by the Private Company Council (PCC). We'll then look at alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs for entities who don't necessarily need to prepare GAAP financial statements but want to use accrual accounting. Finally, we will transition to audit standards that small business auditors will need to implement. 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
The Controllership Series - Managerial Accounting Basics and Costs (1.2 hours)
-
Online
1.2 Credits
Member Price: $39
See more dates
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.
More Dates
Surgent's Applying ASC 820: The Basics of Fair Value Accounting (4 hours)
-
Online
4.0 Credits
Member Price: $159
While once thought just to apply to banking and financial institutions, entities now need to apply fair value accounting under ASC 820 across a variety of transactions. Whether you are assessing financial instruments, leases, business combination accounting, or impairment measurement, GAAP either requires or allows the use of fair value measures in an expanding number of circumstances. Now is the time for you to get up-to-speed on the basics of the fair value approach. In this course, we will review when fair value accounting is required and when an entity can select to use it. Then we will review the basics of the ASC 820 model, including the concept of "exit price," the various approaches that an entity may follow when using a fair value approach, and the different levels of inputs that an entity may consider when determining fair value. Lastly, the course will provide examples of when and how to apply this complex accounting guidance.
The Controllers Role in Data Analytics and Big Data (1.5 hours)
-
Online
1.5 Credits
Member Price: $59
See more dates
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.
More Dates
Creating Terrific Equity Compensation Plans: Beware of the Pitfalls (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
In today’s business world, there is a war for talent and organizations with the best talent will win. We clearly need to motivate talented personnel. Equity compensation plans are useful to retain, reward and recruit. The GAAP and tax accounting for equity compensation plans is not static and decisions that you make during plan set-up can have major consequences to your organization’s bottom line and your management team’s personal tax situations. We will review nuances and details that impact proper accounting. Whether you are the CFO or CEO who has not been happy with prior equity compensation plans or the accountant who performs the intricate analysis and detailed accounting for these plans - this session will help you understand the issues and get it right the first time.
More Dates
The Controllership Series - Financial Statement Preparation (2.6 hours)
-
Online
2.6 Credits
Member Price: $89
See more dates
One of the important roles of any member of the financial team. Including the controller, may be involvement in the preparation of the company’s financial statements. Even if that responsibility falls within the office of the CFO, the controller and other finance personnel must understand how their transitions recorded impact the financial statements. Financial statements (or financial reports) are formal records of the financial activities and position of a business, person, or other entity. Relevant financial information is presented in a structured manner and in a form which is easy to understand. They typically include four basic financial statements accompanied by a management discussion and analysis: A balance sheet or statement of financial position reports on a company's assets, liabilities and owners’ equity at a given point in time. An income statement may have varying names including profit and loss report (P&L report), statement of comprehensive income, or statement of revenue & expenses. These report on a company's income, expenses, and profits over a stated period. A profit and loss statement provides information on the operation of the enterprise. These include sales and the various expenses incurred during the stated period. A statement of changes in equity or “statement of equity” also called “statement of retained earnings” reports on the changes in equity of the company over a stated period. A cash flow statement reports on a company's cash flow, particularly its operating, investing and financing activities over a stated period. A balance sheet represents a single point in time, where the income statement, the statement of changes in equity, and the cash flow statement each represent activities over a stated period. For large corporations, these statements may be complex and may include an extensive set of footnotes to the financial statements, management discussion and analysis and supplementary information. The notes typically describe each item on the balance sheet, income statement and cash flow statement in further detail. Notes to financial statements are considered an integral part of the financial statements.
More Dates
How Changes in Business Methods Affects Internal Control
-
Online
8.0 Credits
Member Price: $239
New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Controllership Series - The Controller's Role in Pro Forma Financial Statements (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
Pro forma statements are used by businesses to make decisions on planning and control, as well as for external reporting to owners, investors, and creditors. For example, giving financial estimates for a given period in a standardized manner is known as “presenting pro forma,” a Latin phrase that means “as a matter of form.” Pro forma statements can be helpful tools for business owners, investors, creditors, or decision-makers to analyze various scenarios of future events based on certain financial assumptions. It might aid in making predictions performance of the company. A pro forma income statement displays a firm’s anticipated sales and revenue. It also highlights anticipated fixed or variable operational expenses and, in the end, displays the potential profits and retained earnings for a future financial quarter. There are various types of pro-forma statements and methods to develop them. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years. However, the creation of pro forma financial statements is still a core part of their responsibility.
More Dates
The Controllership Series - Overhead, Direct and Indirect Costs and Allocation Methods (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
Managing expenses is a key for business success, and overhead costs play a pivotal role in realizing favorable profit margins. Almost all companies have some form of overhead consisting of specific categories of indirect expenses. The better organizations are able to manage overhead costs, the more competitive they are in the marketplace. It is incumbent in the Controller’s role to effectively manage, monitor and perform ongoing assessment of overhead costs, allocations and rates. Overhead refers to the ongoing business expenses not directly attributed to creating a product or service. A company must pay overhead on an ongoing basis, regardless of how much or how little the company sells. It is important for budgeting purposes but also for determining how much a company must charge for its products or services to make a profit. Overhead can be fixed, variable, or a hybrid of both. There are different categories of overhead, such as administrative overhead, which includes costs related to managing a business. In short, overhead is any expense incurred to support the business while not being directly related to a specific product or service.
More Dates
Data Analytics: Practical Insights for Today's Accountant (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today's popular and software tools and examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements.
More Dates
Introduction to Forensic Accounting (1.8 hours)
-
Online
1.8 Credits
Member Price: $59
See more dates
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.
More Dates
