CPE Catalog & Events
K2’s Mastering Advanced Excel Functions
-
Online
4.00 Credits
Member Price: $149
With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. But if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features-some new and some legacy-to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
K2’s Excel Best Practices
-
Online
8.00 Credits
Member Price: $250
In the ever-evolving world of spreadsheets, staying ahead means mastering the latest and best techniques. Join our comprehensive program and dive deep into the best practices for creating, editing, and auditing Excel workbooks. You'll learn how to secure your workbooks, collaborate seamlessly with others, and effectively report data. Today's Excel best practices are a far cry from those of the past. This "must-see" CPE program will equip you with the knowledge to work smarter, not harder. Our course materials are packed with relevant examples to enhance your learning experience. Don't miss out on this opportunity to fully utilize Excel and elevate your skills to new heights. Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced
IRAs – Contributions & Distributions for Traditional, Roth, SEP & SIMPLE IRAs
-
Online
8.00 Credits
Member Price: $300
This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of S-corporation taxation. The cornerstone of this course is the preparation of the Form 1120S using a fairly complex trial balance common to most S corporation income tax 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 terri.storer@acpen.com Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Comprehensive Estate Planning: Administration & Postmortem Strategies
-
Online
8.00 Credits
Member Price: $250
Navigating the complexities of estate and trust administration is a vital skill for professionals, who play an integral role in the administration team. This comprehensive course is designed to equip professionals with a thorough understanding of their responsibilities and the processes involved in estate administration, enhancing their ability to address estate settlement issues effectively. Participants will be provided with a detailed overview of the professional’s role in estate and trust administration, emphasizing practical insights and strategies for managing assets, addressing the legitimacy of debts and creditors, and ensuring the proper distribution of assets. **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 webcast CPE Credit: 8Program Level: Intermediate
Fringe Benefits & Compensation Planning - Today and Beyond
-
Online
8.00 Credits
Member Price: $250
In today's dynamic economic landscape, staying ahead with effective fringe benefit planning is more critical than ever for both businesses and individual clients. With evolving tax laws and shifting market dynamics, understanding the intricacies of fringe benefit planning is essential to ensure financial well-being and compliance. This course offers a comprehensive overview of essential tools and techniques tailored for financial professionals, allowing them to navigate the complexities of fringe benefit planning with confidence and precision. By attending this course, practitioners will gain invaluable insights into various planning tools and techniques essential for meeting fringe benefit planning objectives. From mastering the subtleties of employee benefit planning, including ERISA reporting and disclosure requirements, to unraveling the complexities of IRC §132 fringe benefit options, attendees will enhance their expertise to deliver superior advisory services. The curriculum also delves into the practical aspects of cafeteria plans, flexible spending accounts, group term life insurance plans, and strategies for financing retiree medical benefits, among others. With a focus on practical application and real-world scenarios, this course equips participants to tackle fringe benefit planning challenges head-on, providing them with the tools and knowledge needed to optimize benefits for both business and personal needs, now and in the future. **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 webcast CPE Credit: 8Program Level: Basic
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
Member Price: $250
This course equips practitioners with the knowledge needed to help clients navigate complex tax and financial challenges. It addresses difficult client situations including divorce, bankruptcy, debt issues, and other personal and business matters that create significant tax consequences. The course provides key insights into the tax implications associated with these situations and highlights planning considerations practitioners should evaluate when advising clients. Participants will explore the tax treatment of divorce-related matters, including filing status, support obligations, and property division. The course also examines bankruptcy, debt cancellation, business dissolution, and other financial hardships that may affect a taxpayer’s reporting and obligations. Through practical discussion and analysis, participants will gain strategies to help clients make informed decisions while understanding the related tax implications. 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 Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
The Single Audit from Beginning to End Update
-
Online
8.00 Credits
Member Price: $250
This course is an updated overview of the single audit of state and local governments and not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits. Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Wired Differently - An Introduction to Neurodivergence
-
Online
1.00 Credits
Member Price: $39
Neurodivergence isn't just something that shows up in childhood or in headlines. It's already in your workplace, quietly shaping how people communicate, create, and collaborate. From autism to ADHD to dyslexia and beyond, neurodivergence shows up in many forms, and chances are, you're already working alongside neurodivergent employees... whether you realize it or not. This session gives professionals a clear, candid introduction to what neurodivergence really is (and isn't), what it can look like in adults, and why many traditional assumptions just don't hold up. We'll bust some big myths, explore real-world examples, and give you a fresh, more human lens for understanding the full spectrum of how brains work. Whether you're brand new to the topic or just want a better foundation, this is your crash course in neurospicy thinking. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Financial Planning: Auto & Homeowners Insurance
-
Online
1.00 Credits
Member Price: $55
While many financial services professionals advise their clients on tax, investment, and life insurance issues, far fewer venture to help in the area of property and casualty insurance. Auto and homeowners policies are mandatory products that everyone generally needs - yet they are also complex products. This complexity raises questions in clients' minds: Are all my belongings covered under my policy? Do I have to adjust my policy if I want to let my neighbor borrow my car? Do I need an additional policy if I want to work as a rideshare driver? And will my premium go up when I move? In this course, we will cover the fundamentals of auto and homeowners' policies. We will touch on these questions, explore basic coverages, and offer some guidance on what practitioners should cover with their clients in this area, so you can offer guidance and give them the peace of mind they need. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Understanding the 4 W's in Budgeting: Who, What, When, and Which?
-
Online
2.00 Credits
Member Price: $89
This session introduces a structured approach to government budgeting using the four W’s: Who, What, When, and Which. Participants will explore WHO should be involved in the budgeting process, including internal teams and external stakeholders, while learning effective communication strategies to foster collaboration. The session examines WHAT the budgeting process entails, covering essential phases, components, legal requirements, and common challenges. Attendees will also learn WHEN to engage the public through strategic planning, workshops, and outreach initiatives. Finally, the session highlights WHICH departments play key roles, from financial planning to managing capital projects. By the end of this session, participants will have a comprehensive understanding of government budgeting and how to align financial planning with community priorities. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
Online
2.00 Credits
Member Price: $89
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 webcast CPE Credit: 2Program Level: Intermediate
S Corporation Essentials: Stock & Loan Basis Reporting
-
Online
2.00 Credits
Member Price: $89
This program addresses the critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions. *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 Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Annual Update on the 2024 Revised Uniform Guidance And Time & Effort Reporting
-
Online
2.00 Credits
Member Price: $89
The Uniform Guidance (2 CFR 200) pertains to the management of Federal Financial Assistance for grants and cooperative agreements. The Biden Administration has performed a comprehensive update where the revised Uniform Guidance was released in April 2024. We will review all of the significant compliance and threshold changes. In addition, we will provide a brief presentation of the revised guidance as it pertains to Time and Effort reporting. Delivery Method: Individual webcast CPE Credit: 2Program Level: Update
K2’s Taking Another Look At Power BI
-
Online
2.00 Credits
Member Price: $89
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! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Accounting Update in a Post COVID-19 World
-
Online
2.00 Credits
Member Price: $89
The COVID-19 pandemic has altered corporate and public accounting in ways we could never have imagined. This broad-based course will discuss accounting and auditing implications that have arisen as a result of the pandemic. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Five Amazing Business Books in 100 Minutes
-
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Treasury Circular 230 for EAs and Other Tax Preparers
-
Online
2.20 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2.2Program Level: Basic
2026/27 Not-for-Profit Accounting & Auditing Update
-
Online
4.00 Credits
Member Price: $149
This comprehensive annual update brings together key accounting, auditing, and compliance developments affecting not-for-profit organizations. The course integrates recent standard-setting activity, audit and attestation updates, and Single Audit developments to provide a practical view of changes impacting nonprofit financial reporting and oversight. Participants will begin with an overview of accounting developments affecting not-for-profit organizations, including recently issued Accounting Standards Updates (ASUs) from the Financial Accounting Standards Board and an introduction to the International Non-Profit Accounting Standard (INPAS). Emphasis is placed on understanding the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. The course then shifts to auditing and attestation developments from the AICPA, including the next phase of quality management with a focus on monitoring and remediation responsibilities. Participants will also review recent and upcoming standards affecting audit, attestation, and consulting engagements, including updates related to SSAEs, SSARSs, exposure drafts on confirmations and fraud, and changes affecting group audits. Delivery Method: Individual webcast CPE Credit: 4Program Level: Update
K2’s Excel Essentials For Staff Accountants
-
Online
8.00 Credits
Member Price: $250
Staff accountants often face unique challenges when working with Excel, and their existing knowledge might not always meet their needs. This comprehensive eight-hour session is designed to bridge that gap and empower you with the essential skills to maximize efficiency and accuracy. Participate in this dynamic and engaging session, and you will learn how to: • Summarize data quickly and accurately • Generate stunning, professional reports • Create essential accounting calculations for depreciation, amortization, and interest We start with a quick overview of Excel best practices and dive into advanced topics like PivotTables, sophisticated formulas, Tables, formatting, and working with dates. Our course is packed with accounting-centric examples to reinforce key learning points. Plus, you'll enjoy a "laptop-friendly" environment with access to all demonstration files. This seminar is a must for all staff accountants eager to enhance their Excel skills and transform their workflow. Don't miss out on this opportunity to elevate your Excel expertise and take the first step towards mastering Excel today! Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
K2’s QuickBooks Online For Accountants
-
Online
8.00 Credits
Member Price: $250
Discover the power of QuickBooks Online (QBO)! Intuit's cloud-based accounting platform has evolved and thrived over the past decade, now generating approximately five times the revenue of its desktop counterpart. Yet, many accountants and business professionals are still unaware of the extensive features QBO offers. Unlock the advantages of the subscription model and learn how to leverage QBO to manage inventory, enhance internal controls, create presentation-quality financial statements, and seamlessly migrate from QuickBooks Desktop or other accounting platforms. Join our dynamic session to explore the best practices for implementing, using, and excelling with QuickBooks Online. Don't miss out on the opportunity to elevate your accounting game with this surprisingly robust platform! Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate