CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Dashboard and Report Design Principles Using Excel
-
Online
4.00 Credits
Transform your data presentation skills with our comprehensive course on creating impactful dashboards and reports using Excel. This workshop is tailored for professionals who: Regularly produce or update dashboards and reports Struggle with confusing or overly complex reporting tools Seek to streamline varied reporting styles across their organization Aim to establish a consistent, replicable "house style" for reporting Want to impress stakeholders with clear, user-friendly data presentations Through a combination of theory and hands-on practice, you'll learn the fundamental principles that make reports and dashboards easy to understand. We'll distill these concepts into a set of practical rules and guide you through their application in Excel.
Federal Tax Update for Individuals with Doug Van Der Aa
-
Online
4.00 Credits
This program will address recent legislation, rulings and developments affecting individual 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 Securing Your Data: Practical Tools For Protecting Information
-
Online
4.00 Credits
Security is not optional, and yesterday’s security techniques do not minimize today’s security threats. Therefore, now is the time for you to tune up what you know about protecting sensitive data. This program will teach you the latest tools and techniques for securing your data, including encryption, virus protection, safe communications, electronic signatures, secure authentication, and more. You will also learn how to implement a practical, five-step approach to securing your PC and the questions you should ask your staff to ensure server-based information remains protected. Security failures, such as a breach of client or customer data, are costly – they can even drive your company out of business. So, what security tools do you need, and how should you use them to secure your sensitive data and systems? Can you afford to risk attempting to manage today’s threats using yesterday’s techniques? Participate in this program to learn how to identify viable and practical solutions to mitigating today’s security threats.
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.
Construction Contractors: Non-Revenue and Non-Lease Accounting Considerations
-
Online
4.00 Credits
The construction industry stands out in its need to adhere to a diverse range of accounting standards. This course explores the essential knowledge required for success in construction accounting, as well as the key issues influencing this field. Discover the implications of recent developments for yourself, your business, or your clients. In addition, we will examine the relationship between contractors and sureties. Given the construction industry's significant and ever-expanding share of the economy, staying up to date with the latest accounting updates in this sector is critical. Note: This course does not address FASB ASC 606, Revenue from Contracts with Customers, or FASB ASC 842, Leases. The AICPA offers a companion course which focuses on revenue and lease accounting for construction contractors. See Contract Accounting and Lease Accounting and Their Impact on Construction Contractors (CCREVL).
Preparing and Reviewing Workpapers - Essential Tips for Avoiding Deficient Audit and Other Attest Engagements
-
Online
8.00 Credits
Workpapers are the primary support for findings, conclusions and opinions on any audit or other attest engagement. This course will provide the essential tips and techniques for ensuring workpaper documentation is of a high quality, yet efficient, nature.
ACPEN Signature 2025- Small Business: Hot Tax Issues Today
-
Online
8.00 Credits
2025 will be a big year for small businesses no matter what decisions are made: Will tax cuts/changes enacted as part of the Tax Cut and Jobs Act expire at year end as scheduled or will they be extended? If extended, which provisions are included and how long is the extension? Will overtime pay be taxed differently in the future causing additional changes to small business payroll systems? Will employers be relieved of reporting tip income and what exactly is tip income? What additional requirements may be imposed on employers to deter employment of illegal/undocumented workers? What requirements and penalties are already in place and what’s coming? What will happen to ongoing judicial efforts of small businesses to fight self-employment taxes imposed by the IRS on LLC Members and active limited partners? How is the IRS reacting to changes? **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 Advanced Excel
-
Online
8.00 Credits
If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
This course equips practitioners with the knowledge to help clients navigate complex tax and financial challenges. Covering a range of difficult situations—such as divorce, bankruptcy, and other personal and business matters—this course provides key tax insights and strategic planning considerations. Participants will gain practical strategies to support clients in making informed decisions while understanding the tax implications of these situations.
Surgent's Audit Skills Training Level 1: Developing Critical Skills for Success in Public Accounting
-
Online
8.00 Credits
Level 1 focuses on the basic skill sets that new staff need to quickly master in order to "hit the ground running," while not overwhelming them with too much information all at once. This course explains the basics of what new auditors are generally expected to know and do. This course will focus on "why" certain procedures are performed, as well as "how" to perform typical procedures expected of new staff. This course is critical in establishing the groundwork for the expectation that all staff should critically analyze and understand the underlying purpose of procedures, as well as how to effectively and efficiently complete assigned tasks. IMPORTANT NOTE: This course takes place over two consecutive days. Registration for both days is required.
Walter Haig's Personal Financial Health Checkup
-
Online
8.00 Credits
This course has significantly changed for the better the lives of a significant number of practitioners and their clients. Participants will learn a step-by-step process for performing an annual personal financial health checkup for themselves, family members, employers, and, if in the practice of accounting, their clients. This course is loaded with practical aids to enable CPAs to help individuals get a "great" financial health checkup result! This course will enable practitioners to add a huge value to their tax preparation services. 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 Ten Must Know Features In Excel
-
Online
2.00 Credits
Most business professionals have used Excel for years, often without the benefit of any formal training. Thus, they don't know about key features in the application and, therefore, don't use them. Of course, this leads to inefficiencies and errors. Isn't it time to stop this madness? This session is for you if you're ready to become more efficient and effective with Excel! You will learn ten critical features that can help you get more work done in less time and improve your accuracy. We encourage you to make plans to join us for this session to learn the best ways of working with Excel!
1040 Tax Prep Automation with AI Tools
-
Online
2.00 Credits
There has never been a greater opportunity to leverage technology tools to automate various aspects of 1040 tax preparation. This course will provide specific examples of how you can use AI (artificial intelligence) based tools to complement your core 1040 tax prep software. You will learn how to leverage AI to automate the collection and organization of client source documents, enhance the engagement management process and add value to your 1040 service through AI enhanced 1040 advisory services. This course will separate the hype from reality about AI and how it can be used in 1040 tax preparation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Economic Update Series
-
Online
1.00 Credits
As the status of the economy weighs heavy on most everyone's minds, MOCPA is hosting a complimentary online Economic Update Series for members, featuring Chris Kuehl, Ph.D. author of the Flagship Report and president of Armada Corporate Intelligence. He will provide a big picture understanding of the current environment and identify important elements to watch for that might impact your business or clients in the short- and near-term.
Awful Ethical Dilemmas - Bringing it to Life, featuring J. Michael Inzina and Don Minges
-
Online
1.00 Credits
Professional Codes of Conduct make Ethics seem easy and clear cut. However, this is not so in real life. This session discusses five cases where the ethics is not so clear cut. What should be considered? We will explain how you can be more diligent and maintain awareness of ethical issues to become more effective and enhance the reputation of the profession.
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.
A Guide to Sampling - Part 2
-
Online
2.00 Credits
Building on Part 1, this course will review the application of sampling in financial statement audits with a focus on sampling for tests of controls. We'll also review the requirements for sampling in Single Audits with a focus on tests of controls and tests of compliance.
Best Non-Google Search Tools for Accountants
-
Online
2.00 Credits
The course explains why you need more than Google to search the Internet and highlights a rich constellation of alternative search engine applications. The session also explains how to set up your own customized online research management platform, and discusses dynamic search strategies (two-step, vertical and lateral searching) that can be used to gain an extra edge when using any search engine. Participants will walk away with scores of new knowledge sources and streams that will complement their use of Google and improve their online research power. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial Acumen for Today's HR Leader
-
Online
2.00 Credits
Financial Acumen for the HR Professional is a part of the series "The HR Professional's Guide to Evolving Business Strategy, Finance and Development." This course identifies how HR Professionals can increase their financial understanding to participate more effectively with management as well as understand the financial results and implications for the business.
K2's Advanced Topics In Power BI
-
Online
2.00 Credits
So, you've been using Power BI to create fundamental reports and dashboards, and now you're ready for even more advanced reporting & if so, this session is for you. In this session, you will learn how to extend your Power BI environment by incorporating tools such as Data Analysis Expressions, Key Performance Indicators, Hierarchies, and Apps and Content Packs, among others. By taking advantage of the tools and techniques covered in this session, you will be able to move beyond simple reports and dashboards in Power BI and truly leverage the power of this awesome reporting tool.