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!
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.
Invest in Your Mental Health and Avoid Burnout
-
Webcast Only
2.00 Credits
The major topics covered in this course include:How to recognize burnout and evaluate where you are on the burnout scale.How impostor syndrome drives coping reactions of overworking, over preparing and perfectionism.How mindfulness can reduce stress and save time.Silencing the critical inner voice.Tools to help you become more attuned to your needs and emotions.How attending to and regulating your nervous system impacts your mood and well-being.
Installment sales: Maximize Tax Benefits and Stay Compliant
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Installment sale treatment eligibilityWhen to elect out of installment sale treatmentInstallment sale of business assetsInstallment sale default and the rules for personal property versus real propertyInstallment sales and depreciation recapture
The Ethic of Teamwork
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Virtue ethicsTeam dynamicsCharacteristics of highly effective teamsMeeting managementTeam communicationDecision making
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
Microsoft Teams - Everything You Need to Know from A to Z
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Understanding the "big picture" of the role the Teams app plays in your Microsoft 365 ecosystemHow to effectively design your teams / channels configurationDetailed review of all the features for creating conversation postsDetailed review of all the features for creating, editing and managing Office files within the Teams appHow to use the search features to find Teams content instantlyStep by step review of how to host and participate in Teams online meetingsUsing Teams calling features for your phone systemHow to manage your notification settings in TeamsAnd more
Operations Level Internal Control
-
Webcast Only
4.00 Credits
The major topics covered in this course include:An overview of controls that drive proceduresConsiderations for procedural control developmentUnderstanding and controlling risk that arises when organizations change
2025 Yellow Book Update
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Yellow Book engagements.Independence requirements in GAGAS.Quality management in Yellow Book. Common deficiencies found in Yellow Book engagements.
Hot Topics Audit & Attest Update
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Recent quality improvements to the SASs and SSARsOther matters that should be on your radar
Navigating IRS Authorizations: Form 2848 & Form 8821
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of IRS Power of Attorney (POA) rules.Form 2848: Authority to Represent Clients before the IRS.Form 8821: Accessing Tax Information Without Representation.Identifying errors and compliance risks in POA filings.Rules for revoking or updating POA authorizations.Managing authorizations through the CAF system.Electronic submissions and the IRS online authorization process.Ethical responsibilities when holding a POA.
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
Learning to Teach "Tax" as a Second Language
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Accounting as a foreign languageCommonly misunderstood conceptsCommunicating tax mattersClient-practitioner interactionsInteracting with tax authorities
Ethical Considerations in Working with Cannabis
-
Webcast Only
1.00 Credits
The major topics covered in this class include:Framework for assessing the propriety of offering services within the state legal, regulated cannabis industryAssist in identifying key stakeholders to be considered in conjunction to providing cannabis industry services, including:partnersstaffclientsBanking relationshipsMalpractice insurance
Donating Cryptocurrency and Avoiding Traps for the Unwary
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Intro to digital assetsDifferences between cryptocurrency and non-fungible tokens (NFTs)IRS Notice 2014-12Tax implications of contributing digital assetsGift tax rules for donating, gifting or bequeathing cryptocurrency and NFTs.Substantiating charitable contributions of digital assetsTraps for the unwary.
Surgent's Choosing the Right Business Entity
-
Webcast Only
2.00 Credits
Why businesses operate as C corporations Why businesses operate as pass-through entities Adopting C corporation status Why businesses choose S corporation status. Tax and business situations that impact entity selection.
Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
-
Webcast Only
4.00 Credits
Economic update Leadership and management changes as a result of the pandemic Managing for productivity Metrics and benchmarking Social media's place in our organizations
A&A Update for Nonprofits and Single Audit (2025)
-
Webcast Only
8.00 Credits
The major topics that will be covered in this course include:• Current impacts of accounting and financial reporting on nonprofit entities • Recently released FASB standards that impact nonprofit financial reporting the most• Current issues and challenges involving Yellow Book financial statement audits• Critical considerations when performing Single Audits under OMB Uniform Guidance for Federal Awards • Important AICPA professional standard developments related to providing audit and nonaudit services to nonprofits
Surgent's Advanced Audits of 401(k) Plans: Best Practices and Current Developments
-
Webcast Only
8.00 Credits
Audit requirements for ERISA §103(a)(3)(C) audits An annual update of the changes affecting 401(k) plans Compliance issues associated with eligibility and enrollments, remittances, lack of oversight, compensation, vesting, and other topics Best practices for engagement planning, internal controls, risk assessment, and detailed testing Avoiding common mistakes while performing audit procedures Plan mergers and acquisitions Common audit reporting and disclosure issues
Operations Level Internal Control
-
Webcast Only
4.00 Credits
The major topics covered in this course include:An overview of controls that drive proceduresConsiderations for procedural control developmentUnderstanding and controlling risk that arises when organizations change
Controller Series: Communicating for Connections with Coworkers, Customers, and Stakeholders
-
Webcast Only
1.00 Credits
What are the three types of misconceptions of communication? What are the different types of personality styles in the workplace? Recognize how to communicate with the different types of personality styles effectively Key takeaways