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!
Advanced Excel: Hidden Secrets and Gems
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models
Seeing Beyond the Numbers: Analysis for CFOs & Controllers
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Purpose of Financial Statement AnalysisComparing Actuals vs. Expectations & BenchmarkingCase Studies 1 & 2Ratio AnalysisCase Study 3Analysis of Statement of Cash FlowsCase Studies 4 & 5Other Uses of Ratios
Internal Control Changes for Remote Workers
-
Webcast Only
2.00 Credits
The major topics covered in this course include:The benefits and pitfalls of remote employees.How to maximize the value provided by distance workers.Policies, procedures, and control measures designed for a more geographically dispersed workforce.
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
Microsoft 365: Save More Time, Make More Money
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Appreciate the full potential of Microsoft 365 to drive efficiency in your businessLearn best practices for harnessing the power of Microsoft 365 Design your Teams app setup to meet the unique attributes of your businessUse SharePoint and OneDrive to organize your files and share them securely internally and externallyOrganize your thoughts, meeting notes and other content centrally in OneNoteManage your projects, large and small, with the Planner appDeploy the Stream app to document processes efficiently and effectively Bonus Content: Understand how to harness the power of AI with Microsoft Copilot
ChatGPT Vision for Financial Analysis
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to GPT Vision - Understanding the fundamentals of GPT Vision and its capabilities.Advantages of Vision Mode Research - Exploring the unique benefits of visual data analysis over traditional methods.Accessing GPT Vision - Guidance on how to access and utilize GPT Vision capabilities.Financial Screenshot Analysis - Techniques for analyzing financial documents and reports through screenshots.Operational Insights from Visual Data - Using images to gain insights into operational processes and asset management.Integration with Google Maps - Learning how to combine ChatGPT's vision capabilities with mapping technologies for enhanced spatial analysis.DDPP Analysis - Applying descriptive, diagnostic, predictive, and prescriptive analysis to visual data.Sentiment and Facial Expression Analysis - Techniques for interpreting emotions and sentiments in images to gauge client and employee feedback.Body Language Interpretation - Analyzing body language in images to understand non-verbal cues in business contexts.Effective Photo Capturing Techniques - Best practices for taking photos that provide optimal insights for financial analysis.
How Much Are Your Ethics Worth?
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Understanding ethicsAvailable tools to aid in ethical decision makingThe role of bias in making ethical decisionsApplication through case studies
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.
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
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
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
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
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
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
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
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
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
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.
Using e-Signature Software to Process Agreements-Updated
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Review of the digital document signing process.Key features to evaluate in selecting a solution.Review and distinguish top selling e-signature applications.Best practices for deploying e-signature software in your practice or business.
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.