CPE Catalog & Events
Smart Formula Selection in Excel: What to Use When
-
Online
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
Create Measures in Power BI that Define Your Metrics
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
Microsoft 365 Application Lightning Round Review-Updated
-
Online
1.00 Credits
Member Price: $55
The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps
How AI Fits into the Accounting World
-
Online
2.00 Credits
Member Price: $89
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 Current and Future Landscape of Audit Technology
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Explore the transformative impact of technology on the audit profession in this forward-looking courseGain practical insights into cutting-edge tools and trends, including data analytics, artificial intelligence (AI), and automationNavigate the evolving audit landscape with confidence and adaptability
Comprehensive Accounting and Financial Reporting Update
-
Online
4.00 Credits
Member Price: $149
The major topics covered in this class include:CECL for nonfinancial institutions.Accounting for Paycheck Protection Program loans.Accounting for web-hosting services.Revenue recognition.Leases.FASB projects in progress.
Leadershift: Drive Results Through Ethical Performance Mgmnt
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:How Inspirational leadership is the foundation that ethically drives results.Simplify the complex: Walk through the Results Model and discover practical how-to examples of execution.Hacks for getting great results with specific examples you can leverage in your business:The How: Empower your people to feel like an owner, managing difficult conversations well, leading with empathy and what that looks like, how it should feel, motivational coaching techniques to get your employee relationships back on track, and unleashing the power of appreciation and gratitude.The What: Powerful score-carding, transformational goal-setting conversations, and positive accountable follow- up.
The Ethic of Recruitment and Selection
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Discussion of ethical and effective recruiting strategiesSelection processes that foster diversity and inclusionHow to increase talent pools to ensure hiring success
Hot Topics Audit & Attest Update - 2026
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:The major topics that will be covered in this course include:Recent quality improvements to the SASs and SSARsOther matters that should be on your radar
Navigating IRS Correspondence: Responding to IRS Letters
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Types of IRS letters: General notices, audits, collections, return requests, and errors.Deadlines for responding to IRS correspondence.Communication best practices for dealing with the IRS.Avoiding escalation and penalties through proactive responses.Ensuring compliance when addressing IRS correspondence.Real-world examples of successful IRS communications.Common pitfalls in handling IRS letters and how to avoid them.Strategies for advising clients on IRS correspondence.
NotebookLM Use Cases for Accountants
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:NotebookLM fundamentals: notebooks, sources, prompts, and outputsTurning financial PDFs into searchable, conversational knowledge basesAudit and assurance use cases: workpaper synthesis and issue trackingTax and regulatory research: comparing guidance across sourcesCross-referencing: tracing claims back to documents for defensibilityDrafting deliverables: memos, client notes, and executive summariesRisk controls: confidentiality, data handling, and “trust-but-verify” habits
Ethics, AI, and Music: What Every CPA Must Know
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include: Four key aspects of artificial intelligence that are relevant to CPAs: machine learning, generative AI, large language models, and GPT.The role that five powerful principles—the principles of ethical intelligence—play in using AI the right way. Short, focused writing exercises (30 seconds each) designed to deepen understanding of the topic. Real-world case studies about the use of AI in music as well as accountingAnswers to several crucial questions about how to use artificial intelligence with ethical intelligence.
LEARNING PATH: AI-Powered Accounting
-
Online
10.00 Credits
Member Price: $259
This learning path helps CPAs move from "AI curious" to AI capable by building practical skills across prompt engineering, core AI concepts, and real accounting use cases. You'll learn how AI fits into the profession, where it can improve efficiency and judgment, and how to apply tools like Copilot in Excel to real workflows. It's ideal if you want to stay relevant as automation expands-without getting lost in jargon-while still grounding the learning in accounting and audit realities.
LEARNING PATH: Audit and Risk Fundamentals
-
Online
10.00 Credits
Member Price: $259
If you want stronger audits with fewer surprises, this path is built around the core building blocks: risk assessment, internal controls, walkthroughs, and operating effectiveness testing. It reinforces how to identify what can go wrong, where controls fail, and how fraud risk often shows up in control gaps. CPAs take this path to sharpen planning, improve documentation quality, and make testing more meaningful—especially useful for audit seniors, managers, and internal auditors responsible for higher-risk engagements.
LEARNING PATH: Auditing Key Financial Statement Areas
-
Online
10.00 Credits
Member Price: $259
This path is designed for CPAs who want to strengthen execution in the areas that most often drive audit risk, adjustments, and review comments. It walks through practical approaches to auditing cash, inventory, estimates, payables/expenses, and PP&E, helping you improve testing choices, evidence quality, and professional judgment. Take this path if you want a tighter, more repeatable approach to auditing the "big buckets" that can make or break engagement quality.
LEARNING PATH: CPA to CFO Leadership
-
Online
10.00 Credits
Member Price: $259
This path helps CPAs expand from technical expertise to executive finance leadership-the mindset shift needed for controller, finance director, and CFO tracks. It blends strategic competencies (ratios, budgeting/forecasting thinking, behavioral finance) with real-world leadership topics like supplier relationships and what it takes to operate as a fractional CFO. CPAs should take this path to strengthen advisory value, communicate like a finance leader, and make more confident decisions that go beyond compliance.
LEARNING PATH: Combatting Fraud
-
Online
10.00 Credits
Member Price: $259
Fraud risk is evolving, and this path gives CPAs a balanced toolkit across prevention, detection, and response-without making it purely theoretical. You'll explore control-based prevention ("Fraud Busters"), external fraud countermeasures, and higher-risk topics like money laundering, plus practical considerations tied to modern work patterns (like the gig economy). CPAs should take this path to better protect clients and organizations, improve skepticism, and recognize red flags early-before losses compound.
LEARNING PATH: Ethics and Professional Responsibility
-
Online
10.00 Credits
Member Price: $259
This path reinforces the ethical backbone of the profession by covering real scenarios CPAs face: technology-driven dilemmas, malpractice risk, fraud/embezzlement case studies, and professional ethical considerations. It's built to strengthen decision-making, professional skepticism, and risk awareness-especially helpful for CPAs renewing licenses and firm leaders setting the tone at the top. Take this path if you want ethics training that feels practical and job-relevant, not checkbox-only.
LEARNING PATH: Financial Strategy and Analysis
-
Online
10.00 Credits
Member Price: $259
This learning path is for CPAs who want to translate financial data into insight-sharpening analysis, budgeting, and performance interpretation. You'll build skill in statement analysis and forecasting fundamentals, then level up with case studies and "numbers-to-narratives" communication (including storytelling in financial reporting). CPAs should take this path to become more valuable to leadership by turning reports into decisions-and decisions into clear explanations stakeholders can act on.
LEARNING PATH: Government and NFP Specialist
-
Online
10.00 Credits
Member Price: $259
Government and Not-For-Profit work has unique standards, reporting expectations, and compliance requirements-this path focuses specifically on those realities. It pairs Yellow Book ethics with governmental accounting updates and what's changing in A&A for governmental entities, giving CPAs a current, practical view of the landscape. Take this path if you serve public-sector or NFP clients (or want to) and need specialized CPE that aligns with their standards and oversight environment.