CPE + Events Catalog

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.

The technology landscape of 2026 is defined by a practical convergence of intelligence and automation. This session begins with a strategic look at the major trends set to reshape the next decade, from the long-term potential of quantum computing to the continued evolution of autonomous systems. We will move past the immediate hype to understand how these looming shifts will eventually bridge the gap between today's workflows and the firm of the future. The core of the discussion focuses on how generative tools have evolved to manage complex tasks and integrate directly with firm information. We will analyze the trio of AI, data intelligence, and digital crypto assets while exploring how these tools help practitioners stay relevant and effective. This course provides the roadmap for maintaining efficiency in an era where the pace of change is only accelerating, ensuring you can turn emerging disruption into a strategic advantage.

Join us for a focused, insightful session on sales and use tax hosted by Charli Harrell and Aldo Rodriguez, sales tax subject matter experts. This event is designed to help tax professionals confidently navigate one of the most misunderstood areas of state and local taxation. With a spotlight on 2026 updates and real-world examples, this webinar will equip you with guidance to protect your clients from sales tax surprises and stay ahead of changing laws. Whether you're advising startups or established businesses, you’ll leave with new knowledge, practical tools, and a stronger foundation in sales tax compliance.

Elevate your expertise, stay ahead of legislative changes, and gain practical insights tailored for tax professionals. Join us for an in-depth exploration of the Washington legislation effective October 1, 2025. Don't miss the opportunity to master the complexities of SALT and transform your tax practice.

With recent Excel updates provided through Microsoft 365/Office 365 subscriptions, Office 2021, and Office 2024 Microsoft continues to pack new features into the popular spreadsheet tool. More recent Excel versions offer enhanced data analysis tools, new functions, and improved collaboration opportunities. For those who know about these new features and apply them, exciting opportunities for improved productivity await. So, take advantage of this opportunity to learn how to use Excel's best new features! Summary Description Microsoft continues to add new features to Excel at a breakneck pace. Dynamic Arrays, XLOOKUP, Power Query, and collaboration and commenting tools can improve productivity and efficiency. Learn about these features - and others - in this session.

This intermediate-level course provides a focused review of federal reporting requirements for tax-exempt organizations and selected international information returns. Participants will examine key compliance components of Form 990, including governance disclosures and unrelated business income considerations, as well as commonly encountered international reporting forms such as Forms 5471, 8865, and 8938. The course emphasizes reporting mechanics, disclosure requirements, penalty exposure, and common filing errors. Practical examples highlight areas of heightened IRS scrutiny and documentation considerations.

The most effective path to success lies in being indispensable to clients. Achieving that indispensability requires a robust understanding of the client. Participants will explore the latest developments affecting not-for-profit entities, including FASB requirements, OMB Uniform Guidance, and Yellow Book developments. Moreover, they will thoroughly review updates to ethics, governmental auditing standards, and accounting for not-for-profit entities. After taking this course, participants will be well-versed in current standards and best practices in not-for-profit accounting and auditing. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity. OSCPA has partnered with the Idaho Society of CPAs for this event.

This course addresses advanced §199A issues affecting partnerships, S corporations, and complex ownership structures. Participants will examine aggregation elections, SSTB limitations, W-2 wage and qualified property tests, and tiered entity complications. The course emphasizes practical application and documentation requirements to support the qualified business income deduction.

In a rapidly evolving public practice accounting landscape, K2's CPA Firm Update continues to be your essential guide to staying ahead. This session provides actionable insights into transformative technologies and management strategies reshaping the profession. With a focus on data analytics, cybersecurity, practice management, and client service excellence, this year's update delves into how firms can thrive amidst change. Key technologies covered include AI-powered auditing, blockchain applications for financial processes, advancements in cloud computing, robotic process automation (RPA), and workflow optimization tools. Gain clarity on significant trends and how they affect your firm's strategy, enabling you to make well-informed decisions for sustainable growth.

Designed to provide participants with the knowledge to be more efficient and effective at planning and performing audits, this course will help ensure skills are up to date with the latest information in this challenging audit area. Participants will examine how the Single Audit Act relates to OMB Uniform Guidance and explore the different types of guidance and requirements found in the Uniform Guidance. Additionally, participants will learn the responsibilities and requirements of the auditor and the auditee, how to identify federal assistance, and how to determine a nonfederal entity's major programs. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity. OSCPA has partnered with the Idaho Society of CPAs for this event.

In this session you will learn how the conduit theory works for trusts, differentiate how trusts account for trust accounting income, distributable net income, and taxable income, and how each of these accounting methods affect trust and beneficiary taxation, understand the differences between simple, complex and grantor trusts, and when trusts are required to file tax returns. 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

In this session you will learn to identify the powers and circumstances that cause a trust to be classified as a grantor trust, the history and uses of grantor trusts in tax planning including the use of intentionally defective grantor trusts, and gain an understanding of the scope and operation of IRC Sections 671-679 including reversionary interests, administrative powers including the "swap" power, retained powers over income, and general powers of appointment granted to persons other than the grantor. 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

Technology continues to expand at an exponential rate, creating many opportunities for you to improve your company's efficiencies and lower your operating costs. Firms across the nation are quickly realizing the need to adopt these new technologies or risk being left behind. This presentation introduces the Cloud, one of the fastest-growing trends in Internet technology. It takes a deep dive into the major components, deployment methods, service providers, and applications. It aims to help attendees have a good working knowledge of how the Cloud and Internet work so they can better implement these technologies in their organizations. This essential course explores the use of how the Cloud can be used inside your organization and the benefits and risks of moving to the Cloud. The course discusses the differences between the different levels of cloud technology, applications vs. thin clients, the role of mobile apps, and different types of Internet connections. Finally, many examples of actions your office can take to move to the cloud are explored, outlining the risks and benefits of these actions.

More Dates

Master the preparation of Form 990 schedules with practical guidance and actionable insights you can apply immediately. Focus on the three most critical schedules: Schedule A, required for all 501(c)(3) organizations; Schedule B, applicable to many (c)(3)s and certain non-(c)(3)s and Schedule O, where some of the form's most complex disclosures reside. Develop a clear understanding of Schedule A, including its two public support tests, and clarify common misconceptions around donor reporting in Schedule B. Gain insight into Schedule O's most sensitive disclosure requirements, ensuring you can handle its underlying obligations. Leave with the insight needed to prepare these schedules accurately and communicate their implications confidently. OSCPA has partnered with the Minnesota Society of CPAs for this event.

Transform your daily Excel workflows and eliminate hours of manual data processing with powerful automation techniques designed for business professionals. This comprehensive course reveals the full potential of Excel Tables and Power Query, showing participants how to turn complex data challenges into streamlined, automated solutions. Business professionals will discover how to leverage seven key table functions that dramatically reduce formatting time, eliminate formula errors, and create dynamic reports that update automatically. Organizations today need efficient ways to handle increasing amounts of data from multiple sources. This course demonstrates how Power Query serves as the ultimate tool for extracting, transforming, and loading data into Excel with minimal effort. Participants will develop practical skills to automate repetitive tasks, create robust data models, and build reliable reporting systems that save hours of work each week. These time-tested techniques have helped countless professionals reduce their manual data entry by up to 80%, allowing them to focus on higher-value analysis and decision-making activities.