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!
How Fraud Can Affect Smaller Organizations
-
Webcast Only
4.00 Credits
The major topics included in this course include:The reasons for fraudFraudulent acts that are initiated against smaller organizationsMethods to stop fraud attempts against small businesses
Income Tax Analysis: Exploring In-Depth Concepts
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to GAAP and IRC FrameworksKey Differences Between Financial Reporting and Tax ReportingUnderstanding Timing DifferencesRecognition of Revenue and Expenses Under GAAP vs. IRCDiscussion of Deferred Tax AssetsImpact of Deferred Tax LiabilitiesPermanent vs. Temporary DifferencesReconciliation of Book Income to Taxable Income
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
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
Recruit. Retain. Engage. Mastering LinkedIn for HR Success
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:How to pro-actively find, identify, and connect with new candidates from various sources within LinkedIn.Best practices for organically attracting candidates to your company and team.Strategic talent networking opportunities.Essential considerations of employee advocacy and brand building using LinkedIn.Retention strategies such as promoting a positive work environment, and expanding employee recognition and engagement strategies.
Money Laundering 101 for CPAs
-
Webcast Only
4.00 Credits
The major topics covered in this class include:The theory of money launderingCommon money laundering statutesExamples from court cases of money laundering statutesCommon occurrences with CPAsPossible money laundering transactionsApplying the money laundering statutes in real life scenarios
Individual Tax Update: Recent Developments
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:2025 Tax Provision SunsetsResidential Energy CreditVirtual currency reporting and Form 1099-DAStudent loansRecent individual taxpayer case rulings
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
Internal Control - Testing for Operating Effectiveness
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Generally accepted audit requirements related to testing controls for operating effectivenessIdentifying key controls that may prove effective and efficient to test in a control reliance strategyResponses when deviations are discovered when evaluating the design or operating effectiveness of internal controlLeveraging audit evidence available for Service Organization Control (SOC1) ReportsGeneral computer control considerations when evaluating the design and operating effectiveness of internal control over financial reporting
Installment sales: Maximize Tax Benefits and Stay Compliant
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Installment sale treatment eligibilityWhen to elect out of installment sale treatmentInstallment sale of business assetsInstallment sale default and the rules for personal property versus real propertyInstallment sales and depreciation recapture
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
How to Audit Inventory
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Auditing Inventory.Related Audit assertions, risks, and threats to inventory.Substantive auditing procedures that staff should perform.
Ethics: IRS Criminal Investigations: Key Lessons for Accountants
-
Webcast Only
2.00 Credits
Snapshot of IRS Criminal InvestigationsGeneral tax fraudAbusive tax schemesRefund fraudEmployment tax fraudIdentity theftData compromisesMoney launderingPublic corruptionCorporate fraudGeneral fraudsCyber crimesGlobal tax and economic crimesNarcotics, counter-terrorism and transnational organized crimeSelected Field Office Case Files from Across USNew EnglandMiddle AtlanticEast NorthCentralWest North CentralSouth AtlanticEast South Central West South CentralMountainPacificHow accountants can add value to their operations by aiding law enforcement and fighting economic crime
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.
Disrupt to Dominate: Mastering Change Leadership
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:The urgency of leading change now & the steps in leading changeThe power of crafting a vision that encourages buy-inThe art and science of building strong partnershipsAccelerating change through relationship networksCommunication strategies for changeEstablishing a feedback culture for successful changeManaging self in times of changeCase studies and real-world scenarios
How Much Are Your Ethics Worth?
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Understanding ethicsAvailable tools to aid in ethical decision makingThe role of bias in making ethical decisionsApplication through case studies
Mastering the Excel Lookup Functions
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
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
Keeping Up with the FASB
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Review of current items on the FASB agendaDiscuss the new revenue recognition standardProvide an update on the new lease accounting standardAddress U.S. GAAP alternatives for certain entities
Business Partnerships: Managing Supplier Relationships
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Overview of supplier contractsCase studies of successful and not-so-successful supplier relationshipsRisk potentials