CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
LLC's & S Corps -- A Comparative Analysis
-
Online
4.50 Credits
This course provides an in-depth comparative analysis of Limited Liability Companies (LLCs) and S Corporations, focusing on their tax implications, compliance requirements, and operational structures. Participants will explore key aspects of entity formation, tax treatment, and compliance with corporate formalities. Topics include electing Subchapter S status, mechanics of Form 2553, and relief options for late filings under Rev. Proc. 2022-19. The course also highlights entity-specific tax forms, accountable plans, taxable fringe benefits, officer reasonable compensation, estate planning, business continuation planning, and audit strategies. Additionally, participants will review Schedules K-1, K-2, K-3, and effectively connected income for both entity types. *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
How to Get a Better Return on Financial Statement Audits - Avoiding the Most Misapplied Risk-Based Audit Conce
-
Online
8.00 Credits
By far, the biggest contributing factor that leads to a profitable, yet high quality, financial statement audit is the proper identification, evaluation, and response to assessed risk of material misstatement. When designing your detailed audit plan, how and where you decide to spend your time is largely a matter of professional judgment. The proven tips and techniques for critically rethinking how you plan and design your audit taught in this course will help auditors enhance audit quality and manage profitability in all engagements.
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.
SECURE Act 2.0 and Updates (2025)
-
Online
2.00 Credits
After a false start in 2022 when it failed to pass through Congress, the Secure Act 2.0 was passed in a flurry of year-end legislation. This two hour program will cover the important changes in savings and distributions of retirement plans that impact individuals. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones. This course will provide a concise look at these hot topics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Hiring Remotely: Using Personality Assessments for Better Hiring Decisions
-
Online
1.00 Credits
This course explores the best practices for hiring remotely while leveraging personality assessments to make more informed decisions. Learn how to effectively integrate personality testing into your recruitment process to identify candidates who are the right fit for your team, even from a distance.
Digging Deep with Excel Pivot Tables
-
Online
1.00 Credits
This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables.
The Controllership Series - Sales, Collections and Customer Credit
-
Online
1.50 Credits
Why do for profit organizations exist??? To make money!!!!! What a great concept. But if the organization does not have the proper collections and credit procedures in place, they may not be able to access that money. Hence the importance of the credit and collection process.Credit and collections are critical areas for the financial statement controllers. Customer credit is a form of payment that allows small business customers to purchase a product or service before paying for it in full. The process works similarly to the way a credit card does - you procure something and pay it back later. Collections is a term used by a business when referring to money owed to that business by a customer. When a customer does not pay within the terms specified, the amount of the bill becomes past due and is sometimes submitted to a collection agency. The sales and collection process includes business activities related to selling products and services, maintaining customer records, billing customers, and recording payments from customers. It also includes activities necessary to manage accounts receivable, such as aging accounts and authorizing credit. This course delves into the topics that impact the sales, credit and collections process for management. We discuss strategic steps management can take to ensure their processes are efficient and that they are able to actually collect their revenue.
Employees Today and Tomorrow: The ROI on Your People?
-
Online
2.00 Credits
Employees drive the written and unwritten culture at your organization. Understanding the key workplace issues and how to solve them in today's environment can maximize the returns that employees provide for an organization. We take a deep dive into the research behind the larger issues with our workforce and discuss multiple practical solutions that will enhance your leadership and growth. How can we realize the most from our staff?
Individual Tax Update: Recent Developments
-
Online
2.00 Credits
This course addresses the most recent legislative developments impacting individual taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client 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
K2'S Tech Update
-
Online
2.00 Credits
Staying up to date with advances in today's technology has never been more vital, and K2's Tech Update equips you with the knowledge to stay ahead of the rapid pace of innovation. This comprehensive session is designed for accountants who want to understand the evolving technological landscape and its implications for the accounting profession. Which technology trends are worth monitoring? What are the proper hardware and software products for your strategic and tactical plans? How do Artificial Intelligence, quantum computing, Software-as-a-Service, and productivity suites like Microsoft 365 influence practice, especially since this year marks the 40th anniversary of the release of Excel? Separate vendor hype from reality and discover how to achieve a 2X or more return on investment from your technology expenditures. Attendees will leave with actionable insights, including ideas they may not have previously considered.
K2's Taking A Fresh Look At Teams
-
Online
2.00 Credits
Just because Microsoft Teams is no longer a new tool doesn't mean it hasn't evolved & it certainly has! Since its introduction in 2016, Teams has become the de facto business productivity platform for organizations worldwide. Yet, many users barely scratch the surface of all that Teams offers. Participate in this session to learn how to get more from Teams and enhance your ROI on the platform. In this session, you will learn about the core options available in Teams and how to leverage them. You will also learn about new enhancements in Teams, including threaded conversations, enhanced meeting features, and integration with Microsoft's Copilot platform. If you use Teams and want a deeper understanding of the platform, don't miss your opportunity to participate in this session.
Supporting Mental Wellness to Thrive in Work and Life
-
Online
2.00 Credits
In today's fast-paced world, maintaining a healthy work-life balance is essential for mental wellness. This course is designed to provide practical tools and strategies to help you create a balanced, fulfilling life. You'll learn actionable techniques for improving sleep hygiene, incorporating proper nutrition, fostering open communication, and managing stress. Whether you're struggling with burnout, seeking better work-life harmony, or simply looking to improve your overall well-being, this course offers valuable insights and tools to help you thrive. Designed to fit into your busy schedule, it delivers the guidance you need to make practical, sustainable changes in your life, starting today. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Applying ASC 820: The Basics of Fair Value Accounting
-
Online
4.00 Credits
While once thought just to apply to banking and financial institutions, entities now need to apply fair value accounting under ASC 820 across a variety of transactions. Whether you are assessing financial instruments, leases, business combination accounting, or impairment measurement, GAAP either requires or allows the use of fair value measures in an expanding number of circumstances. Now is the time for you to get up-to-speed on the basics of the fair value approach. In this course, we will review when fair value accounting is required and when an entity can select to use it. Then we will review the basics of the ASC 820 model, including the concept of "exit price," the various approaches that an entity may follow when using a fair value approach, and the different levels of inputs that an entity may consider when determining fair value. Lastly, the course will provide examples of when and how to apply this complex accounting guidance.
Build a Data Model for Analysis in Power BI
-
Online
4.00 Credits
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Tax Depreciation: Review and Update
-
Online
2.00 Credits
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Basics of Employment Law for Non-HR Professionals
-
Online
4.00 Credits
Learn the basics of employment law and how they affect best practices to help control the interview and discover hidden talents of applicants.
Mastering The Three Pillars of Cybersecurity: Team & Compliance
-
Online
1.00 Credits
Are you looking to fortify your practice against the ever-growing threats in the digital landscape? Join us for the third installment of our exclusive webinar series, "Mastering Cybersecurity," brought to you by Practice Protect. In today's digitally connected world, the need for comprehensive cybersecurity is paramount. With cyberattacks becoming more sophisticated, it's crucial to stay ahead of the curve in protecting your sensitive client data. This webinar series is designed to equip CPAs with the knowledge and tools needed to secure their practices and client information effectively.
Tax Procedure
-
Online
2.00 Credits
This seminar will introduce the process from filing a tax return to the IRS audit, IRS Appeals, Collections and litigation at courts of original jurisdiction. We will discuss the options taxpayers have at any point in the process with reference to real-life stories from the trenches. **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.
Ethics without Fear for Accounting and Finance Professionals
-
Online
2.00 Credits
Finance and accounting professionals are on a pedestal and are often held to a higher standard. Keeping your ethical skills sharpened is crucial to reducing your fear and raising your courage as you solve tough decisions in real-time. This fast-paced and interactive presentation will help you practice exactly that. What will you gain? The ability to choose the most effective path in daily situations, so that when a significant crisis hits you are comfortable in your actions. Be ready, be courageous, be fair, and be consistent.
Excel for Accounting Professionals Session 1: Tables and Named References
-
Online
2.00 Credits
Transforming how you use Excel with engaging and expert-led instruction Designed for you to work alongside an expert and complete the same exercises, you'll dig deeper into topics, including: Benefits of using named references for faster navigation Increased versatility and efficiency withing your Excel workbooks Excel Tables special properties and Error reduction for greater productivity. Mastering Excel functions Excel mastery involves understanding how to create functional and efficient workbooks. The instructor will guide you through Tables, named references, and more as you build on basic Excel skills and use critical functions, such as: Excel conventions Critical shortcuts Efficient navigation techniques Automatic formula updating *Session 1 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 2: Data Validation and Conditional Formatting] (https:// https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-2--data-validation-and-conditional-formatting) to further prepare to tackle real-world issues and build powerful workbooks.*