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
Mastering Partnership Basis: Inside and Outside Basis
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Explain the use of both "inside" and "outside” basis determination.How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property.Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis.Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest.Comprehensive example to illustrate the mechanics of the basis determination process.
Supervision/Management Competencies: An Ethical Approach
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Overview of Virtue EthicsMilgram and Zimbardo case studiesNavigating the transition from "Buddy to Boss"Self-Awareness and Regard for OthersSetting Standards and Analyzing PerformanceUnconscious BiasCommunication Skills
Tactics to Find Work Life Balance in a Complex World
-
Webcast Only
1.00 Credits
The major topics covered in this class include:How to get more out of one's workHow to achieve greater balance between today's ever more demanding and complex demands of work without losing sight of what is important in daily routinesExample of how to develop and be challenged by your own personal bucket list
Integrity, Objectivity and Judgment: Values in Action
-
Webcast Only
1.00 Credits
The major topics covered in this class include:AICPA Code of Conduct: Integrity and ObjectivityCase Study: Mortgage crisis of 2007-2010Case Study: World Com
Mastering Microsoft 365 Copilot for CPAs
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of Microsoft 365 Copilot featuresAutomating tasks with AI assistanceEnhancing content creation and data analysisCollaboration tools powered by AIBest practices for maximizing Copilot's benefits
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.
S Corporations: Comprehensive walk through of Form 1120S
-
Webcast Only
8.00 Credits
The major topics that will be covered in this course include:Subchapter S status election and compliance requirementsRelief for late Form 2553 filings under Rev. Proc. 2022-19Comparison of Rev. Proc. 2022-19 and Rev. Proc. 2023-3I.R.C. §1361 and §1362 analysis for S Corporation electionsCorporate governance and formalities complianceShareholder stock and debt basis rulesBuilt-in capital gains and other aspects of Form 1120SSchedules K-1, K-2, and K-3 preparation and reporting requirementsOfficer reasonable compensation: requirements, advisory strategies, and audit defensesS Corporation eligibility errors and corrective measures
Securing Your Data with a Password Management App - Updated
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Introduction to the world of password management apps and what makes them so secureReview and demonstration of top selling password management appsSoftware features that will be reviewedPassword generationEmergency user accessEntity vs. individual password managementDesktop vs. cloud basedMulti device synchronizationPII (personally identifiable information) forms fillerCredit card storageDigital data vault
2025 Annual Update for Accountants & Auditors
-
Webcast Only
8.00 Credits
The major topics that will be covered in this course include:Technology Hot Topics for Audits.Accounting Standard UpdatesProjects identified by the FASB's Invitation to Comment: Agenda Consultation.Year 2 considerations for leases including modification accounting.The impact of the changes to auditing group auditsThe status of the AICPA's quality management project management.The current work of the ASB.
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
Microsoft 365: Save More Time, Make More Money
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Appreciate the full potential of Microsoft 365 to drive efficiency in your businessLearn best practices for harnessing the power of Microsoft 365 Design your Teams app setup to meet the unique attributes of your businessUse SharePoint and OneDrive to organize your files and share them securely internally and externallyOrganize your thoughts, meeting notes and other content centrally in OneNoteManage your projects, large and small, with the Planner appDeploy the Stream app to document processes efficiently and effectively Bonus Content: Understand how to harness the power of AI with Microsoft Copilot
Love it or Leave It: Engagement and Retention at Work
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Ethical Values and Engagement and RetentionEnhancing Employee engagementStrategic/Intentional Actions to Enhance RetentionGeneration X
Defining Where and Why Internal Controls are Needed
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Control design basicsAreas or segments of an enterprise to controlControls to reduce riskControls to drive operations
Ethical Considerations of the New AICPA SSTS Rules
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Review of the new AICPA Statement on Standards for Tax ServicesReorganization of SSTS by type of work performedDiscuss new standards on data protection, reliance on tools and representation of tax clients before taxing authorities
Retaining Talent in a Competitive Marketplace
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Decision Making TheoryCompensation & Employee SatisfactionWhat benefits do employees care about?Retirement Plan BasicsHealth Insurance BasicsDisability Insurance BasicsLife Insurance BasicsFringe BenefitsSumming It Up
Behind the Curtain: Exploring IRS Audit Technique Guides
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of ATGsBest practices for utilizing ATGsSalient provisions of selected ATGsInsights auditors may obtain from analytical proceduresNuances associated with selected industries
SECURE Act 2.0 and Updates (2025)
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Implications for individualsChanges to the Saver’s CreditChanging the required minimum distribution rules for Roth 401(k)sChanges to required beginning dates for required minimum distributions of retirement plans. Penalty-Free Withdrawals for Certain Emergency ExpensesSpecial provisions for firefighters and military personnel spouses Increases in catch-up contributions Impact on 529 plansOpportunities for student loan payment matchingImplications for EmployersStarter § 401(k) plans for small employersRequiring automatic 401(k) enrollmentImproving worker access to emergency savingsIncreasing part-time workers’ access to retirement accountsStatute of Limitations on excise taxes imposed on overcontributions to retirement plansMultiple employer §403(b) plansAutomatic portability provisionsOther changes in the administration of company retirement plans
Ethics without Fear for Accounting and Finance Professionals
-
Webcast Only
2.00 Credits
Case studies that clarify the challenges of making appropriate ethical decisions in the fast-paced modern organizational world A frank discussion of how to decide between a teaching moment rather than a termination moment when bad decisions are made. Applying the structure of understanding ethical dilemmas, and then applying the nine-step resolution process to arrive at a fair and consistent decision.
Excel for Accounting Professionals Session 1: Tables and Named References
-
Webcast Only
2.00 Credits
Excel conventions Critical shortcuts Named references Tables