CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Excel: Mastering PivotTables
-
Online
2.00 Credits
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.
Fundamentals of Form 1040 -- Business
-
Online
4.00 Credits
This course builds on the foundational knowledge from Part 1, Fundamentals of the 1040 - Core Concepts. It expands into business income taxation and additional reporting requirements. Participants will learn how to accurately report self-employment income, income from pass-through entities on Form 1040. This course covers Schedule C, Schedule E, and essential forms such as Form 7203 and Form 7217 to ensure accurate tax preparation for clients with business activities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Mining Your Firm Client Database for Revenue
-
Online
1.00 Credits
Your client database is more than a record of past engagements-it's a goldmine of untapped opportunity. In this practical and forward-thinking session, accounting professionals will learn how to strategically analyze and segment their existing client data to uncover new service opportunities, deepen relationships, and drive sustainable revenue growth. From identifying cross-selling potential to leveraging automation tools for proactive outreach, this webinar will equip firm leaders and client managers with actionable strategies to turn dormant data into dynamic business development. Whether you're a solo practitioner or part of a larger firm, you'll walk away with a roadmap for transforming your client list into a revenue-generating engine. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
An Ethical Approach to Mental Health Issues at Work
-
Online
2.00 Credits
In the past talking about mental issues in the workplace was taboo. Not anymore!!! So many of us suffer with mental health issues at some point in our lives. Poor mental health impacts, from a work perspective, productivity, absenteeism, retention and more. On a personal level it often causes personal distress and hopelessness. The Society of Human Resource Management (SHRM) is addressing mental illness as a critical factor for the wellbeing of organizations. Additionally, the EEOC is cracking down on mental health discrimination. It is a very important topic for any functional business! This ethics-based webinar will bring awareness to this issue and offer suggestions on managing mental health issues in ethical, compassionate and healthy ways. It will offer suggestions on managing mental health issues for leaders, managers and all staff to create and environment of safety and belonging. This webinar will also address the topic of suicide talking about warning signs and resources. 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.
ACPEN: There is NO Such Thing as ‘Business Ethics’ featuring John Levy and Don Minges
-
Online
1.00 Credits
What happens when businesspeople think they can lie and cheat at work, as long as it makes a profit? Some believe that business is like war, and there are no rules! Do you really want to behave differently in business than in your personal life? Can, or should, ethics be ‘switched on’ or off? Presented by: Don Minges, John LevyType: Live Webcast Replay
ACPEN: Revenue Recognition - Topic 606 Overview
-
Online
1.80 Credits
This session is the beginning in a series on the new revenue recognition standard. The standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry. This course is designed to provide an overview of the technical guidance and outline the five steps involved in the revenue recognition model. We also explore some concepts to consider within each step and then evaluate some challenges that specific industry's may have when complying with the standard. Future courses will further delve into each step and provide example and scenarios that should be considered to properly apply the step. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: From Numbers to Narrative: Effectively Presenting Your Budget and Reporting
-
Online
2.00 Credits
Perhaps the most important element of the budget process is its communication. If management does not understand the budget – there is an issue. Knowing the right ways to communicate at all levels is essential to stakeholders laying an ownership claim to successful budgets. This session reveals several key guidelines in successful budget presentations and will identify key problems in how people often communicate financial plans. Presenting your budget and reporting is the final part of a four part series, but can easily stand on its own course that is intended to be fun, enjoyable and educational. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: Travel/Entertainment Expenses and Taxes: What You Need to Know for Compliance
-
Online
2.00 Credits
This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. An OBBBA of 2025 update, cases and rulings will also be addressed. *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 terri.storer@acpen.com Presented by: Steven DilleyType: Live Webcast Replay
ACPEN: K2’s Excel Tips – Today’s Best Features
-
Online
2.00 Credits
Wow! So many new Excel features and so little time! Microsoft continues to add tremendous functionality to Excel - the business professional's tool of choice. Yet most Excel users have not discovered these new tools and remain mired in yesterday's practices for working in Excel. In this session, you will learn how to use many of Excel's latest features to work more efficiently and effectively with your spreadsheets. Participate in this session to learn about recently released features such as PIVOTBY, GROUPBY, Office Scripts, integration with Copilot, new ways to share and collaborate in Excel, and data entry and formula improvements. If you work with Excel - and who doesn't - this session is necessary to help you improve your efficiency and effectiveness when using Excel. Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Introverts Have Real Power, Why Quiet Leaders are So Successful
-
Online
2.00 Credits
Leaders were once chosen for their character, but today we live in an age where loudmouthed extroverts seem to take center stage in everything, including business, politics and entertainment. While the talkative, charismatic leader makes the front page of business magazines, recent research shows that successful business leaders tend to be more reserved, pensive and sometimes outright shy. Learn why your desire to spend significant time inside your own head may be your greatest asset. Whether you are introverted or not, you likely work with, manage or are a related to an introvert. We will discuss proven methods to better understand introverts, how to manage them, and how to get the most out of their amazing talents. If you want to enhance your leadership skills, this seminar is for you. Presented by: Don MingesType: Live Webcast Replay
ACPEN: Practical Excel Topics for Today’s Accountant
-
Online
2.00 Credits
This course introduces practical ways that public accountants can use Excel to enhance both the efficiency and effectiveness of client engagements. We will reinforce core concepts by illustrating ways that Excel is a tool for analysis and reporting. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when obtaining, analyzing, and reporting information. Presented by: Dr. Chris HarperType: Live Webcast Replay
ACPEN: Cash Flow Clarity: Effectively Communicate Cash Flows for your Board and C-Suite
-
Online
2.00 Credits
The cash flow statement is one of the most confusing financial reports—yet it has the potential to deliver the essential keys to understand business performance. After all, cash is still both king and queen! This session explores how to present, interpret, and communicate cash flows effectively to help CEOs, boards, and decision makers drive smarter results. By using the Sources and Uses format, professionals can make the statement more intuitive and actionable. Learn how to simplify cash flow information and focus discussions on what matters most: how cash is generated and deployed? We will demonstrate how to confidently present this powerful financial statement to non-financial leaders. The cash flow statement is misunderstood, and we will show you how to fix that, and include some amusing videos to drive the points home. We will use the Apple Corporation as an example company in presenting. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: Effective Manager - Traits and Skills
-
Online
2.00 Credits
Many courses deal with leadership and manager skills. Whether you have held a management position for several years or are just transitioning to a manager role, you will find that becoming/remaining a good manager can often be an art rather than just a technical skill. It can be (and should be) a learning and an ever- evolving process. Presented by: Lynn FountainType: Live Webcast Replay
S Corporations: Calculating Shareholder Basis
-
Online
2.00 Credits
A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many 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.
ACPEN: How to Develop Your System of Quality Management Using the AICPA Practice Aids
-
Online
3.00 Credits
This course provides an overview of the Quality Management standards and the requirements under SQMS 1. The AICPA requires CPA firms with accounting and auditing practices to implement a system of quality management, including firms performing preparation and compilation engagements. While the objective is to improve quality within the profession, implementation may seem overwhelming. To assist, the AICPA has developed practice aids to guide firms through the development and documentation process. In this webcast, Jeff walks through where to find the practice aids, how to use them, required documentation, use of the risk assessment template, and development of final documentation. Practical guidance is provided throughout to simplify implementation. Presented by: Jeff SailorType: Live Webcast Replay
ACPEN: Estates & Trusts: Executor Duties and Tax Responsibilities in Estate Administration
-
Online
4.00 Credits
This course reviews the legal, fiduciary, and federal tax responsibilities of an executor or personal representative during the administration of a decedent’s estate. Participants will examine the executor’s duties from initial appointment through final distribution, including identifying and managing estate assets, settling creditor claims, and administering distributions to beneficiaries. The course also reviews filing requirements for the decedent’s final Form 1040, the estate’s Form 1041, and the federal estate tax return, Form 706, along with the treatment of income in respect of a decedent (IRD) and basis adjustments. Participants will also examine IRS procedural requirements, including obtaining an EIN for the estate, responding to IRS notices, and recognizing potential audit risks. Emphasis is placed on practical estate administration procedures, executor liability considerations, and maintaining proper estate accounting records and documentation to support compliance with federal tax requirements. *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 terri.storer@acpen.com Presented by: Mary Jane HouraniType: Live Webcast Replay
ACPEN: K2’s Implementing Internal Controls In QuickBooks Online Environments
-
Online
4.00 Credits
The QuickBooks Online (QBO) ecosystem is rapidly expanding, with millions of small businesses now relying on it for their accounting and business management needs. However, many QBO implementations lack adequate internal control infrastructures, which can lead to potential risks and inefficiencies. This is often due to a lack of understanding of the internal control options available in the cloud-based version of QuickBooks and how to implement them effectively. Join our session to learn about the four common types of internal controls and how to assess the internal control structure of a small business. We'll guide you through the opportunities to enhance internal controls in QBO environments using features found within the application. Additionally, you'll discover additional internal control procedures for situations where adequate controls cannot be established in QBO. Contrary to popular belief, QBO-based organizations can indeed benefit from strong internal controls, and this session will show you how. Don't miss this opportunity to strengthen your QuickBooks Online implementation and ensure your business is safeguarded against risks. Sign up now and take the first step towards a more secure and efficient QBO environment! Presented by: Thomas StephensType: Live Webcast Replay
Create Measures in Power BI that Define Your Metrics
-
Online
4.00 Credits
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
How to Audit Inventory
-
Online
2.00 Credits
Inventory observations are often a right of passage for audit staff. This course will cover the basics of auditing inventory, including the related audit assertions, risks, & threats to inventory. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through how to conduct a physical inventory observation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.