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!
Coping With the Growth of Online Fraud
-
Webcast Only
4.00 Credits
The major topics covered in this course include:The actuation of online and other cyber fraudsFraudulent acts that are initiated electronicallyAutomated and employee driven methods that can reduce cyber-fraud risk
Ethics and Technology for CPAs
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:The foundational ethical principles CPAs are required to follow and how these principles apply to audit quality, data privacy and security, and the use of emerging technologies.The profession's need to change to meet its ethics standard in a technology-centric environment.Changes being considered by the AICPA and the National Association of State Boards of Accountancy that could impact the profession.
Mastering the Excel Lookup Functions
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
Leveraging ChatGPT for Innovative Business Advisory Services
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Introduction to ChatGPT and its applications in the business advisory contextIn-depth exploration of enterprise evaluation methodologies like SWOT, PESTLE, BCG Matrix, McKinsey 7S Model, Ansoff Matrix, etc.Practical case studies demonstrating application of ChatGPT in accounting business analysisKey challenges faced by accounting firms and how ChatGPT can help overcome theseBest practices for implementing AI tools in the accounting sectorFuture opportunities and trends in AI-enhanced business advisory services
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
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
How SAS Nos. 134-145 Improve Risk-Based Audits
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement auditsEnhanced required by-product communications with management and those charged with governance to promote more reliable financial statementsClarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimatesNew definitions and requirements related to identifying and evaluating risks of material misstatementOther important matters contained in SAS Nos. 134-145
Walter Haig's Personal Financial Health Checkup
-
Webcast Only
8.00 Credits
The topics that will be covered in this course include:Preparing a personal financial statement following U.S. GAAPRecasting U.S. GAAP personal financial statements into powerful management toolsIdentifying key financial factors that must be managed in order to achieve financial self-sufficiencyKey personal planning documents including HIPAA Medical Disclosure Document, Living Will, Medical Durable Power of Attorneys, and Letter of Instruction at DeathHow to create "goal" statements that achieve results
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
Written Information Security Plans
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Introduction to the Gramm-Leach-Bliley Act and its impact on data security.Circular 230 compliance and due diligence for practitioners.AICPA Statements of Standards relevant to WISP requirements.Key components of a Written Information Security Plan.Training requirements for employees, staff, and contractors.Practical guidance for drafting and implementing a WISP.FTC enforcement of data security standards for PTIN holders.Best practices for maintaining and updating WISP compliance.
ChatGPT for Accountants: 50+ Use Cases
-
Webcast Only
2.00 Credits
Major topics covered in this course include:Introduction to ChatGPT and artificial intelligence chatbot technologiesAutomating frequently asked questions and the onboarding processVerifying and reviewing financial recordsProviding real-time support to clientsGenerating financial reportsAutomating tax return preparation and financial planningProviding guidance on financial decision making
How Recent Auditing Standards Improve Risk-Based Audits
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement auditsEnhanced required by-product communications with management and those charged with governance to promote more reliable financial statementsClarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimatesNew definitions and requirements related to identifying and evaluating risks of material misstatementOther important matters contained in recent SASs
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.
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.
Exercise Your Ethics: Techniques to Improve Ethical Response
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Explore research for common answers to "what does ethics mean to you?" and examine whether those are valid.Identify common ethical barriers - reflecting the latest from the ACFE Report to the Nations.Discover ways to improve ethical response.Practice, using practical advice from leading thinkers in ethics.
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