CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
ACPEN: 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, then this course is for you! In this dynamic and engaging session, you'll master how to: • Build PivotTables from scratch • Group data inside PivotTables, including options for fiscal periods • Create user-defined calculations in your PivotTables We start with the fundamentals and quickly move to advanced techniques, including: • Building PivotTables that consolidate data from multiple ranges • Connecting PivotTables dynamically to external databases and financial accounting systems • Leveraging other Excel features associated with PivotTables, such as Slicers, Power Query, and Power Pivot This seminar is a must for anyone eager to enhance their Excel skills and transform their workflow. With guidance and coaching from your K2 instructor, you'll be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks. Presented by: Thomas StephensType: Live Webcast Replay
Financial & Tax Accounting for S Corporations & Partnerships
-
Online
8.00 Credits
This program compares and contrasts the financial and tax accounting differences of partnerships, LLCs, and S corporations, as well as discuss the tax accounting for these entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Appreciation Intelligence: The New AI Elevate Culture. Deepen Loyalty. Strengthen Performance.
-
Online
1.00 Credits
Appreciation isn’t a soft skill—it’s a strategic advantage. In today's competitive professional landscape, your ability to express appreciation effectively can be the difference between retaining top talent, building strong client relationships, and creating a thriving team culture—or not. This course introduces a powerful, research-backed framework for understanding how appreciation works—and how to use it to fuel performance, loyalty, and engagement across your firm, practice, or department. Based on the work of Dr. Gary Chapman and Dr. Paul White, you’ll explore the four core "languages of appreciation" and learn how to recognize and use them in a way that resonates with clients, colleagues, and team members. The truth is, everyone wants to feel valued—but not everyone receives appreciation the same way. In this hands-on session, you’ll discover your own appreciation style, learn to spot others’, and develop practical tools to build a more energized, connected, and committed workplace. Presented by: Roger WolkoffType: Live Webcast Replay
ACPEN: Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
Online
2.00 Credits
GAAP is changing at an increasing rate. Every successful organization has a sound strategy. Financial leaders are faced with the dual challenge of navigating evolving accounting standards while strategically guiding their organizations toward sustainable growth and profitability. What are the newer accounting changes that will impact professional accounting? This seminar will equip finance professionals with the critical skills and practical insights needed to effectively manage the complexities of ever-changing accounting standards and upgrade your essential strategic planning skills. Strategic skills are mandatory today. Strategies that do not keep pace with the market are doomed to fail. If we do not keep up, our successor will. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: K2’s Taking Another Look At Power BI
-
Online
2.00 Credits
Although Power BI has been available for ten years, most business professionals don't fully appreciate all it can do and its easy use. Further, many are intimidated by the platform and continue to use less efficient and effective reporting practices. If this describes you, invest some time in this session to learn how to work with Power BI almost immediately. In this session, you will learn how to use Power BI to create compelling dashboard reports. You will also learn how to optimize these reports to enhance their effectiveness. If you want to improve financial and operational reporting processes, this session is for you! Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Five Amazing Business Books in 100 Minutes
-
Online
2.00 Credits
If you are efficient and want to learn lessons from the best in a short time, this seminar is for you. Popular speaker Don Minges will review the key lessons from five fantastic business books that will help you become more effective. The topics are; leadership, how to create a valuable business, how to turnaround a business, how to make terrific presentations and how do humans think? These lessons are valuable for every business leader. Presented by: Don MingesType: Live Webcast Replay
ACPEN: Ethical Practices and Responsibilities Under Circular 230
-
Online
2.00 Credits
The IRS has recently issued proposed regulations to update the Circular 230 rules for all tax practitioners, amending these rules in various ways to reflect changes in the law. This session will review these new rules and discuss their impact on your tax practice. The course also covers in detail major provisions of Circular 230 and analyses them using factual situations. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com Presented by: Steven DilleyType: Live Webcast Replay
ACPEN: Stop Loss & Contract Review: Protecting Your Plan and Your Bottom Line
-
Online
2.00 Credits
Go in-depth to understand the three main components of self-funded plans: Stop Loss, Third Party Administrators (TPA), and Pharmacy Benefit Managers (PBM). This section will review both Specific and Aggregate Stop Loss as a concept while also providing in-depth knowledge of contract terms and risk management. It will discuss the key components of a TPAs/PBMS and show examples of admin agreements. The instructor will also use real world examples to show how to avoid common pitfalls and use cost savings tools to ensure that waste, fraud, and abuse are eliminated from your plan structures. The end of this unit will also introduce point solutions and how they can be used to ensure peak plan performance and claims savings. Presented by: William MinickType: Live Webcast Replay
ChatGPT for Accountants: 50+ Use Cases
-
Online
2.00 Credits
This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Are You Up For the Challenge? Test Your Skills as a Quality Control Reviewer
-
Online
4.00 Credits
Have you ever wanted to reduce the number of financial statement review points you receive? Are you curious about a reviewer's thought process? This hands-on session will answer these questions by helping you understand the role of an engagement quality control reviewer. Not only will you develop an appreciation for the role of an engagement quality control reviewer, but this interactive session will allow you to step into the reviewer's shoes by performing a quality control review during the class session. You will leave with an understanding of best practices for minimizing your exposure to critique by reviewers. Presented by: Dr. Chris HarperType: Live Webcast Replay
ACPEN: 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 terri.storer@acpen.com Presented by: J. Patrick GarverickType: Live Webcast Replay
ACPEN: K2’s Advanced Excel
-
Online
8.00 Credits
Elevate your Excel expertise with K2's Advanced Excel program! This laptop-friendly course is designed for experienced Excel users who are ready to take their skills to the next level. In this session, you will master critical advanced Excel skills in six key areas: 1. Collaborating seamlessly with other users and securing your workbooks 2. Utilizing tables to analyze and report data efficiently 3. Integrating and manipulating data from external sources with ease 4. Creating and auditing complex formulas 5. Harnessing advanced data analysis tools for deeper insights 6. Employing visualization techniques to communicate information effectively Drawing from over thirty years of experience in delivering Excel training to accountants and business professionals, this program is packed with relevant, real-world examples that reinforce the topics presented. Don't miss this opportunity to become more efficient and proficient in Microsoft Excel, the go-to tool for accounting and financial professionals. This course covers advanced Excel topics that are essential for business success. Participate in this session to elevate and transform your Excel skills! Presented by: Thomas StephensType: Live Webcast Replay
Microsoft 365 Application Lightning Round Review-Updated
-
Online
1.00 Credits
Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Introduction to Governmental Budgeting
-
Online
2.00 Credits
The introduction to governmental budgeting course is an overview of the typical timeline and process a government uses when creating their annual budget. Topics covered include the basics of governmental budgeting, establishing priorities for the budget, the common steps and timeline of the budget process, what, when and how we should be monitoring the budget throughout the year, and how long-term budgets fit in with the annual budget process. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Best Individual Income Tax Update Course by Surgent
-
Online
8.00 Credits
This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that will serve their ever-evolving needs. This course is continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BFTU.
ACPEN: Ethics, Education and AI; Can Thy Coexist?
-
Online
1.00 Credits
AI (‘Artificial Intelligence’) has fundamentally changed education – at all levels. These changes have ignited severe ethical dilemmas in schools, higher education and continuing professional development. There is an escalating ‘arms race’ between the students, teachers and professors. What does this mean for the future of education and the future of the workplace? Presented by: Don Minges, John LevyType: Live Webcast Replay
ACPEN: HR Investigations – Episode 3 – Gathering-Analyzing-Reporting
-
Online
1.00 Credits
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for gathering and analyzing evidence and reporting the investigation results. Attendees will end the session with takeaways to immediately implement in future HR investigations. Three of three Episodes in the series. Presented by: Daniel PorterType: Live Webcast Replay
ACPEN: The AB5s of Employees and Independent Contractors
-
Online
2.00 Credits
This course explores the tests used to determine whether a worker is properly characterized as an employee or an independent contractor for tax purposes, with a focus on the cost of getting it wrong and possible Section 530 relief. The game changing impact of the Dynamex case and AB5 will also 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 terri.storer@acpen.com Presented by: Doug Van Der AaType: Live Webcast Replay
ACPEN: Global Internal Audit Standards (GIAS) Domain V - Part 1
-
Online
2.00 Credits
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 Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: No Tax on Overtime: Payroll Compliance
-
Online
2.00 Credits
This course provides tax and accounting professionals with a comprehensive overview of overtime requirements under the Fair Labor Standards Act (FLSA). Participants will examine the statutory framework governing overtime, including employee classification, the definition of a workweek, and the calculation of the regular rate of pay. Through practical examples and compliance-based scenarios, the course focuses on the accurate application of overtime rules across various compensation structures. Emphasis is placed on identifying risk areas, avoiding common misclassification and calculation errors, and maintaining proper documentation to support compliance. 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