CPE + Events Catalog

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.

ChatGPT has grown its user base to over 800 million active users per week. As a leader in the generative market, it is a tool that every CPA should have a basic understanding of how to use it and apply it in business. This course will provide a comprehensive review and demonstration of how to put ChatGPT to work for you and your clients. It is designed as a "hands-on" course that facilitates your following along with the presenter while applying the features of ChatGPT on your computer. Practice files will be provided so that you don't have to expose your confidential data.

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.

Develop your soft skills in training courses that benefit both the person attending and their organization. This course is applicable for various accounting departments (i.e. audit, tax, consulting, and accounting services) but because these are universal leadership concepts, they are equally applicable to other professional business leaders. AHI soft skills training will help improve efficiency, make managers more effective with others, and increase the organization's bottom line. Also, as these courses often include other industries besides accounting, there is an opportunity to work and network with leadership professionals from other industries. 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.

Google Gemini has emerged as a top leader in the generative AI competition. Due to the extraordinary size of the Google user base, it a tool that every CPA should have a basic understanding of how to use it and apply it in business. This course will provide a comprehensive review and demonstration of how to put Google Gemini AI to work for you and your clients. It is designed as a "hands-on" course that facilitates you following along with the presenter to apply the features of Gemini on your computer. Practice files will be provided so that you don't have to expose your confidential data.

Microsoft 365 is one of the most widely used business applications software suites used in business today. Microsoft Copilot is the generative AI application that is integrated directly into the Microsoft 365 ecosystem. If your firm or business is a Microsoft 365 user, this is a course that teach how to use Copilot AI to optimize the use of your Microsoft 365 apps. This course will provide a comprehensive review and demonstration of how to put Microsoft Copilot AI to work for you and your clients. It is designed as a "hands-on" course that facilitates you following along with the presenter to apply the features of Microsoft Copilot on your computer. Practice files will be provided so that you don't have to expose your confidential data.

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. We encourage in-person attendance to maximize engagement, interaction, and networking. If you're unable to attend onsite, a live webcast option is available.

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.

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.

What can we do when the world changes constantly This four-topic presentation spotlights various methods to enhance decision-making in a dynamic, ever-changing environment, focusing on proven and new risk reduction techniques. We also take an in-depth look at the practices that work and the ones that do not. The focus is straightforward: understanding risk and getting the most return from risk reduction with verified approaches to increase profitability, since our mission is to increase the value of the organization. This day of the CFO Series will focus on these four topics: Acute Uncertainty Will Never Go Away: Can We Prevent Our Plans from Failing? Decision Making in a Non-linear World: What They Did Not Teach in Management Accounting Advanced Financial Analysis: Choosing the Right Tools in a World Full of Randomness Diversification: A Risky or Risk-Averse Strategy? OSCPA has partnered with the Idaho Society of CPAs for this event.

We all want to make the organization more profitable, but do we do it the best way? Many simply hack away at costs and then repeat the same unwieldy process every eighteen months. Do our internal and external customers truly understand our numbers? There is a better way to communicate financial information, so they DO understand and take the proper actions. Building an effective team always results in improved performance, talent retention and reduces costs. We also discuss the ethics of creativity - is creativity good or bad or a mixed bag? We will discuss how, and specifically what, you can do to rein in costs and get the most from what the organization already has and remains ethical. These four sessions will help you become better at controlling the right costs and becoming more successful. This day of the CFO Series will focus on these four topics: Improving Profitability the Right Way: How to Cut the Right Costs Building High-Performing Teams: Cohesive Teams Get Results Do Creative Accountants Belong in Prison? Storytelling Your Financials for Impact: Narrative Beats Numbers OSCPA has partnered with the Idaho Society of CPAs for this event.

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.

The newest evolution of AI technology is Agentic AI. This technology enables you to deploy AI agents to take action on your behalf and execute tasks. Agentic AI is the key enabler to using AI technology to automate your workflows. Learning how to take advantage of AI agents provides a substantial competitive advantage. This course will teach you the fundamentals of agentic AI and how you can put them to work in your firm or business.

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