CPE + Events Catalog
2026-27 OSCPA-Select™ CPE - 2 catalog options:
Browse CPE by Field of Study, and use the Format/Type filter to narrow by In-Person, Webcast, Bundles or On-Demand.
You Don't Know What You Don't Know About Microsoft Excel [NT]
-
Online
8.0 Credits
Member Price: $239
See more dates
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. 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
Power Skills: Professionalism and Client Interactions (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Client interactions and professionalism are at the core of what we do as accountants. However, communication with clients is not always as straightforward as it may seem. Sometimes there will be difficult conversations and disagreements that can be tough to navigate. During this course, we will discuss best practices when communicating with the client and also walk through complicated scenarios to practice what we learn. 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
Optimize Your Staff's Performance (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
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.
More Dates
Defining Lines: Advanced Professional Boundaries (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This is a specialized course designed for experienced accounting professionals who are looking to strengthen their interpersonal and professional skills in maintaining appropriate boundaries within and beyond the workplace. This course delves deep into the complexities of workplace relationships, personal practices, & ethical dilemmas, providing participants with advanced strategies to effectively manage professional distances and avoid problematic conflicts of all kinds. Through interactive sessions, case studies, and expert guidance, attendees will learn how to navigate sensitive situations with tact and integrity, ensuring that their professional conduct remains impeccable, and their careers continue to thrive in an increasingly complex business environment.
More Dates
Become a Data Analysis Expert (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers, they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide you through the intricacies of making complex data analysis approachable and engaging. You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. It's not just about learning a tool; it's about enhancing your professional identity as a forward-thinking accounting professional. 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
Preparation, Compilation and Review Issues - Highlights 26-27 (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
This course is a refresher of the more significant SSARS requirements for preparation, compilation and review engagements. Includes discussion of SSARS 26 and SSARS 27.
More Dates
Shortcuts that Excel Users Love (2 hours - morning) - Webcast
-
Online
2.0 Credits
Member Price: $105
Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session! OSCPA has partnered with the Washington Society of CPAs for this event.
Fraud-How to Find, How to Prevent 26-27 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
Participants will review how to maintain a heightened awareness of fraud with clients and gain a better understanding of how to detect fraud. This interactive workshop, designed for practitioners in small and medium-sized CPA firms, will include a lecture with generous time for questions and case studies to reinforce the concepts.
More Dates
Preparing Financial Statements for Clients 26-27 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
This course provides an overview of standards for preparation services, accountants' risks, and strategies to minimize risks. The course objective is to furnish current guidance and examples from the AICPA's professional standards for financial statement preparation so that you can apply these to reduce the risk of material misstatements caused by fraud or by error. In addition, this course covers the AICPA's guidance about professional judgments when providing preparation engagements. Together with the four-hour course "Start-up and Small-Business Financial Statements: Issues and Fraud," these two courses meet the eight-hour accounting CPE requirement for accountants that prepare financial statements for clients but do not perform client audits, reviews or compilations.
More Dates
Tax Update: "One Big Beautiful Bill" (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a focused analysis of the individual and small business provisions in Pub. L. 119-21 (H.R.1), "One Big Beautiful Bill." Tailored for tax professionals working with Form 1040 filers, the course explores impactful updates, from the no-tax-on-tips provision to enhanced bonus depreciation. Designed to inform planning strategies and compliance for the 2025 tax year and beyond. Participants will gain actionable insight into newly proposed deductions and expanded credits. 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
Beyond the Basics: Financial Ratios You Might Be Overlooking (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
Overview: Understanding your company's financial health requires more than just traditional metrics. This webinar is designed to reveal deeper insights through advanced, underutilized financial ratios. In this session, accounting and finance professionals will explore metrics such as operating leverage, free cash flow yield, and margin of safety-tools that go beyond standard ratios to deliver nuanced perspectives on profitability, risk exposure, and operational efficiency. 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
Microsoft Excel: Moving Beyond the Basics (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information.
More Dates
Leveraging ChatGPT for Innovative Business Advisory Services (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
In this cutting-edge course, participants will gain a deep understanding of how to leverage ChatGPT, OpenAI's powerful language model, to innovate and enhance business advisory services in the accounting sector. The course integrates theory and practice, demonstrating how various enterprise evaluation methodologies can be applied in conjunction with ChatGPT for increased business analysis efficiency, profitability, and growth. It also provides hands-on training for implementing these techniques in real-world scenarios. 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
Surgent's Excel Shortcuts for Accountants (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.
More Dates
A Practitioner’s Guide to IRAs and Qualified Retirement Plans
-
Online
8.0 Credits
Member Price: $250
See more dates
Are you ready to expand your practice and offer comprehensive retirement planning services? Look no further! Delve deeper into the realm of IRAs and qualified retirement plans with this comprehensive eight-hour course tailored for financial practitioners. Understanding the intricate tax implications, design options, and strategic considerations of these plans is essential for meeting your clients' diverse retirement needs effectively. By the end of the program, practitioners will emerge equipped to confidently advise clients on a myriad of retirement planning strategies, enhancing their expertise and credibility in the field. Explore the intricacies of different IRAs, ranging from traditional to Roth, and gain valuable insights into SEPs, qualified plans, and contribution plans. Navigate through the complexities of 401(k) plans, including Roth 401(k)s, and master the art of seamlessly navigating minimum distribution rules. Through practical highlights, case studies, and real-world scenarios, this course empowers practitioners to not only select the optimal retirement plans for their clients' unique financial goals but also to provide personalized retirement solutions tailored to individual needs. Don't miss out on this opportunity to elevate your practice and establish yourself as a trusted advisor in retirement planning. Enroll today and embark on a journey towards maximizing your clients' financial future! *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to terri.storer@acpen.com
More Dates
The Ethic of Self-Esteem For Women (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Ethics is ultimately about our relationship to ourself, others, and the world in which we live. Therefore, to enhance our relationships with those around us, we must first start with the regard we hold for ourselves. From an ethical vantage, it can be said that we have a moral obligation to work toward self-love, honor, and respect. Matters of self-esteem are important in every aspect of life including goal setting, relationships, establishing boundaries, handling conflict, levels of productivity, and expressing our needs in respectful and dignified ways. This course explores traps of low self-esteem and ways to minimize those traps. We also explore components of high self-esteem and actions to foster higher regard for self. 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
CPA to CFO: Essential Competencies for Finance Leaders (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
The path from CPA to CFO has evolved dramatically in recent years, with only 43% of S&P 1000 CFOs holding CPA licenses in 2022, down from 55% a decade earlier. This comprehensive course, based on groundbreaking research from the Pennsylvania Institute of CPAs surveying over 320 CEOs and hiring executives, reveals what today's leaders truly seek in CFO candidates and provides a roadmap for CPAs to secure their seat at the executive table. Participants will discover the five critical competencies that distinguish successful CFO candidates: forward-looking financial acumen that goes beyond traditional reporting, strategic leadership skills including critical thinking and strategy creation, the evolving role of emotional intelligence, industry-specific expertise requirements, and the balance between technical proficiency and visionary leadership. Through practical frameworks, real-world examples, and actionable strategies, attendees will learn how to transform their CPA foundation into a comprehensive skill set that meets the dynamic demands of modern CFO roles, whether in high-growth companies, nonprofits, or traditional corporations. 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
Key Tax Issues for Individual Taxpayers (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course addresses the most recent legislative developments impacting individual taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns. **Please Note: If you need credit reported to the IRS for this IRS-approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.
More Dates
Current Fraud Trends - Nonprofit and Government Entities (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Nonprofit entities and governmental entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.
More Dates
Surgent's Data Analytics for Accountants and Financial Managers (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Data analytics and mining are the fastest growing disciplines in accounting and general management. Many organizations are either planning programs or have them already underway. Unfortunately, a number of these attempts fail due to poor planning/preparation and a lack of commitment, training, and clear vision of the program's goals. Today there is no shortage of data, but relatively few organizations have established an environment and ongoing process to isolate, capture, analyze, and convert data into actionable information. At times, even organizations that are employing leading-edge analytics are doing it with traditional, limited sets of data. This session explores how an organization can successfully become data driven. The discussion includes numerous examples demonstrating how accounting and financial professionals can build upon their current analytical skills to better perform traditional tasks and assume a role as a business partner with others in their organization. The program is aimed to assist those just beginning the journey, as well as those who want to test their current efforts or are considering the need for a restart. In addition to discussing a number of analytical tools, including available software, lists of reference books and next-level software are provided. This program continues to build upon the Controllership Update Series.