CPE + Events Catalog

Excel is ubiquitous in the accounting and financial professionals' workplace, but some of the best functions and features for accounting and financial professionals are unknown or underutilized. Leverage Tables, shortcuts, and best practices to increase efficiency. Master the functions such as VLOOKUP, INDEX & MATCH, Dynamic Array Formulas. As well as Formulas and uses such as Depreciation, Amortization, Interest, Payment, and more. In this course, we will even take you deeper into statistical analysis with formulas for everything from median, most, and standard deviation and regression analysis.

Unlock the secrets of effective state and local tax strategies with our comprehensive SALT Mastery Series! Elevate your expertise, stay ahead of legislative changes, and gain practical insights tailored for tax professionals. Join us for an in-depth exploration of advanced techniques, guided by industry-leading experts. Don't miss this opportunity to master the complexities of SALT and transform your tax practices. Sign up today and take the first step towards becoming a SALT expert!

Staff accountants have specific needs when working with Excel. Unfortunately, their existing Excel knowledge often does not meet these needs. Chief among these are summarizing data quickly and accurately, generating accurate and aesthetically pleasing reports, and creating accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills to maximize efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a "laptop-friendly" environment, and participants will have access to all the demonstration files. In sum, this seminar is a "must" for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.

The landscape of small business accounting constantly changes, and K2's Small Business Accounting is your essential guide to navigating these changes. This course focuses on the most effective accounting solutions and supplementary tools for today's small businesses. We explore robust, user-friendly software options, from industry staples like QuickBooks Online and Xero to emerging Cloud-based platforms and add-ons. The course helps you understand how these tools can streamline financial management for businesses with annual revenues up to $15 million. You will gain insights into the latest advancements, integration capabilities, and how to maximize efficiency and accuracy in small businesses.

There's no shortage of reports about rapid, pervasive changes in the accounting profession. Talent shortages, changing client needs and expectations, and other emerging challenges are disrupting traditional services and the core of many CPA firms. At the same time, along with these challenges come exciting new opportunities. Break away for a day to work on your firm, not just in your firm, as you set your practice up to thrive, not just survive, in today's rapidly changing marketplace. Join us for two information-packed days focused on skills and knowledge that will help you and your firm become more effective dealing with several major trends impacting the accounting profession. OSCPA has partnered with the Idaho Society of CPAs for this event.

Discover the real-world power of Artificial Intelligence (AI) and equip yourself with the skills to conquer modern challenges in accounting and finance. In this engaging course, we demystify AI and unveil its practical applications, transforming it from theory into a hands-on tool. Learn the essential AI fundamentals and unlock its remarkable potential to boost your productivity and effectiveness alongside your team. Explore the specific problem-solving capabilities of AI, tailored to address the unique challenges faced by accounting and financial professionals. Gain expertise in leveraging AI features integrated into everyday applications, including the ubiquitous Excel. Uncover how these features enable you to effortlessly detect fraud, identify potential transaction errors, and elevate your financial operations to new heights. Witness firsthand how AI is reshaping the present and future of your profession, positioning you at the forefront of this revolutionary wave.

This course provides an in-depth examination of partnership basis concepts, focusing on the distinction and interaction between inside and outside basis. Participants will analyze contributions, allocations, distributions, liabilities, and basis adjustments that commonly lead to reporting errors. Emphasis is placed on reconciling partner capital accounts, K-1 reporting, and tax basis schedules.

Partnership taxation remains one of the most complex and high-risk areas of federal tax compliance. From basis calculations and allocation rules to disguised sales, debt allocations, and partnership audit exposure, even experienced CPAs can encounter technical pitfalls that create significant financial and professional risk. This two-hour program examines the top 10 partnership tax issues most frequently encountered in practice. Designed specifically for CPAs advising partnerships and partners, the course provides practical guidance to identify, analyze, and avoid common compliance errors under Subchapter K. Through real-world examples and application of current tax law, participants will strengthen their technical proficiency and improve the quality of client advisory services.

This intermediate-level course provides a focused review of federal income and transfer tax reporting for trusts, estates, and taxable gifts. Participants will examine key reporting requirements and filing mechanics for Forms 1041 and 709, including income distribution deductions, Schedule K-1 reporting, and taxable gift calculations. The course emphasizes fiduciary accounting considerations, compliance risks, and common preparation errors. Practical examples reinforce accurate reporting and documentation standards in fiduciary and gift tax return preparation.

This webcast is part of a new three-part 2026 Internal Audit Series. You may purchase individually, or save up to $75 when purchasing the bundle (see below). The series is led by Elizabeth McDowell, CPA, CIA, founder of Audit Forward and a seasoned internal audit leader with more than 20 years of experience. She brings real-world insights to every session. Known as an “edutainer,” Elizabeth combines education and entertainment to make auditing concepts engaging, practical and memorable.OSCPA has partnered with the Iowa Society of CPAs for this new series.

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.

The term "artificial intelligence" (AI) has become mainstream and while most have a layperson understanding of AI, few know the depth and breadth of these technologies' capabilities. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advance. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as to what's coming in the not too distant future. OSCPA has partnered with the Washington Society of CPAs for this event.

Are you ready to pass the CPA Exam? Have you studied enough? Are you focusing on the right material? There’s only one way to find out – give it a try!  OSCPA members are invited to participate in Surgent CPA Review's live 4-hour mock CPA Exam workshop. This unique opportunity will allow you to experience what it is like to sit for any CPA Exam section as you immerse yourself in questions pulled from the actual CPA Exam Blueprints. Plus, you will leave the session with your own personalized ReadySCORE™ (an accurate measurement of your actual exam score) plus a detailed report showing your areas of strength and weakness for that section. Can't make this mock exam date? Questions? Please contact Membership; 503-641-7200 / 800-255-1470, ext. 4. Program facilitated by:

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

Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel's most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you'll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we'll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.

Advance your skills to propel your career. This course is the second in a five-course series, provides the guidance needed to handle small engagements and to complete small audits, reviews and compilations with minimal supervision. Gain knowledge to improve your skills to perform more complex analytical procedures, as well as drafting financial statements and footnotes. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

In this session you will learn how to create a synopsis of critical trust terms and provisions, correctly interpret mandatory and discretionary distribution language, understand how the marital deduction functions for trusts, and identify and understand the tax implications of various trust funding formulas. This course is recommended to take first before the others in the series. This event is part of the Trust & Estate Mastery Series Bundle. There are 10 courses included in the bundle designed to equip CPAs, tax preparers, and fiduciary professionals with a complete understanding of trust taxation—from the basics to advanced concepts. Each course is a stand-alone topic. If you miss one in the series, no worries! Purchase individual courses or purchase the Trust & Estate Mastery Series Bundle and save up to $150!

More Dates

As IRS scrutiny of digital assets intensifies, CPAs must stay current on cryptocurrency taxation and reporting requirements. This focused 2-hour course provides a practical update on the federal income tax treatment of cryptocurrency transactions, emerging reporting rules, and current IRS enforcement initiatives. Participants will review the tax implications of common digital asset transactions, including sales, exchanges, mining, staking, hard forks, and airdrops. The program emphasizes reporting requirements, including the Form 1040 digital asset question, Form 8949 reporting, and new broker reporting developments such as Form 1099-DA. Special attention is given to audit risk factors, documentation standards, and practitioner responsibilities in an evolving regulatory environment. This session is designed to equip tax professionals with the tools needed to ensure compliance and confidently advise clients in today’s increasingly regulated digital asset landscape.

Navigate the complex world of Form 990 and discover how its structure, definitions and disclosures shape public perception and regulatory oversight. Gain a clear understanding of the form's core components, the triggers for its schedules and the key terms every preparer must know. Learn how to identify data sources within an organization, manage sensitive disclosures and guide board members in understanding what the completed form communicates. Gain the clarity and confidence needed to complete Form 990 accurately and effectively. OSCPA has partnered with the Minnesota Society of CPAs for this event.