CPE Catalog & Events
AI 101 for CPAs: Core Concepts and Practical Applications
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:ABCs of how generative AI tools such as ChatGPT, Microsoft Copilot, and Google Gemini workWhat inherent risks are associated with this powerful technologyActionable steps you can take to mitigate the risksPractical examples of how AI can be applied in accounting, auditing, tax, and finance services
Smart Formula Selection in Excel: What to Use When
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Introduction to Strategic Formula Use:Why choosing the right formula matters: clarity, performance, and maintenanceCommon traps: overusing IF, defaulting to familiar tools, ignoring modern functionsHow Excel offers multiple ways to solve the same problem and how to pick wiselyConditional Logic and Branching Tools:IFS vs SWITCH vs nested IF: comparing readability and structureWhen to simplify logic and how to avoid nested nightmaresSummarizing Data:SUMIFS vs SUMPRODUCT: multiple conditions, weighted sums, totalsFiltering and Output Control:FILTER vs IF + INDEX: dynamic data extraction with vs without Excel 365Trade-offs in backward compatibility and ease of useCustom Output and Decision Trees:CHOOSE vs SWITCH vs LOOKUP: logic trees and category mappingEmbedded Variables and Reusability:LET vs named ranges: clarity and efficiency for long formulasUsing LAMBDA with LET to create custom functionsSimplifying and documenting complex calculationsBest Practices for Formula Selection:Criteria for deciding: readability, flexibility, future maintenanceTips for avoiding overengineering and formula bloat
ACPEN: A Fox in the Henhouse/Courthouse
-
Webinar
1.00 Credits
Member Price: $39
Internal Controls Fraud Prevention Fraud Investigation
ACPEN: The Ethics Hour: Dealing With Conflicts of Interest: Members in Business and Industry, featuring Don Minges
-
Webinar
1.00 Credits
Member Price: $39
The multi-step process to address conflicts of interest How to remedy threats Preparing to defend your actions or inactions Causes of conflicts of interest
K2's Saving Time With Electronic Forms 26-27
-
Webinar
1.00 Credits
Member Price: $55
Comparing the capabilities and costs associated with forms/data collection tools and the different approaches taken by each tool The benefits and risks associated with using each approach Examples of how tools can be used effectively, with examples
ACPEN: Responding To Retaliation Concerns and Capturing Key Retaliation Case Metrics
-
Webinar
1.00 Credits
Member Price: $39
Speak up Culture Ethical Culture Internal complaint reporting and investigations
ACPEN: Leading Up: The Superpower Every Ascending Leader Needs
-
Webinar
2.00 Credits
Member Price: $89
The consequences of upward leadership failure. Building credibility with your boss, Serving multiple bosses. Making the business case for your ideas.
ACPEN: K2’s Formatting Excel Spreadsheets The Right Way
-
Webinar
2.00 Credits
Member Price: $89
Creating and using Styles in Excel The Accounting Format and why you should use it How to Create Custom Formats Formatting dates for maximum impact The advantages of storing formats in templates
ACPEN: K2’s Getting Started With Artificial Intelligence
-
Webinar
2.00 Credits
Member Price: $89
Understanding AI tools available today Creating accounts in AI platforms Querying data from AI platforms Customizing your AI subscriptions
ACPEN: Peeking Behind the Curtain: Exploring IRS Audit Technique Guides
-
Webinar
2.00 Credits
Member Price: $89
Overview of ATGs Best practices for utilizing ATGs Salient provisions of selected ATGs Insights auditors may obtain from analytical procedures Nuances associated with selected industries
ACPEN: Preparation, Compilation and Review Engagements
-
Webinar
2.00 Credits
Member Price: $89
Auditing Yellowbook
2026/27 AICPA Regulatory Ethics Update
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Update on ethics and independence developments from the AICPA Professional Ethics Executive Committee (PEEC)Recent developments shaping ethical requirements for the professionProposed and ongoing projects on PEEC's agenda
ACPEN: The Commonsense Approach to Auditing for Fraud
-
Webinar
3.00 Credits
Member Price: $89
Occupational Fraud Professional Skepticism Fraud Indicators Error vs. Fraud Fraud Risk Fraud Hypothesis Development Fraud Intent
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Discuss the impact of the Section 199A flow-through entities deduction on partnerships and their partnersThe meaning of a "tax basis capital account"How the financial accounting and tax capital accounts differ from one anotherDetermine a partner's share of the partnership's liabilitiesDistinguish "recourse" loans from "nonrecourse" loansWhat are "qualified nonrecourse financing" loans and how they affect partnersSection 704 "built-in gain or loss" rules and how they impact Schedule K-1 reportingSection 4655 "at risk" rules and how they impact Schedule K-1 reporting
ACPEN: Key Tax Issues Facing Business & Industry
-
Webinar
4.00 Credits
Member Price: $149
Update and review of recent and key tax developments impacting business and industry "Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Other recent legislative, judicial, and IRS developments impacting business taxpayers Current status of Research and Experimentation costs and Interest Expense Limitation Phaseout of Bonus Depreciation and MACRS issues Travel and entertainment expense rules Independent contractor vs. employee
Executive Presence, Personal Brand: Structure Your Narrative
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Components of executive presenceAudience-centered elevator pitch structureProfessional value proposition frameworkStructuring a concise executive biographyAligning personal narrative with organizational valueCommon pitfalls in professional self-presentationApplication and refinement exercise
ACPEN: Critical "Soft" Skills for CFOs and Controllers
-
Webinar
4.00 Credits
Member Price: $149
Tips for being a balanced leader-manager Adapting to various personality styles Tips for coaching millennials and beyond Best practices for managing organizational change
ACPEN: Staff Retention Keep the Best People
-
Webinar
3.00 Credits
Member Price: $109
Remote workforce Employee retention Staff turnover
ACPEN: K2's Automation For Increasing Personal Efficiency And Effectiveness
-
Webinar
1.00 Credits
Member Price: $39
What are integration and automation? Exploring Integration Platform as a Service (iPaaS) tools and services Intelligent Voice Assistants (IVAs) and home automation systems Personal automation workflows and time-saving strategies Smart home integration and optimization
Calculating the Retirement Need
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Overview of retirement expenses and needsOverview of risk tolerance, time value of money and retirement planning factorsExamples of client retirement situations