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.
Complete Guide to Analyze Data with Excel PivotTables
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
LLC's & S Corporations: a Comparative Analysis
-
Webcast Only
8.00 Credits
The major topics that will be covered in this course include:Comparative analysis of LLCs and S CorporationsEntity formation, compliance, and operational structuresSelf-employment tax and its implications for LLCs and S CorporationsForm 2553 preparation and relief for late filingsRev. Proc. 2022-19 and Rev. Proc. 2023-3: analysis and applicationS Corporation eligibility errors and corrective measuresCorporate governance and formalities for both entity typesShareholder stock and debt basis for S CorporationsForms 1120S, 1065, and related schedules (K-1, K-2, K-3)Officer reasonable compensation and general partner guaranteed paymentsAudit strategies, estate planning, and business continuation planning
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Webcast Only
8.00 Credits
SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services -- 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Sample comprehensive engagement work programs for preparation, compilation and review engagements Reporting and disclosure illustrations for each level of service, including attesting on personal financial statements, prescribed form, special purpose framework and other engagement variations Other communication requirements, such as sample engagement letters and management representation letters
Finding Errors in Excel Spreadsheets
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
Bytes, Bias, and Balance: Data Ethics for Savvy Accountants
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:The transformative role of artificial intelligence (AI) in accounting and auditingEnhancing efficiency and innovation with AI toolsMitigating challenges such as overreliance, data security vulnerabilities, and ethical dilemmas
Fiduciary Taxation Part 3: Complex Trusts & Charitable Deduction 26-27
-
Webcast Only
2.00 Credits
The Differences between a Simple and Complex Trust The Use of the Tier System with Complex Trusts Review of Basic Requirements of the Charitable Contribution Deduction under IRC Sec. 642(c) Preparation of a Tax Spreadsheet for a Complex Trust Preparation of a Tax Spreadsheet for a Complex Trust with a Charitable Contribution Deduction Complex Problem Form 1041 Examples with Spreadsheets and Exhibits
Tax Practice Conduct Standards: Circular 230 and AICPA Statements 26-27
-
Webcast Only
4.00 Credits
Federal and California statutory and regulatory standards governing tax preparers: Preparer penalty provisions, Circular 230 and; AICPA Statements on Standards for Tax Services Tax shelter and reportable transaction issues in depth Attorney-client, Sec. 7525 and work product privilege issues and Kovel arrangements
The Generation-Skipping Transfer Tax and Dynasty Trusts 26-27
-
Webcast Only
4.00 Credits
Calculation of the GST tax, and how it relates to the estate tax and gift tax Direct skips, taxable distributions, and taxable terminations GST tax allocations, Reverse QTIP election, and Exempt and Nonexempt Trusts Calculating the benefit of and designing Dynasty Trusts
A&A Update for Closely Held Businesses 26-27
-
Webcast Only
6.00 Credits
Recently issued FASB Accounting Standards Updates, including those that will become effective during audit engagements conducted in 2026 Recently issued Statements on Auditing Standards and other AICPA activity Recently issued Statements on Standards for Accounting and Review Services
Top 10 Things to Know About Estate Taxation & Planning 26-27
-
Webcast Only
8.00 Credits
The Numbers: Exemptions, exclusions and discounts Portability and step-up in basis Asset valuation Deductions: Marital, charitable, transmission and administration Retirement plan assets, annuities and life insurance Trust funding and administration
Behavioral Finance Biases
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Overview of biases and standard of living riskOverview of difference between emotional and processing biasesExamples of various real life examples and case studies
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Discuss the impact of the Section 199A flow-through entities deduction on partnerships and their partnersThe meaning of a "tax basis capital account"How the financial accounting and tax capital accounts differ from one anotherDetermine a partner's share of the partnership's liabilitiesDistinguish "recourse" loans from "nonrecourse" loansWhat are "qualified nonrecourse financing" loans and how they affect partnersSection 704 "built-in gain or loss" rules and how they impact Schedule K-1 reportingSection 4655 "at risk" rules and how they impact Schedule K-1 reporting
ChatGPT for Accountants: 50+ Use Cases
-
Webcast Only
2.00 Credits
Major topics covered in this course include:Introduction to ChatGPT and artificial intelligence chatbot technologiesAutomating frequently asked questions and the onboarding processVerifying and reviewing financial recordsProviding real-time support to clientsGenerating financial reportsAutomating tax return preparation and financial planningProviding guidance on financial decision making
CPA to CFO: Essential Competencies for Finance Leaders
-
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: Top competencies hiring executives seek in CFO candidates based on survey of 320+ CEOs and recruiters Critical thinking frameworks and strategy creation techniques for financial leadership Forward-looking financial skills including capital management, forecasting, and funding strategies Industry-specific requirements for high-growth companies and nonprofit organizations Practical career development strategies to build CFO-ready competencies
Common Financial Statement Disclosures
-
Webcast Only
2.00 Credits
The major topics covered in this class include:General disclosures about the entity and its environmentCommon critical information useful to financial statement readers for making economic decisionsExplain results of operations through information that supplements the face financial statements
Cybersecurity Risk Management for Financial Professionals: Policies, Controls and Emerging Threats
-
Webcast Only
2.00 Credits
Core components of a cybersecurity risk management program Overview of key policies, controls, and procedures for financial organizations Applicability of global compliance standards, like the EU AI Act and GDPR, in the U.1`S. financial landscape Case studies: financial implications of breaches and mitigation strategies Best practices for integrating cybersecurity with financial reporting
Fiduciary Taxation Part 4: Miscellaneous Topics & AMT 26-27
-
Webcast Only
2.00 Credits
Review the Passive Activity Rules under IRC Sec. 469 as they apply to fiduciary entities The 65-day Rule and Election Under IRC Sec. 663(b) Special Rules for Specific Bequests under IRC Sec. 663(a) Alternative Minimum Tax for Trusts & Estates AMT Bracket Rates and Exemption for Fiduciary Entities Alternative Minimum Tax Spreadsheet Approach Using AMT Problem Example with Passive Activity Loss (PAL)
Schedule K-1: What is it & What do I do with it?
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of Schedule K-1 for Partnerships, S Corporations, and Estates/TrustsReporting Schedule K-1 information on Form 1040Basis limitations, loss limitations, and material participation rulesQualified Business Income (QBI) Deduction and Schedule K-1 integrationSchedules K-2 and K-3 requirements
Surgent's Forms 7217 and 7203
-
Webcast Only
2.00 Credits
Tax treatment of partnership distributions to partners of cash and property other than cash Basis of property received in a partnership distribution Executive Order 14219 withdrawing the IRS’s new regulations regarding basis shifting Organization and structure of the new Form 7217 Who must file Form 7203 Determining the S corporation shareholder’s initial basis in his or her stock Basis limitations on partnership losses and deductions Organization and structure of Form 7203 — understanding the three parts of Form 7203 Filing criteria for Form 7203 Calculating an S corporation shareholder’s share of S corporation deductions and credits Understanding stock and debt basis
Surgent's The Accounting Leaders’ Survival Guide - Strategies for Managing Organizational Change
-
Webcast Only
1.00 Credits
Learn the power of flexibility and adaptability Manage daily changes and stressors Avoid burnout and achieve work-life balance