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!
PFP Update: Income Tax, Retirement and Estate Planning 25-26
-
Webcast Only
2.00 Credits
The personal financial planning process Relevance to income tax Retirement and estate planning concerns and solutions
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.
Comprehensive FASB & AICPA Update for Tax Professionals 25-26
-
Webcast Only
8.00 Credits
Broadly applicable ASU effective in 2024 and beyond Significant recent SAS Tax-basis financial statements Statements on Quality Management Standards
Financial Accounting Standards: A Comprehensive Review 25-26
-
Webcast Only
16.00 Credits
Application of professional judgment Codification, GAAP and the GAAP hierarchy Recent changes in financial statement presentation Hot Topics in financial reporting & accounting
ChatGPT Bootcamp for CPAs with John Higgins
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Review the history of ChatGPTTour of the ChatGPT app and how to use itSetting up a ChatGPT account (free & premium)Variety of hands-on case study examples for accounting, finance and taxA look under the hood at how ChatGPT worksCaution - how to avoid risks in using ChatGPTA look into the future potential for AI in business
Everyday Ethics at Work: Don't be the Next News Story!
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Discuss ethics from an every-day real-world perspectiveHow to prevent an ethical lapse that can turn your business into the next news story
The Ethical Management of Conflict
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Professionalism, Conflict and EthicsSources and approaches to conflictManaging Conflict from the Inside: Awareness of human tendencies, human emotions, and gossipGuidelines for managing conflict collaboratively
SEC Case Studies: Ethical Dilemmas in Finance and Accounting
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to Ethics and Ethical DilemmasEthical Codes and Professional StandardsFraud and the Fraud TriangleEthical Decision-Making ModelsFinancial Statement Manipulation TacticsCash Flow and Key Metrics Misrepresentations
Nonprofit A&A Series Part 1: Financial Statement Presentation & Disclosure 25-26
-
Webcast Only
2.00 Credits
Overview of required financial statements Unique considerations in the nonprofit environment Presentation options for reserves, restrictions, functional expenses and liquidity. Common pitfalls and little-known alternatives Recognize financial statement presentation requirements for nonprofits
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
Nonprofit A&A Series Part 2: Revenue Recognition 25-26
-
Webcast Only
2.00 Credits
Pledges and contributions Restrictions and conditions Special concerns with governmental funding Donated goods and services Special events Revenues earned through sales and services to customers, including the application of CECL
PFP Update: Issues, Exposures and Developing Client Strategy 25-26
-
Webcast Only
2.00 Credits
Cash flow management Insurance, investment, income tax, education, retirement and estate planning Understanding client issues, diagnosing client exposures and determining client solutions Closely held business owner strategies
Becoming Conflict Competent
-
Webcast Only
2.00 Credits
Major topics covered in this course include:Levels of conflictStrategies to de-escalate conflictDistinction between miscommunication and conflictResponses to conflictTactics to address, rather than avoid, conflict
Understanding Internal Control Constructs
-
Webcast Only
4.00 Credits
The major topics covered in this course include:Underlying concepts of internal controlThe importance of control measure interdependency
Ethical Intelligence for Artificial Intelligence
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Benefits and pitfalls of artificial intelligence in the accounting professionSelecting and utilizing artificial intelligence resourcesApplying professional skepticism to resultsMaintaining independence while utilizing artificial intelligenceUpholding client confidentialityData security and retentionCitation of sources and related reporting considerationsApplication of the AICPA Code of Professional ConductEthical considerations when crafting policies and establishing best practices
More Money: Strategic Ways to Improve Cash Flow
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:How do I optimize cash flow?Qualitative Evaluations – Core Earnings & Sustainable GrowthQuantitative Evaluations – Liquidity RatiosIncreasing Customer Base vs. Payment TermsBusiness Cycle & CashInvesting Company CashWhat keeps companies from becoming streamlined?Behavioral Finance BiasesInformation Processing BiasesEmotional BiasesDealing with Behavioral Biases
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
Create Paginated Reports with Power BI Report Builder
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Introduction to Power BI Report Builder: Overview of the tool, its interface, and integration with the Power BI ecosystem.Designing Report Layouts: Techniques for setting up professional layouts, including headers, footers, and managing pagination.Data Connection and Management: Connecting to various data sources and preparing data for reporting.Creating Visualizations: Utilizing Power BI’s visualization tools for impactful data presentation.Advanced Report Features: Exploring sub-reports, drill-through capabilities, and dynamic expressions.Publishing and Sharing: Guidelines for publishing reports to the Power BI service and sharing them with relevant stakeholders.
Creating an Ethical Work Environment
-
Webcast Only
2.00 Credits
Ethical Values and PrinciplesHuman Factors impacting ethical choicesProfessional and organizational responsibilities in creating an ethical work environmentTools for ethical decision making