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!
The Leadership Skills of Tomorrow: Delegate and Listen
-
Webcast Only
2.00 Credits
The major subjects that will be covered in this course include:Three levels of listeningStrategies to remain focusedBuilding trust through listeningTactics to practice the Titanium RuleDelegating with confidenceEstablishing an accountability system
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 Generation-Skipping Transfer Tax and Dynasty Trusts 25-26
-
Webcast Only
4.00 Credits
Calculation of the GST tax, and how it relates to the estate tax and gift tax Direct skips, taxable distributions, and taxable terminations GST tax allocations, Reverse QTIP election, and Exempt and Nonexempt Trusts Calculating the benefit of and designing Dynasty Trusts
Complete Guide to Analyze Data with Excel PivotTables
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
Leases: ASC Topic 842 in Depth 25-26
-
Webcast Only
8.00 Credits
FASB ASC 842, Leases All recently released updates to ASC 842, Leases
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
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
Building a Better Budget in a Time of Uncertainty
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting
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.
Casualty Losses: Disaster Relief Act of 2024
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Federal Disaster Relief Act provisions enacted in December, 2024Comparison of personal use casualties with business/investment casualtiesWhen to claim casualty lossesHow to postpone casualty gainsBusiness casualty gains and depreciation recapture
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
The Bookkeeper Goes to Prison
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
Accounting for and Auditing Cryptocurrency & Digital Assets
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Common applications related to initial recognition and measurement, subsequent measurement or derecognition, presentation, and disclosure of cryptocurrency and other digital assetsFeedback from the AICPA's Digital Assets Working Group intended to assist auditors with opining on these digital records
Leadershift: Drive Results Through Ethical Performance Mgmnt
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:How Inspirational leadership is the foundation that ethically drives results.Simplify the complex: Walk through the Results Model and discover practical how-to examples of execution.Hacks for getting great results with specific examples you can leverage in your business:The How: Empower your people to feel like an owner, managing difficult conversations well, leading with empathy and what that looks like, how it should feel, motivational coaching techniques to get your employee relationships back on track, and unleashing the power of appreciation and gratitude.The What: Powerful score-carding, transformational goal-setting conversations, and positive accountable follow- up.
Navigating IRS Collections: The Collection Process
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of the IRS collection process.Taxpayer rights and the Taxpayer Bill of Rights.Collection due process and appeals.Installment agreements and offers in compromise.Wage garnishments, levies, and liens.Penalties and interest.
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.
AI Privacy, Security, and Compliance Masterclass
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction: What is AI Security, Privacy and Compliance (AISPC)?Why AI Security, Privacy and Compliance (AISPC) is Increasingly Important for AccountantsAISPC Policy Best PracticesKey Tactical Questions for Addressing Data Security and PrivacyOpenAI and Compliance with Government RegulationsOpenAI and Two-Factor AuthenticationOther OpenAI Security, Privacy and Compliance ConsiderationsBest Practices for Secure Data Sharing with GPT How to Create a GenAI and ChatGPT Usage Policy for Your OperationsGeneral AI Policy Do’s and Don’tsAI Copyright Compliance & Protection GuideDeepfakes and Synthetic Media: A New Frontier for Fraud and MisinformationFrom Financial Oversight to AI Governance: The Sarbanes-Oxley Legacy and Accountants' New Frontier in AI Security, Privacy, Compliance and EthicsKey Takeaways
Fraud & Embezzlement: Case Studies from the Trenches
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:How organizations can find themselves defrauded due to lax oversight and weak internal controls.How the existence of the "trusted advisor" creates situations where CPAs can drop their professional skepticism.Illustrations of the issues companies should look for in preventing fraud and embezzlement.
Implementing an AI-Enabled Marketing Strategy for Your Firm
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Module 1: Introduction to AI in Marketing The Basics of AI – Concepts and TerminologyModule 2: Leveraging AI Tools and Technologies Overview of AI Tools for MarketingModule 3: Practical Strategies for AI Integration Integrating AI into Your Marketing WorkflowModule 4: Measuring AI-Driven Marketing Effectiveness Key Metrics for Assessing AI-Driven CampaignsModule 5: Real-Life Case Studies and Success Stories Case Studies of Firms Successfully Using AI in MarketingModule 6: Developing Your AI-Enabled Marketing Strategy Creating a Custom AI Marketing Strategy
Microsoft 365 Application Lightning Round Review-Updated
-
Webcast Only
1.00 Credits
The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps