CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Avoiding Legal Liability and Peer Review Deficiencies in Nonaudit Services, Including Bookkeeping and Preparin
-
Online
8.00 Credits
The majority of peer review deficiencies and malpractice claims result from nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns.
Complete Guide to Analyze Data with Excel PivotTables
-
Online
4.00 Credits
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Walter Haig's Business Financial Health Checkup
-
Online
8.00 Credits
This course fills an important need for both financial managers and accountants in the practice of public accounting by offering the tools to help ensure the future success of a business. Practical guidance for the effective use of benchmarking and analytical procedure is also provided. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
CPA to CFO
-
Online
1.00 Credits
This Masterclass is a one-hour training exclusively for CPAs and accountants. Rely less on tax season and use your expertise to help business owners have a better future! Designed for CPAs, but also applicable to enrolled agents and accountants, this webinar covers the steps necessary to effectively transform a tax or accounting practice into an advisory service. We explore what it means to be a CFO/advisor to small-to-medium sizes businesses and what qualifications are necessary to offer such a service. We will also cover how to find and convert leads and how to price and package services, including combining advisory services with the firm's current offerings. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel Tips & Tricks for the Non-Accountant
-
Online
2.00 Credits
You don’t need an accounting degree to harness the power of Microsoft Excel. This course shows how Excel makes sense beyond dollars and cents. We will focus on fundamental concepts for creating, editing, and utilizing Excel content. Participants will learn how to use Excel’s menus and other functions to craft Excel workbooks. Because this course is designed for newer users, we intentionally offer a broad overview of Excel’s numerous capabilities with in-depth coverage of selected resources tailored for non-accounting applications.
Synchronize Your Files to the Cloud with SharePoint -Updated
-
Online
2.00 Credits
One of the most cost effective methods for storing your files safely and economically in the cloud is with Microsoft 365 OneDrive and SharePoint apps. If you use either or both of these cloud storage apps, this course is a "must take." There are often times when you want or need cloud based files to be stored on your local laptop or desktop PC. With the OneDrive Sync app, you can have the best of both worlds. You can have copies of a file stored locally and in the cloud simultaneously. The Synch app will update both copies of the file in real time for any changes that are made in the local or cloud copy of the file. A classic example is if you have a QuickBooks Desktop data file that you need to store locally to work with the files in QuickBooks. However, you also want the file stored in the cloud for anytime, anywhere access and enhanced security. The Sync app facilitates this scenario effortlessly. Nationally recognized accounting technology advisor and thought leader, John Higgins, will take you through the step-by-step process of setting up and using the Sync app. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Accommodation Requests - Substance Abuse - Contagious Infections
-
Online
1.00 Credits
Good judgment works well in handling most employee relations matters. However, there are special situations where legal requirements dictate specific handling to avoid significant personal and employer liability. This course provides practical knowledge and scripts for responding to requests for accommodation regarding religious practices or disabilities, confronting employees in substance-abuse situations, and handling disclosures of contagious infections so that individual is properly helped, and the health of your workforce is protected.
Making Culture A Competitive Advantage
-
Online
1.00 Credits
In the world of work today, nothing is more critical than Culture. If people are your competitive advantage, then culture is the best way to help your people realize a great destination. While many leaders and companies talk a lot about culture, few take the time to really plan, build, and invest in a great culture. Today, the world of work could not be more challenging, and the changes that we are seeing in the workforce, such as the rise of remote workers and increasing turnover, are adding to the complexity. Now more than ever, Culture must become your competitive advantage. In this course, you will learn about the key macro changes in the workforce and what some leading companies and leaders are doing to create amazing cultures and high-performing organizations. From LinkedIn to Patagonia to Eventbrite, you will learn from some top organizations ow they have successfully leveraged culture. You will learn what Culture is and can be, and you will learn what culture is not. As you set sail in 2024 and beyond as a leader, you will benefit from this class and learn how to make culture your competitive advantage. Your teacher for the class is Steve Cadigan, whom many credit for being the architect of LinkedIn's world-class and groundbreaking culture.
Global Internal Audit Standards (GIAS) - Overview and Contrast to 2017 International Professional Practices Fr
-
Online
1.60 Credits
In May 2023, the IIA released a draft of the new Global Internal Audit Standards. The intent was to provide more effective standards for Internal Audit globally. The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service
Ethical Intelligence for Artificial Intelligence
-
Online
2.00 Credits
Organizations and individuals enticed by the siren song of artificial intelligence cannot ignore ethical considerations. Professionals must consider accuracy of information, data privacy, independence, source citations, organizational policies, security, data retention, and other ethical matters. This course discusses ethical issues associated with the utilization of AI in a professional setting and provides suggested best practices.
Introduction to Yellow Book
-
Online
2.00 Credits
Performing engagements in accordance with Generally Accepted Government Auditing Standards (GAGAS), commonly referred to as the "Yellow Book," involves additional reporting, ethics, and performance requirements that go beyond those outlined in AICPA Generally Accepted Auditing Standards (GAAS). This course provides an overview of the guidance found in the Yellow Book and explores its relationship with the AICPA Code of Professional Conduct. Participants will gain an understanding of the unique CPE requirements for GAGAS engagements and review the Yellow Book standards for financial statement audits, with a focus on ethical principles and independence. This course is designed to equip professionals with the foundational knowledge needed to navigate the complexities of Yellow Book engagements effectively.
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.
Common Sense CFO: Balance Sheet Issues Walk through to Understand and Build Value
-
Online
2.00 Credits
We mostly focus on the income statement, but what about other financial statements and countless other accounting concerns? This seminar is dedicated to breaking down common balance sheet issues, both on-the-books and off, that have an impact on our stakeholders and the value of the organization. Using practical analysis, we highlight several key tools in understanding and communicating the importance of the forgotten cornerstone of accounting: the balance sheet. Most notably, we dedicate time to the pressing issue of “unrecorded assets”. This session is designed to also be fun and entertaining. This seminar stands on its own but is also part of the Common Sense CFO series.
Surgent's Excel Budgeting Ideas
-
Online
2.00 Credits
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.
Surgent's Food, Beverage, and Entertainment Expensing
-
Online
2.00 Credits
The IRS has issued final regulations regarding the Tax Cuts and Jobs Act's (TCJA) elimination of the deduction for expenditures related to entertainment, amusement, or recreational activities and provided guidance to determine whether an activity is considered to be entertainment. The final regulations also address the 50% limitation on the deduction of food and beverage expenses and when the 50% limitation does not apply. Due to the pandemic, Congress changed the rules for 2021 and 2022 to allow for 100% deductibility for meals. These temporary rules no longer applied starting in 2023. To effectively advise clients, it is imperative for tax practitioners to understand these rules and be updated on the latest IRS guidance related to meals and entertainment. This course qualifies for IRS credit.
SAS No. 122, AU 315, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstate
-
Online
3.00 Credits
If you do not understand the entity that you are auditing, you won’t know what type of transactions they should be entering into. As a result, you won’t recognize those transactions they should not be there. In other words, you will be performing the audit without having any idea of what you should be looking at. This statement requires that the auditor document their understanding of the entity and its environment that it operates in as well as assessing the risks of material misstatement. Prior to this statement, auditors often assessed risk at maximum and did not evaluate internal controls. A big change made by this statement is that, while it allowed the auditor to continue to assess risk at maximum, they now must first evaluate internal controls in order to have a basis for making such an assumption. As a result, auditors are now required to document their evaluation of internal controls on every financial statement audit. This presentation is an overview of the many procedures auditors are now required to perform and document on every audit related to their understanding of the entity and its environment and the basis for assessing the risk of material misstatement.
Dashboard and Report Design Principles Using Excel
-
Online
4.00 Credits
Transform your data presentation skills with our comprehensive course on creating impactful dashboards and reports using Excel. This workshop is tailored for professionals who: Regularly produce or update dashboards and reports Struggle with confusing or overly complex reporting tools Seek to streamline varied reporting styles across their organization Aim to establish a consistent, replicable "house style" for reporting Want to impress stakeholders with clear, user-friendly data presentations Through a combination of theory and hands-on practice, you'll learn the fundamental principles that make reports and dashboards easy to understand. We'll distill these concepts into a set of practical rules and guide you through their application in Excel.
Critical Technical Skills for CFOs and Controllers
-
Online
4.00 Credits
Accounting and finance managers and executives must demonstrate sound technical and analytical necessary for personal growth and organizational success. This course will provide insights into the most critical technical and analytical skills needed by CFOs and Controllers - or those that want to be!
K2's Excel Best Practices
-
Online
8.00 Credits
As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.
Federal Tax Update - Individual & Business Current Developments
-
Online
8.00 Credits
With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a one-day fast-paced update course focusing on the hottest Federal income tax topics affecting individuals, businesses and their owners with an emphasis of newly enacted income tax legislation. **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