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.
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.
Ethics in the Real World 26-27
-
Webcast Only
4.00 Credits
Why model codes of ethics fail The science behind organizations "Ethical DNA" Understanding the psychology behind "Tone at the Top" The interaction between critical thinking and ethics Breaking myths about motivation related to decision-making Ethical decision-making under pressure Are ethics and morals "fixed" or can we learn to improve
How to Review Financial Statements 26-27
-
Webcast Only
4.00 Credits
Practice reviewing financial statements Financial statement case studies
SSARS Practice Issues and Standards Update 26-27
-
Webcast Only
4.00 Credits
Review of applicable SSARS standards, including standards updates Review of AICPA professional ethics requirements In-depth discussion of non-attest services Review of independence issues for SSARS services Overview of SSARS #21'performance, documentation and other requirements Detailed analysis of preparation vs. compilation engagements Detailed analysis of review engagements
Tax Planning for Seniors 26-27
-
Webcast Only
4.00 Credits
Income for seniors: retirement, earnings and investments Tax Deductions: planning, bunching, strategies Planning to help family members
Metrics Management: Choose and Use Key Performance Indicators 26-27
-
Webcast Only
8.00 Credits
Link long term strategy to short term financial plans Use benchmarking to determine what performance should be
ChatGPT Vision for Financial Analysis
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to GPT Vision - Understanding the fundamentals of GPT Vision and its capabilities.Advantages of Vision Mode Research - Exploring the unique benefits of visual data analysis over traditional methods.Accessing GPT Vision - Guidance on how to access and utilize GPT Vision capabilities.Financial Screenshot Analysis - Techniques for analyzing financial documents and reports through screenshots.Operational Insights from Visual Data - Using images to gain insights into operational processes and asset management.Integration with Google Maps - Learning how to combine ChatGPT's vision capabilities with mapping technologies for enhanced spatial analysis.DDPP Analysis - Applying descriptive, diagnostic, predictive, and prescriptive analysis to visual data.Sentiment and Facial Expression Analysis - Techniques for interpreting emotions and sentiments in images to gauge client and employee feedback.Body Language Interpretation - Analyzing body language in images to understand non-verbal cues in business contexts.Effective Photo Capturing Techniques - Best practices for taking photos that provide optimal insights for financial analysis.
2026/27 Not-for-Profit GAAP Update
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline.The International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025.
The CFO Who Went to Prison
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:The importance of valuesIdentifying successEthical dilemmasMitigation strategiesCreating tools to help make better decisionsPersonal accountability strategies
Preparing Quality of Earnings Analysis 26-27
-
Webcast Only
3.00 Credits
Uses of a Quality of Earnings Report Information needed to prepare the report Overlapping enterprise valuation concepts Various adjustments to "as reported" EBITDA
Analyzing Financial Statements
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Balance sheet analysisIncome statement analysisCash flow statement analysisClues in the notes and MD&AIndustry nuances
Financial Planning: Auto & Homeowners Insurance
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Overview of Insurance types Overview of Insurance policies and contract sectionsExamples of types of policies and coverages
An Ethical Approach to Mental Health Issues at Work
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Virtue Ethics and Mental HealthDefinition, Myths and Bias of Mental HealthSuicide: Facts and ResourcesRecognizing signs of potential mental health challengesEmpathy and ListeningMental Health and Generational ExpectationsBecoming a Mental Health Ally
Surgent's Exploring Business Valuation Fundamentals
-
Webcast Only
2.00 Credits
What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models
More Money: Strategic Ways to Improve Cash Flow
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:How do I optimize cash flow?Qualitative Evaluations – Core Earnings & Sustainable GrowthQuantitative Evaluations – Liquidity RatiosIncreasing Customer Base vs. Payment TermsBusiness Cycle & CashInvesting Company CashWhat keeps companies from becoming streamlined?Behavioral Finance BiasesInformation Processing BiasesEmotional BiasesDealing with Behavioral Biases
Ethics: How to Run Your Business Well
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:The five principles of ethical intelligenceHow to make the right decisions in a range of challenging situationsThe fundamental ethical principal, "Do No Harm"
Surgent's Preparing and Writing Findings in Yellow Book and Single Audits
-
Webcast Only
4.00 Credits
The types of audit findings reported in Yellow Book and single audit engagements The finding elements required by the GAO and OMB standards Where audit findings get communicated in the reporting process
How AI Is Automating Internal Control
-
Webcast Only
4.00 Credits
The major topics covered in this class include:An explanation of Artificial Intelligence (AI).Specific ways AI is replacing human cognition. What is on the internal control horizon related to AI and other technologies.
Surgent’s Weekly Expert Hour
-
Webcast Only
1.00 Credits
Each week’s topics will change based on the most critical issues affecting financial professionals
Agentic AI for CPAs: Automate Workflows with Intelligence
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to Agentic AI concepts and terminologyCase studies for using AI agents in accounting, finance, and tax servicesStep by step demonstration of creating and deploying an AI agentIntroduction to Microsoft Copilot Studio agent builderDeveloping your AI agent deployment strategy