CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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.
Microsoft Outlook "Must Know" Email Tips
-
Online
2.00 Credits
If you use Outlook on a daily basis to process your email, chances are pretty good that you are missing out on a lot of opportunities to improve your efficiency in composing, processing and organizing your messages. There are many different features in Outlook that often get overlooked, even though we are working in the app all day, every day. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will review numerous tips and features to improve your productivity in Outlook. You will learn many time-saving, practical ways to improve the quality of your email message. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 2 (Cryptology)
-
Online
1.00 Credits
This is a continuing part of our series on forensic accounting. Within this segment we discuss the concepts that are part of computer forensics known as cryptology. The term cryptography is from Ancient Greek and means “hidden secret”. It is the practice and study of techniques for secure communications in the presence of adversarial behavior. Cryptography is about constructing and analyzing protocols that prevent third parties or the public from reading private messages. Cryptography starts with secrets. Various aspects in information security such as data confidentiality, data integrity, authentication and non-repudiation (where a statement’s author cannot successfully dispute its authorship) are central to modern cryptography.
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.
Introduction to Governmental Budgeting
-
Online
2.00 Credits
The introduction to governmental budgeting course is an overview of the typical timeline and process a government uses when creating their annual budget. Topics covered include, the basics of governmental budgeting, establishing priorities for the budget, the common steps and timeline of the budget process, what, when and how we should be monitoring the budget throughout the year, and how long-term budgets fit in with the annual budget process.
New Client Ethical Challenges: The CPAs Guide
-
Online
2.00 Credits
This course explores the multitude of issues that taking on a new client can bring with it, and then interprets them using three sets of ethical rules. A group of "players" reveal real-life challenges faced by the CPA firm in bringing the new client into compliance, as well as proper financial and tax compliance issues. *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
Devious Ethics: Avoiding Snakes in Suits
-
Online
2.00 Credits
Good people believe everyone else is just like them. They cannot imagine someone could con them or their company and have no guilt or remorse about what they have done. Lack of guilt and empathy are key traits of a psychopath. Most of us envision psychopaths to be cold-blooded serial killers who are locked away in prison. However, experts estimate that 4% of corporate executives are psychopaths who may initially appear to be more normal than the rest of us. Psychopaths may present a convincing picture of virtue while helping themselves to money, status and sex while leaving a path of shattered expectations, empty wallets, and broken hearts in their wake. Learn how to recognize and deal with others who have no conscience.
Retirement Planning: Next Stage for You or Your Client
-
Online
2.00 Credits
If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Coping With the Growth of Online Fraud
-
Online
4.00 Credits
Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
S Corporation Essentials: Review & Update
-
Online
4.00 Credits
This program addresses the critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions. **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.
Audit & Attest Quality Matters that Should be on Your Radar - Avoiding Common Deficiencies in SAS, SSARS and S
-
Online
8.00 Credits
Quality management is important. Every CPA firm that provides audit and other attest services must undergo a third-party quality control review. This session will provide you with the tips on how to avoid common quality control deficiencies in all services that are subject to peer review.
Introduction to Yellow Book: 8-Credit Boot Camp
-
Online
8.00 Credits
This 8-credit boot camp is perfect for accountants in public practice or industry who work with nonprofit and governmental entities. The course starts by exploring key financial reporting differences for these organizations, providing a solid foundation for understanding what makes their accounting and auditing unique. Participants will then dive into the essentials of Yellow Book and Uniform Guidance audits, gaining practical insights to confidently navigate these specialized areas. Whether you're new to the nonprofit and governmental arena or seeking a refresher, this course equips you with the knowledge and tools to succeed.
Creating an Ethical Work Environment
-
Online
2.00 Credits
This session introduces theories on human nature and organizational factors affecting ethical choices. Robbie examines the role of gossip in the workplace, provides tools for ethical decision making and offers concrete actions for creating and sustaining an ethical work environment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excelling at Excel: The Magic of Power Query
-
Online
2.00 Credits
Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before.
Cash Management: Strategies for Long-Term Success
-
Online
2.00 Credits
Many finance departments spend considerable time managing cash, particularly if the organization is highly leveraged or cash rich. Many opportunities exist to reduce your financing costs or increase short-term cash returns if you manage cash effectively. This session will cover a wide variety of day-to-day cash management tools.
Taking a Global View of Professional Ethics
-
Online
2.00 Credits
Just as there is some convergence of U.S. accounting standards (GAAP) with international standards (IFRS), a convergence of U.S. professional ethics standards (AICPA Code of Professional Conduct) with the international Code of Ethics for Professional Accountants is continuing to emerge. This workshop compares these two sets of ethics standards, emphasizing both the theoretical aspects and practical implications for today's accounting professionals.
Common Deficiencies in Employee Benefit Plans
-
Online
2.00 Credits
Discover critical insights from the latest Department of Labor studies on employee benefit plan audits and tackle the pressing issue of audit deficiencies head-on. This course dives deep into the most common errors undermining audit quality and explores the underlying causes of these issues. Through practical strategies, engaging case studies, and regulatory guidance, participants will learn how to close gaps in compliance, enhance audit execution, and protect plan participants and beneficiaries. Whether you're an experienced auditor or new to benefit plan audits, this course will equip you with the tools needed to elevate audit quality and ensure regulatory compliance.
Ethics, Tax Practice & The Cannabis Industry
-
Online
2.00 Credits
This course provides an in-depth discussion of the ethical considerations and compliance requirements when working with taxpayers in the cannabis industry. Attendees will review the implications of Circular 230, preparer due diligence, and the specific challenges posed by conflicting federal and state laws. Federal case law, standards set by Boards of Accountancy, and guidance from the IRS Office of Professional Responsibility will also be covered to help practitioners navigate this complex area with confidence.
Financial Decisions that Led Two Businessmen to Prison
-
Online
2.00 Credits
Two college graduates built impressive careers: One worked in sales, the other in technology and investing. Both of those people made decisions in the course of their business that led to government investigations. They had to hire attorneys, go through judicial processes, face charges, and plead guilty. Each of those people are on their way to prison. Learn from the lessons they offer. We interview both financial professionals, and they tell us more about how their decisions influenced the consequences that followed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Form 1120S - Preparation and Analysis
-
Online
2.00 Credits
This course is designed for financial professionals looking to understand Form 1120S. It covers the essential aspects of S corporation taxation, including the preparation of Form 1120S, determining taxable income, and accurately reporting and allocating income, deductions, and credits. Participants will also learn how to calculate shareholder basis and understand the strategic advantages and limitations of an S corporation.