CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Build Better Budgets: Fundamental Techniques
-
Online
2.00 Credits
This session provides insights for enhancing the preparation and utilization of budgets. Seasoned accountants will benefit from a refreshed awareness of popular techniques. Budding financial professionals will obtain novel insight regarding fundamental budgeting concepts. All participants will develop an appreciation for the holistic nature of budgeting as an integral tool for planning and control.
ChatGPT and Advanced Financial Analysis for Accountants
-
Online
2.00 Credits
This course provides a concise overview of how to utilize ChatGPT for advanced financial analysis in accounting. The session reveals how to combine sophisticated evaluation and interpretation of financial data with the cutting-edge AI capabilities of ChatGPT. Aimed at enhancing the understanding of an entity's performance, predicting future financial health, and aiding in informed business decision-making, this course goes beyond basic financial statement analysis to include a wide array of techniques and tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Schedule K-1: What is it & What Do I Do with It?
-
Online
2.00 Credits
This seminar provides a comprehensive overview of Schedule K-1, which taxpayers may receive from pass-through entities such as Partnerships, Subchapter S Corporations, or Estates/Trusts. The course will cover the most common characteristics of Schedule K-1, including how to report the information on Form 1040. Attendees will also learn about the Qualified Business Income (QBI) Deduction and its reporting criteria. Additionally, relevant topics such as basis and loss limitations, material participation, and integration with the QBI deduction will be addressed, along with a discussion of proposed changes to Schedules K-2 and K-3. *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
Surgent's Excel Tables and Conditional Summing
-
Online
2.00 Credits
In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.
Surgent's The CMA's Guide to Project Management
-
Online
2.00 Credits
A significant number of projects fail to achieve their initial goals and/or are not completed within budget and their original timetable. As a team member, a CMA has a unique skill set and experiences to assist in project management. In addition to their analytical training and knowledge of budgets and controls, they typically have ongoing contacts with other professionals from a variety of backgrounds. Familiar analytical tools/techniques can be applied to managing projects. This brief program is designed to aid both experienced and less experienced participants in increasing their knowledge of, and comfort with, the steps and skills needed for success.
Achieve Competency in Three Basic Tool Categories - Master the Fundamentals
-
Online
4.00 Credits
Financial skills needed in many situations are constantly changing. It is prudent to routinely look into your toolbox to restock or revise your tool set. In this course we will examine three tool categories that form the foundation for many analytical processes.
Federal Tax Update for Business with Doug Van Der Aa
-
Online
4.00 Credits
This program will address recent legislation, rulings and developments affecting business taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **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.
K2's Next Generation Excel Reporting
-
Online
8.00 Credits
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 quickly and easily format your spreadsheets 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.
Nonprofit Accounting and Financial Reporting Explained
-
Online
8.00 Credits
This course provides a high-level overview of the most important issues facing nonprofit entities and their auditors. The focus of this course is on explaining the theory behind major issues and trends, enabling professionals to understand the most important aspects of relevant professional and regulatory standards related to reliable financial reporting for nonprofit entities.
Analyzing Financial Statements
-
Online
2.00 Credits
This course provides tools and insights into financial statement analysis - both quantitative and qualitative. We'll look not only at the three main financial statements but also dive into the MD&A and footnotes. We'll also discuss the affect of industry nuances on comparability of different analysis tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Leading in Exponential Times
-
Online
1.00 Credits
Navigating through change Against the backdrop of change and uncertainty, there's an immediate need for accountants and finance professionals to evolve and accelerate. Technology, demographics, regulations and standards are driving changes in the way CPA firms work. What can you do to better navigate a world of volatility, uncertainty, complexity and ambiguity (VUCA)? How can you influence others to join you? This webcast will help you make sense of the dizzying array of challenges around culture, technology, generations and the speed of change.
Resolving Ethical Dilemmas-You Make the Call
-
Online
1.50 Credits
By now, we should all understand the ethical obligations we have as CPAs. So, theoretically, if we just all agree to remain ethical, we should not have CPA ethical violations. But, of course, our professional ethics committees still have plenty of cases to investigate. This session will examine several ethical frameworks, including the AICPA’s Code of Professional Conduct’s and the GAO Yellow Book’s Threats and Safeguards approach to remaining ethical and resolving ethical dilemmas. The session will present several ethical case studies that illustrate the complexities of and challenges to staying ethical. By exercising our “ethical muscles”, we should be better positioned to effectively deal with the ethical dilemmas that we will inevitably encounter.
The Controllership Series - The Financial Close Process
-
Online
1.50 Credits
A common challenge for the controller role is in closing the month-end and period-end books in preparation to issue financial statements. This duty requires precision, timing and efficiency. In today’s digital world, many organizations have access to financial accounting software that will assist with the steps in the financial close. However, even with this aid it is critical the accountant understand the various steps for the close process and how they inter-relate to other accounting processes. This course gives you an insight into the inter-relationships between many processes that impact the financial close. The closing process has traditionally been a slow one with many companies taking two weeks to close its subsidiary’s books and another two to three weeks to roll up and consolidated the results. With the introduction of technology much has been done to help accelerate that process with integrated enterprise resource planning systems and general ledger and consolidate software. Within this segment we will discuss the elements of the financial close and also important concepts to assist the controller in accelerating their close timeline. This includes addressing all functional areas of the close including payroll, invoicing, payables, inventory, cash, and the general ledger. We will also discuss important concepts of ensuring your financial close is accurate by discussing bank reconciliations, overhead allocations, bad debt reserves, unpaid wages and accruals for vacation time, account reconciliations, deprecation and overall financial statement review. Note: This course does not address utilizing technology in the financial close. Its focus is to understand the varied procedures involved in the financial close whether or not technology is utilized.
K2's Office Scripts - The New Macros
-
Online
2.00 Credits
Office Scripts is a new feature that allows you to automate tasks in Excel and other Office applications. Unlike VBA, a legacy language that runs only on Windows, Office Scripts can run on any platform and device that supports Office on the web. Further, Office Scripts has a modern and intuitive interface that lets you easily create, edit, and share your scripts. Office Scripts are stored in the Cloud, and they work with Office Online apps and integrate with Power Automate for process automation. Save time and improve productivity using Office Scripts in Excel and other Office applications.
Peeking Behind the Curtain: Exploring IRS Audit Technique Guides
-
Online
2.00 Credits
Have you ever considered a tax audit from the perspective of an IRS examiner? This session explains how you can use IRS Audit Technique Guides (ATGs) to enhance tax compliance. You will obtain a glimpse of the audit process from the viewpoint of an IRS agent as we explore insights that the IRS provides to its own examiners.
Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information.
Monthly Federal Tax Updates - April 2026
-
Online
2.00 Credits
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Planning for Small Business Success
-
Online
4.00 Credits
Strategic Planning for SMEs
2025 Accounting & Auditing Update for Small Businesses
-
Online
4.00 Credits
For many small businesses, the standards issued by the FASB may have little to no effect as they impact topics that do not reflect the type of transactions that these entities most frequently experience. This class will focus on the Accounting Standards Updates (ASUs) that are most likely to impact small businesses with a focus on ASUs initiated by the Private Company Council (PCC). We'll then look at alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs for entities who don't necessarily need to prepare GAAP financial statements but want to use accrual accounting. Finally, we will transition to audit standards that small business auditors will need to implement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
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.