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.
Overcoming Tech Adoption Challenges in CPA Firms
-
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: Five critical technology adoption challenges facing CPA firms today Digital maturity assessment models and implementation frameworks AI integration strategies for tax, audit, and advisory services Cybersecurity considerations and risk management protocols Case studies of successful technology transformations in accounting firms
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
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
Comprehensive Pass-Through Owners” Basis and Distribution Rules 26-27
-
Webcast Only
8.00 Credits
Understand the four loss limitation rules applied on the owner's individual income tax return (i.e., basis, at-risk, passive, and excess business loss limitations) Determine how to calculate an owners" initial tax basis of his pass-through entity Learn how to correctly make annual adjustments to a pass-through owners" tax basis Identify what constitutes a debt basis for an S corporation shareholder Learn the tax ramifications of repaying loans to S corporation shareholders
Retirement Advising: Accumulation and Decumulation Strategies 26-27
-
Webcast Only
8.00 Credits
The downside of traditional retirement asset accumulation strategies Threats to a successful retirement Holistic retirement planning: how personal goals integrate with tax, estate, risk, and investment management principles Matching investment assets with the appropriate retirement plan and distribution strategy Review recent legislation, including the changes for seniors in the One Big Beautiful Bill and the provisions of the SECURE Acts, and how they will impact retirement planning
CFO Solutions to IRS Problems
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:The authority of IRS in assessing and collecting taxes.The common misconceptions when dealing with IRS.Common questionable actions by business owners.How to prepare for an IRS audit.The seven options in IRS collections.Possible criminal tax violations by CFOs and small business owners.
Executive Presence, Personal Brand: Structure Your Narrative
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Components of executive presenceAudience-centered elevator pitch structureProfessional value proposition frameworkStructuring a concise executive biographyAligning personal narrative with organizational valueCommon pitfalls in professional self-presentationApplication and refinement exercise
Adobe Acrobat Tips for Working with PDF Files
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Review of all that Adobe Acrobat has to offerOrganizing your PDFs with bookmarks, links, file attachments and moreFormatting the presentation of PDFs with headers, footers and watermarksCreating and processing fillable formsProcessing documents for e-signatureTips for converting email messages, documents and spreadsheets into PDF formatCombining multiple PDF files into a single binder Utilizing the security features of Adobe Acrobat to protect document confidentiality
No Tax on Overtime: Payroll Compliance
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of the Fair Labor Standards Act (FLSA) overtime provisionsDefinition of a “workweek” and the 40-hour thresholdTime-and-a-half requirement and exclusions from overtime payExempt vs. nonexempt employee classifications (executive, administrative, professional, and industry-specific exemptions)Excluded payments (discretionary bonuses, reimbursements, retirement contributions)Step-by-step calculation examples for different compensation structuresBest practices for documentation and payroll systemsCase studies illustrating misclassification and miscalculation issues
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.
Erase the Mark: Best Practices in Penalty Abatement
-
Webcast Only
2.00 Credits
The major topics covered in this course include:The authority of the IRS in assessing tax penalties.The types of penalties that can be removed.The process the IRS uses to evaluate penalty abatements.How to request penalty abatements.Best practices in asking for penalty abatement, including using appeals.
Surgent's Understanding S Corporation Taxation: Compensation Issues and Entity-Level Taxes
-
Webcast Only
2.00 Credits
Reasonable compensation Fringe benefits for S corporation shareholders Built-in gains tax Excess passive income tax Notice 2020-75: PTE elections
Master the Art of CPA Communication: Boost Your Influence!
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Techniques for simplifying complex financial information for clients and stakeholdersPersuasive communication principles aligned with CPA rolesBuilding and maintaining trust and credibility with diverse stakeholdersCase studies and Interviews with Finance, Accounting and CPA professionalsDeveloping empathy and emotional intelligence in communicationsBest practices for active listening to strengthen client relationshipsApplication of Influencer principles for impactful change in communication
Professional Ethical Considerations for CPAs
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Core principles of any Code of Professional Conduct applicable to all CPAs, including conflicts of interest, preparing and reporting information, competence, confidential information, and moreThe importance of maintaining independence for CPAs in public practice, especially when also performing nonattest services for the attest client Comparing and contrasting various ethical standards, including those promulgated by the AICPA, PCAOB, and international bodies
Surgent's Applying the Yellow Book to a Financial Statement Audit
-
Webcast Only
4.00 Credits
Circumstances requiring auditors to follow the Yellow Book (Government Auditing Standards or GAGAS) Relationship of Yellow Book requirements to GAAS and single audit requirements The Yellow Book requirements related to the performance of and reporting on a financial audit Identifying and reporting findings under the Yellow Book
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
Accountants and Malpractice: Can We Get Sued for This?
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:How accountant liability is a very real threat in today's litigious society.A discussion of scenarios in which accounting professionals can find themselves inadvertently involved in a lawsuit.Pitfalls in which the accountant may find him- or her- self while dealing with clients.Real-life examples from the speaker's extensive experience as a practitioner and as an expert witness in accounting malpractice cases.
Surgent's Contract Law for Accounting and Finance Professionals
-
Webcast Only
2.00 Credits
Contract formation The necessary components of an enforceable contract Common defenses to enforcement Legal capacity requirements Contract interpretation
Enterprise-Wide Risk Management in Accounting and Finance
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Enterprise-wide risk management best practices for identifying, evaluating, and determining how to respond to relevant risks.The importance of risk and uncertainty disclosures in the preparation and fair presentation of financial statements, including evolving risks with cybersecurity and ESG.Coordinating risk management efforts, including the required involvement of corporate governance.How to embed risk management into day-to-day accounting and finance activities.