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 support your professional development. Our goal is to strengthen your knowledge and help you achieve even greater success.

Most MTCPA courses are offered in both LIVE (In-Person) and VIRTUAL formats—MTCPA Webcasts (in-house) or Webinars (other providers).

Looking for flexibility? Explore Anytime CPE, our on-demand learning platform. Choose individual courses or an all-access subscription to our full Anytime library. Click the Anytime CPE tab below to get started!

Courses are listed by format. Be sure to choose the correct tab below to view and register for the class you want.

In-Person 3 MTCPA Webcasts 8 Webinars 9372 Chapter Events 1 All 9384 Anytime CPE 84

Showing 741-760 of 9372 Results (Page 38 of 469)

Smart Formula Selection in Excel: What to Use When

-

Webcast Only

2.00 Credits

The major topics that will be covered in this class include:Introduction to Strategic Formula Use:Why choosing the right formula matters: clarity, performance, and maintenanceCommon traps: overusing IF, defaulting to familiar tools, ignoring modern functionsHow Excel offers multiple ways to solve the same problem and how to pick wiselyConditional Logic and Branching Tools:IFS vs SWITCH vs nested IF: comparing readability and structureWhen to simplify logic and how to avoid nested nightmaresSummarizing Data:SUMIFS vs SUMPRODUCT: multiple conditions, weighted sums, totalsFiltering and Output Control:FILTER vs IF + INDEX: dynamic data extraction with vs without Excel 365Trade-offs in backward compatibility and ease of useCustom Output and Decision Trees:CHOOSE vs SWITCH vs LOOKUP: logic trees and category mappingEmbedded Variables and Reusability:LET vs named ranges: clarity and efficiency for long formulasUsing LAMBDA with LET to create custom functionsSimplifying and documenting complex calculationsBest Practices for Formula Selection:Criteria for deciding: readability, flexibility, future maintenanceTips for avoiding overengineering and formula bloat

Steps to Stop External Fraud

-

Webcast Only

2.00 Credits

The major topics covered in this course include:Types of external fraudConsiderations as organizations work to reduce fraud riskExternal fraud and known parties/External fraud unknown perpetrators

Surgent's You’ve Got This: An Introduction to Yellow Book and Single Audits

-

Webcast Only

4.00 Credits

What’s included (and excluded) in a Yellow Book audit Key qualification, performance, and reporting standards under the Yellow Book How single audits differ from financial statement audits, plus core concepts like the SEFA, major program determination, and findings reporting Fundamentals of testing internal controls over compliance and performing compliance testing

Comprehensive Accounting and Financial Reporting Update

-

Webcast Only

4.00 Credits

The major topics covered in this class include:CECL for nonfinancial institutions.Accounting for Paycheck Protection Program loans.Accounting for web-hosting services.Revenue recognition.Leases.FASB projects in progress.

Accountants and Malpractice: Can We Get Sued for This?

-

Webcast Only

2.00 Credits

The major topics that will be covered in this class include:How accountant liability is a very real threat in today's litigious society.A discussion of scenarios in which accounting professionals can find themselves inadvertently involved in a lawsuit.Pitfalls in which the accountant may find him- or her- self while dealing with clients.Real-life examples from the speaker's extensive experience as a practitioner and as an expert witness in accounting malpractice cases.

Surgent's Section 754 Step-Up in Basis: Understanding the Tax Issues for Partnerships and LLCs

-

Webcast Only

2.00 Credits

How and why a partnership makes a 754 election The effect of the 754 election when an interest in a partnership is sold or inherited How the 754 election applies when a partnership makes a distribution of property to one or more of its partners How to make the 754 basis adjustment

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

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

Professional Ethical Considerations for CPAs

-

Webcast Only

2.00 Credits

The major topics that will be covered in this course include:Core principles of any Code of Professional Conduct applicable to all CPAs, including conflicts of interest, preparing and reporting information, competence, confidential information, and moreThe importance of maintaining independence for CPAs in public practice, especially when also performing nonattest services for the attest client Comparing and contrasting various ethical standards, including those promulgated by the AICPA, PCAOB, and international bodies

Mining Your Firm Client Database for Revenue

-

Webcast Only

1.00 Credits

The major topics that will be covered in this course include:How accounting and tax professionals can transform dormant data into dynamic growth. When leveraged strategically, your client base becomes more than a list --it becomes a roadmap to higher-value services, expanded engagements, and greater long-term retention.How to audit client records, segment strategically, and surface needs that often go unmet --all without adding complexity or compromising relationships.Using the data you already own and relationships you have already built to drive smarter growth. 

Financial Decisions that Led Two Businessmen 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

AI & Accounting in Retail

-

Webcast Only

2.00 Credits

The major topics that will be covered in this course include:AI-powered personalization and its impact on revenue recognitionDynamic pricing models and tax compliance risksAI in demand forecasting, inventory valuation, and COGS calculationsIntegration challenges with ERP and POS systemsGovernance, ethics, and auditability of AI decisionsData quality, audit trails, and regulatory documentationAI-assisted fraud detection, financial controls, and oversight

Volume to Value: A New Era of Precision Hiring in Accounting

-

Webcast Only

1.00 Credits

The major topics that will be covered in this course include:The shift from volume to precision hiringWhy firms are moving to targeted, competency-based hiringTalent market impacts and competitive hiring realitiesAI in recruiting: practical use cases and implicationsWhere AI tools commonly support hiring workflowsBenefits and limitations of AI-enabled screening and assessmentThe skills mismatch in accounting hiringWhy critical thinking and professional communication gaps persistWhy traditional hiring methods miss these competenciesThe new competency hierarchy for high performersDefining and prioritizing the competencies that drive resultsAI ethics awareness and professional judgment in an AI-enabled workplaceAssessment methods for precision hiringStructured behavioral interviewing and scoring rubricsWork simulations, case presentations, and client scenariosUsing AI-enabled assessments responsibly and consistentlyMetrics and ROI: evaluating successQuality-of-hire measures (performance, ramp time, manager satisfaction)Retention and turnover measuresEfficiency measures (time-to-fill, cost-to-fill) and how to balance themImplementation roadmapA phased approach to adopting precision hiring (foundation → expansion → optimization)– Building governance, documentation, and consistency for scalability

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

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

Navigating IRS Correspondence: Responding to IRS Letters

-

Webcast Only

2.00 Credits

The major topics that will be covered in this course include:Types of IRS letters: General notices, audits, collections, return requests, and errors.Deadlines for responding to IRS correspondence.Communication best practices for dealing with the IRS.Avoiding escalation and penalties through proactive responses.Ensuring compliance when addressing IRS correspondence.Real-world examples of successful IRS communications.Common pitfalls in handling IRS letters and how to avoid them.Strategies for advising clients on IRS correspondence.

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 Buying and Selling a Business: Tax and Structuring Overview

-

Webcast Only

4.00 Credits

An overview of the beginning of the process and documents for preliminary tax planning Recognizing the need for due diligence in acquisitions, including checklists of important points Deemed asset sales – §338 and §338(h)(10) The impact of the §197 amortizable intangibles regulations on the acquisition and disposition of a business Allocating purchase price for tax advantage Planning to avoid double taxation under the repeal of the General Utilities doctrine Special problems and opportunities when an S corporation is the buyer or seller Installment sale and interest issues Avoiding tax pitfalls and recognizing tax planning opportunities Unique issues in buying and selling LLC/partnership interests Impact of the net investment income tax (NIIT) and the §199A pass-through deduction on the tax due on the sale of a pass-through entity Individually owned goodwill

Surgent's Critical Issues Involving Taxation of Construction Contractors

-

Webcast Only

4.00 Credits

The impact of recent legislation on the construction industry (including the OBBBA) How to qualify for the small contractor exemption and its advantages for the taxpayer Options available to small contractors regarding taxation of long-term contracts How the choice of entity impacts taxation of contractors How AMT impacts the construction industry IRC §460 and large contractors How uninstalled materials impact taxation of contractors Look-back rules Using the 10 percent method to allow certain contractors to defer recognizing taxable income Critical tax planning strategies for contractors

Surgent's Government and Nonprofit Frauds and Controls to Stop Them

-

Webcast Only

4.00 Credits

Examine real-world misappropriations of cash, check frauds, vendor scams, credit card abuse, grant frauds, benefit schemes, inventory thefts, and payroll frauds Identify and develop practical controls to prevent and detect fraud Tailor controls to the size and fit of the government or nonprofit