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.
ChatGPT and Advanced Financial Analysis for Accountants
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Financial Modeling with ChatGPT IntegrationAdvanced Ratio Analysis TechniquesRisk Assessment and Scenario AnalysisValuation Methods and ChatGPT ApplicationsUtilizing Performance Metrics in Financial AnalysisData Analysis and Interpretation with AIInvestment Analysis Enhanced by ChatGPT
Enterprise-Wide Risk Management in Accounting and Finance
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Enterprise-wide risk management best practices for identifying, evaluating, and determining how to respond to relevant risks.The importance of risk and uncertainty disclosures in the preparation and fair presentation of financial statements, including evolving risks with cybersecurity and ESG.Coordinating risk management efforts, including the required involvement of corporate governance.How to embed risk management into day-to-day accounting and finance activities.
Navigating IRS Collections: The Collection Process
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of the IRS collection process.Taxpayer rights and the Taxpayer Bill of Rights.Collection due process and appeals.Installment agreements and offers in compromise.Wage garnishments, levies, and liens.Penalties and interest.
2024 Revision to Government Auditing Standards Impact
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Key changes made by the 2024 Revision to Government Auditing StandardsReview when the GAGAS requirements are applicable to a financial statement auditWhen reporting on key audit matters may apply in a GAGAS auditClarifications related to the independence requirements in a financial statement audit imposed by the 2024 Yellow BookReview the impact of the Quality Management Standards to a financial statement audit conducted under the 2024 Revision to Government Auditing StandardsOther important matters contained in the 2024 Government Auditing Standards related to financial statement audits
Accounting and Disclosure Issues After a Natural Disaster
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Current and noncurrent asset impairment. Insurance claims and related recoveries. Debt and liquidity issues. Government assistance and relief. Subsequent Events. Lease modifcations. Other matters.
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
What You Can Learn From the Statement of Cash Flows
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Preparation of the statement of cash flowsImportance of identifying sources and uses of cash in financial reportingFinancial statement analysisCash-related financial statement disclosures
Understanding Internal Control Constructs
-
Webcast Only
4.00 Credits
The major topics covered in this course include:Underlying concepts of internal controlThe importance of control measure interdependency
Compilation, Preparation and Review Basics and Peer Reviews
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Basic requirements included in AR-C Section 60, General Principles; AR-C Section 70, Preparation of Financial Statements; AR-C Section 80, Compilation Engagements; and AR-C Section 90, Review of Financial Statements.New requirements included in SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions.Common peer review findings.Practice tips for high-quality engagements.
The CFO Who Went to Prison
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:The importance of valuesIdentifying successEthical dilemmasMitigation strategiesCreating tools to help make better decisionsPersonal accountability strategies
CFO & Controller Critical Skills: Budgeting & Forecasting
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of budgeting toolsOverview of difference between budgeting and forecastingExamples of various budgeting and forecasting techniques
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.
Microsoft 365: Save More Time, Make More Money
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Appreciate the full potential of Microsoft 365 to drive efficiency in your businessLearn best practices for harnessing the power of Microsoft 365 Design your Teams app setup to meet the unique attributes of your businessUse SharePoint and OneDrive to organize your files and share them securely internally and externallyOrganize your thoughts, meeting notes and other content centrally in OneNoteManage your projects, large and small, with the Planner appDeploy the Stream app to document processes efficiently and effectively Bonus Content: Understand how to harness the power of AI with Microsoft Copilot
2025 Not-for-Profit GAAP Update
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Accounting Standard Updates issued by the FASB.Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on.
Unlock the Power of AI with Copilot in Excel
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to Copilot in ExcelAutomating Tasks and Enhancing ProductivityAdvanced Data Insights with Copilot
AI Privacy, Security, and Compliance Masterclass
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction: What is AI Security, Privacy and Compliance (AISPC)?Why AI Security, Privacy and Compliance (AISPC) is Increasingly Important for AccountantsAISPC Policy Best PracticesKey Tactical Questions for Addressing Data Security and PrivacyOpenAI and Compliance with Government RegulationsOpenAI and Two-Factor AuthenticationOther OpenAI Security, Privacy and Compliance ConsiderationsBest Practices for Secure Data Sharing with GPT How to Create a GenAI and ChatGPT Usage Policy for Your OperationsGeneral AI Policy Do’s and Don’tsAI Copyright Compliance & Protection GuideDeepfakes and Synthetic Media: A New Frontier for Fraud and MisinformationFrom Financial Oversight to AI Governance: The Sarbanes-Oxley Legacy and Accountants' New Frontier in AI Security, Privacy, Compliance and EthicsKey Takeaways
Noble Leadership: An Ethical Approach
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Leadership DefinitionVirtue EthicsRelationship of Virtue Ethics to LeadershipCharacteristics of the Noble LeaderActions to create a culture of respect and dignity
Tech It to the Next Level: Slim Your Team for Max Efficiency
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:How to leverage tech and automation to fill workflow gaps, How to build a strong tech stack, and connect tools seamlessly.How one proven tech stack replaced more than half a traditional team while improving client satisfaction and reducing overhead.
The Role of Internal Control in the Risk-Based Audit
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Specific matters auditors should consider when obtaining and documenting an understanding of the client's internal control systemDevelopment of a tailored audit approach that considers the potential reliance on internal controlsGuidance for establishing an adequate basis for reliance on internal controls of less formal, smaller clients