CPE Catalog & Events
Shortcuts that Excel Users Love
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:The power of keyboard shortcutsOft used features with more capability than meets the eyeNew helpful featuresNote: This session is taught using Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.
Seeing Beyond the Numbers: Analysis for CFOs & Controllers
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Purpose of Financial Statement AnalysisComparing Actuals vs. Expectations & BenchmarkingCase Studies 1 & 2Ratio AnalysisCase Study 3Analysis of Statement of Cash FlowsCase Studies 4 & 5Other Uses of Ratios
Financial & Tax Accounting for S Corporations & Partnerships
-
Online
8.00 Credits
Member Price: $239
The major topics that will be covered in this class include:Review the Accounting Standards Codification, OCBOA/Special Purpose Frameworks, and AICPA financial reporting framework and their application to partnerships, LLCs and S corporationsFinancial accounting issues arising from changes in ownershipFinancial vs. tax accounting for partnership/LLC capital accountsSection 704(b) substantial economic effect rules and their relation to financial accountingThe integration of financial accounting with Forms 1065 and 1120SFinancial accounting basis for ownership interests vs. tax accounting basis for ownership interestsDeferred tax accounting for partnerships/LLCs and S corporationsFinancial accounting for the operations of a partnership/LLCFinancial accounting impact of the C to S election and the S to C electionFinancial and tax accounting for S corporation shareholder equity and partner capital accountsFinancial vs. tax accounting for loans to and from S corporations and their shareholders
Calculating the Retirement Need
-
Online
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
Analyzing Financial Statements
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Balance sheet analysisIncome statement analysisCash flow statement analysisClues in the notes and MD&AIndustry nuances
AI 101 for CPAs: Core Concepts and Practical Applications
-
Online
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
ChatGPT Vision for Financial Analysis
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Introduction to GPT Vision - Understanding the fundamentals of GPT Vision and its capabilities.Advantages of Vision Mode Research - Exploring the unique benefits of visual data analysis over traditional methods.Accessing GPT Vision - Guidance on how to access and utilize GPT Vision capabilities.Financial Screenshot Analysis - Techniques for analyzing financial documents and reports through screenshots.Operational Insights from Visual Data - Using images to gain insights into operational processes and asset management.Integration with Google Maps - Learning how to combine ChatGPT's vision capabilities with mapping technologies for enhanced spatial analysis.DDPP Analysis - Applying descriptive, diagnostic, predictive, and prescriptive analysis to visual data.Sentiment and Facial Expression Analysis - Techniques for interpreting emotions and sentiments in images to gauge client and employee feedback.Body Language Interpretation - Analyzing body language in images to understand non-verbal cues in business contexts.Effective Photo Capturing Techniques - Best practices for taking photos that provide optimal insights for financial analysis.
Beyond the Basics: Financial Ratios You Might Be Overlooking
-
Online
1.00 Credits
Member Price: $55
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
Criminal Tax: How CPAs Bring Value to Defense Attorneys
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:The common weaknesses in a criminal tax investigation.The key documents to review (In a sea of thousands of documents).Crafting questions to recommend in court proceeding.
Numbers to Narrative: Storytelling in Business Communication
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Role of narrative in professional communicationSituation–complication–resolution frameworkNarrative arcs in business contextsIntegrating data within a structured storyDefining tension and resolution logicallyMaintaining accuracy while improving clarityApplication of storytelling framework to a workplace scenario
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.