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 Tax Research
-
Webcast Only
2.00 Credits
Tax code hierarchy Organization of an Internal Revenue Code section Special rules for IRC citation Citing other primary authority Private letter rulings Primary vs. secondary authority Secondary sources of authority Steps in the tax research process Research memoranda
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.
Fraud Case Studies: 21st Century Professional Misbehavior
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Salient provisions the AICPA Code of Professional ConductExamination of actual fraudsDiscussion of internal controls that could have prevented or mitigated actual fraudsContemplation of epiphanies for your own professional scenarios.Implications for professional conduct and compliance with professional standards
Surgent's Predicting Future Financial Issues Facing the Financial Executive
-
Webcast Only
8.00 Credits
CPA becoming attuned to broad based business knowledge, professional skepticism, and subordination of judgment The future of medical care in the United States in a post COVID-19 environment Future of social security and impact on retirement planning and employee retention Impact on financial executive if the dollar is no longer the world currency “Fate of the States” – will the location of your business make you less competitive Future of workmen’s compensation and unemployment compensation Future of interest rates Impact of greater reliance on technology AICPA top 10 trends and technologies National infrastructure ESG and DEI trends in the global economy Impact of continuing uncertainty in markets
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.
Next Steps Series - The Next Generation: A Different Take on the Generations
-
Webcast Only
1.00 Credits
Understand the modern workforce, from both a generational angle and from a societal viewpoint. Realize that our communication patterns must change to reach across the workforce Prioritize the effort based on the makeup of the workforce, with Millennials the largest cohort Strategies and tips for managing the new workforce A reminder about the importance of Ethics and Integrity to the sustainability of a high-performing culture
Accounting Fraud 25-26
-
Webcast Only
8.00 Credits
The elements of fraud and the Fraud Triangle Theory Types of fraud with a focus on management fraud Best practices in fraud detection and deterrence
Divorce Concerns: Taxes, Valuation, Finances, Retirement, & Obligations 25-26
-
Webcast Only
8.00 Credits
Divorce and ongoing payment issues dealing with alimony and child support Documents protecting a client going forward, including pre-nuptials, cohabitation agreements, post-nuptials and many others Advanced income tax issues, including like-kind exchanges, filing status issues, credits and asset sales Advanced retirement issues, including dissecting qualified, personal retirement, and nonqualified plans, QDROs, past and defunct plans, and using retirement assets to equalize assets High-level valuation issues, including closely held business, stock redemptions, partnership redemptions and stock options
Estate Planning: A Comprehensive Overview 25-26
-
Webcast Only
8.00 Credits
Intestate succession and probate administration Holding title to assets Lifetime asset transfers and testamentary asset transfer planning Structures to avoid or minimize transfer taxes Living trusts, including A-B and A-B-C, life insurance trusts, terminating irrevocable trusts, use of trust protectors, trust administration during incapacity and post-mortem
Implementing and Maintaining an Internal Control System 25-26
-
Webcast Only
8.00 Credits
Considerations for the maintenance of an internal control system The types of policies and procedures organizations should utilize Reviewing and testing control measures Updating controls and implementing control changes
Beyond the Numbers: Success Strategies for Female CPAs
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:How to increase your visibility instead of flying under the radar.Critical time management techniques that allow you to focus and prioritize the right strategic initiatives.How your inner critic operates and how to silence it.How to build a network of community support and mentoring.What impostor syndrome is and how it may be holding you back.
Self-Rental Real Estate: Passive Activity & Section 199A
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Definition of self-rental property - both for Sections 199A and 469Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2Form 8582 (passive activity)The flow-through entity grouping electionIllustrative examples and consequences of failing to comply with the reporting standardsSelf-rental property and "former passive activities" rules
The Ethic of Recruitment and Selection
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Discussion of ethical and effective recruiting strategiesSelection processes that foster diversity and inclusionHow to increase talent pools to ensure hiring success
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.
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
Ethics: What a CPA in Business & Industry Needs to Know
-
Webcast Only
2.00 Credits
Ethics for Members in Business: Why Bother?Re-Introducing the AICPA Code of Professional ConductThe Basic Ethics Rules for Members in BusinessThe Conceptual Framework: Avoiding the Risk of NoncomplianceCase Analysis: Members in Business
Surgent's Exploring Business Valuation Fundamentals
-
Webcast Only
2.00 Credits
What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models
Surgent's The CMA's Guide to Project Management
-
Webcast Only
2.00 Credits
Establishing a system: identifying forces that support the status quo; setting milestones and goals; the role of the CMA Necessary first steps: set a framework for the project’s activities; identify needed resources; obtain support; decide on a structure; establish a team for a specific project; identify necessary team skill sets Project evaluation: analytical tools, strategic evaluation; sources of risk Maintaining focus: monitoring and measuring results; keeping to the project’s scope Avoiding frequent traps: sunk costs; financing pitfalls; project creep; tunnel vision; failure to integrate the team’s work internally and/or the final project with the remaining organization Introduction and examples of analytical tools throughout the session: mapping; CPM; Gantt charts; benchmarking; Pareto analysis; PESTLE analysis; valuation techniques; post-completion evaluations
What's Going on at the FASB (2025)
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. Review year 2 implications of the leases standard including modification accounting. A look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation.
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