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.
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
SSARS Practice Issues and Standards Update 25-26
-
Webcast Only
4.00 Credits
Review of applicable SSARS standards, including standards updates Review of AICPA professional ethics requirements In-depth discussion of non-attest services Review of independence issues for SSARS services Overview of SSARS #21 performance, documentation and other requirements Detailed analysis of preparation vs. compilation engagements Detailed analysis of review engagements
Advanced Cybersecurity - Beyond the Basics
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Understanding Cyber Threats and Risks in FinanceCybersecurity Frameworks and Best Practices for Financial ProfessionalsFinancial Data Security and Encryption TechniquesCybersecurity Auditing and Forensic InvestigationsEmerging Technologies and Trends in Financial CybersecurityLeadership and Governance in Cybersecurity for Financial Executives
Behind the Curtain: Exploring IRS Audit Technique Guides
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of ATGsBest practices for utilizing ATGsSalient provisions of selected ATGsInsights auditors may obtain from analytical proceduresNuances associated with selected industries
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.
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
Generative AI Strategy for Accountants
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Evolution and current state of AI technologies in accountingDevelopment of comprehensive AI usage policies and guidelinesImplementation frameworks for integrating AI into accounting workflowsStrategic approaches to AI-driven process automation and optimizationMethods for identifying and capitalizing on AI opportunitiesBest practices for human-AI collaboration in accountingRisk management and ethical considerations for AI implementation
Ethical Considerations in Working with Cannabis
-
Webcast Only
1.00 Credits
The major topics covered in this class include:Framework for assessing the propriety of offering services within the state legal, regulated cannabis industryAssist in identifying key stakeholders to be considered in conjunction to providing cannabis industry services, including:partnersstaffclientsBanking relationshipsMalpractice insurance
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
Integrate ChatGPT into Your Client Advisory Services-Updated
-
Webcast Only
2.00 Credits
The major topics covered in this course include:ChatGPT and generative AI technology primerBuilding your generative AI vocabularyDig deeper into your engagement research to develop a higher quality advisory servicePolish your client reporting with the help of ChatGPTDeveloping your ChatGPT client advisory servicesStart with client education. You don’t need to be a technical expert to be an educatorUse AI to help your clients automate their workflows / business processesBuild better spreadsheets with ChatGPT and ExcelHelp your clients identify, evaluate and select applications for their business
Invest in Your Mental Health and Avoid Burnout
-
Webcast Only
2.00 Credits
The major topics covered in this course include:How to recognize burnout and evaluate where you are on the burnout scale.How impostor syndrome drives coping reactions of overworking, over preparing and perfectionism.How mindfulness can reduce stress and save time.Silencing the critical inner voice.Tools to help you become more attuned to your needs and emotions.How attending to and regulating your nervous system impacts your mood and well-being.
Operations Level Internal Control
-
Webcast Only
4.00 Credits
The major topics covered in this course include:An overview of controls that drive proceduresConsiderations for procedural control developmentUnderstanding and controlling risk that arises when organizations change
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
2025 Governmental GAAP Update: Navigating GASB Standards
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:New GASB standards:GASB 100, Accounting Changes and Error Corrections.GASB 101, Compensated Absences.Practical case studies.
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.
Retirement Planning: Next Stage for You or Your Client
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Welcome to Your Next Stage -- Developing a new perspective on what this next stage is really all aboutIt's About Time -- Discovering a new sense of purposeMoney Matters -- Assessing your financial conditionsRelationships Matter Too -- Addressing needed or potential changes in your relationshipsHealthy Habits -- Examining new or renewed ways to stay healthyWho I Am -- Creating a new identity, and answering "So what do you do?"My Master Plan -- Figuring out what to do next
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.
Accounting of the Soul: Making the World a Better Place
-
Webcast Only
1.00 Credits
The major topics covered in this course include:Overview of Virtue Ethics and the Common GoodProfessionalismThe Virtue of CompassionGossip in the WorkplaceGratitude
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 Governmental Accountants & Auditors
-
Webcast Only
8.00 Credits
The major topics that will be covered in this course include:GASB 100, Accounting Changes and Error Corrections.GASB 101, Compensated Absences.Yellow Book and Single Audit engagements.Yellow Book independence requirements.Changes to the Uniform Guidance.2024 Compliance Supplement and the common deficiencies identified by the federal agencies and peer reviewers.