CPE + Events Catalog
Download the 2024-25 CPE Catalog (pdf)
K2's Ethics and Technology (4 hours - late morning) [NT] – Webcast
-
Online
4.0 Credits
Member Price: $195
With the explosion of technology over the past thirty years, one fair question is, "what are the ethical considerations and impacts related to this technology?" Of course, practical technology issues such as data privacy and security undoubtedly carry ethical considerations. However, technology also affects the ethics associated with work-life balance, the digital divide, training needs, copyrights, and fraud, to name a few. This course will teach you about "technoethics" and its implications for individuals and organizations. To that end, you will explore many current and emerging issues associated with ethics and technology, such as copyrights, cybercrimes, privacy versus security, and geo-tracking technologies. Given the profound implications of ethics and technology, this could be the most impactful session you will ever attend.
K2's Excel Charting and Visualizations (4 hours - morning) – Webcast
-
Online
4.0 Credits
Member Price: $195
Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing - three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.
K2's Mastering Advanced Excel Functions (4 hours - late morning) – Webcast
-
Online
4.0 Credits
Member Price: $195
With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features - some new and some legacy - to elevate your productivity to higher levels.In this session, you will learn about many of Excel's newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.
K2's Microsoft Office 365 – All the Things You Need to Know [NT] – Webcast
-
Online
8.0 Credits
Member Price: $310
Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment. Isn't it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.
Tax Planning for Small Businesses (4 hours - morning) – Webcast
-
Online
4.0 Credits
Member Price: $195
Clients want help with present and future business services. Which tax planning strategies will you provide for your corporate and small business clients? Updated for the latest legislation and IRS guidance on tax reform, this course answers the tough questions and shows you what strategies are best for your clients We use a case-study approach to explore opportunities for businesses and how the tax practitioner can continue to add value for their clients. Discussions will include traditional and new planning opportunities as a result of the latest tax legislation, including the SECURE 2.0 Act, and IRS guidance.
K2's Next Generation Excel Reporting – Webcast
-
Online
8.0 Credits
Member Price: $310
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.
Exploring the A-B-C-D of the Digital Age and their Impact on Accounting (1 hour - morning) [NT] – Webcast
-
Online
1.0 Credits
Member Price: $50
This session will start with a quick look at how Artificial intelligence, Blockchain, Cybersecurity, and Data governance are impacting the accounting ecosystem supporting transaction recordation and financial reporting. Then we'll dive deeper into how to identify opportunities for automation, whether with traditional programming, robotic process automation (RPA), or machine learning. We'll close out with a look at how the role of the finance team leader will change and the skills needed to be successful in the near future. OSCPA has partnered with the Washington Society of CPAs for this event.
How Automation and AI are Enhancing Management Accountants (1 hour - afternoon) [NT] – Webcast
-
Online
1.0 Credits
Member Price: $50
Headlines abound saying that Robotic Process Automation (RPA) and artificial intelligence (AI) is going to eliminate the need for accountants. In reality, RPA and AI provide a great opportunity for accountants to automate more routine procedures and focus on delivering more value-added insights to help improve an organization's performance or risk mitigation. Conversely, the use of AI within organizations can also have some perverse results if not managed properly. Accountants must be aware of these risks and work to ensure that the proper controls are in place to manage an organization's operational and financial risks associated with automation and AI. Attend this session to learn more about these technologies and their implications to the skills and knowledge needed to be an effective management accountant. OSCPA has partnered with the Washington Society of CPAs for this event.
Preparing Individual Tax Returns for New Staff and Paraprofessionals – Webcast
-
Online
8.0 Credits
Member Price: $315
The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare a moderately complex federal individual income tax return (Form 1040). Over the years, thousands of new staff have received practical, hands-on experience to become familiar with tax forms. This course covers the latest tax law changes, making it essential for your new staff. NOTE: This course qualifies for IRS CE (PTIN) credit. To receive IRS CE credit, please email your PTIN to profdev@orcpa.org at the end of the course. Surgent will report credit at the end of each quarter.If you have questions, you can contact Professional Development at 503-641-7200, ext. 3 or email profdev@orcpa.org.
SALT Mastery Series: Sales Tax: Understanding Enough to Advise Clients (2 hours - morning) - NEW! - Webcast
-
Online
2.0 Credits
Member Price: $69
Ensure your clients are prepared for complex sales tax challenges in this essential session of the SALT Mastery Series. Gain a deep understanding of sales tax nexus considerations and the key factors that determine when and where tax obligations arise. Learn how to accurately assign sales to the correct jurisdictions and navigate existing exposure with strategies for voluntary disclosure. With expert guidance, you’ll leave equipped to confidently advise your clients on minimizing risks and staying compliant in the ever-evolving world of sales tax.
K2's Case Studies in Fraud and Technology Controls (4 hours - morning) – Webcast
-
Online
4.0 Credits
Member Price: $195
Fraud continues to plague businesses at epidemic levels, and technology control failures are a significant reason fraud occurs. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures contributing to fraud, and what you can do to mitigate fraud risk.A specific focus of this course is applying information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general and application control failures that contributed to each fraud. By learning through these real-world case studies, you will be positioned better to reduce fraud risk.
K2's Artificial Intelligence for Accounting and Financial Professionals (4 hours - late morning) – Webcast
-
Online
4.0 Credits
Member Price: $195
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.
K2's Accountants Guide to QuickBooks Online – NEW! – Webcast
-
Online
8.0 Credits
Member Price: $310
QuickBooks Online's (QBO) market share continues to expand, and the Cloud-based accounting platform now dominates the small business market. Yet, most accounting and financial professionals have not participated in any formal training on the Cloud-based accounting service. Thus, they are unaware of many of the tool's available features and do not work with QuickBooks Online as efficiently and effectively as they should.This course teaches you how to set up QBO and convert QuickBooks Desktop files into a QBO instance. You will learn how to process all types of transactions, including accounts payable, accounts receivable, bank feeds, inventory, and payroll. Further, you will learn how to implement appropriate internal controls and how to capitalize on advanced features such as workflow management and management reports. Join us in this session to learn how to set up QBO properly and take full advantage of all it offers while avoiding common errors and mistakes.
SALT Mastery Series: Protecting Yourself & Your Clients: Understanding the Implications of Remote Work & Licensing Requirements (2 hours) - Webcast
-
Online
2.0 Credits
Member Price: $69
Remote work has changed the landscape for tax professionals and their clients, bringing new challenges and obligations. In this critical session of the SALT Mastery Series, gain insights into registration obligations across different states, including payroll tax, nexus generation, and apportionment issues for remote workers. Learn which agencies to register with and how to navigate the complexities of multi-state compliance. Additionally, ensure you avoid the risks associated with the unauthorized practice of law. This session will arm you with the knowledge to protect both your practice and your clients in the era of remote work.
SALT Mastery Series: Multnomah County / City of Portland Taxation Update (2 hours - morning) - NEW! - Webcast
-
Online
2.0 Credits
Member Price: $69
Learn about the Multnomah County and City of Portland taxation laws and calculations, including changes and current issues! This in-depth 2-hour session will walk you through how these local taxes are calculated and update important taxation issues in Multnomah County and the City of Portland.
SALT Mastery Series: City of Portland, Multnomah County, and Metro Taxes: Practitioner Perspectives (2 hours - late morning) – NEW! – Webcast
-
Online
2.0 Credits
Member Price: $69
Join experienced local practitioners for their practical perspectives on the City of Portland, Multnomah County, and Metro Taxes, including compliance requirements, apportionment, pass-through entity considerations, and interaction with other tax programs. Practitioners will offer their perspectives on tax planning and strategies for these tax programs, insight into potential future developments, and suggestions for communicating with clients. This program will cover the City of Portland, Multnomah County, and Metro business and personal tax programs.
SALT Mastery Series: Oregon Department of Revenue Update (2 hours - afternoon) - NEW! - Webcast
-
Online
2.0 Credits
Member Price: $69
Join your colleagues for this two-hour technical session to obtain a practical update on Oregon Department of Revenue hot topics.
Not-for-Profit Knowledge Network: Bundle - In-person
Multiple Events Between -
Up to 5.0 Credits
OSCPA Members: Add this Not-for-Profit CPE In-Person Bundle for FREE! The OSCPA Not-for-Profit Knowledge Networks offer a great opportunity to explore important not-for-profit topics in one-hour informal discussions with experts and peers - and to obtain valuable CPE.
2024 Accounting & Attestation for ESG (2 hours)
-
Online
2.0 Credits
Member Price: $79
Environmental, Social and Governance (ESG) has become a hot topic among standard setters. This session will look at the work of the FASB, GASB, and AICPA in the areas of ESG. We’ll also look at the types of engagements CPAs can provide to entities who want assurance around their ESG reporting.
Basic Individual Taxation Course (2 hours)
-
Online
2.0 Credits
Member Price: $89
Please join us for an introductory course on the fundamentals of preparing and filing an individual federal income tax return. We will cover topics such as what the federal income tax is and how it is computed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.