CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel - Advanced Formatting to Improve Your Spreadsheets
-
Online
2.00 Credits
In the "Excel - Formatting Spreadsheets for Beginners" class, you learned basic formatting of a spreadsheet. In this class, we take you to the next level by teaching you how to customize many of the formatting options. Learn to customize cell styles and how to use these styles in other workbooks. Most Excel users know how to select number formats but this class shows how to leverage the Custom Number Formatting option to create special formatting options. Many of the formatting options are applied manually, cell-by-cell or by range. This can be tedious if there is a condition by which you want to apply a format. You will learn to use Conditional Formatting to format based upon a criteria. Have you ever finalized a spreadsheet, only to accidently make changes over the top? This action is something that is very easy to do. This class demonstrates various options to prevent this from happening and will look at various security options within Excel. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Case Study Ethics for Today's Accountant
-
Online
1.00 Credits
This program analyzes and applies the AICPA Code of Professional Conduct and other sources of ethical guidance to actual scenario-based case studies, providing accounting professionals with ethical standards to integrate into their practices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Tee Off at BigShots Golf!
-
Springfield
0.00 Credits
You don’t have to be a pro to have fun playing golf at BigShots! Join your fellow MOCPA chapter members—of all skill levels—for a night of friendly competition and relaxed networking over a round of virtual golf. Food and beverages will be provided, so don’t miss out. Take a swing at the fun!Thursday, May 2 | 5-7 p.m.BigShots Golf1930 E. Kearney St.Springfield, MO 65803Space is limited, so don't delay!$35 Member and Non-members (includes food and drinks)If you have any questions, please contact Dana Seipp at dseipp@mocpa.org or (800) 264-7966, ext. 123.
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.
The Next Step Series: Avoiding Ulcers in the "New Abnormal World"
-
Online
1.00 Credits
In today's "new abnormal" COVID environment, waves of changes are pushing at each of us from all sides and forcing us to adapt. What works? What fails? How can we adapt faster? This facilitated discussion covers the topic from both the human capital viewpoint and from the operational side of the Manager's desk. We will build the skills and processes needed to manage others through change - either co-workers or clients.
Forgotten Managerial Accounting Tools for CPAs
-
Online
2.00 Credits
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Cases in Corporate Ethics: Discuss Real Life Conflicts
-
Online
4.00 Credits
If you have ever had someone just read you the rules in an ethics class, you know there is a better way. Cases in Corporate Ethics reviews 10 real life cases and puts you in the position of someone in the middle of it all. You'll learn about conflicts that corporate financial professionals often encounter, you'll gain skills for dealing with a boss who is behaving badly and find out where to go for help. Once you have studied ethics using real world cases, you'll never want to do it any other way. 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 Advanced Audits of 401(k) Plans: Best Practices and Current Developments
-
Online
8.00 Credits
Looking to improve the quality of your 401(k) benefit plan audits? This is the course for you. Based on recent data from the U.S. Department of Labor and peer reviews on employee benefit plan audits, we know auditors need to up their game to meet stakeholder demands and provide the best possible audit services. In this advanced course, we will discuss the audit and reporting requirements in accordance with SAS 136 and other recently issued SASs. We will also discuss laws and regulations (such as ERISA) that are unique to employee benefit plans and provide practical guidance on their application. Course topics will focus on the most common compliance issues identified in 401(k) audits by the Department of Labor and peer reviews, as well as recommended corrections. Auditors will identify best practices for auditing areas such as payroll and compensation, participant loans, hardship distributions, investments, and plan mergers and acquisitions.
Walter Haig's GAAP for SMEs, Tax & Cash Frameworks Update
-
Online
8.00 Credits
This course provides an update of the recent changes that have occurred in the financial reporting frameworks commonly used by small and medium-sized entities (SMEs). Troublesome areas in these financial reporting frameworks as identified in peer reviews and litigation will be highlighted. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Yellow Book: Staying Compliant with Government Auditing Standards
-
Online
8.00 Credits
The guidance you need. Understand the concepts and standards of generally accepted government auditing standards (GAGAS) so that you can perform Yellow Book audits. Gain an excellent baseline of information for understanding the Yellow Book, with guidance found in the Government Auditing Standards. With guidance related to independence and peer review, increase your knowledge of the requirements and application guidance related to the following: Ethics Independence Standards for financial audits Attestation engagements Performance audits
About the TIGTA: Who Watches the IRS?
-
Online
2.00 Credits
This course will provide an overview of the work and impact of the Treasury Inspector General for Tax Administration (TIGTA) on the US tax system, regulatory ethics, and accounting profession. TIGTA is an independent organization that provides oversight of the Internal Revenue Service (IRS) and conducts audits, investigations, and inspections and evaluations to promote integrity, economy, and efficiency in the administration of the nation's tax system. The course will explore the role of TIGTA in improving the efficiency and effectiveness of the IRS, identifying opportunities to improve the administration of tax laws, and upholding ethical standards in the accounting profession. 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 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 webinar 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.
Surgent's Lessons Learned from Successful Companies
-
Online
2.00 Credits
Why do some companies fail while others grow and succeed for generations? Common perceptions often attribute organizational success to great leadership, timing, or unique ideas. Although these traits certainly play a role in helping companies grow, research shows that corporate success often hinges on whether a company is value driven. Such companies have core ideologies that drive almost every major decision. In this course, we look at empirical data on why some companies succeed while others fail. By looking at companies that were created prior to 1950 (e.g., Disney, Marriott, or 3M), we can understand why certain organizations have been able to grow and achieve exceptional success through many different eras in the American economy. The lessons learned from these visionary companies can be broadly applied to organizations of all sizes, including accounting and financial service firms.
CFO Series: Tactics to Reduce Risk: 3rd Strategy to Help ROI
-
Online
2.00 Credits
What do investors want? They actively pursue three key strategies: 1) improve profit (most over used strategy) 2) reduce investment (an under used strategy) 3) reduce risk (a much-neglected strategy) In this third of three sessions, see 3) above, we will explore strategies to reduce risk. When risks are exhibited on the income statement - it is too late. Risk is silent and insidious. We must plan, as we have seen what happens when risk becomes real and reduces net income. We will discuss proven techniques to help your organization plan for risk before the next miscalculation. Be prepared!
Creating a Culture of Trust in a Fraud-filled World
-
Online
2.00 Credits
This session will highlight recent cases of ethical failures and fraud and will highlight concepts of trust, personal accountability, responding to fraud, and the conduct expected of CPAs outlined in the Code of Professional Conduct. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Revision to Government Auditing Standards Impact
-
Online
4.00 Credits
This course will provide an update of Government Auditing Standards as a result of the GAO's issuance of the 2024 Revision to Government Auditing Standards. The course will focus on the Revisions impact on financial statement audits. The course will also focus on the impact of Quality Management Standards as well as clarify as to when the concept of reporting key audit matters might apply for financial audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
CFO Series - May 2024 Webinar Bundle
-
Online
8.00 Credits
This series includes four 2-hour consecutive Friday sessions, airing live beginning May 3, for a total of 8 CPE. Once registered for this bundle, log in instructions will be emailed to you separately for each individual course._ You receive significant savings when purchasing these webinars as a bundle._ The CFO Series provides a convenient, one-stop way for senior level financial managers and executives, CFOs and those who aspire to be CFOs, to attend multiple webinars of CPE with a single decision. The CFO Series features high-quality presentations and an interactive, executive level colleague-to-colleague approach with case studies, group discussions, and team exercises.
Audit 105: The Audit Risk Model - Foundational Principles
-
Online
2.00 Credits
The Audit Risk Model - Understanding Foundational Principles is a critical foundational course. Financial statement auditors are engaged to provide reasonable assurance that financial statements are not materially misstated, whether due to fraud or error. Professional standards require auditors to obtain sufficient and appropriate evidence to support that opinion. It is critical for effective and efficient auditors to have a clear understanding of all the important elements and concepts related to properly identifying, evaluating, and deciding how to respond to risk in a financial statement audit. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors, while it is also appropriate for anyone who has the need to understand the foundational principles of the audit risk model. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Using ChatGPT with Excel
-
Online
2.00 Credits
In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Everyday Ethics at Work: Don't be the Next News Story!
-
Online
2.00 Credits
When asked, most people would say they are an ethical person. So why is it that every month there are reports of ethical breaches at major companies? The concept of ethics is easy to understand, easy to talk about, but incredibly hard to implement on a consistent basis. In this course, we will discuss current ethical issues, and walk-through a nine-step ethical decision-making model. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.