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.

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.

More Dates

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

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.

Excel is the default program for many financial professionals-and highly effective-if used correctly. It can be used for everything from simple tabular analysis to creating in-depth aggregate pivot tables. This course will give participants the necessary tools to turn data into meaningful information and will examine cutting edge ways to store, retrieve, report, and analyze data using Excel and plugins. It will provide recommendations on how to more efficiently use Excel and potential traps to avoid. Participants are encouraged to bring their technology devices to follow along with the interactive discussions, technology demonstrations, sample spreadsheets, and demo tools. Financial professionals will walk away from this course with valuable tools and insights into understanding, managing, and utilizing data in an organized and meaningful manner inside their organizations.

In today's digital landscape, data loss can be catastrophic - whether it's your personal photos, critical business documents, or enterprise-level databases. Organizations and individuals face numerous threats including ransomware, hardware failures, natural disasters, and human error. The implementation of a robust backup strategy isn't just an IT consideration - it's a fundamental business requirement. Understanding the various backup methodologies, from local storage to cloud solutions, and knowing how to implement them effectively can mean the difference between quick recovery and devastating loss. Don't wait until disaster strikes to realize the importance of a comprehensive backup strategy. This course provides you with practical, actionable knowledge about modern backup solutions, from personal cloud storage to enterprise-level systems. You'll learn how to evaluate and implement various backup technologies, create effective retention policies, and ensure your data remains secure and accessible when you need it most. Join us to develop the skills needed to protect your digital assets and ensure business continuity in an increasingly complex technological landscape.

The traditional process of chasing receipts and manually reconciling credit card statements is being replaced by intelligent systems that capture data at the point of purchase. This course provides a practical look at the current landscape of expense and bill management technology, featuring tools like Dext, Bill.com, and the automated features within leading small business accounting solutions. We will examine how these platforms use mobile apps, email integration, and OCR technology to stream transactions directly into the books, significantly reducing manual data entry while maintaining the necessary oversight and approval workflows that businesses require. Participants will explore the practical benefits of modernizing their "cash-out" processes, from deploying virtual cards with built-in spending limits to utilizing AI-driven anomaly detection to flag duplicate or unusual activity. We will discuss the features and benefits of various online payment systems and why a business might choose one solution over another based on their specific integration needs. By the end of this session, you will understand how to build an efficient, transparent expense management system that provides real-time visibility into company spending while strengthening internal controls.

More Dates

QuickBooks Desktop, Online, and Enterprise Solutions remain three of the most widely used accounting applications in use today. However, each platform continues to experience major changes across several fronts. Feature sets, licensing requirements, and price changes all impact users at unprecedented levels. Further, competition continues to emerge in the small business accounting battleground, adding confusion to the options existing QuickBooks and QuickBooks Online users may have. In this session, you will learn about many of the changes impacting QuickBooks Desktop, Online, and Enterprise users, and you can manage these changes for the benefit of your company or your clients.

Are you tired of struggling to create compelling charts and graphs? Join our session and transform your data into stunning visualizations that captivate and inform your audience. This isn't just another seminar on basic charts; it's a comprehensive guide to mastering advanced, interactive, and dynamic visualizations in Excel. In this session, you'll learn how to create visually appealing charts that are not only informative but also engaging. Discover the secrets to making your data come alive with interactive elements that ensure your audience understands and retains the information you present. Whether you're looking to enhance your communication skills or impress your stakeholders, this seminar is a must-attend. Don't miss out on the opportunity to take your Excel skills to the next level. Sign up now and start creating visualizations that make a lasting impact!

Some estimates indicate that business professionals spend almost half their time in Excel applying formats. If you want better formatting results in less time, participate in this session to learn the best practices for formatting your Excel spreadsheets. In this session, you will learn best practices for applying formats in your workbooks. More specifically, you will learn about features such as Custom Format Codes, Templates, Styles, the Accounting Format, Precision as Displayed, date formats, and many others, all of which can save you substantial time when working in Excel.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. 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. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

As working remotely becomes the new normal, virtual meetings are now the norm. How do you put your best foot forward and make sure your space and tech are up to the challenge. We will show you some of our favorite tech to make you stand out. From the best cameras and microphones for outstanding quality to using a green screen and making custom backgrounds, there are many ways to look and sound your best.

Free to OSCPA Members: Get the latest updates on trends and issues impacting you and the accounting profession. Join your colleagues at the OSCPA 2026 Professional Issues Update.

Collaboration is a key to productivity and success. But remote work can make collaboration more challenging, including collaborating on spreadsheets. Fortunately, tools such as portals with check-in/check-out capabilities, version control, comment tracking, and co-authoring can enable online spreadsheet collaboration. Further, Excel's Inquire tool can facilitate spreadsheet collaboration in offline environments. Don't let remote work hamper your spreadsheet collaboration needs! Participate in this session to learn how to collaborate on spreadsheets effectively from anywhere using tools you already own or license.

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

We will take a deep look into setting up a QuickBooks Online Accountant (QBOA) account. We will examine all the various firm, staff, and client configuration options for getting this to work inside your organization. This class is going to specifically focus on the configuration options for this application. QBO is a big application and it is important to ensure you've properly set up your firm and client files. Additionally, we will look at the various import/export functionality for getting your data into or out of QBO. Participants will leave this class supercharged with the knowledge of how to set up their QBO accounts correctly for long-term success.

More Dates