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!
Ethics: IRS Criminal Investigations: Key Lessons for Accountants
-
Webcast Only
2.00 Credits
Snapshot of IRS Criminal InvestigationsGeneral tax fraudAbusive tax schemesRefund fraudEmployment tax fraudIdentity theftData compromisesMoney launderingPublic corruptionCorporate fraudGeneral fraudsCyber crimesGlobal tax and economic crimesNarcotics, counter-terrorism and transnational organized crimeSelected Field Office Case Files from Across USNew EnglandMiddle AtlanticEast NorthCentralWest North CentralSouth AtlanticEast South Central West South CentralMountainPacificHow accountants can add value to their operations by aiding law enforcement and fighting economic crime
Complete Guide to Analyze Data with Excel PivotTables
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
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
How Much Are Your Ethics Worth?
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Understanding ethicsAvailable tools to aid in ethical decision makingThe role of bias in making ethical decisionsApplication through case studies
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.
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
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.
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