CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Independence for Auditors - AICPA, PCAOB, GAO & DOL
-
Online
4.00 Credits
This course will look at the various rules related to Independence and compare and contrast the requirements. This overview course will help auditors understand the nuances of independence and ensure they meet the requirements to perform attest services for their clients. We will review the requirements for the AICPA, GAO, DOL, and PCAOB.
Expand Your Analytical Toolbox More Tools for Success
-
Online
4.00 Credits
Valuation techniques and cash management activities are two other tool categories that can round out your analytical toolbox. In this course we will initially discuss how to turn your financial plan into a powerful valuation engine. We then will discuss the formation of an efficient cash management program based on solid banker relationships. Finally, we will review Ten Steps for keeping your financial toolbox full.
ACPEN Signature 2025- Small Business: Hot Tax Issues Today
-
Online
8.00 Credits
2025 will be a big year for small businesses no matter what decisions are made: Will tax cuts/changes enacted as part of the Tax Cut and Jobs Act expire at year end as scheduled or will they be extended? If extended, which provisions are included and how long is the extension? Will overtime pay be taxed differently in the future causing additional changes to small business payroll systems? Will employers be relieved of reporting tip income and what exactly is tip income? What additional requirements may be imposed on employers to deter employment of illegal/undocumented workers? What requirements and penalties are already in place and what’s coming? What will happen to ongoing judicial efforts of small businesses to fight self-employment taxes imposed by the IRS on LLC Members and active limited partners? How is the IRS reacting to changes? **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.
ACPEN Signature 2025: Single Audit and Uniform Guidance Issues Update
-
Online
8.00 Credits
If you think applying one set of audit standards is tough enough, how about applying three different sets of audit standards in one “single” audit? That’s exactly what happens when the auditor applies GAAS, the Yellow Book and the OMB requirements in a Single Audit. This session will start with a single audit “nuts and bolts” overview before delving into unique aspects and audit issues of the continued era of pandemic-related funding, and, of course, provide an update of any recent changes to the funding related to the Infrastructure and Investment in Jobs Act, or IIJA. Recent changes to the Single Audit and Uniform Guidance rules will also be covered. Join our expert panel of federal, state and local auditors and practitioners to learn what you need to know if you are performing audits under these audit standards and the Uniform Guidance for Federal Awards.
AICPA's Annual Federal Tax Update
-
Online
8.00 Credits
All-new material updates tax practitioners on the most pressing tax matters affecting business entities, individuals, estates and trusts, and more.
K2's Advanced Excel
-
Online
8.00 Credits
If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.
K2's Excel Essentials For Staff Accountants
-
Online
8.00 Credits
Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.
K2's Excel PivotTables for Accountants
-
Online
8.00 Credits
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables – including grouping options for fiscal periods – and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.
Erase the Mark: Best Practices in Penalty Abatement
-
Online
2.00 Credits
If there is a potential error, the IRS will assess a tax and add a hefty penalty, without even knowing the facts. As a tax professional, you will be exposed to the IRS and their methods of penalizing taxpayers for the smallest of violations. This presentation will focus on the rules and regulations that create the penalty, and the reasons that exist that the IRS will consider to remove those penalties. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 1
-
Online
1.00 Credits
This course is a continuation of our series on preparing to become a forensic accountant. Within this segment we focus on elements of computer forensics. This session is designed to delve into further investigative procedures used in computer forensics.
The Psychology of Fraud
-
Online
1.50 Credits
We all know that Fraud Happens. But, why? Why do people we think we can trust let us down? This session will explore the minds of white-collar criminals and examine some recent high-profile fraud cases. Why did they do it? How did they do it? What were the warning signs? If you think that fraud cannot happen to your organization, this session might give you pause.
Preparation, Compilation and Review Engagements
-
Online
2.00 Credits
This course is an introduction to preparation, compilation, & review engagements. During this course, we will compare and contrast these different engagements by reviewing the procedures that should be performed, different reports, as well as the level of assurance specific to each type of engagement.
CFO Series: Decoding Balance Sheet Accounting
-
Online
2.00 Credits
We mostly focus on the income statement, but what about other accounting concerns? This seminar discusses multiple 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 and case discussions, we highlight several key tools in understanding and communicating the importance of the cornerstone of accounting: the balance sheet. We must understand the real drivers of accounting issues to ensure that the balance sheet will be exemplary.
Critical Thinking Skills: Prevent Mistakes Now
-
Online
2.00 Credits
What were they thinking? Why do some people make horrible decisions that severely damage themselves and their organizations? It is tempting to assume that a poor choice must be due to a leader’s incompetence, inexperience, bad character, or low intelligence – but such easily attributed factors generally aren’t the true cause when leaders blunder. In such situations, many turn to finance and accounting professionals for evaluation, answers, remedies, and solutions for improved decision-making.
HR's Role in Business Evolution: Strategy, Finance, and Growth
-
Online
2.00 Credits
This course is tailored for business leaders and HR professionals who want to enhance their strategic management skills and create actionable plans for success. You’ll learn the overall strategic management process, how to develop both simplified and detailed business and strategic plans, and the crucial role of corporate culture, leadership, and staff development in driving or hindering strategic outcomes. Additionally, you’ll explore how to leverage ChatGPT (Generative AI) as a powerful tool to improve your performance as a key business partner to the management team, helping you make data-driven decisions and enhance organizational effectiveness.
Treasury Circular 230 for EAs and Other Tax Preparers
-
Online
2.20 Credits
Please join us for a discussion on Treasury Circular 230 and other ethical issues faced by enrolled agents and other tax preparers. In addition to covering the practice standards espoused by Treasury Circular 230, there will also be an overview of the applicable provisions in the Internal Revenue Code (IRC) and common law which will affect tax preparers. The discussion will conclude with other ethical issues, such as avoiding conflicts of interest, proper fee structure and maintaining competency. Also included will be case studies illustrating dilemmas faced by tax practitioners. **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.
Allison McLeod's Federal Tax Updates for Business Entities - 4 Hour
-
Online
4.00 Credits
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this four hour program in order to stay abreast of these developments. This program will cover new court decisions, recent IRS publications, and the latest tax legislation that will impact businesses and individuals. The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner. **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.
Small Business Risk Avoidance
-
Online
4.00 Credits
Enterprise Risk Management for SMEs
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.
K2's Business Intelligence, Featuring Microsoft's Power BI Tools
-
Online
8.00 Credits
Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today’s business climate. Increasingly, organizations of all sizes seek to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools – from Excel add-ins to dedicated solutions such as Power BI – now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyzes unthinkable until recently. This program will teach you to implement “do-it-yourself business intelligence” using various techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.