CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
ACPEN: K2’s Mastering Advanced Excel Functions
-
Online
4.00 Credits
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. Presented by: Thomas StephensType: Live Webcast Replay
Controls to Secure the Growing Digital Footprint
-
Online
4.00 Credits
The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2026/27 Not-for-Profit GAAP Update
-
Online
1.00 Credits
Stay current on the latest accounting developments affecting not-for-profit organizations with this timely GAAP update. This course reviews recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline. The course also introduces the International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025. Participants will gain perspective on the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. This course is designed to help practitioners, financial leaders, and auditors of not-for-profit organizations understand both current GAAP requirements and emerging global developments shaping the future of nonprofit financial reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: The Controller Function - Inventory Part 2 - Valuation, Inventory Methods and Inventory Fraud
-
Online
1.50 Credits
This course is one of the courses dedicated to our Controllership Series. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we continue our discussion on inventory from segment one. This specific segment focuses on areas of inventory valuation, the types of physical inventory methods, and inventory fraud. These areas are critical for the controller to have a strong comprehension of and also participate in the development of policies and procedures. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Planning in an Uncertain World
-
Online
2.00 Credits
We all make predictions in our personal and professional lives. We base our decisions to marry, buy a house, launch a new product or hire staff on expectations about the future. In the past few years, research into improving predictions has advanced. We will look at this research and current best practices in forecasting to help us prepare better budgets and projections. Presented by: John LevyType: Live Webcast Replay
ACPEN: What to Do When Clients Attempt to Fudge the Numbers on Their Tax Returns
-
Online
2.00 Credits
To believe or disbelieve ... that is the question often faced by CPAs. For tax practitioners, this question is especially nettlesome as it pertains to the proper reporting of income and the correct reporting of deductions for business gifts, business meals, auto expenses, etc., on clients' income tax returns. Presented by: Albert SpaldingType: Live Webcast Replay
Microsoft Copilot Deep Dive Hands-on Bootcamp for CPAs
-
Online
2.00 Credits
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 course will teach you 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 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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: 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 terri.storer@acpen.com Presented by: Doug Van Der AaType: Live Webcast Replay
ACPEN: Partnership Essentials: Review & Update
-
Online
4.00 Credits
This course examines the critical issues and special opportunities facing partnerships and their partners, as well as the relationship between limited liability companies and partnerships, with a focus on reporting tax basis capital accounts. *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 terri.storer@acpen.com Presented by: Doug Van Der AaType: Live Webcast Replay
Ethics, Tax Practice & Understanding Circular 230
-
Online
2.00 Credits
This course provides a comprehensive overview of the ethical standards and principles governing tax practice, as outlined in IRS Circular 230. Participants will explore the importance of ethics in the tax preparation industry, review IRS rules, and examine common ethical violations and their associated penalties. The course emphasizes procedures that promote compliance with ethical guidelines, equipping tax practitioners to navigate complex ethical dilemmas confidently. Real-world scenarios will be used to demonstrate the application of ethical principles in tax preparation and representation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Leverage PowerBI.com to Create Data Analysis for Others
-
Online
2.00 Credits
Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports, and dashboards, and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports, and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease, and add a valuable credential to your portfolio. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: HR Investigations – Episode 3 – Gathering-Analyzing-Reporting
-
Online
1.00 Credits
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for gathering and analyzing evidence and reporting the investigation results. Attendees will end the session with takeaways to immediately implement in future HR investigations. Three of three Episodes in the series. Presented by: Daniel PorterType: Live Webcast Replay
ACPEN: Revenue Recognition Topic 606 Contract with Customers - Identify the Contract Part 2
-
Online
1.20 Credits
This course is a continuation of discussion over Step One in the revenue recognition process of Identify the Contract. Specifically, this session delves further into the considerations surrounding contract modifications, change orders, unpriced change orders, cancelations, non-finalized changes and accounting treatment when a contract does not exist. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: The Controller Function - Elevating the Role
-
Online
1.50 Credits
This is the beginning of a series that will cover major aspects of the Controllership function. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc., the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. A Controller is an individual who has responsibility for all accounting-related activities including high-level accounting, managerial counting, and finance activities within a company. The duties of a Controller include assisting with the preparation of the operating budgets, overseeing financial reporting, and performing essential duties relating to payroll. However, in today’s evolving world, the Controller function can provide much more in-depth value to their organizations. This series is dedicated to exploring the traditional Controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. In this first course we focus on the typical Controller function and begin to identify ways to elevate the function. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Leaders Eat Last. Why? The Characteristics of Great Leaders
-
Online
2.00 Credits
If a great leader is someone we are willing to sacrifice for – what do those leaders do that makes us want to do more? Many of us work in dysfunctional organizations that want followers, but have no leaders that lead. What makes a leader effective? True leaders sacrifice, they are trustworthy and they empathize. We discuss the steps to take so you can become a true leader: including, integrity, humility, communication, self-control and self-awareness. With diligence, you can become a better leader and we will discuss how. Presented by: Don MingesType: Live Webcast Replay
ACPEN: Budget Mastery: Walkthroughs and Real World Calculations Towards Tying Budgets To Value
-
Online
2.00 Credits
This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial modeling. From the beginning of the accounting process – ‘the chart of accounts’ to the end of the process – ‘the valuation of the company’, the budgeting cycle via a live case model to learn best practices common to successful companies. This course stands on its own but is part two of a four part budget mastery series. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: K2’s Collaboration – Best Platforms And Practices
-
Online
2.00 Credits
Collaboration remains one of today's hottest topics. Technology has fueled today's collaboration options, and work-from anywhere environments virtually demand collaboration platforms. In this session, you will learn today's best tools and practices to facilitate more effective collaboration in your organization. In this session, you will learn about today's mainstream collaboration platforms & Microsoft 365, Google Workspace, and Zoho - and how these options are similar and differ. You will also learn about other collaboration options, including Slack, Zoom, and Webex, and you can incorporate these tools into your collaboration environments. Further, you will learn about some of the best practices and procedures that must be in place to optimize your collaborative environments and experiences. Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Estimates, Contingencies and Going Concern
-
Online
2.00 Credits
This course covers a broad range of topics involving uncertainty in accounting and auditing. It addresses accounting standards related to going concern, contingencies, guarantees, and credit losses, along with auditing standards applicable to auditing accounting estimates and evaluating going concern. The course provides a practical overview of how these areas are addressed under current standards and how they impact financial reporting and audit procedures. Jeff presents the material in an engaging manner to reinforce key concepts and maintain focus. Presented by: Jeff SailorType: Live Webcast Replay
ACPEN: Rethinking Your Customers to Maximize Profitability: Identifying the Right Clients
-
Online
2.00 Credits
Some customers are unprofitable from an economic or time perspective – but many organizations do not differentiate or know the difference. When an organization has a unique, well-differentiated service or product, understanding value from the customer’s perspective becomes a crucial factor in profitable pricing. We must take the time to fully understand what our customers value - from the customer’s point of view. What is value? Why do brand, value, and customer focus matter? Developing a deep understanding of our customers is vital. Our most important customer might be someone we have not yet recognized. Understanding both external clients and internal stakeholders - including the evolving role of the finance department, is critical to long-term success. Using humorous video clips, memes, and vetted research, your understanding of customer bases will improve. Presented by: Bob MimsType: Live Webcast Replay
Profiles in Fraud
-
Online
2.00 Credits
Nobody is immune to fraud risk. This course opens with stories of real fraud perpetrators then examines the similarities between the fraud perpetrators, discovering that they all have many common traits. It finishes with techniques accountants can use to deter these behaviors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.