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!
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.
Internal Control Changes for Remote Workers
-
Webcast Only
2.00 Credits
The major topics covered in this course include:The benefits and pitfalls of remote employees.How to maximize the value provided by distance workers.Policies, procedures, and control measures designed for a more geographically dispersed workforce.
Monthly Federal Tax Updates - August 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
Create Visuals in Power BI to Successfully Analyze Data
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Tour of the Power BI Desktop Interface: Understand the layout, tools, and features of Power BI Desktop.Tour of PowerBI.com Interface: Familiarize with the online environment of Power BI for report creation.Importing Power Pivot Data Model: Understand how to integrate Power Pivot models into Power BI for more complex data analysis.Building Visuals: Learn the step-by-step process to create compelling visuals and understand the importance of visual context in data storytelling.Review of Available Visuals: Explore the variety of visuals available in Power BI and their appropriate applications.Power BI Desktop Features: Delve into the advanced features of Power BI Desktop, enhancing data manipulation and visualization capabilities.Building Interactivity into Visuals: Learn to create dynamic and interactive reports that engage and inform.Publishing Reports to PowerBI.com: Gain skills in uploading and managing reports on PowerBI.com for wider access and collaboration.
Navigating IRS Collections: Overview of Form 433 & OIC
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of the IRS collection process and enforcement actions.Initial notices, taxpayer rights, and IRS timelines.When to use Forms 433-A or 433-B and required documentation.Offer in Compromise (OIC): criteria, process, and practical considerations.Payment options: installment agreements, partial payment plans, and OIC.Advising clients on IRS collections and avoiding penalties.Compliance strategies for minimizing tax liabilities.Real-world scenarios and examples for tax debt resolution.
2025 Single Audit Update
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Review of the impact of the 2024 Compliance Supplement on Single AuditsReview of the changes to the Uniform GuidanceReview of common audit deficiencies found in Single Audits
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
Controls to Secure the Growing Digital Footprint
-
Webcast Only
4.00 Credits
The major topics covered in this course include:Securing individual documentsProtecting information resident in the CloudSecuring data stored on or accessed by mobile devices
Ethics of AI: A CPA's Guide
-
Webcast Only
2.00 Credits
The major subjects that will be covered in this course include:A primer on AI technology applications in the accounting professionEthical dilemmas that originate from the use of AI by CPAsPractical guidelines for using AI technology ethicallyStep by step guide for creating an AI usage policy for your organizationReview of a variety of reference materials to assist you in using AI ethically
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
Surgent's Stock vs. Asset Acquisitions of C Corporations
-
Webcast Only
2.00 Credits
Advantages and disadvantages to buyer and seller of an asset acquisition and a stock acquisition Tax treatment of consulting agreements and covenants not to compete Sale of personal goodwill associated with an asset acquisition Tax consequences associated with a stock acquisition and an asset acquisition Acquisitive reorganizations Non-tax issues that must be considered when a corporation is acquired
Surgent's Examining ASC 842, Leases: More Than Meets the Eye
-
Webcast Only
4.00 Credits
ASU No. 2016-02, Leases (Topic 842) Overall lease accounting guidance Lessor Accounting 101 Lessee Accounting 101 Detailed review of accounting by lessees and lessors Sale and leaseback transactions Transition guidance Other operational issues Recently issued updates to the lease accounting guidance FASB guidance on accounting for COVID-19-related rent concessions Feedback from the public company adoption of Topic 842
Surgent's Four Tiers of Loss Limitations: A Guide to the Rules for Pass-Through Entities
-
Webcast Only
4.00 Credits
The Inflation Reduction Act of 2022 Tier 1: Basis limitations for S corporation shareholders and partners Tier 2: Section 465 at-risk limitations for S corporation shareholders and partners, including the impact of debt, indemnities, guarantees, and shareholder/partner agreements Tier 3: Section 469 passive loss limitations and exceptions to the limitations Tier 4: The excess business loss limitation of the Tax Cuts and Jobs Act of 2017 (new §461(l)), American Rescue Plan Act, and Inflation Reduction Act
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
Ethical Intelligence for Artificial Intelligence
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Benefits and pitfalls of artificial intelligence in the accounting professionSelecting and utilizing artificial intelligence resourcesApplying professional skepticism to resultsMaintaining independence while utilizing artificial intelligenceUpholding client confidentialityData security and retentionCitation of sources and related reporting considerationsApplication of the AICPA Code of Professional ConductEthical considerations when crafting policies and establishing best practices
Building a Better Budget in a Time of Uncertainty
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting
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.
Love it or Leave It: Engagement and Retention at Work
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Ethical Values and Engagement and RetentionEnhancing Employee engagementStrategic/Intentional Actions to Enhance RetentionGeneration X
Steps to Stop External Fraud
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Types of external fraudConsiderations as organizations work to reduce fraud riskExternal fraud and known parties/External fraud unknown perpetrators
Taking Advantage of Array Formulas in Excel
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants: This section teaches how simplify the use of static values called Array Constants