CPE + Events Catalog

After purchasing this bundle, you will automatically be registered for all three sessions included in the series (6 hours CPE credit total). See dates/topics included in the series at the bottom of page. The NEW Internal Audit Series delivers three, expert-led sessions designed to help confidently navigate today’s internal audit landscape. Each session is offered in a convenient, flexible virtual format - making it easy to join from anywhere, gain actionable insights and walk away with knowledge to immediately apply. 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. 09/03/26 - Using AI to Audit Smarter, Not Harder! (2 hours - morning) - Webcast 10/08/26 - The Data Detective: Actionable Analytics for Internal Auditors (2 hours - morning) - Webcast 11/05/26 - Fraudsters Unmasked: Internal Audit's Role in Preventing Fraud (2 hours - morning) - Webcast There are three courses in the bundle. Each course is a stand-alone topic. If you miss one in the series, no worries! Purchase individual courses or purchase the 2026 Internal Audit Series Bundle and save up to $75! OSCPA has partnered with the Iowa Society of CPAs for this new series.

After purchasing this bundle, you will automatically be registered for the sessions included in the series (up to 8 hours CPE credit total). See dates/topics included in the series below. Artificial intelligence (AI) is no longer a future concept - it’s already reshaping the accounting profession. From automating routine tasks to enhancing data analysis, AI is changing how CPAs work and the value they deliver. New tools, evolving regulations and emerging risks mean today’s knowledge can quickly become outdated. AI isn’t replacing CPAs, but CPAs who understand AI will lead the way forward. Staying informed isn’t optional, it’s essential.This NEW Fall/Winter AI Series delivers four, expert-led sessions designed to help you confidently navigate today’s rapidly evolving AI landscape. Each session is offered in a convenient, flexible virtual format - making it easy to join from anywhere, gain actionable insights and walk away with knowledge to immediately apply.  10/16/26 - The AI Revolution in 2026: What CPAs Should Know (2 hours - morning) - Webcast 10/23/26 - AI 101 for CPAs: Core Concepts and Practical Applications (2 hours - morning) - Webcast 12/18/26 - Agentic AI for CPAs: Automate Workflows with Intelligence (2 hours - late morning) - Webcast 12/30/26 - Smarter Tax Services with (AI) Tools (2 hours - morning) - Webcast Each course in the series is a stand-alone topic. If you miss one in the series, no worries! Purchase individual courses or purchase the AI for CPAs Series - Fall/Winter Bundle and save up to $80!

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.

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.

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.

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.

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.

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.

Transform business operations and reduce manual workload through powerful automation tools and strategies. This comprehensive course reveals how organizations can leverage QuickBooks Online Advanced's automation features for both workflow and advanced reporting, alongside integration platforms like Zapier and Microsoft Power Automate. Participants will discover practical solutions for automating bills, payments, invoices, scheduled reports, and vendor management while learning to implement custom workflows that streamline daily operations and enhance productivity. Business leaders and accounting professionals will gain hands-on experience with automation tools that revolutionize reporting processes and stakeholder communication. The course combines QuickBooks Online Advanced's native capabilities with broader integration strategies, demonstrating how to utilize Integration Platform as a Service (iPaaS) solutions and third-party tools to create seamless connections between accounting systems and other business applications. Participants will walk away with actionable strategies to reduce manual data entry, minimize errors, and create more efficient processes that save both time and resources. This practical approach to automation empowers organizations to scale operations without increasing overhead costs.

More Dates

Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session! OSCPA has partnered with the Washington Society of CPAs for this event.

AI is reshaping audit, tax, and finance. This update surveys what's real in 2026: core concepts, major tools, risks/controls, and practical CPA use cases. Leave with a clear vocabulary, a current landscape view, and actionable talking points for staff, clients, and vendors.

This course provides tax and accounting professionals with a comprehensive framework for transitioning from a compliance-driven busy season model to a sustainable, year-round advisory practice. Participants will explore strategies for expanding services into tax, financial, and estate planning. The course addresses both transitioning existing clients and attracting new, higher-value clients while improving efficiency, client value, and revenue stability. OSCPA has partnered with the Washington Society of CPAs for this event.

Part one of a five-course series, address common issues new staff members face. Focus on strategies to improve efficiency and quality control, build technical skills, and make valuable contributions to a company. Dive into the fundamentals: workpaper techniques, analytical procedures, compilation and review services, tax recognition and research techniques, understanding audit objectives, and auditing and reviewing selected accounts. 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.

More Dates

To better serve today's busy professionals, we've reimagined our long-standing Business & Industry Conference as the Business & Industry Focus Forum. This new 4-hour virtual format concentrates on the most timely and impactful topics affecting finance, accounting, and business professionals, delivering the insights you need in a more flexible and efficient experience. Note: This event was originally advertised at 8-hours. A special thank you to the members of the Business Management & Advisory Serivces Project Committee for developing the 2026 conference.

Digital assets are no longer niche—they're now a key part of personal and business portfolios. This course breaks down the core technologies behind cryptocurrency and blockchain while giving attendees the tools they need to address evolving IRS guidance, proposed FinCEN reporting, and the treatment of crypto in estates and trusts. We'll look at wallet types, transaction tracking, taxable events, and reporting obligations under current law, including the infrastructure bill's impact on brokers and exchanges. Beyond theory, this session focuses on practical planning. You'll learn how to advise clients on basis tracking, crypto-to-crypto exchanges, charitable donations of crypto, and estate transfers involving NFTs and other digital assets. This course is designed for financial professionals who need clear guidance on how to keep their clients compliant—and prepared—for what's coming next. OSCPA has partnered with the Washington Society of CPAs for this event.

Financial professionals can transform their daily workflow with this comprehensive training designed specifically for accountants and business analysts. Participants will discover how to leverage advanced Excel formulas, including VLOOKUP, XLOOKUP, dynamic arrays, and logical functions that streamline complex calculations and automate routine tasks. This practical approach focuses on real-world applications, showing professionals how to reduce hours of manual work into efficient, automated processes that minimize errors and maximize productivity. Beyond powerful formulas, participants will gain hands-on experience with pivot tables, the cornerstone of modern business reporting. The course demonstrates how to create dynamic reports, implement advanced calculations, and design intuitive data visualizations that enhance decisionmaking capabilities. Professionals will walk away with immediately applicable skills that strengthen their analytical capabilities, improve reporting efficiency, and add significant value to their organization. This course bridges the gap between basic Excel knowledge and the advanced techniques needed in today's data-driven business environment, making it an essential investment for accounting professionals seeking to enhance their technical capabilities and career growth.

New to AI? Start here. This beginner-friendly course explains how generative AI works, what terms like "LLM" and "agentic AI" really mean, and how CPAs can safely put these tools to use. You'll leave with a solid understanding of AI fundamentals and how they apply to accounting, tax, and finance.

Improve your planning, review, audit and other engagement skills. Master techniques for effective communication with clients and colleagues in part three of this five-course series. Discover the secrets to planning and efficiently completing engagements, explore methods for assuming higher levels of responsibility, and develop your ability to assess risk and materiality. Learn how AI can be used on engagements to enhance efficiency and quality. Designed to offer audit staff members extensive training in crucial procedural, evaluative and supervisory areas. 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.