CPE Catalog & Member Events

The major topics that will be covered in this course include:Understanding Cost Behavior and Its Impact on Decision-MakingContribution Margin and Break-Even AnalysisMargin of Safety and Its Role in Risk ManagementOperating Leverage and Financial SensitivityAnalyzing Asset Turnover for Operational EfficiencyCash Conversion Cycle and Working Capital InsightsFree Cash Flow Yield as a Valuation Tool

The major topics covered in this course include:Types of external fraudConsiderations as organizations work to reduce fraud riskExternal fraud and known parties/External fraud unknown perpetrators

The major topics that will be covered in this course include:Ways in which data and information can be misleadingCommon pitfalls when encountering dataHow to re-evaluate the data to avoid those pitfalls

The major topics that will be covered in this course include:Overview of Insurance types Overview of Insurance policies and contract sectionsExamples of types of policies and coverages 

Major topics covered in this course include:The role of TIGTA in the US tax systemAuditing, investigating, and inspecting and evaluating IRS programs and operationsIdentifying opportunities to improve the administration of tax lawsPromoting integrity, economy, and efficiency in the tax systemResponding to requests from Congress and other external stakeholdersUpholding ethical standards in the accounting professionBuilding trust and confidence in the tax system

The major topics that will be covered in this course include:The role of a forensic accountant in divorce proceedingsThe marketing of forensic accounting services to family law attorneysHow to conduct a financial investigationCommon areas to uncover hidden assets or incomeThe basic calculations in evaluating marital assetsTestifying in depositions and divorce court

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.

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

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)

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

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 

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.

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

The major topics that will be covered in this course include:Understanding ethical implications of AIData privacy and security considerationsCompliance with regulations and professional standardsDeveloping ethical AI policies and procedures

The major topics that will be covered in this course include:Introduction to the Gramm-Leach-Bliley Act and its impact on data security.Circular 230 compliance and due diligence for practitioners.AICPA Statements of Standards relevant to WISP requirements.Key components of a Written Information Security Plan.Training requirements for employees, staff, and contractors.Practical guidance for drafting and implementing a WISP.FTC enforcement of data security standards for PTIN holders.Best practices for maintaining and updating WISP compliance.

The major topics that will be covered in this course include:An overview of AI constructs.How artificial intelligence is being used by accountants today.Accounting-centric AI developments on the horizon.

The major topics that will be covered in this course include:The rules of IRS disclosure of tax informationUnderstanding the role of IRS transcriptsInterpreting the actions of the IRS in transcriptsFOIA requestsAnalyzing tax information and returns for financial leads

The major topics covered in this course include:The authority of the IRS in assessing tax penalties.The types of penalties that can be removed.The process the IRS uses to evaluate penalty abatements.How to request penalty abatements.Best practices in asking for penalty abatement, including using appeals.

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

The major topics that will be covered in this course include:Salient provisions the AICPA Code of Professional ConductExamination of actual fraudsDiscussion of internal controls that could have prevented or mitigated actual fraudsContemplation of epiphanies for your own professional scenarios.Implications for professional conduct and compliance with professional standards