Skip to main content

CPE Catalog & Events

Join us for this year's classes

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!

In-Person 2 MTCPA Webcasts 3 Webinars 3817 Chapter Meetings 5 All 3827 Anytime CPE 109

Showing 3827 All Results

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

Overcoming Tech Adoption Challenges in CPA Firms

-

Webcast Only

1.00 Credits

To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Five critical technology adoption challenges facing CPA firms today Digital maturity assessment models and implementation frameworks AI integration strategies for tax, audit, and advisory services Cybersecurity considerations and risk management protocols Case studies of successful technology transformations in accounting firms

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

Forgotten Managerial Accounting Tools for CPAs

-

Webcast Only

2.00 Credits

The major topics covered in this class include:Target profit analysisBreak-even analysisRelevant costs and decision-makingStandard costs and variancesActivity-based costingSegment reporting and analysis

How to Audit Cash

-

Webcast Only

2.00 Credits

The major topics that will be covered in this course include:Auditing CashAudit assertions, risks, and threats to the cash balanceAuditing procedures to perform

Ethics: IRS Criminal Investigations: Key Lessons for Accountants

-

Webcast Only

2.00 Credits

Snapshot of IRS Criminal InvestigationsGeneral tax fraudAbusive tax schemesRefund fraudEmployment tax fraudIdentity theftData compromisesMoney launderingPublic corruptionCorporate fraudGeneral fraudsCyber crimesGlobal tax and economic crimesNarcotics, counter-terrorism and transnational organized crimeSelected Field Office Case Files from Across USNew EnglandMiddle AtlanticEast NorthCentralWest North CentralSouth AtlanticEast South Central West South CentralMountainPacificHow accountants can add value to their operations by aiding law enforcement and fighting economic crime

How to Start a CFO Service

-

Webcast Only

1.00 Credits

The major topics that will be covered in this course include:What business owners really want from a CFO/business advisory service (it's not what you think).How to determine if you're qualified to provide CFO/business advisory services.Why now is the right time to be providing CFO/business advisory services.How to get new clients to your practice and how to approach existing clients.Why clients need you and why you need them.How much you should be charging for this type of service.How to provide a CFO/business advisory service in the most efficient way possible.

How to Audit Expenses & Payables

-

Webcast Only

2.00 Credits

The major topics that will be covered in this course include:The basics of auditing expenses.Accrued liabilities and other payables.Relates audit assertions, risks, and threats to the expenses and payables balances.Substantive auditing procedures to peform.

Yellow Book Ethics

-

Webcast Only

2.00 Credits

The major topics that will be covered in this course include:The concept of public interestEthics, independence, and professional judgmentCompetence and continuing professional educationQuality control and peer reviewProper use of government information, resources, and positionProfessional behavior

Surgent's U.S. Taxation of Foreign Corporations: A Case Study Approach

-

Webcast Only

3.00 Credits

Understand how to approach and analyze the U.S. taxation of foreign corporations Using an example, calculate GILTI, Subpart F, and PFIC income inclusions for an individual and C corporation Determine how much foreign tax credit can be claimed against such income inclusions Determine how subsequent dividend distributions from the foreign corporation are taxed Calculate capital gain on the disposition of the foreign corporation Discuss the impact of Section 962 election Compare different outcomes under GILTI, Subpart F, and PFIC regimes for individuals and corporations Identify basic strategies for managing tax liabilities related to foreign corporations

Surgent's Fraud In Single Audits

-

Webcast Only

4.00 Credits

Study real-life misappropriations involving federal awards and how they were carried out The backgrounds, motivations and methodologies of the fraudsters Brainstorm where things went wrong that allowed the frauds to occur without prevention or detection

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

Finance and Innovation: Reinvent Your Organization and Dept.

-

Webcast Only

8.00 Credits

The major topics that will be covered in this course include:What is innovation?The different forms of innovation, e.g., sustaining and disruptive.The five discovery skills needed to be innovative?The value of why we need to find ways to say, “Yes!” How to change your processes, rules and departments to be more innovative? Lessons learned from innovative businesses with examples.How does innovation happen and how to make innovation stick?The need to improvise and embrace broad experiences.

Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update

-

Webcast Only

8.00 Credits

SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services -- 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions  SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Sample comprehensive engagement work programs for preparation, compilation and review engagements Reporting and disclosure illustrations for each level of service, including attesting on personal financial statements, prescribed form, special purpose framework and other engagement variations Other communication requirements, such as sample engagement letters and management representation letters

Surgent's Individual and Financial-Planning Tax Camp

-

Webcast Only

8.00 Credits

Comprehensive coverage of the SECURE Act 2.0 Understanding the environment: what’s new, what’s expired or expiring, and what’s likely to change Reading a tax return for developing client-specific tax strategies Changes to the lifetime estate tax exemption in light of proposed regulations  The net investment income tax: planning for compliance Family income-splitting strategies that need to be considered Income tax issues: impact on timing of other income Selling a principal residence Two principal residences at the same time Use of life insurance to protect families: Whole Life Insurance, Term Life Insurance, Universal Life Insurance, and Variable Life Insurance Using Roth IRAs and Roth contribution programs to best advantage Conversions: do they still make sense? Taking distributions: matching timing to client requirements Qualified plan contributions to reduce current income and Social Security tax: implications for business owners and self-employed Social Security solvency issues Incentive Stock Options and Employee Stock Purchase Plan considerations What to do about itemized deductions Trans-generational planning: conversions, income, and gain-splitting Tax benefits of HSAs and other tax-advantaged accounts Identifying tax opportunities: reviewing the prior-year return to develop a plan for the future Planning for middle-income taxpayers: financial planning for the young, the working, and those approaching or in retirement Best financial planning ideas for young people