CPE Catalog & Events
CPE & Event Classes
MTCPA offers thousands of live and online courses to meet your professional development needs. Our goal is to enhance your knowledge and help you achieve even greater success.
Most MTCPA classes are available both LIVE [In-Person] and VIRTUAL [MTCPA Webcasts (in-house) or Webinars (other providers)], so please be sure to register for the correct format under the appropriate tab below.
Also check out our on-demand learning platform, allowing you to earn CPE at your convenience. You can choose stand-alone courses or opt for an all-access subscription to our entire Anytime library. Click the Anytime CPE tab below to explore the available courses!
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.
Surgent's A Guide to Gig Economy Tax Issues
-
Webcast Only
2.00 Credits
Characteristics of a gig economy Who is an employee and who is an independent contractor? Form 1099-NEC and reporting of non-employee compensation Reporting on Form 1099-K Gig workers and the requirement to pay self-employment tax throughout the year State tax implications of remote work for the business owner and workers How remote work creates state tax nexus Tax implications of employee telecommuting for the employer The “convenience of the employer” rule Drivers of both people and of meals or other products Section 199A deduction Implications of the Vizcaino case
Synchronize Your Files to the Cloud with SharePoint -Updated
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Overview of the OneDrive Sync app functionalityStep-by-step review and demonstration of how to deploy this appInstalling the Sync app on your local devicesConfiguring the files and folders to synchronize toy your local deviceManage the locally stored filesBest practice tips for using the Sync app and avoiding common mistakes
AHI: Beginning In-Charge Staff Training
-
Webcast Only
24.00 Credits
What is expected in the in-charge Plan engagements Assess risks and materiality AI for accountants Meet client needs Complete engagements Review assistants' work Supervision
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
Monthly Federal Tax Updates - October 2025
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Current individual tax issuesCurrent business entity tax issuesAny current tax legislation occurring during the periodOther issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues
Ethical Responsibilities for CPAs: Ethics 25-26
-
Webcast Only
4.00 Credits
Ethical Responsibilities for CPAs The AICPA Code of Professional Conduct PCAOB Ethical Standards The Sarbanes Oxley Act The Foreign Corrupt Practices Act Circular 230 for Tax Practitioners The Dodd-Frank Banking Reform Act
Tax Aspects of Stock Investing 25-26
-
Webcast Only
4.00 Credits
Active and passive investing Dividend-paying stocks, value stocks, and the net investment income tax Favorable capital gain strategies and the netting process Exchange-traded funds (ETFs), stock options, and straddles
2025 A&A Update With Technology Implementation
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Deep dive into the Accounting Standards Updates (ASUs) effective in 2025.Insights from the FAF's 2024 PCC Review.Overview of FASB's Invitation to Comment - Agenda Consultation.The essential changes in quality management standards that firms must implement by the end of 2025. Common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB).
Ethics at Work: Diversity, Equity and Inclusion
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Overview of ethicsEthical values and principlesDEI working definitionsUnconscious bias, assumptions, microaggressionsStanding Up and Speaking OutDEI and Organizational Responsibility
Talk This Way - Communication Skills for the CPA
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Pervasive best practices for effective communicationSpecific strategies for written materialsUnique considerations for verbal presentationsThe importance of recursive revisionTips for successPitfalls to avoid
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
Risk Assessment Under SAS No. 145: The Key to Audit Quality?
-
Webcast Only
2.00 Credits
The topics that will be covered in this class include:New concepts due to the issuance of SAS No. 145Revised requirement to separately assess inherent risk and control riskA new definition of significant risk New emphasis on IT controls and risk of material misstatementNew guidance on maintaining professional skepticismRevised requirements to evaluate the design of certain controlsRevised requirements regarding audit documentationNew guidance on scalability
Implementing an AI-Enabled Marketing Strategy for Your Firm
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Module 1: Introduction to AI in Marketing The Basics of AI – Concepts and TerminologyModule 2: Leveraging AI Tools and Technologies Overview of AI Tools for MarketingModule 3: Practical Strategies for AI Integration Integrating AI into Your Marketing WorkflowModule 4: Measuring AI-Driven Marketing Effectiveness Key Metrics for Assessing AI-Driven CampaignsModule 5: Real-Life Case Studies and Success Stories Case Studies of Firms Successfully Using AI in MarketingModule 6: Developing Your AI-Enabled Marketing Strategy Creating a Custom AI Marketing Strategy
Power BI - Bringing It All Together for Data Analysis
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include: Building a Comprehensive Workflow in Power BI: Streamline and enhance your end-to-end data processes for improved efficiency and clarity.Exploring What's Next After Creating Data Models and Measures: Understand advanced strategies to further enhance the value of your existing data models.Best Practices for Performance Optimization: Learn key tips to ensure smooth, fast, and reliable performance in your existing data models.Leveraging Your Data Model Through PowerBI.com/Power BI Services: Explore advanced functionalities of Power BI Services to make your data insights more accessible and impactful.
Surgent's Comparing and Contrasting Retirement Plans for Small- and Medium-Sized Businesses
-
Webcast Only
2.00 Credits
Factors business owners should take into account when choosing a retirement plan SIMPLE plans Simplified employee pension plans 401(k) plans Defined benefit plans Ensuring eligible employees are covered Employees’ impact on choice of plan Ongoing compliance requirements Establishing a plan after the tax year end Changes to safe harbor 401(k) plans Pooled employer plans Defined benefit plans and cash balance plans
Surgent's Privacy and Security Training: Obligations of Confidentiality and Safekeeping
-
Webcast Only
2.00 Credits
Obligations of confidentiality and safekeeping Security best practices to apply beyond work Likely causes and effects of a large-scale cyberattack Email security best practices Remote work security Mobile device security Internet of Things (IoT) risks Public Wi-Fi risk and the importance of using a VPN Recognizing and avoiding text message/phone call phishing Data loss prevention (DLP)
Surgent's Tax Reporting for Executive Compensation
-
Webcast Only
2.00 Credits
Nonqualified deferred compensation (NQDC) Nonqualified stock options (NQSOs) Incentive stock options (ISOs) Restricted stock/restricted stock units (RSUs) Stock appreciation rights (SARs) and phantom stock Employee stock purchase plans (ESPPs) Applicable tax forms and schedules Stock sale reporting Estimated taxes Filing deadlines and extensions State taxation
AI Prompt Engineering Masterclass for Accountants
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to Prompt Engineering: Basics of structuring effective prompts for meaningful AI responses.Understanding AI's "Lazy" Defaults: Why LLMs provide basic answers and how to push them to deliver richer insights.Multi-Layered Prompting: Techniques to encourage AI to provide responses across beginner to expert levels.Candid and Contrarian Responses: Using prompts that elicit honest and balanced insights, even on controversial topics.Ripple Effect and Cobra Effect: Probing the broader impacts and unintended consequences of financial decisions.Avoid Stupidity Checklist: A practical prompt for reducing mistakes in AI-assisted accounting tasks.Role-Based Perspective Prompts: Crafting prompts that guide AI to respond from specific professional viewpoints.Automation Ideas: Leveraging AI to optimize repetitive accounting tasks.Emotion-Driven Prompting: Exploring how emotion-focused prompts can enhance AI performance and engagement.Practical Applications in Accounting: How to apply prompt engineering in real-world financial analysis and decision-making.
Surgent's Fundamentals of Public Charity Taxation and Form 990
-
Webcast Only
4.00 Credits
Organization and structure of Form 990 Form 990 and its various schedules Form 990 filing requirements The public support tests Taxation of unrelated business income Compensation-related reporting issues