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.
What's Going on at the FASB (2025)
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. Review year 2 implications of the leases standard including modification accounting. A look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation.
AI Lessons Learned for Accountants
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to AI R&D in Accounting: Why internal AI research is essential for modern firms.Theory to Practice: Moving quickly from speculative AI concepts to actionable strategies.Managing Exponential Change: Understanding the urgency of adapting to AI’s rapid evolution.Proactive AI Engagement: Conducting in-house AI benchmarks, research, and hackathons.The Dual Role in AI Development: Balancing innovation with data security and ethical responsibilities.Internal AI Tools Creation: Encouraging accountants to develop AI solutions tailored to their needs.Data Security and Cyber Threats: Addressing AI-enabled cybercrime and protecting against internal risks.Mitigating AI Misuse: Recognizing abuse patterns and implementing safe practices.Challenges in AI Integration: Handling resistance, management concerns, and rapid technological shifts.Continuous Learning and Adaptation: Building a resilient, R&D-focused AI culture in accounting.
Risk Is Increasing - and Risk Management Is Evolving
-
Webcast Only
1.00 Credits
- risk management - value stream and Plus/Delta techniques - Cyber risks - Black Swan events
What You Can Learn From the Statement of Cash Flows
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Preparation of the statement of cash flowsImportance of identifying sources and uses of cash in financial reportingFinancial statement analysisCash-related financial statement disclosures
Microsoft 365 Application Lightning Round Review-Updated
-
Webcast Only
1.00 Credits
The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps
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
Roles and Responsibilities in Risk Management
-
Webcast Only
1.00 Credits
- risk management - Anticipatory leadership - leadership roles in risk management
Self-Rental Real Estate: Passive Activity & Section 199A
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Definition of self-rental property - both for Sections 199A and 469Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2Form 8582 (passive activity)The flow-through entity grouping electionIllustrative examples and consequences of failing to comply with the reporting standardsSelf-rental property and "former passive activities" rules
Seeing Beyond the Numbers: Analysis for CFOs & Controllers
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Purpose of Financial Statement AnalysisComparing Actuals vs. Expectations & BenchmarkingCase Studies 1 & 2Ratio AnalysisCase Study 3Analysis of Statement of Cash FlowsCase Studies 4 & 5Other Uses of Ratios
2025 Annual Update for Governments & Not-for-Profits
-
Webcast Only
8.00 Credits
The major topics that will be covered in this course include:New GASB standardsGASB 100, Accounting Changes and Error CorrectionsGASB 101, Compensated Absences.Accounting Standard Updates issued by the FASBNot-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on.Yellow Book and Single Audit engagements.Changes in the 2024 Compliance SupplementChanges to the Uniform GuidanceCommon deficiencies identified by the federal agencies and peer reviewers.
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
Hot Topics Accounting Update
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:New accounting standards.The impact on Financial Reporting.Hot topics in financial reporting.Current and emerging US GAAP requirements.
Mastering the Art of Conflict: CPA Transformative Strategies
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Common conflicts CPAs faceThe impacts of having/not having crucial conversations Learn your conflict style and how to elevate your conflict capabilitiesIdentifying conflict triggersBest practices using an integrated approach from Crucial Conversations, Fierce Conversations, and Leading with Questions.Interviews from CPAs and real-life scenarios they faced and what crucial conversation approaches they used.
Fraud & Embezzlement: Case Studies from the Trenches
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:How organizations can find themselves defrauded due to lax oversight and weak internal controls.How the existence of the "trusted advisor" creates situations where CPAs can drop their professional skepticism.Illustrations of the issues companies should look for in preventing fraud and embezzlement.
Navigating IRS Collections: The Collection Process
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of the IRS collection process.Taxpayer rights and the Taxpayer Bill of Rights.Collection due process and appeals.Installment agreements and offers in compromise.Wage garnishments, levies, and liens.Penalties and interest.
Form 706 Preparation Part 3: Reporting Deductions 25-26
-
Webcast Only
2.00 Credits
How to report funeral and administrative expenses on Schedule J and/or L How to report debts, mortgages and liens on Schedule K Marital deduction and elections, QTIP, Reverse QTIP, QDOT, over-stated marital deductions Charitable deduction Schedule O and potential problems
Unlock the Power of AI with Copilot in Excel
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to Copilot in ExcelAutomating Tasks and Enhancing ProductivityAdvanced Data Insights with Copilot
Fraud?How to Find, How to Prevent 25-26
-
Webcast Only
4.00 Credits
Fraud and its impact on our clients Fraud prevention Internal controls Fraud risks Fraud prevention tips
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!