CPE Catalog & Events
This will generate a PDF of the current filtered catalog
The 10 Must Know Excel Features
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
Fundamentals of Form 1040 -- Individual
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Form 1040 essentials: filing requirements, due dates, and key schedulesFiling status, dependency rules, and taxable income sources (wages, investment income)Adjustments to income, deductions and tax credits (standard vs. itemized deductions, EITC, Child Tax Credit, Education Credits)Preparer due diligence, Circular 230 compliance and taxpayer rightsIRS cybersecurity considerations and best practices for taxpayer data securityLegislative updates
ACPEN: The Ethics Hour: Dealing With Conflicts of Interest: Members in Business and Industry, featuring Don Minges
-
TBD
1.0 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
Corporate Finance Technology Selection: Practical Frameworks
-
TBD
1.0 Credits
Member Price: $55
The major topics that will be covered in this course include:The changing finance technology landscape: continuous processing, modular ecosystems, automated controls, and real-time visibility (and the risks these shifts introduce)Technology trends and “AI” definitions: automation vs. machine learning vs. generative AI vs. agentic AI—what each means for governance and auditabilityFive common challenges in finance tech projects and how to address them:Cutting through vendor claims and AI hypeIntegration complexity and hidden costsChange management and proving ROIData quality readiness for AI and automationRisk, security, and governanceVendor Evaluation Scorecard: 20 criteria across five categories, including control “deal-breakers” (audit trails, segregation of duties, logging, SOC reporting, error handling)Five-Year Total Cost Framework: software, implementation, data migration/cleanup, integration build & maintenance, internal costs, training, and ongoing operations (plus common underestimates)Industry-specific considerations (manufacturing, distribution/wholesale, SaaS/tech, professional services)Four-phase implementation roadmap with checkpoints and red flags: Assessment & Planning; Selection & Negotiation; Implementation & Testing; Optimization & Ongoing GovernanceWorking with external advisers (CPA/auditor involvement, implementation partner expectations, and common deficiencies to avoid)
ACPEN: The Psychology of Fraud
-
TBD
1.5 Credits
Member Price: $79
Fraud Fraud Triangle
ACPEN: PowerPoint: Tips & Tricks for Today's Accountant
-
TBD
2.0 Credits
Member Price: $89
Exploration of tabs within PowerPoint’s ribbon Initial creation of a slide deck Using slide masters Utilization of external content SmartArt Alignments and layouts Tips and tricks for efficiency Best practices for effective presentation delivery Other creative uses for PowerPoint
ACPEN: K2’s Formatting Excel Spreadsheets The Right Way
-
TBD
2.0 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
-
TBD
2.0 Credits
Member Price: $89
Understanding AI tools available today Creating accounts in AI platforms Querying data from AI platforms Customizing your AI subscriptions
ACPEN: Preparation, Compilation and Review Engagements
-
TBD
2.0 Credits
Member Price: $89
Auditing Yellowbook
ACPEN: The Commonsense Approach to Auditing for Fraud
-
TBD
3.0 Credits
Member Price: $89
Occupational Fraud Professional Skepticism Fraud Indicators Error vs. Fraud Fraud Risk Fraud Hypothesis Development Fraud Intent
Current Cybersecurity Risk Management Trends
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of current cybersecurity threats and how to mitigate data breach risk.Describe how to avoid malware and other security threats
ACPEN: Employee Theft: Understanding the Why and Preventing the Loss with Terry Shulman
-
TBD
2.4 Credits
Member Price: $99
Employee Theft Prevention
ACPEN: Ethics – A Line in the Sand; Implications for Daily Business
-
TBD
4.2 Credits
Member Price: $149
Recognize the underlying drivers of individual ethical behavior Identify the relationship between ethics and integrity Highlight ethical trends in businesses throughout the world Review high profile ethics lapses in recent years
How Recent Auditing Standards Improve Risk-Based Audits
-
TBD
0.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement auditsEnhanced required by-product communications with management and those charged with governance to promote more reliable financial statementsClarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimatesNew definitions and requirements related to identifying and evaluating risks of material misstatementOther important matters contained in recent SASs
Integrate ChatGPT into Your Client Advisory Services-Updated
-
TBD
0.0 Credits
Member Price: $89
The major topics covered in this course include:ChatGPT and generative AI technology primerBuilding your generative AI vocabularyDig deeper into your engagement research to develop a higher quality advisory servicePolish your client reporting with the help of ChatGPTDeveloping your ChatGPT client advisory servicesStart with client education. You don’t need to be a technical expert to be an educatorUse AI to help your clients automate their workflows / business processesBuild better spreadsheets with ChatGPT and ExcelHelp your clients identify, evaluate and select applications for their business
ACPEN: New PCAOB Quality Control Standard Overview
-
TBD
2.0 Credits
Member Price: $89
Background of the new PCAOB Quality Control Standard Overview of the elements of a quality control system Examples of quality risks and potential responses Highligts of what is different between the AICPA Quality Management Standard
ACPEN: Roadmap to Ethical Decision Making
-
TBD
2.0 Credits
Member Price: $89
Provide best practice tips and practical strategies for preserving independence when assisting clients with technical matters Discuss the principles of professional conduct Address compliance with professional standards Use case studies to address circumstances that may create threats to independence
Invest in Your Mental Health and Avoid Burnout
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this course include:How to recognize burnout and evaluate where you are on the burnout scale.How impostor syndrome drives coping reactions of overworking, over preparing and perfectionism.How mindfulness can reduce stress and save time.Silencing the critical inner voice.Tools to help you become more attuned to your needs and emotions.How attending to and regulating your nervous system impacts your mood and well-being.
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
TBD
2.0 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: Cybersecurity & IT Risk for IT Auditors and Financial Auditors
-
TBD
3.0 Credits
Member Price: $109
Cybersecurity IT Risk Governance IT Security Framework(s)