CPE Catalog & Events
CPE & Event Classes
MTCPA offers thousands of live and online courses to support your professional development. Our goal is to strengthen your knowledge and help you achieve even greater success.
Most MTCPA courses are offered in both LIVE (In-Person) and VIRTUAL formats—MTCPA Webcasts (in-house) or Webinars (other providers).
Looking for flexibility? Explore Anytime CPE, our on-demand learning platform. Choose individual courses or an all-access subscription to our full Anytime library. Click the Anytime CPE tab below to get started!
Courses are listed by format. Be sure to choose the correct tab to view and register for the class you want.
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
Ethical Performance Management
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Definition and Benefits of Ethical Performance ManagementSetting Standards/Goal settingPreparing and Conducting the Appraisal InterviewLegal Considerations in Performance ManagementAvoiding Rater BiasFeedback and Coaching
Keeping Up with the FASB
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Review of current items on the FASB agendaDiscuss the new revenue recognition standardProvide an update on the new lease accounting standardAddress U.S. GAAP alternatives for certain entities
Business Partnerships: Managing Supplier Relationships
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Overview of supplier contractsCase studies of successful and not-so-successful supplier relationshipsRisk potentials
Tax Depreciation: Review and Update
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Recent tax legislation and developments related to capitalizationEligible property for Section 179 and Section 168(k)Discussion of the Section 179 deduction and its use to depreciate real propertyThe Section 168(k) deduction and its use to depreciate real propertyDisposition of segments of real propertyExchanges of tangible personal property after repeal of the like-kind exchange rulesOther related topics
Yellow Book Independence and Single Audit Fundamentals
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:The conceptual framework approach to independenceIndependence threats related to preparing financial statements and accounting recordsConsideration of specific non-audit services that would and would not impair independenceDocumentation necessary to support adequate consideration of auditor considerationFundamentals of a compliance audit performed under the Uniform GuidanceSchedule of expenditure of federal awardsDetermination of major programsUsing the Compliance Supplement Uniform Guidance administrative requirements and cost principles Testing internal control over complianceTesting complianceWriting an audit findingReporting requirements of a single audit
Implementing and Maintaining an Internal Control System
-
Webcast Only
8.00 Credits
The major topics covered in this course include:Control creation and implementation basicsImplementation and update procedures for an Internal Control systemMaintaining existing internal controls
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
Become a Data Analysis Expert
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Data Analysis Process Flow: An introduction to the Data Analysis Process Flow and how it is your pathway to becoming a Data Analysis Expert.Data Modeling: A comprehensive discussion of building a data model and calculating metrics.Data Visualizations: An understanding how visualizations can present data in a more insightful and impactful manner.
Fundamentals of Form 1040 -- Business
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Self-employment and business income taxation (Schedule C, self-employment tax, business deductions)Reporting income from pass-through entities (Schedule E, Schedule K-1, Shareholder stock and debt basis on Form 7203)Application of Form 7217 for capital construction fundsBest practices for self-employed clients and small business ownersKey deductions and credits for business ownersAvoiding common IRS audit triggers related to business income reportingLegislative updates impacting business income taxation in the current year
ChatGPT and Advanced Financial Analysis for Accountants
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Financial Modeling with ChatGPT IntegrationAdvanced Ratio Analysis TechniquesRisk Assessment and Scenario AnalysisValuation Methods and ChatGPT ApplicationsUtilizing Performance Metrics in Financial AnalysisData Analysis and Interpretation with AIInvestment Analysis Enhanced by ChatGPT
Surgent's Liquidation of Flow-Through Entities for LLCs and Partnerships
-
Webcast Only
2.00 Credits
Tax rules governing liquidation of a partnership or S corporation Tax treatment of the shareholder/partner/member receiving a liquidating distribution in an S corporation liquidation/partnership liquidation Tax impact on the pass-through entity when the entity is liquidated Receipt of corporate liabilities in an S corporation distribution Proportionate, liquidating partnership distributions to partners, and gains and losses to a partner on a liquidating partnership distribution Tax issues associated with a partnership distribution of noncash properties in a liquidation Compliance requirements on the occasion of a liquidation of a corporation or a partnership
Ethics at Work: Diversity, Equity and Inclusion
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Overview of ethicsEthical values and principlesDEI working definitionsUnconscious bias, assumptions, microaggressionsStanding Up and Speaking OutDEI and Organizational Responsibility
Tax Update: H.R. 1 "One Big Beautiful Bill" & Form 1040
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Individual Taxation: Child tax credit expansion, tip/overtime exclusions, SALT cap extensionIncome & Adjustments: Tip income exclusion, overtime relief, educator expensesBusiness Taxation: Bonus depreciation, §199A expansion, interest deduction limitsEstate & Gift Tax: Increased exemption thresholds, charitable deduction changesEducation Incentives: Student loan discharge, 529 plan expansion, new “Trump Accounts”Compliance & Reporting: 1099-K threshold changes
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.
Risk Is Increasing - and Risk Management Is Evolving
-
Webcast Only
1.00 Credits
- risk management - value stream and Plus/Delta techniques - Cyber risks - Black Swan events
Monthly Federal Tax Updates - February 2026
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Current individual tax issuesCurrent business entity tax issuesAny current tax legislation occurring during the periodOther issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues
The Leadership Skills of Tomorrow: Delegate and Listen
-
Webcast Only
2.00 Credits
The major subjects that will be covered in this course include:Three levels of listeningStrategies to remain focusedBuilding trust through listeningTactics to practice the Titanium RuleDelegating with confidenceEstablishing an accountability system
Ethical Responsibilities for CPAs: Ethics 25-26
-
Webcast Only
4.00 Credits
Ethical Responsibilities for CPAs The AICPA Code of Professional Conduct PCAOB Ethical Standards The Sarbanes Oxley Act The Foreign Corrupt Practices Act Circular 230 for Tax Practitioners The Dodd-Frank Banking Reform Act
2025 Accounting & Auditing Update for Small Businesses
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Accounting Standards Updates (ASUs) that are most likely to impact small businesses.ASUs initiated by the Private Company Council (PCC).Alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs.Audit standards that small business auditors will need to implement.