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 Select Estate and Life Planning Issues for the Middle-Income Client
-
Webcast Only
4.00 Credits
Changes to the lifetime estate tax exemption in light of proposed regulations SECURE 2.0 updates More than 20 documents that should be reviewed that are neither a will nor trust Provisions you need in a will Trusts and other arrangements for children Durable powers of attorney for healthcare and for financial matters Realistic retirement goals Developments relative to estate tax, and the implications for planning
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
Surgent's Introduction to Required Minimum Distributions
-
Webcast Only
2.00 Credits
How SECURE Act 1.0 and SECURE Act 2.0 changed the RMD rules What is an RMD? Who is subject to RMDs? The types of accounts subject to RMDs How to calculate an RMD How to determine if a distribution can be an RMD How to determine which life expectancy table must be used when calculating an RMD The rollover and transfer rules during an RMD year IRS penalties for non-compliance with RMD regulations Applying RMD strategies to different plan types When RMDs can and cannot be aggregated How to correct an RMD shortfall How to get a waiver of the excise tax on an RMD failure The tax implication of an RMD How to donate an RMD tax-free How to determine the RMD rules that apply to a beneficiary
Build a Data Model for Analysis in Power BI
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Data Modeling Essentials: Understanding the core concepts of data modeling in Power BI, including integration of various data sources.Building Relationships: Techniques to establish and manage relationships between different data sets.Calculated Columns and Basic DAX Measures: Introduction to DAX (Data Analysis Expressions) and its application in creating calculated columns and basic measures.Calculated Columns vs Measures: Insights into when to use calculated columns and when to opt for measures.Explicit vs Implicit Measures: Understanding the difference and appropriate application of explicit and implicit measures in data analysis.Hierarchies in Data: Creating and utilizing hierarchies to enhance data analysis and reporting.Using Pivot Tables to Validate Measures: Practical skills in using pivot tables within Power BI to validate and refine measures.
Leadershift Ethics: Things Must Change!
-
Webcast Only
2.00 Credits
The major topics covered in this course include:The litmus test for all of your decisions and actionsEthical principles when managing through changePressures that threaten ethical change managementCase studies of what can go sideways when ethics are not part of every stage of changeWinning strategies for ethical self-regulation
Surgent's Data Security: Best Practices to Protect Your Business and Yourself
-
Webcast Only
1.00 Credits
Ethical duty to safeguard employee, client, and litigant data Common threats, including phishing, ransomware, and bad password management Security management of business and personal electronic devices Best practices for creating and securing passwords Insight into how our personal information is exploited in our daily lives
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.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Webcast Only
2.00 Credits
Creating a data model/Power Pivot Building PivotTables from multiple tables Creating Measures Using named sets
Using AI to Instantly Transform Ideas into Revenue Streams
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:AI-powered ideation and opportunity identification techniquesDigital asset creation workflows using generative AI toolsAudio and video content generation using AI avatars and synthesisE-commerce integration and product development strategiesAI-driven presentation and visual content creationSocial media content optimization and distributionMulti-format content transformation (articles, songs, comics, storyboards)
Unlocking Deep Secrets: Case Studies in Financial Analysis
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of financial statement analysisThe impact of GAAP on financial analysisOverview of the Balance SheetOverview of the Income StatementThe importance of the Statement of Cash FlowsCommon Size AnalysisTrend AnalysisProfitability Ratio AnalysisLiquidity Ratio AnalysisSolvency Ratio Analysis
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
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
Surgent's Contract Law for Accounting and Finance Professionals
-
Webcast Only
2.00 Credits
Contract formation The necessary components of an enforceable contract Common defenses to enforcement Legal capacity requirements Contract interpretation
Surgent's Getting Ahead: The Art of Marketing for CPAs
-
Webcast Only
2.00 Credits
Challenges of marketing CPA firms Developing marketing strategy Elements of a marketing plan Example: CPA firm marketing plan Marketing regulatory/AICPA issues Picking the right marketing channels Marketing channel statistical analysis Developing marketing metrics
Microsoft Teams - Everything You Need to Know from A to Z
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Understanding the "big picture" of the role the Teams app plays in your Microsoft 365 ecosystemHow to effectively design your teams / channels configurationDetailed review of all the features for creating conversation postsDetailed review of all the features for creating, editing and managing Office files within the Teams appHow to use the search features to find Teams content instantlyStep by step review of how to host and participate in Teams online meetingsUsing Teams calling features for your phone systemHow to manage your notification settings in TeamsAnd more
Introduction to Yellow Book: 8-Credit Boot Camp
-
Webcast Only
8.00 Credits
The major topics that will be covered in this course include:The basics needed to understand what makes nonprofit and governmental accounting & auditing unique. The key financial reporting differences for governmental and nonprofit entities.The fundamentals of Yellow Book and Uniform Guidance audits.
Surgent's Form 1065 Boot Camp: Step-by-Step Preparation with Completed Forms
-
Webcast Only
8.00 Credits
Comprehensive coverage of the Inflation Reduction Act of 2022 Gain a thorough understanding of federal income tax laws for partnerships and LLCs, from formation to tax return preparation issues Filing requirements for Schedules K-2 and K-3 Who files Form 1065, and who does not file Form 1065 Tax Basis Capital Account Reporting Requirements Trade or Business income and expenses versus Separately Stated Items The importance of Schedule M-1 Partnership distributions -- current or liquidating, cash or property How to allocate recourse and nonrecourse debt Self-employment tax issues; court cases and trends in tax audits of earnings subject to self-employment taxes Complete coverage of any new legislation enacted before presentation Section 163(j) limitations Mastering two common tax forms, Depreciation (4562) and Sale of Assets (4797) Final regulations on Section 168(k) Partnership reporting oddities Accurately preparing partnership returns and reconciling book income to taxable income The Centralized Audit Regime under the Bipartisan Budget Act of 2015
Surgent's Latest Developments in Government and Nonprofit Accounting and Auditing
-
Webcast Only
8.00 Credits
Developing issues related to the 2024 Yellow Book revision and the 2024 revision to the Uniform Guidance for Federal Awards Key AICPA developments affecting audits of governments and nonprofits (including SAS No. 146 on quality management) Recent GASB activities directed toward state and local governments (e.g., the implementation of GASB No. 101 on compensated absences, GASB No. 102 on certain risk disclosures, GASB No. 103 on improvements to the financial reporting model, and additional GASB projects) Critical, but sometimes overlooked, FASB ASC 958 implementation guidance and illustrations for not-for-profits)
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Webcast Only
8.00 Credits
Congressional Budget Reconciliation Process - explore how this powerful legislative tool allows Congress to fast track tax law changes and how it could be used to enact significant tax reforms in the current political climate President Trump's tax proposals - review key components of President Trump's tax agenda, including a tip income exemption, overtime pay relief, Social Security tax exemption, auto loan interest deductibility, SALT deduction modifications, a lower corporate tax rate, restoration of 100% bonus depreciation, immediate R&D expensing, and permanent extension of select TCJA provisions Potential expiration of select TCJA provisions - understand the implications for taxpayers as key provisions of the TCJA approach sunset dates Tariff policy and implementation - analyze the use of tariffs as a fiscal and trade policy tool Principles and considerations for nonresident withholding, composite payments, and passthrough entity taxes Partnership Distributions, Form 7217, and S Corporation Redemptions Thinking beyond §163(j) -- Interest Allocation Rules, Original Issue Discount, Applicable High Yield Discount Obligations, Convertible Corporate Debt Instruments, and Debt-Financed Distributions Timely coverage of breaking tax legislation Selected Practice and Reporting Issues: What’s new? A review of recent cases and tax law changes and IRS guidance affecting S corporations, partnerships, limited liability companies, and limited liability partnerships Form 1099-K reporting requirements Bonus depreciation Section 174 Research & Experimental Expenditures -- guidance under Notice 2023-63 and Notice 2024-12 Decentralized Autonomous Organizations (DAOs)
Clean, Transform & Load Data in Power BI
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.Data Loading: Efficiently loading data into the Power BI data model.Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.