Professional Development and Event Catalog
This will generate a PDF of the current filtered catalog
Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups
Friday, Mar. 5 9:00am - 11:00am
Online
2.00 Credits
Member Price: $89
See more dates
Practical hands-on Excel learning exercises taught by a highly engaging expert in the field You'll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP, it has its drawbacks. This session will address these drawbacks while offering alternatives. You'll walk through the VLOOKUP and IFERROR functions, and explore the following topics: Improving the use of VLOOKUP with VALUE/TEXT Improving the use of VLOOKUP with MATCH. Moving beyond VLOOKUP with INDEX Trapping errors with IFERROR Moving beyond basic Excel functions Grasping the limitations and possible enhancements for the VLOOKUP feature, along with methods to handle errors can elevate your proficiency in Excel. You'll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets, encompassing: Combining functions to enhance flexibility Utilizing functions for atypical data categories Perfecting sophisticated lookup functions *Session 5 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 6: List Comparisons and Indenting] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-6--list-comparisons-and-indenting) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Hot Topics Accounting Update - 2026
Friday, Mar. 5 9:00am - 11:00am
Online
2.00 Credits
Member Price: $89
See more dates
Many accountants desire to have a quick overview of only the most current issues in accounting and financial reporting. This course will provide an executive summary of the most important changes in U.S. GAAP. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
IRS Penalties and Abatements
Friday, Mar. 5 9:00am - 11:00am
Online
2.00 Credits
Member Price: $89
See more dates
Penalty abatement is a technique that tax practitioners can utilize to help their clients reduce penalties and interest they owe to the IRS if the taxpayer can prove "reasonable cause". This informative and insightful webinar will provide you with some insider tips, practical steps and effective strategies to help your client manage IRS tax penalties and interest. Learn about various types of penalties that you may face, and the various forms and procedures used for requesting penalty and interest abatement, including First Time and Reasonable Cause abatement. Plus, learn about the procedure to follow when requesting refund of paid penalties. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Taxation of Business Entities
Friday, Mar. 5 9:00am - 11:17am
Online
2.50 Credits
Member Price: $99
See more dates
This course will introduce you the different types of business entities and the tax implications of contributions, distributions and earnings, among other topics. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com
More Dates
Implementing and Maintaining an Internal Control System
Friday, Mar. 5 9:00am - 5:00pm
Online
8.00 Credits
Member Price: $239
See more dates
Many organizations are successful as they create a system of internal controls, however some fail to properly implement the measures that are established. Moreover, entities regularly neglect the important process of testing, monitoring, and updating control procedures, which weakens the entire internal control structure. This session provides an overview of control creation methods and discusses ways to successfully implement policies and procedures. Additionally, it includes an array of control maintenance checklists that participants can take and adapt to their organization as they work to improve policies and procedures. Finally, it provides an understanding of the need for dynamic, fluid controls that adapt to changes in business tools and methods. Participants that take this course will have a strengthened ability to implement and maintain an internal control system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Money Laundering Awareness for Accountants
Friday, Mar. 5 9:30am - 11:30am
Online
2.00 Credits
Member Price: $89
See more dates
The course provides general information on how to identify money laundering activities during the conduct of normal tax audits. Discover key resources and tools available for effective detection and deterrence. Explore the impact of money laundering on ethical decision-making, and how examiners and auditors can assist criminal investigators in countering money laundering. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Audit Blind Spots in Modern Cloud: Risks Audits Keep Missing
Friday, Mar. 5 10:00am - 11:00am
Online
1.00 Credits
Member Price: $39
See more dates
As organizations rapidly adopt cloud platforms, traditional audit approaches often fail to identify the risks that matter most. This webinar explores common audit blind spots in modern cloud environments, including misconfigurations, identity sprawl, excessive permissions, and ineffective continuous monitoring. Attendees will learn why checklist-based audits fall short in dynamic cloud environments and how leveraging Cloud Security Posture Management (CSPM) and risk-based audit techniques can significantly improve assurance. Practical examples will illustrate how auditors and risk professionals can enhance visibility, prioritize findings, and provide stronger assurance to leadership.
More Dates
K2’s Getting Started with Artificial Intelligence
Friday, Mar. 5 10:00am - 11:48am
Online
2.00 Credits
Member Price: $89
See more dates
Are you intrigued by the buzz around Artificial Intelligence (AI) but unsure how to dive in? You're not alone! Many professionals find AI tools like Gemini, ChatGPT, and Copilot to be a mystery. But don't worry, we're here to help you unlock the potential of these powerful tools! Join K2's "Getting Started With Artificial Intelligence" session and discover how to harness the power of today's AI tools to boost your efficiency and productivity. This session will guide you through accessing and using multiple popular AI tools, making it easier than ever to integrate AI into your daily workflow. If you're new to AI, this is the perfect opportunity to get started and transform the way you work!
More Dates
Preparation, Compilation and Review Engagements
Friday, Mar. 5 10:00am - 11:51am
Online
2.00 Credits
Member Price: $89
See more dates
This course is an introduction to preparation, compilation, & review engagements. During this course, we will compare and contrast these different engagements by reviewing the procedures that should be performed, different reports, as well as the level of assurance specific to each type of engagement.
More Dates
Introduction to Governmental Budgeting
Friday, Mar. 5 10:00am - 12:00pm
Online
2.00 Credits
Member Price: $89
See more dates
The introduction to governmental budgeting course is an overview of the typical timeline and process a government uses when creating their annual budget. Topics covered include the basics of governmental budgeting, establishing priorities for the budget, the common steps and timeline of the budget process, what, when and how we should be monitoring the budget throughout the year, and how long-term budgets fit in with the annual budget process. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Engaging and Managing Young Professionals
Friday, Mar. 5 10:00am - 12:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Younger professionals comprise a significant part of the accounting and finance workforce. Whether you are an owner of a small accounting practice or a manager in a multinational accounting firm, it is important to understand the characteristics and expectations of this large segment of the workforce. Research reveals that many of the common stereotypes surrounding young professionals are unfounded and counterproductive. This course provides an understanding of who young professionals are in comparison to their predecessors, the Gen-Xers and baby boomers. Equally important, the presentation will look at common myths regarding young professionals and why understanding this class of employees provides opportunities for your organization to grow and succeed.
More Dates
Surgent's Making Sense of Essential OBBBA Provisions
Friday, Mar. 5 10:00am - 12:00pm
Online
2.00 Credits
Member Price: $119
See more dates
When clients ask questions about the impact of new tax legislation embodied in OBBBA, it is important that accounting and finance practitioners can reply with accurate and relevant planning strategies. This program prepares accounting and finance practitioners with the knowledge and insights to help their clients apply the new law to their advantage. This program is an introduction and review of some of these critical changes and their impact on individual and business taxpayers. By taking this program, accounting and finance practitioners will have a broader, deeper understanding of many of the OBBBA changes that impact their clients. This course is a two-hour review and analysis of what we consider some of the most important changes from the OBBBA impacting clients and perhaps their businesses.
More Dates
How SAS Nos. 134-145 Improve Risk-Based Audits
Friday, Mar. 5 10:00am - 2:00pm
Online
4.00 Credits
Member Price: $149
See more dates
Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in SAS Nos. 134-145. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
SSARS Essentials: Best Practices for Review, Compilation, and Preparation Engagements
Friday, Mar. 5 10:00am - 2:00pm
Online
4.00 Credits
Member Price: $149
See more dates
This course explores provisions of Statements on Standards for Accounting and Review Engagements (SSARS) that govern review, compilation, and preparation engagements. Participants will recall foundational concepts, examine recent updates, understand practitioner responsibilities, and apply best practices for engagement performance. Attendees will learn how to efficiently perform SSARS engagements while complying with professional requirements.
More Dates
Spring Tax Update with Steve Dilley
Friday, Mar. 5 10:00am - 6:00pm
Online
8.00 Credits
Member Price: $239
See more dates
This program provides an update on the latest tax developments, rules and regulations impacting individual and business taxpayers, including a review and integration of the most recent legislation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
The Single Audit from Beginning to End Update
Friday, Mar. 5 10:00am - 6:00pm
Online
8.00 Credits
Member Price: $250
See more dates
This course is an updated overview of the single audit of state and local governments and not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits.
More Dates
Take Command of Your Time
Friday, Mar. 5 10:30am - 12:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Understand Yours and Other People's Styles: Meet Them in the Middle and Be More Effective in Generating Great Results!
Friday, Mar. 5 11:00am - 12:00pm
Online
1.00 Credits
Member Price: $39
See more dates
Understanding your own and the people style of others whom you are dealing with which can establish rapport more easily, help you become more persuasive, and avoid miscommunication with the possibility of rubbing someone the wrong way. In our session, you will gain insights into your people style, ways to improve communication connectivity and how to understand your team's functionality (or more likely dysfunctionality).
More Dates
New PCAOB Quality Control Standard Overview
Friday, Mar. 5 11:00am - 12:46pm
Online
2.00 Credits
Member Price: $89
See more dates
Due to advances in technology, use of outside resources, and more, PCAOB released a new integrated, risk-based standard focused on accountability and continuous improvement for all PCAOB-registered firms. This course will provide an overview of the significant elements and foundational principles of this new standard.
More Dates
Mastering the Excel Lookup Functions
Friday, Mar. 5 11:00am - 1:00pm
Online
2.00 Credits
Member Price: $89
See more dates
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.