CPE Catalog & Events
Excel for Accounting Professionals Session 7: Date-Driven Workbooks and Concatenation
-
Online
2.00 Credits
Member Price: $89
Realistic Excel training for skill development Shifting from manual inputs to automated formulas in Excel can help enhance data efficiency. Understanding that Excel can handle date and text values broadens the potential to improve efficiency when managing data in Excel. This webcast will focus on the following essential functions: EOMONTH MONTH and YEAR DATE CONCAT SUMIFS with CONCAT Practical hands-on Excel learning exercises taught by a highly engaging expert In this webcast, you'll develop your skills and implement Excel techniques that will boost the effectiveness of conditional summing functions using comparison operators. Additionally, you'll gain in-depth knowledge of the following: Adding helper columns Distinguishing key function differences Combining values *Session 7 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 8: Dynamic headers, mapping tables and error check] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-8--dynamic-headers-mapping-tables-and-error-check) to further prepare to tackle real-world issues and build powerful workbooks.*
K2's Tech Update
-
Online
2.00 Credits
Member Price: $89
Staying current with today's technology is no longer optional; it is essential. Tech Update 2026 offers accounting professionals a clear, strategic view of the evolving tech landscape, enabling them to cut through the noise and make informed decisions. This forward-looking session is built for practitioners who want to leverage innovation to enhance client service, boost operational efficiency, and remain competitive. Explore the most impactful trends in artificial intelligence, quantum computing, automation, and cloud-based ecosystems. Understand how technologies like Microsoft 365 Copilot, generative AI tools, industry-specific SaaS platforms, and blockchain are reshaping the profession. Learn to identify which solutions align with your firm's goals-and which are just vendor hype. Delivery Method: Individual webcast CPE Credit: 2Program Level: Update
Tax Depreciation: Review and Update
-
Online
2.00 Credits
Member Price: $89
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.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.
Managerial Accounting: Your Prescription for Better Decision Making
-
Online
4.00 Credits
Member Price: $149
This session revisits useful, but potentially underutilized, managerial accounting techniques. You will appreciate a fresh look at concepts you may not have considered since your college days. We will illustrate practical ways you can immediately implement managerial accounting analysis in your professional endeavors. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Shorten Month-End - Closing Best Practices
-
Online
4.00 Credits
Member Price: $149
Surveys show that the average North American company completes its monthly financial statement closing in six (6) days. However, some companies can close their books in one day or less. You don't have to sacrifice accuracy for speed. This session will show you how to close month-end faster, better and cheaper. Yes, to all three. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Advanced Personal Financial Planning Update 26-27
-
Online
8.00 Credits
Member Price: $329
New personal financial planning strategies are emerging due to passage of the One Big Beautiful Bill and evolving personal goals in difficult economic and legal environments. Drawn from recent publications and government directives, this course reviews the latest financial strategies and planning changes from the past year in insurance, investments, tax, estate and retirement, including Social Security and Medicare. Additionally, Randy covers estate and tax planning strategies that enable practitioners to better serve clients by allowing them to take advantage of new opportunities.Delivery Method: Individual webcastCPE Credit: 8Program Level: Update
K2's Advanced Excel 26-27
-
Online
8.00 Credits
Member Price: $329
If you're ready to move beyond Excel's fundamental features, participate in K2's Advanced Excel. This course will teach you about collaboration options, security techniques, tables, data models, PivotTables, and advanced formulas.Delivery Method: Individual webcastCPE Credit: 8Program Level: Advanced
Leases: ASC Topic 842 in Depth 26-27
-
Online
8.00 Credits
Member Price: $329
An in-depth coverage of ASC Topic 842, Leases . Leasing is popular among corporations for needs including office space and equipment. Since ASC Topic 842, Leases has been adopted by most entities, it is time to review the topic, including any recently issued updates. Excerpts from publicly traded companies' recent disclosures on Leases are also examined.Delivery Method: Individual webcastCPE Credit: 8Program Level: Intermediate
Adobe Acrobat Tips for Working with PDF Files
-
Online
2.00 Credits
Member Price: $89
If you find yourself working with PDF files consistently throughout the day, this course will teach you how to review, annotate, format and organize PDF files more effectively and in less time. You will also learn how to use Adobe Acrobat for e-signatures to reduce document processing time significantly and enhance confidentiality. Adobe Acrobat has many features that you can take advantage of and this course will explain and demonstrate how to use them. 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.
Microsoft 365 Application Lightning Round Review-Updated
-
Online
1.00 Credits
Member Price: $55
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.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.
The Future of Work - Building a New Model of Work
-
Online
1.20 Credits
Member Price: $39
Most of the models of work that we use today were not built for the pace of change and the dynamism of work today. In this course, you will learn how so many models we use at work are fundamentally broken and no longer useful. Models that rely on people staying a long time in a firm are no longer helpful in a reality where employees are staying for increasingly shorter periods with their employers. This course will reveal how so much of the architecture of work was not built with short tenure in mind: career paths, compensation, and retention objectives. Delivery Method: Individual webcast CPE Credit: 1.2Program Level: Intermediate
The Controller Function - Elevating the Role
-
Online
1.50 Credits
Member Price: $79
This is the beginning of a series that will cover major aspects of the Controllership function. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc., the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. A Controller is an individual who has responsibility for all accounting-related activities including high-level accounting, managerial counting, and finance activities within a company. The duties of a Controller include assisting with the preparation of the operating budgets, overseeing financial reporting, and performing essential duties relating to payroll. However, in today’s evolving world, the Controller function can provide much more in-depth value to their organizations. This series is dedicated to exploring the traditional Controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. In this first course we focus on the typical Controller function and begin to identify ways to elevate the function. Delivery Method: Individual webcast CPE Credit: 1.5Program Level: Basic
Analytical Procedures for Nonprofits
-
Online
2.00 Credits
Member Price: $89
Strong analytical procedures are critical for evaluating the fair presentation of financial statements. In addition, Financial statements are only as good as the information and trends that they produce for operational, strategic, or compliance purposes. This course will provide insights into how to determine the strength and efficiency of nonprofits in achieving objectives and knowledge to improve the analysis of the fair presentation of a nonprofit's financial statements. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Tax Depreciation: How to Optimize Deductions
-
Online
2.00 Credits
Member Price: $89
Following the ever-changing tax deprecation rules is not a game for the faint hearted! This course analyzes the current landscape of depreciating, capitalizing and disposing of business assets, with examples and illustrated case studies to enhance the CPAs understanding of the most current tax depreciation provisions. *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: 2Program Level: Intermediate
Surgent's Excel Tables and Conditional Summing
-
Online
2.00 Credits
Member Price: $99
In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.Delivery Method: Individual webcastCPE Credit: 2Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Accounting for Leases
-
Online
2.60 Credits
Member Price: $99
In February 2016, FASB issued ASU 2016-02, Leases, which provides new guidelines that change the accounting for leasing arrangements. To be able to properly account for leases, financial professionals must understand ASU 2016-02 (also referred to as Topic 842). This guidance covers information on how leases should be accounted for. The previous leasing standard (ASC 840) had been in existence for almost 40 years. Under ASC Topic 842, lessors continue to classify leases as operating, direct financing, or sales-type. While lessees now classify leases as operating or financing leases. Previous guidance only required capital leases to be reflected on the BS. The new guidance requires all leases to be reflected on the BS. This is a major change for organizations and will cause their balance sheets to swell as leases must now be disclosed on the balance sheet. The standards original effective dates were prior to 2019. In April 2020, due to COVID-19, FASB voted to defer the effective date for ASC 842 for private companies and certain not-for-profit's for one year. For private companies and private not-for-profits, the leasing standard will be effective for fiscal years beginning after December 15, 2021, and interim periods within fiscal years beginning after December 15, 2022. For public companies the leasing standard is effective for fiscal years beginning after December 15, 2019, including interim periods within those fiscal years. The course covers elements of lease classification for both lessees and lessors. Also, numerous examples are incorporated as reference. Delivery Method: Individual webcast CPE Credit: 2.6Program Level: Basic
Criminal Tax: How CPAs Bring Value to Defense Attorneys
-
Online
2.00 Credits
Member Price: $89
CPAs can be requested to assist attorneys in litigation support in criminal proceedings. For criminal tax cases, the IRS has recommended prosecution. However, the rules and stakes are different than a simple civil audit. This presentation will focus on how to assist defense attorneys in calculating tax loss, asking the right questions, and probe possible weaknesses in criminal tax investigations. 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.
Mining Your Firm Client Database for Revenue
-
Online
1.00 Credits
Member Price: $55
Your client database is more than a record of past engagements-it's a goldmine of untapped opportunity. In this practical and forward-thinking session, accounting professionals will learn how to strategically analyze and segment their existing client data to uncover new service opportunities, deepen relationships, and drive sustainable revenue growth. From identifying cross-selling potential to leveraging automation tools for proactive outreach, this webinar will equip firm leaders and client managers with actionable strategies to turn dormant data into dynamic business development. Whether you're a solo practitioner or part of a larger firm, you'll walk away with a roadmap for transforming your client list into a revenue-generating engine. 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.
The Controllership Series - The Future Role of the Controller Part 1
-
Online
1.50 Credits
Member Price: $79
This is a two-part series that discuss new trends and concepts the financial controller should begin to execute in order to truly become a valued member of the senior leadership team. The rapid pace of the evolving technological landscape has promoted changes in how accountants and financial professionals focus attention on strategy and modernize their roles to leverage digital technology. There is increased demand for enhancing flexibility into finance cycles and initiating real-time reporting and insights. These are the core attributes that will assist in transforming the work that controllership function performs. Is the financial controllership prepared to meet future business demands? The IMA® (Institute of Management Accountants) and Deloitte’s Center for Controllership aimed to better understand the current state of controllership and expectations of future demands for controllers and accounting professionals. They conducted a survey in late 2022 and identified several trends. The survey takes a look at how prepared controllership is to meet future business demands. It also highlights some insights for leaders to consider that may increase their preparedness. It also identified areas of additional insight and questions to answer on the controllership transformation journey. In this segment one, we go through numerous concepts in detail and the remaining concepts will be covered in segment two. Delivery Method: Individual webcast CPE Credit: 1.5Program Level: Basic
Mastering Communication Skills for the CPA
-
Online
2.00 Credits
Member Price: $89
Have you ever met an accountant who exhibits solid technical prowess but possesses lackluster communication skills? It is not unusual to meet a savvy accountant who is a technical expert, but could enhance the delivery of written and spoken words. This course is designed to help CPAs improve their written and verbal communication skills. Participants will learn how to tailor communication to their audience, with particular emphasis on techniques for crafting a message that effectively conveys technical information in an engaging manner. The course's author will share personal success tips gleaned from more than two decades of experience communicating myriad topics to a variety of audiences. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic