CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's Ethics and Technology
-
Online
4.00 Credits
With the explosion of technology over the past thirty years, one fair question is, “what are the ethical considerations and impacts related to this technology?” Of course, practical technology issues such as data privacy and security undoubtedly carry ethical K2’s Ethics And Technology considerations. However, technology also affects the ethics associated with work-life balance, the digital divide, training needs, copyrights, and fraud, to name a few. This course will teach you about “technoethics” and its implications for individuals and organizations. To that end, you will explore many current and emerging issues associated with ethics and technology, such as copyrights, cybercrimes, privacy versus security, and geo-tracking technologies. Given the profound implications of ethics and technology, this could be the most impactful session you will ever attend.
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 easy to overlook. 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. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.
Selected Ethics Topics - 2024 - 2025
-
Online
2.00 Credits
This course will help you to stay current on recent changes to the AICPA Code of Professional Conduct, as well as keep you abreast of emerging trends in ethics standards and regulatory initiatives and their potential impact on your practice. We will also explore frequent practitioner ethics compliance challenges, including competence, due professional care, audit quality, and independence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Balancing Employee and Employer Rights
-
Online
1.00 Credits
Leaders have the right to exercise customary management functions. Employees have the right to be kept free from discrimination. Neither employer rights nor employee rights are absolute. The courts are equally protective of the rights of employees and employers. A courtroom is the wrong place for anyone to find this out. This course provides practical knowledge on how to effectively balancing these two sets of rights, such that employees and leaders stay out of court. Employers avoid lawsuits, rather than win lawsuits.
Surgent's Weekly Expert Hour
-
Online
1.00 Credits
As financial and tax professionals well know, information overload is a constant struggle we face because things change quickly, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to present a weekly series designed to eliminate the clutter and get you what you need to stay up-to-date and perform for your clients. Mike and his co-presenters will dispense news on current events impacting taxes, finance, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners' personal finances and those of their clients. Every financial professional will benefit from this series. This is a cost-effective way for accountants to fulfill their compulsory continuing education because this weekly series will include almost 40 one-hour presentations. Sign up today - your clients and your bottom line will thank you.
Data Analytics: Practical Insights for Today's Accountant
-
Online
2.00 Credits
This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today's popular and software tools and examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements.
Public Procurement Basics: Protecting the People's Money
-
Online
2.00 Credits
Procurement is a critical component of successful government operations. While there are challenges in public procurement, there are a number of guidelines and requirements that will help lead you to success. This course will offer guidance on how governments can meet complicated procurement needs and develop best practices that protect public and Federal funds.
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.
Ethics: How to Give and Receive Criticism the Right Way
-
Online
2.00 Credits
How well do you accept criticism? How might it enrich your business - and you - if you did a better job of it? This distinctive webinar will show you why it is in your best interest to accept criticism with gratitude. It's even better to welcome criticism. It's also a good idea to learn how to give criticism the right way. A related topic is the art of giving and receiving apologies, and we'll do a deep dive into this area as well. You'll leave with clear guidelines for how to criticize others, accept criticism from them, give meaningful apologies, and accept apologies with grace and ethical intelligence. The result will be a stronger CPA practice and a better you. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Communicating Financial Results to Stakeholders: A Guide for Client Advisory Services
-
Online
2.00 Credits
One of the most difficult things for any Client Advisory Services (CAS) professional to learn is how to communicate financial information to non-financial people. To be successful, it's crucial to master this skill, as we frequently explain accounting jargon to those unfamiliar with the field. In this course, we will explore how to properly communicate with stakeholders, including investors, clients, boards of directors, and even other departments. We will explore biases that people have when viewing financial information and even how to make sure we keep our message on point. If you are looking to move up in the financial services world, this course is a must for you.
Surgent's Guide to Partner Capital Account Reporting
-
Online
2.00 Credits
Tax practitioners are responsible for presenting partner capital accounts on the tax basis. But what does this mean and how have rules changed in recent years regarding partner capital accounts? This course covers exactly that. For tax practitioners preparing partnership 1065 forms, this course explains these complex rules in practical and understandable terms.This course qualifies for IRS credit.
Complete Guide to Analyze Data with Excel PivotTables
-
Online
4.00 Credits
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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 kori.herrera@acpen.com.
2025 Not-for-Profit GAAP Update
-
Online
2.00 Credits
This course will review the Accounting Standard Updates issued by the FASB that impact nonprofit entities. We will also look at the work of the Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's Introducing Artificial Intelligence To Human Resources Pros
-
Online
1.20 Credits
Artificial Intelligence (AI) is the hottest topic in technology circles today. And for good reason! AI can help all business professionals – including HR professionals – work more efficiently and effectively. AI tools such as ChatGPT, Gemini, and Copilot are proving themselves daily as valuable assets. These tools can help you automate research, draft documents, summarize emails, analyze Excel data, and even create PowerPoint presentations for you. If you haven't yet explored what today's AI tools can do, you'll want to participate in this session to become more productive and efficient with this very practical technology.
Preparing to be a Forensic Accountant - Cloud Forensics
-
Online
1.40 Credits
Cloud computing has become a source of cyber-crime. “Cloud forensics is the application of digital forensics in cloud computing as a subset of network forensics to gather and preserve evidence in a way that is suitable for presentation in a court of law.” Cloud forensics is a combination of the varied types of accounting forensics including: • Digital forensics • Network forensics. • Hardware forensics In cloud crime, the cloud is considered the object when the target of the crime is the cloud service provider they are directly affected by the act. It is considered the subject of the crime when the criminal act is committed within the cloud environment. It is considered the tool when it is used to plan or conduct a crime. This course will delve into the many concepts involved in cloud forensics. The course complements other courses in the series of Becoming a Forensic Accountant.
The Controllership Series - The Controllers Role in Financial Forecasting
-
Online
1.50 Credits
Financial forecasting is an important part of any successful business. It enables businesses to plan for the future and anticipate scenarios based on strategy. The controller helps forecast financials by calculating future revenue and income streams. In recent years, corporate finance has undergone many dramatic changes due to the growth of a number of high-tech tools. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years To maximize performance, Controllers must be aware of how the FC position is changing, and how they must adjust to these changes. There are many types and methods of financial forecasting. This course will review the most prevalent forecasts and relative methods being used.
Introduction to Forensic Data Analytics
-
Online
2.00 Credits
In this introductory course, you'll learn the fundamentals of integrating forensic data analytics into your anti-fraud risk management program. We will cover key definitions, use cases, methodologies and some of the leading innovations and techniques driving this ever-evolving field of "finding hidden money."
Data Extraction, Transformation, Validation the Right Data Sources for Analysis
-
Online
2.00 Credits
In this course, we will explore the various types of data - both structured and unstructured - used in conducting fraud risk investigations and proactive monitoring. We will explore the various tools available on the market and techniques to confirm completeness and accuracy of the data before the analysis begins. The course will cover the process for selecting the right data sources to align with the various risks as well as pitfalls to avoid when preparing the data for analysis.
AI Prompt Engineering Masterclass for Accountants
-
Online
2.00 Credits
An advanced guide to prompting techniques that maximize AI efficiency and precision in everyday business research, operational due diligence and accounting tasks. Designed for accountants with no prior AI knowledge, the session explores how simple language and strategic prompting can unlock powerful, layered responses from large language models (LLMs). Participants will learn to overcome the "lazy" defaults of AI, using specific techniques to enhance detail, accuracy, and contextual understanding in their queries. By understanding prompt engineering's role, attendees will discover how to guide AI to provide practical, relevant, and analytical insights suited to complex financial scenarios, without needing extensive technical expertise. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.