CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
What If Your Client Didn't Take Reasonable Compensation
-
Online
1.00 Credits
Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures, and address challenges within the year. 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 Hardest Ethical Dilemma! Why Revenge Will Always Backfire, featuring Bob Mims and Don Minges
-
Online
1.00 Credits
We believe in fairness. When others do wrong, and their action hurts us - the natural reaction is to fight back and seek retribution. Simple human nature and we are all human. We want fairness and want to fight back, but this is one of the toughest ethical dilemmas we all face. What should we do and what we do are not always the same. What if being nice, or specifically being a positive best version of yourself, makes you a more effective leader? Ethical leadership is effective leadership. That’s what Dr. Cohen, noted psychologist, transformational speaker, executive coach, and author of Be The Sun, Not The Salt, has been teaching organizations to do for years. Dr. Cohen’s work is based on scientific studies of human behavior broken down into simple, easily digestible pillars structured around the Heliotropic Effect. In this webcast we will discuss Dr. Cohen’s path to this work, what the Heliotropic Effect is, and how Be The Sun, Not The Salt is the perfect reminder to Do More of That every day. Presented by: Don Minges, Bob MimsType: Live Webcast Replay
ACPEN: Benefits and Best Practices for Telework
-
Online
2.00 Credits
Prior to the COVID-19 pandemic, telework in state and local government was not often embraced as a form of employment. As the pandemic continues, governments are beginning to experience the benefits of remote work and are reevaluating hiring practices to offer more telework and hybrid work options, not simply as a result of an emergency. This course will review various telework options and best practices for success. Presented by: Jaclyn VenoType: Live Webcast Replay
2025-2026 Missouri State-Specific Ethics: A Plain English Guide
-
Online
2.00 Credits
In a world of increasing complexity, the last thing CPAs need to worry about is obtaining or renewing licenses and permits with regulators. Yet, it can be challenging to find and understand the requirements to keep your license or firm humming along so you can focus on client and business work. Compliance-related issues are not fun, but the basics should be understood by all CPAs. To that end, MOCPA is proud to bring you the 2025-2026 update of the popular Missouri State-Specific Regulatory Ethics course that was introduced in 2019. This program has been developed and edited by members of MOCPA's Professional Ethics Committee and has been reviewed by members of the Missouri State Board of Accountancy.
ACPEN: Treasury Circular 230 for EAs and Other Tax Preparers
-
Online
2.20 Credits
Please join us for a discussion on Treasury Circular 230 and other ethical issues faced by enrolled agents and other tax preparers. In addition to covering the practice standards espoused by Treasury Circular 230, there will also be an overview of the applicable provisions in the Internal Revenue Code (IRC) and common law which will affect tax preparers. The discussion will conclude with other ethical issues, such as avoiding conflicts of interest, proper fee structure and maintaining competency. Also included will be case studies illustrating dilemmas faced by tax practitioners. **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. Presented by: Allison McLeodType: Live Webcast Replay
Streamlined Excel Reporting Series Session 3: PivotTable Wrap-Up and Web Data
-
Online
2.00 Credits
This is part 3 of a 4 part series. In this session, we finish our PivotTable discussion by examining various ways to present report values, discussing the subtly of properly sorting a recurring-use PivotTable, and covering numerous filtering options, including slicers. Next, we explore the lookup function, which is designed specifically to retrieve values from PivotTables. The webcast concludes by transitioning to data acquisition techniques, and we'll retrieve data, including stock quotes from perhaps the largest external data source of all, the World Wide Web.
Tax Depreciation: Review and Update
-
Online
2.00 Credits
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: CPAs and Addictions: Finding Hope and Healing
-
Online
2.50 Credits
Substance abuse and mental health issues among CPAs has become of great concern among many state boards and the AICPA in recent years. This program will cover the factors that push CPAs to unhealthy behaviors, the prevalence of drug and alcohol abuse, and possible options in addressing the situation. We will also discuss steps that friends and family can take to support their struggling CPA find hope and healing. Presented by: Allison McLeodType: Live Webcast Replay
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.
ACPEN: The Ethics of How We Treat People; Why it Matters?
-
Online
1.00 Credits
As leaders in the community and in the profession – we are held to a higher standard and to do more to help others. We do not want to conduct business with unethical organizations or work with those who mistreat others. People, whether they are contractors, employees, customers, suppliers, clients or partners, all want to be treated fairly and with respect. Especially in a service business, people are the only true asset. By treating people with respect and honor – you will attract talent and clients. If you believe there is a war for talent, then listen to this discussion that proves that treating others well is THE ethical course of action and what sets us apart. Being fair, honest and supportive – is being ethical and it matters. Presented by: Don Minges, Bob MimsType: Live Webcast Replay
ACPEN: The SECURE Act 2.0 – Planning Opportunities for Employers
-
Online
1.00 Credits
The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that employers need to know about company retirement plans. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones. This course will provide a concise look at these hot 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. Presented by: Allison McLeodType: Live Webcast Replay
Workforce Transformation and Talent Management in 2025
-
Online
1.00 Credits
The accounting profession faces unprecedented workforce challenges that demand a fundamental rethinking of traditional firm structures. This course examines why the century-old pyramid practice model is becoming obsolete and presents the inverted pentagon framework as a sustainable alternative. Based on comprehensive research showing that 52% of firms expect to shrink by 20% or more in the next five years, participants will learn how to restructure their firms to thrive with fewer entry-level staff while expanding specialized expertise. The course explores the "6 Ps of Business Model Transformation" - Precision Hiring, Proactive Retention, Practical Technology Implementation, Pricing Expertise, Practice Area Expansion/Focus, and People Acceleration. Drawing from success stories in manufacturing, healthcare, and technology industries, attendees will discover proven strategies for accelerating staff development, implementing effective knowledge transfer programs, and building sustainable talent pipelines in an era of technological disruption and demographic shifts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Data Science for Accountants – Business Analytics
-
Online
2.00 Credits
In today’s environment of constant volatility and complexity, organizations are inundated with data yet often lack meaningful insights. The finance and accounting function has a unique opportunity to harness Big Data and the full spectrum of analytics—descriptive, diagnostic, predictive, and prescriptive—to enhance decision-making. However, collecting and reporting data is not the same as analyzing it to extract actionable intelligence. Compared to fields like marketing, sales, and supply chain management, finance has been slower to adopt advanced analytics. This course explores how CFOs and finance leaders can close that gap and transform their function into a true driver of strategic insight. Presented by: Gary CokinsType: Live Webcast Replay
ACPEN: Sleepless Nights: In AI It's All About "The Prompt", in Careers It's All About "The Relationships"
-
Online
2.00 Credits
This course focuses on the individual taking ownership for their career. It provides tools and methods to assist and guide the individual to develop the collateral necessary in navigating their career. It provides a Personal Marketing Plan that can be customized to fit the career objectives and goals of the individual. It also focuses on character self-awareness, crucial for long-tern career success. Presented by: Mario FloresType: Live Webcast Replay
ACPEN: HR Investigations – Episode 2 – Interview Techniques
-
Online
2.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 interviewing to gather accurate information, such as creating and asking open ended questions, effective listening, and understanding verbal and non-verbal communication. Attendees will end the session with takeaways to immediately implement in future HR investigations. Two of three Episodes in the series. Presented by: Daniel PorterType: Live Webcast Replay
Navigating IRS Authorizations: Form 2848 & Form 8821
-
Online
2.00 Credits
Providing a practical overview of the IRS Power of Attorney, Form 2848, and IRS Tax Information Authorization, Form 8821. Participants will explore the differences between these forms, understand when each is required, and how to comply with IRS requirements for representing clients and accessing their tax information. The course will cover practical issues, ethical considerations, and best practices for managing client authorizations through the IRS Centralized Authorization File (CAF) system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Excel Essentials for Today’s Accountant: How To Become an Expert in One Day
-
Online
4.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 and dive into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. Presented by: Dr. Chris HarperType: Live Webcast Replay
ACPEN: K2’s Excel Tips, Tricks, And Techniques For Accountants
-
Online
8.00 Credits
Excel is the go-to tool for accountants when it comes to analyzing and reporting financial data. However, many professionals still rely on time-consuming and error-prone methods for everyday tasks. Whether you're a beginner or an experienced user, our course is designed to help you master Excel and transform your workflows. In this course, you'll discover a trove of tips, tricks, and techniques to boost your productivity and streamline your tasks. Say goodbye to mundane formatting and hello to customized Excel solutions that enhance accuracy and efficiency. You'll also learn how to build powerful formulas, link Excel data from various sources, and simplify report generation and printing processes. Our expert K2 instructors will guide you through the program with practical, real-world examples, ensuring you grasp the key concepts and apply them effectively. With over twenty-five years of experience in delivering top-notch spreadsheet training to accounting and financial professionals, we guarantee that the insights and guidance you receive will be both relevant and invaluable. Join us and elevate your Excel skills to new levels. Don't miss out on this opportunity to work smarter, not harder! Presented by: Thomas StephensType: Live Webcast Replay
How to Build a Custom AI Chatbot and GPT in Plain English
-
Online
2.00 Credits
Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Building and Maintaining an Engaged Remote Team
-
Online
1.00 Credits
Building a remote team is no longer just a perk- it's a strategic advantage for CPA firms that want to attract top talent, improve retention, and scale sustainably. This session will explore how to intentionally design a remote work environment that balances flexibility with accountability. Attendees will learn how to structure communication, meetings, and leadership touchpoints so remote staff stay engaged, aligned, and productive. This session will provide practical systems CPAs can implement immediately. Presented by: Eman Abdur-RahmanType: Live Webcast Replay