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.
Technology Trends Update for CPAs with John Higgins
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Role of cloud computing as the foundation for all tech trendsBig data and data analytics the new frontier for CPAsWorkflow automation with RPA, ML and AI with a focus on ChatGPTBlockchain technology, the revolutionary data storage modelCryptocurrency 15 years later, an update on the market and technologyMetaverse - what's it all aboutCloud based financial and ERP software market update
2025 Annual Update for Not-for-Profit Accountants & Auditors
-
Webcast Only
8.00 Credits
The major topics that will be covered in this course include:The Not-for-Profit Advisory Committee (NAC).Accounting Standards Updates (ASUs).Year 2 considerations of the leases standard.Common nonprofit deficiencies identified in peer review.What's going on at the AICPA.
Accounting for and Auditing Cryptocurrency & Digital Assets
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Common applications related to initial recognition and measurement, subsequent measurement or derecognition, presentation, and disclosure of cryptocurrency and other digital assetsFeedback from the AICPA's Digital Assets Working Group intended to assist auditors with opining on these digital records
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.
ChatGPT and Complex Financial and HR Conversations
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Complex and nuanced communications related to:Budget Allocation and Negotiation TechniquesCompensation and Benefits StructuringManaging Financial Performance and LayoffsFinancial and HR Aspects of Mergers and AcquisitionsRegulatory Compliance and Ethical Financial PracticesStrategies for Financial Crisis ManagementEffective Performance Management Systems
Entertainment, Meals & Travel Expenses: Review and Update
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Definition of what qualifies as an entertainment expenseStrategies to deduct business entertainment expensesDeductibility of mealsSituations not subject to the 50% meals and entertainment reductionHow to handle automobile issues related to employer-provided parkingProper accounting for deductible vs. non-deductible expendituresThe four steps to analyze business expensesThe latest federal legislation, cases and rulings
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 - January 2026
-
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
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
Advanced Excel: Hidden Secrets and Gems
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models
Coping With the Growth of Online Fraud
-
Webcast Only
4.00 Credits
The major topics covered in this course include:The actuation of online and other cyber fraudsFraudulent acts that are initiated electronicallyAutomated and employee driven methods that can reduce cyber-fraud risk
Financial Decisions that Led Two Businessmen to Prison
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
Navigating IRS Authorizations: Form 2848 & Form 8821
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of IRS Power of Attorney (POA) rules.Form 2848: Authority to Represent Clients before the IRS.Form 8821: Accessing Tax Information Without Representation.Identifying errors and compliance risks in POA filings.Rules for revoking or updating POA authorizations.Managing authorizations through the CAF system.Electronic submissions and the IRS online authorization process.Ethical responsibilities when holding a POA.
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.
Coaching the Next Generation of CPAs
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Building a high-performing team comprised of multi-generational workers.How to effectively communicate with the millennial worker.Leveraging younger staff in business development opportunities.Measuring the productivity of a millennial workforce.
Forensic Accounting: Investigating Divorce Cases
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:The role of a forensic accountant in divorce proceedingsThe marketing of forensic accounting services to family law attorneysHow to conduct a financial investigationCommon areas to uncover hidden assets or incomeThe basic calculations in evaluating marital assetsTestifying in depositions and divorce court
Using e-Signature Software to Process Agreements-Updated
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Review of the digital document signing process.Key features to evaluate in selecting a solution.Review and distinguish top selling e-signature applications.Best practices for deploying e-signature software in your practice or business.
Comprehensive Audit & SSARS Update
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:AICPA Accounting and Review Services Committee standards update and new practice aidAICPA Auditing Standards Board standards update including recent changes to the audit and attestation standardsAICPA’s new Quality Management Standards - Overview, implementation considerations, timeline, and AICPA implementation resourcesPCAOB, IAASB standard-setting agenda and potential future AICPA ASB standards changesUpdate on AICPA’s Enhancing Audit Quality InitiativeTrends in audit quality including the DOL’s audit quality studyFrequent peer review findings and practice tips for achieving high practice qualityLatest on the DOL’s audit quality study
Exercise Your Ethics: Techniques to Improve Ethical Response
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Explore research for common answers to "what does ethics mean to you?" and examine whether those are valid.Identify common ethical barriers - reflecting the latest from the ACFE Report to the Nations.Discover ways to improve ethical response.Practice, using practical advice from leading thinkers in ethics.