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!
Ethical AI Practices for CPAs: Ensuring Responsible Use
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Understanding ethical implications of AIData privacy and security considerationsCompliance with regulations and professional standardsDeveloping ethical AI policies and procedures
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 Understanding S Corporation Taxation: Shareholder Basis, AAA, and Retained Earnings
-
Webcast Only
2.00 Credits
S corporation earnings layers Observations on earnings layers S corporation basis calculation IRC 351 transactions Four loss tiers Appreciated property distributions
Shortcuts that Excel Users Love
-
Webcast Only
2.00 Credits
The major topics covered in this course include:The power of keyboard shortcutsOft used features with more capability than meets the eyeNew helpful featuresNote: This session is taught using Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.
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
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:The rules of IRS disclosure of tax informationUnderstanding the role of IRS transcriptsInterpreting the actions of the IRS in transcriptsFOIA requestsAnalyzing tax information and returns for financial leads
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
CPA to CFO
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:The steps necessary to effectively transform a tax or accounting practice into an advisory service.What it means to be a CFO/advisor to small-to-medium sizes businesses.What qualifications are necessary to offer an advisory service.How to find and convert leads and how to price and package services, including combining advisory services with the firm’s current offerings.
Ethics: How to Give and Receive Criticism the Right Way
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Entertaining lecture by a professional presenter, illustrated with relevant video clips and photographs, to cover the main points of the webinarWriting exercises, so you can see how these lessons apply to your own CPA practice and personal lifeTrue stories about CPAs and other leaders to show what can happen when apologies and criticism are done right, and the pitfalls of doing them the wrong way
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
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
Integrity, Objectivity and Judgment: Values in Action
-
Webcast Only
1.00 Credits
The major topics covered in this class include:AICPA Code of Conduct: Integrity and ObjectivityCase Study: Mortgage crisis of 2007-2010Case Study: World Com
Build Better Budgets: Fundamental Techniques
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Advantages of budgetingThe role of budgetingMaster budgetingFlexible budgetingStandards and variancesCapital budgeting
A Culture of Regulatory Ethics: A Competitive Advantage
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Does it pay for a company to have strong ethics?Can you measure the financial impact of ethics?Does ethics make a difference in financial performance?Can ethics be used as a competitive advantage?What sets the CPA designation apart?AICPA Code of Professional Conduct & the Conceptual Framework ApproachEthics as a marketing toolPersonalizing your Code of EthicsFour building blocks of ethical cultureWhat influences employee behavior?Ethical researchBuilding trust in organizationsMaintaining objectivity in difficult situations
Surgent's Annual Accounting and Auditing Update
-
Webcast Only
8.00 Credits
Recently issued FASB Accounting Standards Updates, PCC Update and items on the FASB’s Technical Agenda Leases – Topic 842 Recently issued ASUs covering common control leases, crypto assets (e.g., cryptocurrency), and income tax disclosures ASC 326: CECL Review of SAS 142 – Focus on Audit Evidence Recently issued SASs and other AICPA activity SSARS No. 25 and other recently issued SSARS Detailed review of SAS 145 Other important A&A practice matters
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.
CFO Solutions to IRS Problems
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:The authority of IRS in assessing and collecting taxes.The common misconceptions when dealing with IRS.Common questionable actions by business owners.How to prepare for an IRS audit.The seven options in IRS collections.Possible criminal tax violations by CFOs and small business owners.
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.
The Ethics of Care in the Workplace
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Ethical Values and PrinciplesCompassionManaging ExpectationsRespect and HumilityAttribution Theory
Synchronize Your Files to the Cloud with SharePoint -Updated
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Overview of the OneDrive Sync app functionalityStep-by-step review and demonstration of how to deploy this appInstalling the Sync app on your local devicesConfiguring the files and folders to synchronize toy your local deviceManage the locally stored filesBest practice tips for using the Sync app and avoiding common mistakes