CPE Catalog & Events
Excel for Accounting Professionals Session 7: Date-Driven Workbooks and Concatenation
-
Virtual
2.00 Credits
EOMONTH MONTH and YEAR DATE CONCAT basics SUMIFS with CONCAT
What's Behind the Data?
-
Virtual
2.00 Credits
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
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Virtual
2.00 Credits
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
Microsoft 365 Application Lightning Round Review-Updated
-
Virtual
1.00 Credits
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
Executive Presence, Personal Brand: Structure Your Narrative
-
Virtual
1.00 Credits
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
The Bottom Line on the New Lease Accounting Requirements
-
Virtual
4.00 Credits
Lease classification Amortization of the leased asset Derecognition of the underlying asset Recognition of lease receivables Lease modifications Sale and leaseback transactions
AHI: Accounting Data Analytics
-
Virtual
2.00 Credits
Accounting Data Analytics
Microsoft 365 for CPAs: Unlocking Hidden Productivity Tools
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Round robin review of lesser known M365 appsReduce / eliminate internal email communications with Teams and SharePointCollaborate on spreadsheet and documents with your colleagues in real timeGet control of your appointment schedule with the Bookings appTap the full potential of OneNote as your primary repository for notes, correspondence and moreReplace email attachments with secure file sharing linksDocument business processes with the Stream appLeverage the power of AI in M365 with Copilot
AI Prompt Engineering Masterclass for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Prompt Engineering: Basics of structuring effective prompts for meaningful AI responses.Understanding AI's "Lazy" Defaults: Why LLMs provide basic answers and how to push them to deliver richer insights.Multi-Layered Prompting: Techniques to encourage AI to provide responses across beginner to expert levels.Candid and Contrarian Responses: Using prompts that elicit honest and balanced insights, even on controversial topics.Ripple Effect and Cobra Effect: Probing the broader impacts and unintended consequences of financial decisions.Avoid Stupidity Checklist: A practical prompt for reducing mistakes in AI-assisted accounting tasks.Role-Based Perspective Prompts: Crafting prompts that guide AI to respond from specific professional viewpoints.Automation Ideas: Leveraging AI to optimize repetitive accounting tasks.Emotion-Driven Prompting: Exploring how emotion-focused prompts can enhance AI performance and engagement.Practical Applications in Accounting: How to apply prompt engineering in real-world financial analysis and decision-making.
AHI: AI for Accountants - Practical Applications
-
Virtual
2.00 Credits
AI in Accounting and Auditing
The 10 Must Know Excel Features
-
Virtual
2.00 Credits
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.
AHI: Advanced Management and Leadership Essentials (Mini Course)
-
Virtual
2.00 Credits
Leading Others Coaching & Developing Staff Building Leadership Communication Skills
Ethics, AI, and Music: What Every CPA Must Know
-
Virtual
1.00 Credits
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.
Corporate Finance Technology Selection: Practical Frameworks
-
Virtual
1.00 Credits
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)
Ethics: Critical Thinking, Case Studies and Fraud
-
Virtual
4.00 Credits
AICPA Code of Professional Conduct CPA responsibilities and AU-C 315 The new AICPA Ethics Codification Disciplinary cases and actions CPA Vision Seminal events The impact of ethical and unethical conduct on our profession
Advanced Tax Planning S Corporations - Tax Staff Essentials
-
Virtual
7.50 Credits
Basis in S corporation stock Distributions Compensation planning Qualified subchapter S subsidiaries Liquidations, reorganizations, and redemptions Estate planning and the use of trusts Section 199A
Untying the Knot: Taxes & Divorce
-
Virtual
8.00 Credits
The major topics that will be covered in this course include:Filing Status: Determining the correct filing status during and after divorce.Qualified Domestic Relations Orders (QDROs): Tax implications of dividing retirement accounts.Back Taxes: Strategies for addressing unpaid tax liabilities during and after divorce.Offers-in-Compromise & Installment Agreements: Resolving tax debts with the IRS.Currently-Not-Collectible Status: Understanding when and how to use this option.Innocent Spouse & Injured Spouse Relief: Protecting clients from unfair tax liabilities.Lien Discharges & Subordinations: Managing IRS liens on property during divorce.Reasonable Compensation: Evaluating fair compensation in divorce-related business valuations.Case Studies: Explore unusual and complex tax issues in divorce through real-world examples.
Self-Rental Real Estate: Passive Activity & Section 199A
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Definition of self-rental property - both for Sections 199A and 469Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2Form 8582 (passive activity)The flow-through entity grouping electionIllustrative examples and consequences of failing to comply with the reporting standardsSelf-rental property and "former passive activities" rules
Contract Accounting, Lease Accounting, and Their Impact on Construction Contractors
-
Virtual
1.50 Credits
Contract accounting Revenue recognition Leases
Current Cybersecurity Risk Management Trends
-
Virtual
2.00 Credits
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
