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.
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Webcast Only
2.00 Credits
Automation capabilities of Excel The “Get & Transform” Tool Using “Get & Transform” for flattening, splitting and combining data, unpivoting summarized data, and combining CSV exports
Identify Leadership Gaps Before Busy Season
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Why leadership capacity gets cappedExternal pressures on public accounting firms: private equity, technology disruption, talent shortageThe three kinds of work: hard (physical), smart (intellectual), uncomfortable (emotional)The cost of saying yes: avoided conversations, rework, and time lost to lower-value workThe inventory: five categories of low-value commitmentsMeetings and events (e.g., meetings without agendas, "got a minute" interruptions, fear of not being in the know)Unrealistic expectations (e.g., scope creep, upward delegation, duties outside the role)Strategies and opportunities (e.g., shiny-object initiatives, unqualified leads, FOMO partnerships)Tasks and projects (e.g., low-priority admin, unnecessary reporting, work that should be delegated, deferred, discontinued, or done differently)Suboptimal performance (e.g., avoided accountability conversations, discount requests, non-revenue activities, technology avoidance)Quantifying the gapEstimating weekly hours lost, applying a conservative haircut, annualizingWhat the reclaimed hours are worth when redirected to highest-value workCommitting to one changeSelecting one inventory item to decline for the next monthNaming the higher-value activity the time will fundWhere this step sits in the broader six-step process for doing uncomfortable work
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
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.
Surgent's Tax and Advisory with Agentic AI
-
Webcast Only
2.00 Credits
Agent use in transfer pricing, tax compliance automation, and M&A due diligence Examples of agent deployment in global accounting firms Regulatory frameworks Governance and controls for autonomous tax tools Strategic advisory with agent-based scenario planning
Eat, Drink & Maybe Deduct: Mastering IRC 274
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:IRC § 274 meals and entertainment rules Tax Cuts and Jobs Act changes affecting meals and entertainment Deductible versus nondeductible expenditures Definition of “entertainment” Definition of “business associate” Reimbursement arrangements Exceptions under IRC § 274(e) Compensation-related exceptions Recreational activity exceptions Public availability exceptions Goods or services sold to customers Separately stated food and beverage costs Employer-provided meals Per diem reimbursements Compliance and documentation requirements
Reconciling in QBO
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:What accounts should get reconciled?Why the banking feed still needs reconciliationThe Reconcile interfaceStep-by-step reconcilingTricks to locate errors quicklyHow to solve common QBO workflow errors that create extra transactions...and a slew of time-saving techniques
Surgent's System and Organization Controls (SOC) Engagements
-
Webcast Only
2.00 Credits
Purpose and organization of the Trust Services Criteria Management assertions specific to different SOC engagement types Intended users of SOC 1®, SOC 2®, and SOC 3® reports Determination and use of materiality in SOC engagements Criteria for considering a vendor as a subservice organization Inclusive vs. carve-out method for subservice organizations Service commitments and system requirements in SOC 2® engagements Appropriate form and content of SOC reports
Get started with Power BI
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Overview of the Power BI Tools: Introduction to the Power BI ecosystem, including Excel’s Power BI features (Power Pivot and Power Query) and standalone tools (Power BI Desktop, Power BI Service, Power BI Report Builder and Power BI Report Server).Tour of the Tools: Introduction to the interfaces of Power Pivot, Power Query, Power BI Desktop and Power BI Services.Comparative Analysis: Understand the strengths and limitations of Excel’s Power BI features versus standalone Power BI tools.Strategic decision-making on when to use each tool for optimal efficiency and accuracy in data analysis tasks.
The Bookkeeper Goes to Prison
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
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
Current Nonprofit Fraud Trends
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Best practices for fraud prevention and detection.Common fraud schemes in nonprofit including cash misappropriation; payroll fraud; vendor fraud; falsified billings; improper use of credit cards or purchase cards; the redirection of cash and non-cash contributions; personal use of assets; the redirection of grant benefits; other grant related fraud; travel and expense reporting fraud; and much more!
Microsoft Copilot Deep Dive Hands-on Bootcamp for CPAs
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Getting started with Microsoft CopilotTour of the Copilot app and how to use itVariety of hands-on case study examples for accounting, finance and taxProtecting your data privacy in Microsoft CopilotAdvanced Microsoft Copilot features reviewIntegration with Microsoft 365 apps
Fraud, Controls & Ethics: Best Practices & Case Studies
-
Webcast Only
4.00 Credits
The major topics covered in this course include:Examination of actual fraudsDiscussion of internal controls that could have prevented fraudsContemplation of epiphanies for your own professional scenarios.The AICPA Code of Professional ConductOther elements of professional conduct and compliance with professional standards
Claude Fundamentals for Accountants (2026 Update)
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Understanding Claude and Large Language ModelsPrompt Engineering Fundamentals for AccountantsWorking with Documents, Contracts, and SpreadsheetsProjects, Artifacts, and Reusable AI WorkspacesClaude Connectors and Business System IntegrationMicrosoft 365 Add-ins and Workflow AutomationProfessional Skepticism, Ethics, Privacy, and Verification
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
SEC Case Studies: Ethical Dilemmas in Finance and Accounting
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to Ethics and Ethical DilemmasEthical Codes and Professional StandardsFraud and the Fraud TriangleEthical Decision-Making ModelsFinancial Statement Manipulation TacticsCash Flow and Key Metrics Misrepresentations
Written Information Security Plans
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Introduction to the Gramm-Leach-Bliley Act and its impact on data security.Circular 230 compliance and due diligence for practitioners.AICPA Statements of Standards relevant to WISP requirements.Key components of a Written Information Security Plan.Training requirements for employees, staff, and contractors.Practical guidance for drafting and implementing a WISP.FTC enforcement of data security standards for PTIN holders.Best practices for maintaining and updating WISP compliance.
Ways to Detect AI Fraud and Deception
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:How AI is used for deception.Specific ways to determine when AI is being employed.Controls measures to aid in efforts to thwart AI fraud.
Surgent's Assessing the Risk of Fraud in a Financial Statement Audit
-
Webcast Only
8.00 Credits
The fraud landscape in the United States Fraud risk procedures as updated by recently issued standards Most likely fraud types found in small to mid-sized entities Internal controls to prevent and detect fraud What to do when fraud is identified or suspected Case studies based on recent frauds Cyber fraud schemes and how to prevent and detect them Analytics that can be used as fraud risk procedures Assessing the risk of grant fraud in a Single Audit