CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's 2023 Accessing And Managing Data In Excel
-
Online
4.00 Credits
For many business professionals, accessing and managing data in Excel is one of the biggest stumbling blocks when creating reports and analyses. Common practices include far too many manual processes and formulas, including never-ending manual processes needed to update your data and related reports. Make plans now to join us in this session to learn best practices for accessing and managing data using Excel. In this session, you will learn how you can use Power Query and other Excel tools to quickly access and manipulate your data and generate reports in record time! This is a “must-see” session for any business professional working with Excel!
Coaching the Next Generation of CPAs
-
Online
2.00 Credits
Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
Prioritizing Mental Health in the Post-COVID Workplace
-
Online
1.20 Credits
Over the last few years, mental health has become more of a mainstream issue. In fact, statistics indicate that approximately one in four adults experience a mental health condition. Therefore, it is more important now than ever for organizations to make mental health and wellness a priority, given all the rapid changes leading to higher levels of stress and uncertainty in the post-COVID workplace. The goal of this course is to outline the signs of mental health challenges in the workplace, such as changes in behavior, mood, or performance, while providing practical strategies for HR Professionals and Business Leaders to build and implement accommodations for a mentally healthy work environment.
Public Speaking and Confident Communication in Business
-
Online
1.00 Credits
No matter what role you play in your professional life, being able to command an audience--whether of one or of thousands--is an important skill. Public speaking, no matter how you slice it, is a practice that is worthy of attention. This workshop teaches you approachable strategies to improve your public speaking and presentation skills, recognizing that everyone comes with different comfort levels and experiences. There is no one-size-fits-all speaking style, and trying to force yourself into a specific presentation persona can be more harmful than helpful. Learn actionable tips to help you be more confident next time you need to take the proverbial (or literal) stage.
GASB 96 -SBITA, GASB 94 P3, and GASB 87 Leases (Year 2)
-
Online
2.00 Credits
This is a 2 hour webcast that will focus on the similarities between all three of these GASB accounting standards that deal with contractual arrangements such as leases, Subscription-Based Information Technology Arrangements (SBITA) and P3s. Compare and contrast these standards as you prepare for implementation this year of GASB 94 and GASB 96, and review the implementation efforts of Leases in Year 2.
Ethics in the Real World - Living Values for Today
-
Online
2.00 Credits
Business ethics is not something “nice to do” but can mean the difference between success, failure and survival in today’s competitive environment. Being trustworthy, having consistent business principles and an outstanding reputation may provide an organization’s only long-term competitive advantage. This updated webcast outlines eight steps to create an ethical business environment including specific ways for financial professionals to make better ethical decisions moving forward.
2024 Tax Practice Ethical Challenges and Circular 230
-
Online
2.00 Credits
This presentation will provide a detailed analysis of the Circular 230 rules for conduct of a tax practice, with a review of the political, legislative and regulatory rules impacting every accounting and tax professional. Best practices and guidance provided by the AICPA’s Code of Professional Conduct will be discussed. **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.
Project Management: Making Ideas a Reality
-
Online
2.00 Credits
A project doesn't just happen, it takes a dedicated person to help a team create something from nothing. The best project managers incorporate the art of people management and science of execution to guide an initiative from an idea to reality. Not everyone can hire a project manager, so the great news is these skills and techniques can be learned. This class will show how a project manager breaks down a concept and applies techniques needed to effectively lead a team through the visioning, scoping, testing and rolling out of an initiative. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Gamed: Why Performance Targets and Incentives Fail and How to Fix Them
-
Online
4.00 Credits
Target setting can drive breathtaking positive results, the moonlandings, the eradication of smallpox or the repair of the ozone layer, for example. They can also have a dark side that can put executives in jail, bring global businesses to their knees and even cause wholesale loss of life. Using practical examples and case studies, this course walks you through the steps you need to follow to design robust, effective and credible targets for your organization.
ACPEN Signature 2024: Accounting & Auditing Update
-
Online
8.00 Credits
The Accounting and Auditing Update is designed to provide its participants with a comprehensive, in-depth review of what’s happening at the FASB, AICPA, and other professional bodies who may impact accounting and auditing this year, including FASB Statements and Interpretations, Statements on Auditing Standards, Statements of Position, Statements on Standards for Accounting and Review Services, Ethics Interpretations, exposure drafts and projects in progress, with emphasis on the practical application and impact on practitioners in small to medium sized firms and members in industry. Special attention this year will be focused on the emerging use of data analytics related to audit evidence.
Understanding the Form 990 and its Preparation Prerequisites
-
Online
2.00 Credits
Introductory Session of Borenstein's Form 990 Foundational Series: This "initiation and introduction to" the Form 990's mechanics and importance will prevent you from drowning in the Form 990's force-field! More than 80% of the Form's inputs and relevant definitions are NOT found in the statutes and Regulations that apply to the exempt sector, a reality that can be overwhelming for both novices and more advanced preparers. This session provides an easy-to-digest synopsis of the entirety of the Form's key definitions as well as the mechanics that preparers need embrace from the moment they first approach preparing a 990. Packed with practical tips and perspectives on data gathering, this class is a "must" gateway for beginning (and even more experienced) preparers to learn "how to befriend Form 990 preparation." This webinar will vault preparers past all the initially confounding problems of the Form 990, providing baseline info on the critical nuances the form uses. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 PowerPoint: Tips & Tricks for Today's Accountant
-
Online
2.00 Credits
PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course’s author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We will also explain how PowerPoint can be used for purposes other than delivering presentations.
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Governmental Accounting 101
-
Online
2.00 Credits
Governmental Accounting 101, is a 2 hour webcast that takes the participant of a whirlwind tour of governmental accounting basics, focusing on wetting the participant’s appetite for more. This session will be the first of a series of webcasts, with each subsequent webcast delving deeper and deeper into the governmental accounting basics.
2024 Fiduciary Accounting: Fundamentals & Rules
-
Online
2.00 Credits
This course will dive into the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus.
Ethics: Environmental, Social and Governance for Accountants
-
Online
2.00 Credits
The course provides a concise overview of Environmental, Social and Governance (ESG) reporting -- an emerging system of non-financial record-keeping and governance. Around the world, organizations of all sizes and kinds are under increasing pressure from regulators, consumers, employees, and other stakeholders to provide a fuller and more integrated picture of the way in which entities operate, invest, and create value. This includes taking into account how their operations impact financial, manufactured, intellectual, human, social, relationship, and natural capital. Participants will walk away with an increased situational awareness of ESG reporting, and an ESG starter strategy. This can be used immediately to position themselves for ESG success in an era of growing expectations for conscious capitalism, ethical investing, and moral leadership. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Communication Skills for CPAs
-
Online
2.00 Credits
Have you ever met an accountant who exhibits solid technical prowess but possesses lackluster communication skills? It is not unusual to meet a savvy accountant who is a technical expert, but could enhance the delivery of written and spoken words. This course is designed to help CPAs improve their written and verbal communication skills. Participants will learn how to tailor communication to their audience, with particular emphasis on techniques for crafting a message that effectively conveys technical information in an engaging manner. The course’s author will share personal success tips gleaned from more than two decades of experience communicating myriad topics to a variety of audiences.
Accounting Fraud & Embezzlement: Case Studies from the Trenches
-
Online
2.00 Credits
Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving the theft of public money and the circumstances that allowed the fraud to occur. We will be looking at a variety of case studies to illustrate these points.
2024 MOCPA Eastern Region Awards Celebration - St. Louis
-
St. Louis
0.00 Credits
MOCPA EASTERN REGION AWARDS CELEBRATION Join us for an evening dedicated to honoring those who have achieved major milestones and earned prestigious awards during the past year. Honorees will include recent CPA exam passers, 35-year and 50-year members, MOCPA scholarship winners, MOCPA Impact Award winners, MOCPA Campaign Contributors, and 100% MOCPA Membership Organizations.Organizations are invited to reserve a table for this event so that colleagues, family, and friends can share in this extraordinary evening highlighting their honorees.Wednesday, October 30River City Casino & Hotel777 River City Casino Blvd.St. Louis, MO 63125AGENDA:4:30-5:15 p.m. ..........Reception5:15-6:00 p.m. ..........Dinner6:00-7:30 p.m. ..........Program Cancellation/Refund/Transfer Policy: We accept transfers and cancellations by phone. You may transfer your registration to another person with no penalty, at any time. Cancellations made within five working days prior to the event will not be refunded.Photo Disclaimer: Photographs may be taken at this event and used in MOCPA marketing.Payment Information: Please note: If you did not reserve an entire table of 8, other guests will be seated at your table.