CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Mastering Rapport Skills for Fun and Profit
-
Online
4.00 Credits
You only have one chance to make a good first impression. In the fast paced world we live in, being able to create immediate rapport and a sense of trust with people is more important than ever. Fortunately, this is an easily learnable skill that can serve you in both business and in life. People who can master the one minute relationship end up making more money, being better liked, and enjoying their clients more.
Building a Better Budget in a Time of Uncertainty
-
Online
4.00 Credits
Most financial leaders would agree that budgeting is easy when business and the economy are stable. When revenues and expenses are expected to remain the same, the process becomes merely an exercise in carrying over what was done before to the current year. However, what happens when we are not sure about how the market will react to our product? What happens when the competitive landscape changes? In this course, we will discuss budgeting techniques and considerations when business lacks stability. Through a combination of theory and real-world examples, we will explore how to build flexibility into our budget - so that it can inform and drive decision-making when we don't quite know what is ahead. 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 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.
Hands-On Tax Return Workshop - S Corporations (Form 1120S)
-
Online
8.00 Credits
This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of S-corporation taxation. The cornerstone of this course is the preparation of the Form 1120S using a fairly complex trial balance common to most S corporation income tax returns. **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
S Corporation Preparation, Basis Calculations & Distributions - Form 1120S Schedule K & K-1 Analysis
-
Online
8.00 Credits
This comprehensive training is designed to get the accountant up to speed quickly with S corporation formation and preparation issues as well as a complete understanding of calculating a shareholder’s stock and debt basis. The cornerstone of this course is the in-depth line-by-line analysis of the Form 1120S Schedule K and K-1 and how these items affect the shareholder’s Federal individual income tax return. **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
Mastering Partnership Basis: Inside and Outside Basis
-
Online
2.00 Credits
This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Thrive Amidst the Chaos - 3 Steps to Increase Your Energy and Learn to Dance in the Rain
-
Online
1.20 Credits
Are you running around with a fire extinguisher permanently strapped to your back? Do everyday crises run your life, both at work and at home? Do you find yourself consistently taking care of everyone else with no time left to take care of you? In this session, we dive into controlling your chaos and managing your energy. Make no mistake, this isn't your father's time management class. It’s an energy management class developed on behalf of and with tired, frustrated, and burned out HR professionals like yourselves! If you find yourself drained and drinking far too much coffee, this is the session for you!
5 Steps to Cultivate a Values-Based Approach to Governance
-
Online
1.20 Credits
Emerging from the pandemic is a workplace culture governed by values. Far from a soft approach, it can drive significant business results. Organizations that embrace an empathetic culture increase performance and decrease turnover, while their customers report a more positive experience. Additionally, being more “person-focused” strongly correlates with more effective ethics and compliance programs. These insights can provide a roadmap for the "new normal" as the world emerges from the crisis. How employees and management move forward from this experience will shape the workplace for decades to come.
Revenue Recognition Topic 606 Contract with Customers - Identify the Contract Part 2
-
Online
1.20 Credits
This course is a continuation of discussion over Step One in the revenue recognition process of Identify the Contract. Specifically, this session delves further into the considerations surrounding contract modifications, change orders, unpriced change orders, cancelations, non-finalized changes and accounting treatment when a contract does not exist.
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.
ProActive Response: Active Shooter Training - Recognize. Respond. Survive.
-
Online
2.00 Credits
ProActive Response Group's Active Shooter Response Training course educates participants in current trends of active shooter incidents, how to recognize early warning signs of violence, appropriate actions to increase chances of survival in an active shooter event, and how to use basic medical equipment to save the lives of victims. *****(Warning: This video contains simulated graphic scenes that some viewers may find disturbing)*****
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
Money Laundering Awareness for Accountants
-
Online
2.00 Credits
The course provides general information on how to identify money laundering activities during the conduct of normal tax audits. Discover key resources and tools available for effective detection and deterrence. Explore the impact of money laundering on ethical decision-making, and how examiners and auditors can assist criminal investigators in countering money laundering. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Role of Internal Control in the Risk-Based Audit
-
Online
4.00 Credits
This program explores the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. We offer practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers, with particular emphasis on internal controls of small-to-medium clients.
Microsoft 365: Save More Time, Make More Money
-
Online
4.00 Credits
Join us for an insightful presentation featuring John Higgins, a renowned technology advisor to the CPA profession, who has assisted many firms with Microsoft 365 deployment. Discover how to leverage the Microsoft 365 suite of applications to unlock new efficiencies and opportunities within your business organization or CPA firm. Don't miss this chance to supercharge your operations with cutting-edge tools! Whether you are working in public practice or business and industry, this event will provide you with a return on investment many times greater than your investment to attend. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Create Paginated Reports with Power BI Report Builder
-
Online
2.00 Credits
Elevate your data reporting skills to new heights with our cutting-edge course, "Create Paginated Reports with Power BI Report Builder." This two-hour, expertly crafted training is designed to transform the way you visualize and present data, leveraging the powerful capabilities of Microsoft Power BI Report Builder. Ideal for professionals who aspire to turn complex data into compelling, print-ready reports, this course is a game-changer in the realm of data visualization and business intelligence. Delve into the world of paginated reporting with a curriculum that balances theoretical knowledge with practical examples and demonstrations. You'll learn how to navigate the Power BI Report Builder interface with ease, design intricate report layouts, and connect to diverse data sources for comprehensive reporting. The course covers a spectrum of skills, from creating eye-catching visualizations to utilizing advanced features like sub-reports and drill-through capabilities. By the end of this session, you'll be adept at publishing and sharing professional-grade, paginated reports that can inform and persuade your audience. Enroll now and take the first step towards mastering the art of paginated reporting with Power BI Report Builder. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Ethics Hour: I Can't Believe This Really Happened - Real World Ethics Stories
-
Online
1.00 Credits
You may have read all sorts of stories in books about how bad people steal and make their coworkers and organizations miserable. Come hear veteran Internal Auditor Rob Berry and veteran CFO John L. Daly discuss situations they have seen in the real world.
Understanding the 4 W's in Budgeting: Who, What, When, and Which?
-
Online
2.00 Credits
This session introduces a structured approach to government budgeting using the four W’s: Who, What, When, and Which. Participants will explore WHO should be involved in the budgeting process, including internal teams and external stakeholders, while learning effective communication strategies to foster collaboration. The session examines WHAT the budgeting process entails, covering essential phases, components, legal requirements, and common challenges. Attendees will also learn WHEN to engage the public through strategic planning, workshops, and outreach initiatives. Finally, the session highlights WHICH departments play key roles, from financial planning to managing capital projects. By the end of this session, participants will have a comprehensive understanding of government budgeting and how to align financial planning with community priorities.
Businesses Receiving Government Assistance
-
Online
2.00 Credits
Many for-profit entities receive government assistance or are required to have financial statement or compliance audits due to law or regulation. This course will discuss the requirements under Generally Accepted Auditing Standards relevant to for-profit entity audits.
Accounting and Disclosure Issues After a Natural Disaster
-
Online
2.00 Credits
The repercussions from a natural disaster can be devastating. Properly accounting and reporting for the impact of those disasters can be confusing. This course will focus on some of the most FAQ related to the proper treatment of accounting for disasters in GAAP basis financial statements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.