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!
Advanced Excel: Hidden Secrets and Gems
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models
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.
Surgent's Comparing and Contrasting Retirement Plans for Small- and Medium-Sized Businesses
-
Webcast Only
2.00 Credits
Factors business owners should take into account when choosing a retirement plan SIMPLE plans Simplified employee pension plans 401(k) plans Defined benefit plans Ensuring eligible employees are covered Employees’ impact on choice of plan Ongoing compliance requirements Establishing a plan after the tax year end Changes to safe harbor 401(k) plans Pooled employer plans Defined benefit plans and cash balance plans
Surgent's Understanding Partnership Taxation: Debt Allocations
-
Webcast Only
2.00 Credits
Recourse debt allocations Constructive liquidation scenarios Nonrecourse debt allocations Minimum gains and nonrecourse deductions Section 704(c) gains Allocations under 704(c)
Forensic Accounting: Crafting Expert Reports
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Introduction to Forensic Accounting: Gain an understanding of the fundamentals, roles, and responsibilities of forensic accountants in uncovering financial discrepancies, fraud, and economic damages.Maintain Ethical Integrity: Learn the importance of ethics in forensic accounting and strategies for ethical decision-making.Expert Report Preparation: Learn the essential components, best practices, and common pitfalls in writing clear, concise, and objective expert reports for legal proceedings.Investigation Report Writing: Explore the methodologies for conducting investigations, gathering evidence, and crafting thorough and accurate investigation reports.Economic Damages Writing: Understand the methodologies and best practices for calculating economic damages, including lost profits, business valuation, and other financial impacts.Reviewing Investigation Reports and Economic Damages: Analyze real-world examples to review and critique investigation reports and damage calculations, highlighting key insights and lessons learned.
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)
2024 PCAOB and SEC Update
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Developments at the PCAOB.Recent trends in SEC comment letters.Enforcement actions and administrative proceedings.Conclusions and predictions for the future.
Take Command of your Time
-
Webcast Only
2.00 Credits
The major subjects that will be covered in this course include:Identify time wasters and adopt strategies for eliminating themRecognize the variety of causes of procrastination and apply techniques to overcome themUse practical techniques for prioritizing workDelegation strategiesIncorporate wellness and stress management into your day in short incrementsUnderstand their energy cycles and use it to manage your scheduleLearn techniques to decrease stress in the moment (based on neuroscience)
Criminal Tax: How CPAs Bring Value to Defense Attorneys
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:The common weaknesses in a criminal tax investigation.The key documents to review (In a sea of thousands of documents).Crafting questions to recommend in court proceeding.
IRS Penalties and Abatements
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Various types of penalties: Accuracy related, fraud, understatement of valuation, reporting requirement, failure to pay, and pay or deposit penaltiesRules on waiver of penalties and interestsVarious forms and procedures for requesting reliefFirst Time Abatement: Requirements and proceduresHow an individual taxpayer qualifies for Reasonable Cause abatementProcedures for requesting refund of paid penaltiesAvailable administrative options
How to Build a Custom AI Chatbot and GPT in Plain English
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Fundamentals of GPT Builder and AI agent customization techniquesIntegration of specialized knowledge bases and domain-specific expertiseSecurity and privacy considerations in AI chatbot deploymentCustom GPT development without coding expertiseImplementation of AI agents for customer support and workflow automationMulti-bot interactions and content creation strategiesBest practices for maintaining and scaling AI assistants
PPP Fraud and Financial Professionals
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Ethical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
Surgent's Employee vs. Independent Contractor: Achieving Success in a Worker Classification Audit
-
Webcast Only
2.00 Credits
The 20 common law factors in a worker classification audit that are used to distinguish an employee from an independent contractor How disgruntled independent contractors can use IRS Form 8919 against a former employer When and how to use §530 as a defense in worker classification audits What is "industry practice" for §530 purposes Common sense steps that will avoid the recharacterization of workers treated as independent contractors to employees The IRS’s Voluntary Classification Settlement Program — advantages and disadvantages The DOL Final Rule
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
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.
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
Surgent's Getting Ready for Busy Season: Key Changes Every Tax Practitioner Should Know
-
Webcast Only
4.00 Credits
Timely coverage of breaking tax legislation Comprehensive coverage of the Inflation Reduction Act of 2022 and SECURE Act 2.0 A tour of the most recent changes starting from gross income and ending with alternative minimum tax (AMT) and selected credits including the latest IRS guidance on recent tax legislation Hot developments affecting the upcoming tax season Review of new laws and changes in old forms to provide a familiarity for the upcoming tax season Key new tax and practice developments and how they impact the current-year tax forms for individuals
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
Love it or Leave It: Engagement and Retention at Work
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Ethical Values and Engagement and RetentionEnhancing Employee engagementStrategic/Intentional Actions to Enhance RetentionGeneration X
What's Behind the Data?
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Ways in which data and information can be misleadingCommon pitfalls when encountering dataHow to re-evaluate the data to avoid those pitfalls