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.
2026 OSCPA Professional Issues Update (4 hours - morning) - 3 Tech & 1 [NT] - Webcast
-
Online
4.0 Credits
Free to OSCPA Members: Get the latest updates on trends and issues impacting you and the accounting profession. Join your colleagues at the OSCPA 2026 Professional Issues Update.
K2's Supercharging your Spreadsheet Collaboration (2 hours - afternoon) - Webcast
-
Online
2.0 Credits
Member Price: $95
Collaboration is a key to productivity and success. But remote work can make collaboration more challenging, including collaborating on spreadsheets. Fortunately, tools such as portals with check-in/check-out capabilities, version control, comment tracking, and co-authoring can enable online spreadsheet collaboration. Further, Excel's Inquire tool can facilitate spreadsheet collaboration in offline environments. Don't let remote work hamper your spreadsheet collaboration needs! Participate in this session to learn how to collaborate on spreadsheets effectively from anywhere using tools you already own or license.
K2’s Database Basics for Financial Professionals (4 hours - late morning) - Webcast
-
Online
4.0 Credits
Member Price: $195
See more dates
In today's digital age, databases have become the backbone of every business technology, application, platform, and service. Every system relies on databases to store and organize information, from financial records in Quickbooks and Xero to sales efforts in Salesforce and Hubspot. Popular reporting tools like Power BI and Excel utilize databases to create beautiful, insightful dashboards. Despite the widespread use and importance of databases, many financial professionals lack a basic understanding of how they operate. Traditionally, working with databases has been delegated to an organization's IT department, leaving the accounting team out of scope. However, in today's technology-driven environment, accountants need to have a basic understanding of how databases work and the ability to query data independently. Our database basics course focuses on the knowledge most helpful for financial professionals. Through hands-on learning, participants will develop the skills to query data from a database or cloud provider and use it to create insightful reports in Excel or Power BI. By the end of the course, participants will feel empowered to design their dashboards and work more effectively with cloud data. With our database basics course, gain the knowledge you need to succeed in today's digital age and enhance your value as a financial professional.
More Dates
Oregon & Washington Ethics 2026 (4 hours - morning) - Webcast
Online
4.0 Credits
Member Price: $185
See more dates
Award winning discussion leader Mark Hugh helps you meet the ethics requirements of two states, while learning about recent changes at the national and state level. This four-hour class satisfies the Oregon general ethics requirement and is approved by the Washington Board of Accountancy as meeting its four-hour ethics requirement.
More Dates
K2's Hands on with QuickBooks Online Accountant (QBOA) for Public Accounting (3 hours - late morning) - Webcast
Online
3.0 Credits
Member Price: $145
See more dates
We will take a deep look into setting up a QuickBooks Online Accountant (QBOA) account. We will examine all the various firm, staff, and client configuration options for getting this to work inside your organization. This class is going to specifically focus on the configuration options for this application. QBO is a big application and it is important to ensure you've properly set up your firm and client files. Additionally, we will look at the various import/export functionality for getting your data into or out of QBO. Participants will leave this class supercharged with the knowledge of how to set up their QBO accounts correctly for long-term success.
More Dates
K2's Next Generation Excel Reporting - Webcast
Online
8.0 Credits
Member Price: $315
New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel's "legacy" features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to format your spreadsheets quickly and efficiently to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.
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.
Oregon Ethics and New Developments (4 hours - morning) - Webcast Replay
Online
4.0 Credits
Member Price: $185
See more dates
All the ethics you need to know! Award winning and entertaining discussion leader Mark Hugh will review the AICPA Code of Professional Conduct and key Oregon differences; discuss new developments at the national and state level in ethics in the last two years; best practices for CPAs in public accounting and industry; highlight emerging issues; and discuss Oregon administration and enforcement, including examples of recent disciplinary actions.NOTE: This course meets the Oregon Board of Accountancy's biennial four-hour ethics requirement.For the most current Oregon Administrative Rules (OARs), refer to the BOA website: https://tinyurl.com/OR-BOA-Rules.
More Dates
1065 - Understanding Partnerships Tax Returns (2 hours)
Online
2.0 Credits
Member Price: $79
See more dates
Form 1065 is the tax return filed by partnerships, which is one of the most common forms of business organizations in the United States. This course provides an in-depth understanding of the preparation and filing of Form 1065. The course will cover the basics of partnership taxation, including how partnerships are taxed, the different types of partnerships, and the tax obligations of partners. It will also discuss the importance of keeping accurate financial records, the role of the partnership agreement in tax reporting, and the filing deadlines for Form 1065. Participants will gain a comprehensive understanding of the various sections of Form 1065, including the Schedule K-1, which reports each partner's share of the partnership's income, deductions, and credits. The course will also cover how to report partnership income, expenses, and deductions, as well as the tax implications of buying and selling partnership interests. In addition, the course will provide an overview of common errors and omissions made when preparing Form 1065, and how to avoid them. It will also cover recent changes in tax laws that affect partnership taxation. Overall, this course is designed for tax professionals, accountants, business owners, and individuals who need to understand the intricacies of partnership taxation and the preparation and filing of Form 1065. Upon completion of the course, participants will have a solid understanding of partnership taxation and will be able to prepare and file Form 1065 with confidence. **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
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
Guide to Deducting Travel, Meals and Entertainment Expenses (4 hours)
Online
4.0 Credits
Member Price: $129
This program will explain the new rules for deducting travel, meals and entertainment expenses and the TCJA disallowance of business entertainment expenses. Documentation requirements and planning opportunities related to travel, entertainment, and automobile expenses will also be addressed. **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.
Nonprofit Accounting and Financial Reporting Explained
Online
8.0 Credits
Member Price: $225
See more dates
This course provides a high-level overview of the most important issues facing nonprofit entities and their auditors. The focus of this course is on explaining the theory behind major issues and trends, enabling professionals to understand the most important aspects of relevant professional and regulatory standards related to reliable financial reporting for nonprofit entities.
More Dates
Big Picture Mega-Trends, Big Data, and World We Now Face (2 hours)
Online
2.0 Credits
Member Price: $79
See more dates
It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize.
More Dates
Guide to Preparing Form 1041 for Estates and Trusts (4 hours)
Online
4.0 Credits
Member Price: $129
This program examines the critical issues, rules, and special opportunities when preparing your clients' Form 1041 US Income Tax Return for Estates and Trusts. Learn what is considered taxable income; filing requirements and deadlines; impact of the 3.8 percent Medicare surtax on net investment income; and the 10 principles of tax accounting for trust income. **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.
The Competent Accountant - Mastering the Role of the Controller/ CFO (4 hours) [NT]
Online
4.0 Credits
Member Price: $129
See more dates
How do you raise your skills to the next level to master the Controller or CFO role? Welcome to a course that provides insights that align the CGMA Competency Framework. The course will examine each of the areas: Technical, Business, Leadership and People to increase your competency. How are your technical skills? Are you a traditional accountant or have you learned to expand your technical skills to go beyond “what are the financial numbers?” to “why did these financial results occur?” Are you able to use ratios to understand the business dynamics and the implications to change course or take corrective action? Are the systems that you implement and operate best practices or merely stop-gap solutions? How are your business skills? Can you set a vision? Can you develop a strategy? Do you understand the macroeconomic environment of your organization? Can you lead a major project to a successful conclusion? This session will explore the role of business as opposed to tracking the results of the business. How are your people skills? How good is your ability to influence others? How are successful are your negotiation skills? How well can you communicate? Are you a collaborator or a partner? This section will help accountants understand that it is people skills that drive the overall success of the accounting operations. Finally, how are your Leadership skills? Do you inspire staff or make them angry? Do you know why your staff work for your company and you? Do you understand what employees want from their position? Do you know how to deal with a difficult staff person? Can you lead difficult change? This session will help you recognize what leadership truly is as opposed to what passes for day to day management.
More Dates
New Mergers & Acquisitions: Tricks, Traps, & Terrors (4.2 hours) [NT]
Online
4.2 Credits
Member Price: $129
See more dates
Welcome to a course that makes the process of M&A easy to understand and easy to implement within your organization or your clients' organization. The course will provide an intensive overview of the M&A process. Focus will be on practical techniques to guide you through the M&A jungle and avoid the traps that have befallen many organizations.
More Dates
Getting the Most When Selling a Business: Little Details to Get Top Value (2 hours)
Online
2.0 Credits
Member Price: $79
See more dates
Every business will be sold eventually. When you have built a great business and decide to move on – you want the most you can get for that terrific organization! What are the steps to take to maximize the value realized? What do buyers really want? What are the three levers to achieve maximum value? If you want top dollar, preparing to sell takes years of planning. This seminar helps CEOs, entrepreneurs, CFOs, Board members, controllers, and their advisors prepare for a successful sale of the organization to maximize shareholder value. We will outline the process to get the most bang for the buck. Proper exit planning demands planning and time.
More Dates
What's Changing in Risk Assessment (2 hours)
Online
2.0 Credits
Member Price: $79
See more dates
SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. The audit standard amends AU-C 315, including many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315. Attendees will have an opportunity to evaluate the impact on audit methodology and documentation.
More Dates
Selected Ethics Topics - 2024 - 2025 (2 hours)
Online
2.0 Credits
Member Price: $89
This course will help you to stay current on recent changes to the AICPA Code of Professional Conduct, as well as keep you abreast of emerging trends in ethics standards and regulatory initiatives and their potential impact on your practice. We will also explore frequent practitioner ethics compliance challenges, including competence, due professional care, audit quality, and independence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Accountability and Action (4 hours) [NT]
Online
4.0 Credits
Member Price: $159
Good managers know how to delegate, but it can be a challenge to manage employees who are more interested in passing the buck than being responsible. Lack of ownership and responsibility can bog down processes and shut down projects. This workshop will help you create a game plan for building a culture of accountability with your team.