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 below to view and register for the class you want.
You Don't Know What You Don't Know About Microsoft Excel
-
Webcast Only
8.00 Credits
The major topics covered in this course include:Excel shortcuts and time saversWorking with templates, formats, styles, and themesCustomizing and enhancing ExcelProtecting and securing workbooksFormula building and the Excel function libraryNote: This session is taught using a Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.
Best Practices: Conducting Meaningful Walkthroughs
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Review of audit procedures.Documentation requirements.Real world examples of red flags that may arise.
The One Big Beautiful Bill: 2025 tax legislation
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:The Congressional process in passing tax legislation. Major Tax Provisions in the House version of Big Beautiful Bill Individual General Business International Health Care Accounts Qualified Opportunity Zones Industry Specific Provisions Tax Exempt Organizations Miscellaneous Provisions
Avoiding the Most Misapplied Audit Concepts
-
Webcast Only
8.00 Credits
The major topics that will be covered in this course include:Risk Assessment - Properly assessing inherent, control, and detection risk on an engagement, and linking the results to an appropriately tailored detailed audit plan based on risk assessment and client service goals, regardless of entity type.Substantive Analytics- Leveraging strong substantive analytic procedures as audit evidence to cut back on tests of details.Selecting items to test common misunderstandings related to designing, performing and concluding on tests of details, including sampling.Identifying and Evaluating Internal Control Deficiencies - Emphasizing the importance of identifying both design and operating effectiveness deficiencies during the course of the audit, and how to properly categorize deficiencies as inconsequential, significant or material for impact on the audit or required communications with management and those charged with governance.
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
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Webcast Only
2.00 Credits
Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations
Surgent's Top Individual Tax Planning Strategies
-
Webcast Only
2.00 Credits
Extension and enhancement of reduced rates and the standard deduction The temporary senior deduction Extension and enhancement of increased Child Tax Credit Extension and enhancement of increased estate and gift tax exemption amounts Contributions to ABLE accounts and benefitting from the Saver’s Credit Increased SALT deduction Deduction for car loan interest Using Trump Accounts Extension and enhancement of paid family and medical leave credit Enhancement of Adoption Credit, the dependent care assistance program and the child and dependent care tax credit Tax credit for contributions of individuals to scholarship granting organizations Additional expenses treated as qualified higher education expenses for purposes of 529 accounts Individual charitable contributions Health savings account related tax changes
Surgent's Virtual Currency: Keeping Up with the Tax Code
-
Webcast Only
2.00 Credits
Overview of virtual currency Property transactions with virtual currency Receiving virtual currency as payment Paying using virtual currency Charitable donations with virtual currency Gifting of virtual currency Form 8300 reporting
Analyzing IFRS Financial Statements
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Financial Analysis fundamentals: Overview of financial statements, their interconnections, and the foundation of advanced analysisLoblaw Companies Case Study: Introduction to our example company and its financial performanceAdvanced Analysis Techniques: Common size analysis, Dupont framework, financial leverage, and operational metricsOperational Focus: Separating core business performance from financing activitiesApplied analysis and managerial ratios: Segment analysis, cash flow analysis, and managerial ratiosManagement Commentary: Overview of the corporate narrative as presented from IFRS lens.
Compilation, Preparation and Review Basics and Peer Reviews
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Basic requirements included in AR-C Section 60, General Principles; AR-C Section 70, Preparation of Financial Statements; AR-C Section 80, Compilation Engagements; and AR-C Section 90, Review of Financial Statements.New requirements included in SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions.Common peer review findings.Practice tips for high-quality engagements.
What If Your Client Didn't Take Reasonable Compensation
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Review best practices to help your client evaluate if an S election is an appropriate choiceHow to be proactive and head off common reasonable compensation issues before they happenExplore strategies for cash management if cash isn't available at year endExplore what’s at stake when reasonable compensation isn’t paid timely
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
Audits Under Uniform Guidance—Single Audit & NPOs 26-27
-
Webcast Only
4.00 Credits
Concepts of the Single Audit under the Uniform Guidance Performing the compliance audit of federal awards, including testing auditee compliance and internal control over compliance Auditor reporting responsibilities including the compliance audit reports, the report on the schedule of expenditures of federal awards, and schedule of findings and questioned costs Requirements for the schedule of expenditures of federal awards, known as the SEFA Update on the OMB Compliance Supplement
Retirement Distributions: Planning Options 26-27
-
Webcast Only
8.00 Credits
Roth IRA: The right choice" Income tax treatment of distributions from retirement plans of all types Laws, regulations and IRS rulings concerning plan distributions Avoiding penalty on distributions that happen too early or too late Beneficiary choices - eligible or not" Self-directed IRA investment problems
SSARS Codification: Preparation, Compilation and Review 26-27
-
Webcast Only
8.00 Credits
SSARS Codification requirements SSARS engagements: preparation of financial statements, compilation of financial statements and proforma financial information Review of financial statements Coverage of the amendments to the SSARS contained in SSARS 26 and SSARS 27
Social Security Basics and Strategies for Maximizing Benefits 26-27
-
Webcast Only
8.00 Credits
Social Security planning, benefit calculation, and beneficiaries Recent changes to "file and suspend" and "restricted application" strategies Increasing benefits for divorced and surviving spouses Early retirement and the earnings test An overview of the obstacles beneficiaries face when claiming Social Security disability benefits Integrating retirement plan distribution strategies with Medicare and Social Security claiming strategies
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
Workforce Transformation and Talent Management in 2025
-
Webcast Only
1.00 Credits
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Understanding why the traditional pyramid structure is failing firms The inverted pentagon framework and its talent retention advantages Impact of technology and AI on entry-level accounting roles The 6 Ps of Business Model Transformation implementation Accelerating specialized skills acquisition in your workforce Effective knowledge transfer through mentorship and job rotation Technology-driven training and development strategies Best practices from other industries for workforce transformation Building and retaining specialized middle layers of expertise Strategic pricing models to support the pentagon structure
Navigating IRS Authorizations: Form 2848 & Form 8821
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of IRS Power of Attorney (POA) rules.Form 2848: Authority to Represent Clients before the IRS.Form 8821: Accessing Tax Information Without Representation.Identifying errors and compliance risks in POA filings.Rules for revoking or updating POA authorizations.Managing authorizations through the CAF system.Electronic submissions and the IRS online authorization process.Ethical responsibilities when holding a POA.
How to Build a Custom AI Chatbot and GPT in Plain English
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Fundamentals of GPT Builder and AI agent customization techniquesIntegration of specialized knowledge bases and domain-specific expertiseSecurity and privacy considerations in AI chatbot deploymentCustom GPT development without coding expertiseImplementation of AI agents for customer support and workflow automationMulti-bot interactions and content creation strategiesBest practices for maintaining and scaling AI assistants