CPE Catalog & Events
K2's Excel Essentials For Staff Accountants
-
Online
8.00 Credits
Member Price: $225
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. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Retaining Talent in a Competitive Marketplace
-
Online
4.00 Credits
Member Price: $149
Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
K2's Accounting Automation
-
Online
1.00 Credits
Member Price: $39
Why can it be hard to automate accounting? Because many accountants don’t know their options and, therefore, fail to reap the rewards of accounting automation. This session will teach you how easy and profitable accounting automation can be. In it, you will learn how to automate many traditional accounting processes, often with technology you already own. In addition to bank feeds, you will learn about automation options for processing accounts payable and receivable, approving transactions, and linking data from one platform to another. If you are serious about improving efficiency and accuracy, you should make plans to attend this session. Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: Overview
Business Intelligence (BI) and Business Analytics (BA)
-
Online
2.00 Credits
Member Price: $79
Volatility and complexity are the new normal. Most organizations are drowning in data, but starving for information. The finance and accounting function has the opportunity to leverage Big Data and the continuum of analytics – descriptive, diagnostic, predictive, and prescriptive. All are useful for better decision making. Collecting, validating, and reporting data is not the same thing as analyzing information where we can glean valuable, actionable insights. In some ways the finance function is many years behind other disciplines such as marketing, sales, and supply chain managers, in applying analytics. How can the CFO’s function catch up? Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Behind the Curtain: Exploring IRS Audit Technique Guides
-
Online
2.00 Credits
Member Price: $89
Have you ever considered a tax audit from the perspective of an IRS examiner? This session explains how you can use IRS Audit Technique Guides (ATGs) to enhance tax compliance. You will obtain a glimpse of the audit process from the viewpoint of an IRS agent as we explore insights that the IRS provides to its own examiners. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
Online
2.00 Credits
Member Price: $79
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. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Intermediate
Surgent's IT Systems and Data Management
-
Online
2.00 Credits
Member Price: $99
Explore the critical intersections between information technology (IT) systems and data management through this specialized CPE course for accounting professionals. This session covers business resiliency and disaster recovery strategies, change management processes, and much more. Through interactive discussions and hands-on activities, participants will learn how to enhance their organization's IT framework while ensuring robust data collection and storage. Equip yourself to oversee IT systems with confidence and reinforce data integrity and system availability.Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Preparing and Reviewing Workpapers for Higher Quality Audits
-
Online
4.00 Credits
Member Price: $129
This course will focus on preparing financial statement audit documentation critical for high quality audits that can pass peer review. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Basic
Business Consulting for CPAs
-
Online
4.00 Credits
Member Price: $129
Does your firm have interest in expanding its’ services beyond traditional CPA services? Do you have staff with the expertise to compete against non-CPA firms? Welcome to a course that will lead you through the maze of creating a successful Consulting Business Practice for your CPA firm. The course will help you understand: where consulting business opportunities exist, what are the firm’s professional responsibilities and most importantly how to recognize the needs of the client. Delivery Method: Individual webcastCPE Credit: Management servicesProgram Level: Intermediate
OBBA 2025 Unpacked: Impact for Taxpayers and Business Owners
-
Online
4.00 Credits
Member Price: $129
Whether you asked for it (or not) and its here! The One Big Beautiful Bill Act was signed on July 4. This program will dig into the meat of the Act that will matter to your clients, including No Tax on Tips, No Tax on Overtime, increased Section 199A Deduction, 100% Section 168(k) Bonus and much, much more! *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 Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Intermediate
LLC's & S Corps -- A Comparative Analysis
-
Online
4.50 Credits
Member Price: $129
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 Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Intermediate
How to Get a Better Return on Financial Statement Audits - Avoiding the Most Misapplied Risk-Based Audit Concept
-
Online
8.00 Credits
Member Price: $225
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. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Intermediate
K2's Excel PivotTables for Accountants
-
Online
8.00 Credits
Member Price: $225
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. Delivery Method: Individual webcastCPE Credit: Accounting, Computer software & applicationsProgram Level: Advanced
SECURE Act 2.0 and Updates (2025)
-
Online
2.00 Credits
Member Price: $89
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.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Hiring Remotely: Using Personality Assessments for Better Hiring Decisions
-
Online
1.00 Credits
Member Price: $39
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. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: Basic
Digging Deep with Excel Pivot Tables
-
Online
1.00 Credits
Member Price: $39
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. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
The Controllership Series - Sales, Collections and Customer Credit
-
Online
1.50 Credits
Member Price: $59
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. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Update
Employees Today and Tomorrow: The ROI on Your People?
-
Online
2.00 Credits
Member Price: $79
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? Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram Level: Intermediate
Individual Tax Update: Recent Developments
-
Online
2.00 Credits
Member Price: $79
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 Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Intermediate
Excel for Accounting Professionals Session 1: Tables and Named References
-
Online
2.00 Credits
Member Price: $125
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.*Delivery Method: Individual webcastCPE Credit: Specialized knowledgeProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by AICPA.