CPE Catalog & Events
CPE & Event Classes
MTCPA offers thousands of live and online courses to meet your professional development needs. Our goal is to enhance your knowledge and help you achieve even greater success.
Most MTCPA classes are available both LIVE [In-Person] and VIRTUAL [MTCPA Webcasts (in-house) or Webinars (other providers)], so please be sure to register for the correct format under the appropriate tab below.
Also check out our on-demand learning platform, allowing you to earn CPE at your convenience. You can choose stand-alone courses or opt for an all-access subscription to our entire Anytime library. Click the Anytime CPE tab below to explore the available courses!
Mastering the Excel Lookup Functions
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
Ethics: IRS Behavioral Insights for Accountants
-
Webcast Only
2.00 Credits
Behavioral insights (BI) PrimerHow and why BI are used by the IRSIRS and individual decision-makingIRS and environmental and design considerationsIRS and social normsIRS "top of mind" issues BI and Implementation of tax reform legislation BI and private debt collectionBI and online taxpayer accountsBI and taxpayer rights in "real" vs. "unreal" auditsBI and the tax-exempt approval processBI and passport renewal and revocationHow to use BI to more mindfully interact with the IRS to improve outcomes
2025 Not-for-Profit GAAP Update
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Accounting Standard Updates issued by the FASB.Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on.
Beyond the Basics: Financial Ratios You Might Be Overlooking
-
Webcast Only
1.00 Credits
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
Casualty Losses: Disaster Relief Act of 2024
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Federal Disaster Relief Act provisions enacted in December, 2024Comparison of personal use casualties with business/investment casualtiesWhen to claim casualty lossesHow to postpone casualty gainsBusiness casualty gains and depreciation recapture
Determining Reasonable Compensation for Owner Employees
-
Webcast Only
1.00 Credits
The major topics covered in this class include:An analytical framework for analyzing and opining on reasonable replacement compensation for owner-employees of closely held businesses and professional practices in the context of tax planning, compliance, management consulting and business appraisal assignmentsExecutive compensation components, including the valuation of non-qualified plans and restricted stock units
Comprehensive Accounting and Financial Reporting Update
-
Webcast Only
4.00 Credits
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.
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Webcast Only
8.00 Credits
Comprehensive coverage of the Inflation Reduction Act, including: The Corporate Alternative Minimum Tax, The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, §45L New Energy Efficient Home Credit, Elective Payment, Transferability, and Prevailing Wage and Apprenticeship Requirements Principles and considerations for nonresident withholding, composite payments, and passthrough entity taxes Comprehensive coverage of the SECURE 2.0 Act with a focus on provisions applicable to employers Thinking beyond §163(j) -- Interest Allocation Rules, Original Issue Discount, Applicable High Yield Discount Obligations, Convertible Corporate Debt Instruments, and Debt-Financed Distributions Retirements and redemptions: considerations for partnerships and S corporations Timely coverage of breaking tax legislation Selected Practice and Reporting Issues: What’s new? A review of recent cases and tax law changes and IRS guidance affecting S corporations, partnerships, limited liability companies, and limited liability partnerships Form 1099-K reporting requirements Bonus depreciation Section 174 Research & Experimental Expenditures -- new guidance under Notice 2023-63 and Notice 2024-12 FinCEN reporting requirements A review of like-kind exchange transactions under §1031
ChatGPT: What Every CPA Should Know-Updated
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Overview of the current landscape for AI in businessHistory of ChatGPT and generative AIFundamentals of generative AI technology and related nomenclatureABC's of how to use ChatGPTDemonstration of practical ChatGPT applications for accounting, finance and taxA word of caution: What you should be concerned aboutDeveloping a ChatGPT usage policy for your firm / business
Disrupt to Dominate: Mastering Change Leadership
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:The urgency of leading change now & the steps in leading changeThe power of crafting a vision that encourages buy-inThe art and science of building strong partnershipsAccelerating change through relationship networksCommunication strategies for changeEstablishing a feedback culture for successful changeManaging self in times of changeCase studies and real-world scenarios
The 10 Must Know Excel Features
-
Webcast Only
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.
Google Gemini AI for Accountants
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Google Gemini Quick StartGemini Standalone ChatbotMobile AppGemini integration with:WorkspaceGmailDocsSheetsSlidesUser Tips
Partnership Tax Updates (2025)
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Court decisions covering partnership issues such as TEFRA, Statute of Limitations, Economic Substance, and Sec. 754 Elections.IRS procedural updates on passthrough entities.New developments on conservation easements.
What You Can Learn From the Statement of Cash Flows
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Preparation of the statement of cash flowsImportance of identifying sources and uses of cash in financial reportingFinancial statement analysisCash-related financial statement disclosures
Implementing an AI-Enabled Marketing Strategy for Your Firm
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Module 1: Introduction to AI in Marketing The Basics of AI – Concepts and TerminologyModule 2: Leveraging AI Tools and Technologies Overview of AI Tools for MarketingModule 3: Practical Strategies for AI Integration Integrating AI into Your Marketing WorkflowModule 4: Measuring AI-Driven Marketing Effectiveness Key Metrics for Assessing AI-Driven CampaignsModule 5: Real-Life Case Studies and Success Stories Case Studies of Firms Successfully Using AI in MarketingModule 6: Developing Your AI-Enabled Marketing Strategy Creating a Custom AI Marketing Strategy
Cryptocurrency 15 Years Later - A Market Update
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Update on the cryptocurrency marketplaceCryptocurrency exchanges - the good, the bad and the uglyOverview of cryptocurrency taxation regulationsThe technology behind cryptocurrency - Proof of stake, Layer 2, wallets and moreBlockchain technology update
Surgent's Real Estate Taxation: Critical Considerations
-
Webcast Only
4.00 Credits
The impact of recent tax legislation on the real estate industry Depreciation and recapture Determining the basis when acquiring real estate Passive activity losses Calculation of gain or loss on sale of real estate Rental operations Installment sales
CFO Solutions to IRS Problems
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:The authority of IRS in assessing and collecting taxes.The common misconceptions when dealing with IRS.Common questionable actions by business owners.How to prepare for an IRS audit.The seven options in IRS collections.Possible criminal tax violations by CFOs and small business owners.
Accounting Fraud 25-26
-
Webcast Only
8.00 Credits
The elements of fraud and the Fraud Triangle Theory Types of fraud with a focus on management fraud Best practices in fraud detection and deterrence
Surgent's Advanced Audits of 401(k) Plans: Best Practices and Current Developments
-
Webcast Only
8.00 Credits
Audit requirements for ERISA §103(a)(3)(C) audits An annual update of the changes affecting 401(k) plans Compliance issues associated with eligibility and enrollments, remittances, lack of oversight, compensation, vesting, and other topics Best practices for engagement planning, internal controls, risk assessment, and detailed testing Avoiding common mistakes while performing audit procedures Plan mergers and acquisitions Common audit reporting and disclosure issues