CPE + Events Catalog
View or download your copy of The Resource today!
AICPA Town Hall Series (5/22/2025) (1 hour)
-
Online
1.0 Credits
See more dates
OSCPA is pleased to partner with AICPA to offer the Town Hall Series. These webcasts are FREE to OSCPA members.The AICPA Town Hall Series provides the latest news and updates on pressing issues facing the accounting profession. Hear from AICPA executive leads and leading subject matter experts, to dive into key drivers of this accelerated time of change. Hear the latest updates and guidance from Treasury and SBA as well as review top firm questions surrounding the CARES Act and PPP forgiveness.
More Dates
Ethics: IRS Criminal Investigations: Key Lessons for Accountants (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of recent IRS criminal investigations and what practitioners can learn from these cases to help fight economic crime and even avoid personal criminal prosecution. While accountants are numbers people by training (not detectives per se with the exception of forensic accountants), practitioners are increasingly being called upon by governments and economic organizations at all levels to step up and help law enforcement battle financial impropriety. The stakes are huge. In the United States alone, the OECD estimates that 5% to 10% of the annual budget of the US health care programs, Medicare and Medicaid, is wasted as a result of corruption. Every dollar lost to monetary malfeasance has a crippling effect that ripples through countries, industries, companies, communities and individual lives. Government resources are wasted, public services are compromised, companies are financially destabilized, shareholders are cheated, employers are swindled, charities are undermined and much more. By increasing their awareness of what and how the IRS investigates and prosecutes, accountants can heighten their "spidey sense" of what doesn't look right in financial records. This includes honing skills to more readily notice -- and report -- ledger anomalies and irregularities, and even rethink a "silence is always safer" mindset. As technology disrupts and automates many fundamental accounting functions, practitioners can add value by more diligently scanning for "creative accounting" red flags on the frontlines. Prioritizing transparency and behaving ethically -- the core of the profession -- not only helps society and the economy as a whole, it can help accountants boost their reputation as highly trusted business advisors and even supercharge their bottom line. 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
K2's 2023 Accessing And Managing Data In Excel (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $129
For many business professionals, accessing and managing data in Excel is one of the biggest stumbling blocks when creating reports and analyses. Common practices include far too many manual processes and formulas, including never-ending manual processes needed to update your data and related reports. Make plans now to join us in this session to learn best practices for accessing and managing data using Excel. In this session, you will learn how you can use Power Query and other Excel tools to quickly access and manipulate your data and generate reports in record time! This is a “must-see” session for any business professional working with Excel!
Beyond the Numbers: Success Strategies for Female CPAs (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Women finance leaders face challenges that traditional corporate training and mentoring rarely prepare them to overcome. For example, you've demonstrated yourself as an excellent tactician, you know how to get the job done, and do it very well on your own. Yet, what got you to your current level of success won't get you to the next level. It's time to change the way you think and operate in your role. You need to move from doer to leader. You're familiar with the saying that if you want to go fast, go alone, if you want to go far, go together. In this workshop, you'll learn key strategies that are unique and critical to women to be successful in their careers. These strategies will help you grow, expand and elevate yourself professionally. 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
Integrate ChatGPT into Your Client Advisory Services-Updated (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." 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
Written Information Security Plans (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
Thsi course provides a comprehensive overview of Written Information Security Plans (WISP), focusing on their purpose, requirements, and implentation. All PTIN holders must certify they have a WISP prior to renewal, along with certifying the training of employees, staff and contractors as necessary. Participants will explore the history and legal foundation of WISP under the Gramm-Leach-Bliley Act, and how compliances is enforsed through IRS Circular 230, AICPA Statments of Standards, The American Bar Associations and the Federal Trade Commission (FTC). 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
K2's 2023 Advanced Excel
-
Online
8.0 Credits
Member Price: $225
If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.
K2's 2024 Excel Best Practices And Features (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $79
Excel remains a staple tool for virtually all accounting and financial professionals. In this session learn about many of the newer features in Excel, along with some you may have overlooked in the past…truly “must-see CPE!”
K2's 2024 Office Scripts – The New Macros (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $79
Office Scripts are an exciting new development for Excel and other applications. Although they are like macros in some respects, most users will likely find them easier to work with. Learn how to put this powerful automation tool to use!
2025 OSCPA Circle of Excellence
-
Tigard
0.0 Credits
The Circle of Excellence celebrates aspiring CPAs and the CPA profession! Join us for this fun, uplifting evening. Registration & No-host Social: 5:30 - 6:30 pmDinner & Awards Ceremony: 6:30 - 8:30 pm OSCPA is proud to recognize and honor professional achievements and accomplishments of our members and those in the accounting profession. Honorees include members with milestone anniversaries, newly certified CPAs, those who have passed the Uniform CPA Examination, top accounting students, and OSCPA Educational Foundation scholarship recipients. Special Recognition of: Member Milestones New Certified Public Accountants Exam Passed Candidates Top CPA Exam Scorers OSCPA Educational Foundation Scholarship Recipients OSCPA Educational Foundation Endowment Donors Top Accounting Students Honorees will receive email notifications to submit their photo to be used in a presentation during the awards program. The presentation will also be available online post the event. All photos must be provided to OSCPA no later than Monday, May 5, 2025. When submitting your photo, please provide a high-resolution headshot photo (preferably a jpg file). This photo can be taken with a cell phone. The appropriate dress is professional business attire. We'd like to share our deepest appreciation to Banner Bank, 2025 Sponsor of the Circle of Excellence. Note: In-person seats are limited, please register by Thursday, May 8, 2025. Individual Registration Instructions: Login Scroll down and click "Add to Cart" Select appropriate honoree option- The fee for attendees and guests is $80 per person unless noted as a complimentary honoree type Complimentary honoree types include: 2025 OSCPA Educational Foundation Scholarship Recipients Top Accounting Students If bringing a guest, select the "Add Guest" button, enter name and select Guest option. Select "Add Guest" for additional guests or Select "Checkout." Review items in cart and Select "Checkout" to complete transaction. If you have successfully registered you will receive a confirmation email within 24 hours. Firm & Business Registration Instructions: Firms and businesses that wish to purchase a table, please complete a Table Reservation Form. Questions or Dietary Restrictions? Please contact Megan Drennen; 503-597-5475 / 800-255-1470 ext. 110.
2024 Taxation of Non-fungible Tokens (NFTs) (2 hours)
-
Online
2.0 Credits
Member Price: $79
Non-fungible Tokens (NFTs), unique, identifiable digital assets based on blockchain technologies, have become a fast-growing industry. This course will provide a background on how NFTs came into the mainstream marketplace. These materials will assist the practitioner to understand the tax implications of the creation, purchase and sale of these assets. **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.
Surgent's A Complete Guide to Reporting Form 1099-DA (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
For each digital asset sale that a broker has affected for a customer in 2025, the broker must complete Form 1099-DA. A broker includes any person who, in the ordinary course of a trade or business, stands ready to affect sales of digital assets to be made by others. This program covers the required rules for reporting digital asset transactions on Form 1099-DA.
More Dates
Unlocking Deep Secrets: Case Studies in Financial Analysis (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Unlock the secrets to understanding a company's financial health and management performance through comprehensive financial analysis. This seminar will guide you through essential tools such as vertical analysis, horizontal analysis, and ratio analysis to gain deep insights into business performance. - Vertical Analysis: Learn how to express each line item of financial statements as a percentage, making it easier to compare companies of different sizes and identify key trends. - Horizontal Analysis: Discover how to compare financial information over multiple periods to spot significant changes and trends, providing a clearer picture of a company's growth and performance. - Ratio Analysis: Dive into calculating and interpreting financial ratios to assess profitability, liquidity, and solvency. Understand how these ratios reveal the effectiveness of management and the potential of the business. This seminar goes beyond just teaching terms and formulas. We will apply these analytical tools to real-world financial data, demonstrating how to derive meaningful insights and make informed decisions. Join us to enhance your financial analysis skills and gain a competitive edge in evaluating business performance. 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
Achieve Competency in Three Basic Tool Categories – Master the Fundamentals (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $129
See more dates
Financial skills needed in many situations are constantly changing. It is prudent to routinely look into your toolbox to restock or revise your tool set. In this course we will examine three tool categories that form the foundation for many analytical processes.
More Dates
S Corporations: Comprehensive walk through of Form 1120S
-
Online
8.0 Credits
Member Price: $239
See more dates
This course is designed for financial professionals looking to understand Form 1120S. It covers the essential aspects of S corporation taxation, including the preparation of Form 1120S, determining taxable income, and accurately reporting and allocating income, deductions, and credits. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. It will further compare the S Corporation to other forms of entities, along with compliance with corporate formalities. Highlights of Form 1120S will be discussed, including build-in capital gains, accountable plans, taxable fringe benefits, officer reasonable compensation and audit strategies. Schedules K-1, K-2, K-3, and effectively connected income will be reviewed in this course as well. 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 Social Security and Medicare: Planning for You and Your Clients
-
Online
8.0 Credits
Member Price: $279
See more dates
Social Security seems poised for changes in benefits and eligibility age. The leading edge of the baby boomer generation has already reached retirement age. Financial and tax planners can expect increased demand for strategies that dovetail Social Security with other retirement and estate planning objectives. This course provides tax and financial planning professionals with both the background information on the Social Security system and the strategies clients will need in dealing with Social Security, and the myriad other related retirement planning issues.
More Dates
Taking Advantage of Array Formulas in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. 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
Technology Trends Update for CPAs with John Higgins (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Join us for an enlightening presentation where we delve into the pivotal technology trends reshaping the accounting profession. This course covers an array of topics including cloud computing, big data, data analytics, Robotic Process Automation (RPA), Machine Learning (ML), Artificial Intelligence (AI), cryptocurrency, blockchain technology, and the metaverse. We will also cover provide an update on the current market for cloud based accounting / ERP and personal productivity software. Designed for forward-thinking professionals, this session offers insights into how these technologies impact your business, your firm, your clients and most importantly, your career. Stay ahead in your field by understanding these emerging technologies and their practical applications in business. 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
Enact Retaliation Abatement and Monitoring Measures (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
Once an employee decides to report an issue, the risk for retaliation must be minimized. Metrics matter. As such, capturing and reviewing employee data for indicators of possible retaliation are key to protecting those who report. The more subtle forms of retaliation, though, require a focused communication plan to address. This course offers recommendations for implementing specific retaliation monitoring protocols.
More Dates
Everyday Ethics at Work: Don't be the Next News Story! (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
When asked, most people would say they are an ethical person. So why is it that every month there are reports of ethical breaches at major companies? The concept of ethics is easy to understand, easy to talk about, but incredibly hard to implement on a consistent basis. In this course, we will discuss current ethical issues, and walk-through a nine-step ethical decision-making model. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.