CPE Catalog & Events
K2's Excel Tips, Tricks, and Techniques for Accountants
-
Online
8.00 Credits
Member Price: $225
Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program. Delivery Method: Individual webcastCPE Credit: Accounting, Computer software & applicationsProgram Level: Intermediate
Surgent's Key Current Financial and Economic Issues Facing the Financial Executive
-
Online
8.00 Credits
Member Price: $279
The course explores the challenges of the current economic trends and analyzes their impact on you as the financial executive in areas of human resource management; credit markets and banking; risk management and pandemic style disruptions; cash flow planning strategies; debt and equity mix impacts in uncertain markets; globalization of the market in times of uncertainty; retirement planning and social security funding; and acquiring distressed companies and assets. Specific recommendations and insights will be offered to you to deal with the challenges.Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram 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 Surgent McCoy.
Walter Haig's AICPA Auditing Standards Update
-
Online
8.00 Credits
Member Price: $309
This course will enable practitioners to understand and apply the AICPA "clarification" auditing standards to audits of Small- and Medium-Sized Entities (SMEs). Further, this course will provide guidance on how to perform an effective, efficient and profitable audit engagement. The course is loaded with practical practice aids to help enable participants to comply with the standards. Troublesome areas as identified in peer reviews and litigation will be covered. Participants who take this course will enjoy smooth sailing in their peer reviews, guaranteed! 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: AuditingProgram 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.
CFO Reporting Re-Imagined: Unlocking Operational Insights with Excel and Gen AI (Module 4)
-
Online
1.00 Credits
Member Price: $49
In Module 4 of CFO Reporting Re-Imagined — Unlocking Operational Insights with Excel & Gen AI, you'll explore how to uncover powerful operational insights by combining Excel's reporting tools with Gen AI support. This session focuses on AR aging, AP vendor analysis, sales trends, and employee analysis —the operational metrics CFOs rely on daily. You'll see how to use Excel's power tools, and modern Excel functions to build flexible reports and how Gen AI can help streamline and simplify the process.This course is being offered by a 3rd party vendor and will not be accessible from your My CPE page. Access information will be emailed directly to you by AICPA.
Accounting Update in a Post COVID-19 World
-
Online
2.00 Credits
Member Price: $79
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 webcastCPE Credit: AccountingProgram Level: Basic
Inventory Accounting GAAP, Software and Recognizing Variances
-
Online
2.00 Credits
Member Price: $79
Many organizations struggle to keep budgets current in an ever-changing business climate. Twenty-first century performance metrics focus on determining what budgets should be rather than what they were in the past. Using performance metrics effectively reduces work, reduces politics, provides flexibility and substantially improves the performance management process. This session will show you powerful techniques to drive your organization’s performance. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Basic
Leading Up: The Superpower Every Ascending Leader Needs
-
Online
2.00 Credits
Member Price: $79
Most leadership training focuses on leading downstream, with the goal of eventually advancing to an executive role. Few people get to be “top dog” in their organization. So, nearly every worker will spend their entire career leading up, even while serving in a leadership role. Learn the skills and tactics needed to develop an effective working relationship with your boss and other superiors. Gain the credibility and support necessary to get things done and advance professionally. Delivery Method: Individual webcastCPE Credit: Personal developmentProgram Level: Basic
K2's Top PDF Features You Should Know
-
Online
4.00 Credits
Member Price: $129
Stop struggling with PDFs! Adobe Acrobat and other PDF tools provide access to features that make working with PDF files a breeze. In this course, you will learn how to use tools and features such as PDF forms, redaction, converting PDFs to Word and Excel files, and electronic signatures. You will also learn how to create and apply tick marks, build indices, catalogs, and portfolios, and secure PDF documents to their fullest. The popularity and usefulness of PDFs increase daily, but most PDF users have not learned how to manipulate PDF documents effectively. Accordingly, they struggle and strain with these standard files. You do not need to let this be the case. Join us in this very timely session where you will learn the top features necessary to optimize your work with PDF documents. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
ChatGPT Bootcamp for CPAs with John Higgins
-
Online
4.00 Credits
Member Price: $149
ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. 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: Computer software & applicationsProgram 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.
Estate Planning Strategies: Advanced Techniques and Tools
-
Online
8.00 Credits
Member Price: $245
As the new administration proposes changes to tax policies, estate planning strategies must adapt to evolving laws and regulations. This course equips financial professionals with advanced tools and techniques to address complex estate planning issues, including the latest legislative and regulatory updates. Participants will gain insights into tax-efficient wealth transfer strategies, charitable giving techniques, and the impact of recent tax law changes on estate and gift taxation. With a focus on real-world application, this course provides practical strategies for leveraging closely held stock, split-interest trusts, and life insurance in estate planning. Attendees will explore how to maximize tax benefits while ensuring compliance with changing regulations, ultimately helping clients achieve their financial and legacy goals. *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 Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Intermediate
Retaining Top Talent: Strategies for CPA Firms
-
Online
1.00 Credits
Member Price: $55
In today's challenging talent market, accounting firms face unprecedented pressure to retain their best performers. This course provides actionable, research-backed strategies to help firms keep their top talent from leaving. Based on comprehensive surveys of both current accounting professionals and those who have recently left the profession, participants will learn the real reasons employees stay or go-and what firms can do about it. The course goes beyond simple solutions like "pay more, expect less" to explore comprehensive retention strategies including whole-person compensation, work-life balance improvements, career development pathways, and necessary business model transformations. Participants will discover why 73% of surveyed professionals want to stay with their current firm, yet many still leave-and how to bridge that gap. Key topics include understanding the true cost of turnover versus retention, implementing flexible work arrangements that actually work, creating meaningful career paths for non-partner track professionals, and transforming firm operations to support both profitability and employee satisfaction. Special attention is given to retaining diverse talent and adapting to the expectations of younger professionals who will comprise 27% of the workforce by 2025. Whether you're a firm leader, HR professional, or manager responsible for team retention, this course provides the insights and tools needed to build a sustainable talent strategy in an evolving profession. 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: AccountingProgram 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.
K2's Excel Charting And Visualizations
-
Online
4.00 Credits
Member Price: $129
Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Excel for Accounting Professionals Session 7: Date-Driven Workbooks and Concatenation
-
Online
2.00 Credits
Member Price: $125
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.*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.
K2's Six Essential Teams Features
-
Online
1.00 Credits
Member Price: $39
The mad scramble to remote work and utilize apps like Teams has been trying for most organizations over the past couple of years. With a rush to install and no time to plan, most team members did their best, prioritizing remote meetings as the primary concern. Therefore, as a result, Teams is vastly misunderstood and underutilized in most organizations. Join us in this session to go beyond the remote meetings aspect of Teams and to learn how to optimize efficiency, communication, and workflow with Teams. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Overview
Governmental Accounting 101
-
Online
2.00 Credits
Member Price: $79
Governmental Accounting 101, is a 2 hour webcast that takes the participant of a whirlwind tour of governmental accounting basics, focusing on wetting the participant’s appetite for more. This session will be the first of a series of webcasts, with each subsequent webcast delving deeper and deeper into the governmental accounting basics. Delivery Method: Individual webcastCPE Credit: Accounting (governmental)Program Level: Basic
Internal Controls That May Have Prevented Fraud
-
Online
2.00 Credits
Member Price: $79
This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Basic
Self-Rental Real Estate: Passive Activity & Section 199A
-
Online
2.00 Credits
Member Price: $89
This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. 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.
Managing Your Money in Retirement
-
Online
3.00 Credits
Member Price: $99
You spent your life building retirement savings. Now you want to make sure your savings last the rest of your life and perhaps pass some on to the next generation. Come hear a veteran financial educator talk about money management and planning issues for this phase of your life. Delivery Method: Individual webcastCPE Credit: FinanceProgram Level: Basic
Lease Implementation for Private Entities 25-26
-
Online
4.00 Credits
Member Price: $175
The Financial Accounting Standards Board (FASB) has issued a new accounting standard for leases. This new standard?ASC Topic 842?replaces the existing ASC Topic 840, changes the accounting for operating leases (requiring capitalization in the financial statements), and upgrades many other lease accounting and reporting aspects.Delivery Method: Individual webcastCPE Credit: Accounting, AuditingProgram Level: Basic
Mergers & Acquisitions Part 2: Financial Accounting 25-26
-
Online
4.00 Credits
Member Price: $175
This course is designed to provide a deep dive into purchase accounting, also known as business combination accounting or the "acquisition method" of accounting for business combinations. You'll become familiar with ASC 805, Business Combinations and recent Codification updates impacting purchase accounting. We'll discuss the key analysis points, including the definition of a business and identify which transactions require the application of business combination accounting. The course covers common difficulties, including joint ventures and non-controlling interests, determining the acquisition date, valuation allowances and most balance sheet categories, including intangibles, inventory and deferred income taxes. Be sure to register for both courses in this series: Mergers & Acquisitions Part 1: The Accountant's Role Mergers & Acquisitions Part 2: Financial AccountingDelivery Method: Individual webcastCPE Credit: AccountingProgram Level: Intermediate