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!
Surgent's Excel: Mastering PivotTables
-
Webcast Only
2.00 Credits
Explore PivotTable capabilities and functionality Retrieve data from a database and feed it into the PivotTable Pull web tables from web pages into Excel
How AI Fits into the Accounting World
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:An overview of AI constructs.How artificial intelligence is being used by accountants today.Accounting-centric AI developments on the horizon.
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
Professional Ethical Considerations for CPAs
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Core principles of any Code of Professional Conduct applicable to all CPAs, including conflicts of interest, preparing and reporting information, competence, confidential information, and moreThe importance of maintaining independence for CPAs in public practice, especially when also performing nonattest services for the attest client Comparing and contrasting various ethical standards, including those promulgated by the AICPA, PCAOB, and international bodies
Surgent's Excel Budgeting Ideas
-
Webcast Only
2.00 Credits
Set up an in-cell drop-down list of budget methods Change the calculations in the cells based on the selected budget method Use names in worksheets
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
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
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
AI Revolution: The Big Picture for CPAs
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of AI and its evolution in businessDeep dive into generative AI and its applicationsImpact of AI on accounting, tax and finance sectorsFuture trends and opportunities for CPAsPreparing for the AI-driven business environment
Improve Spreadsheets by Building Controls in Excel
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Learn best practices when designing your spreadsheets How to create a proper worksheet structureLearn to use Excel's built in features to find errorsHow to create your custom controls to prevent and find errorsUsing links to quickly move to controlsUsing Conditional Formatting to highlight errors
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.
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
GPT Builder for Accountants
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to GPT Builder platform and interface for accounting professionalsCreating accounting-specific custom instructions and knowledge basesImplementing financial data analysis capabilities through GPTsDesigning GPTs for tax preparation assistance and compliance checkingBuilding client communication tools with accounting terminologyEnhancing bookkeeping efficiency with automated GPT workflowsSecurity and confidentiality considerations for financial data
How SAS Nos. 134-145 Improve Risk-Based Audits
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement auditsEnhanced required by-product communications with management and those charged with governance to promote more reliable financial statementsClarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimatesNew definitions and requirements related to identifying and evaluating risks of material misstatementOther important matters contained in SAS Nos. 134-145
Todd and Julie Chrisley Go to Prison
-
Webcast Only
2.00 Credits
Major topics covered in this course include:What is bank fraud?What is wire fraud?Role of financial service professionals in combating tax evasion and white-collar crimeRed flags indicating of white-collar crimesImportance of knowing customersCriminal justice proceedingsRelationship between victim impact and sentencingRelationship between loss amounts and sentencing
Ethics: 10 Crucial Qualities of High Character CPAs
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Discover why the ten crucial qualities of high-character CPAs are essential to your successLearn how to evaluate these qualities in job candidates and why you must do so
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
Ethics Case Studies: Remaining Ethical in the Age of Oversharing
-
Webcast Only
2.00 Credits
Risks Associated with Social MediaSections of the AICPA Code of Professional Conduct That Might Be Violated Using Social MediaCase Study Discussions
Guide Strategy, Attract Investments with Financial Forecasts
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to Financial Statement ForecastingOverview of the importance and benefits of forecasting for strategic planning and investment attraction.The Forecasting Process: Steps to project future income, expenses, and resources using historical data and market trends.Analyzing Historical Data: Methods for leveraging past financial data to inform future projections.Incorporating Market Trends: How to integrate market insights into financial forecasts.Forecasting Profitability: Techniques for predicting future earnings and their implications for budgeting, cash flow management, and investment planning.Forecasting the Balance Sheet: Approaches for predicting future financial positions, including growth potential, solvency, and capital structure
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