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
Best Non-Google Search Tools for Accountants
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Why Advanced Search Skills Are So Critical for AccountantsWhy You Need More than Google to Search the InternetGARP: Generally Accepted Research PrinciplesAlternatives to GoogleAdvisory SearchSocial SearchSpecialty searchSearch Engine resourcesWhat's Ahead in Search
Tactics to Find Work Life Balance in a Complex World
-
Webcast Only
1.00 Credits
The major topics covered in this class include:How to get more out of one's workHow to achieve greater balance between today's ever more demanding and complex demands of work without losing sight of what is important in daily routinesExample of how to develop and be challenged by your own personal bucket list
Accounting of the Soul: Making the World a Better Place
-
Webcast Only
1.00 Credits
The major topics covered in this course include:Overview of Virtue Ethics and the Common GoodProfessionalismThe Virtue of CompassionGossip in the WorkplaceGratitude
Surgent's Employer's Handbook: Health Care, Retirement, and Fringe Benefit Tax Issues
-
Webcast Only
4.00 Credits
ERISA compliance: employee welfare plans and qualified plans Fringe benefit issues: COBRA, Family and Medical Leave Act, and new developments in health care Health care plans: HRAs, HSAs, and other employer-sponsored plans Qualified plan requirements: eligibility, coverage, and vesting
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:The rules of IRS disclosure of tax informationUnderstanding the role of IRS transcriptsInterpreting the actions of the IRS in transcriptsFOIA requestsAnalyzing tax information and returns for financial leads
Managing Current Fraud Trends in a Shifting Environment
-
Webcast Only
8.00 Credits
The major topics that will be covered in this course include:Summary of the impact of fraud on entities worldwide.Common fraud schemes and typical median losses that result.How smaller entity fraud risk differs from those of larger entities.The statistical profile of the most common fraud perpetrator.The most effective methods for preventing and detecting fraud.Cybersecurity risk management trends and best practices.
Understanding the New Forms K-2 and K-3
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Introduction to Schedules K-2 and K-3Review the filing requirementsDiscuss the different parts of the schedules and what needs to be included
Create Measures in Power BI that Define Your Metrics
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
Clean, Transform & Load Data in Power BI
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.Data Loading: Efficiently loading data into the Power BI data model.Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.
Mastering Partnership Basis: Inside and Outside Basis
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Explain the use of both "inside" and "outside” basis determination.How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property.Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis.Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest.Comprehensive example to illustrate the mechanics of the basis determination process.
Unlocking Deep Secrets: Case Studies in Financial Analysis
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of financial statement analysisThe impact of GAAP on financial analysisOverview of the Balance SheetOverview of the Income StatementThe importance of the Statement of Cash FlowsCommon Size AnalysisTrend AnalysisProfitability Ratio AnalysisLiquidity Ratio AnalysisSolvency Ratio Analysis
The Art of Engaging in Difficult Conversations
-
Webcast Only
2.00 Credits
The major subjects that will be covered in this course include:Awareness of your mindset entering the conversationTactics to build a pool of meaningClarity around story tellingBiggest mistakes to avoid
Accounting and Tax Ethics: Standards, Issues, & Case Studies 25-26
-
Webcast Only
4.00 Credits
AICPA Code of Professional Conduct Threats to compliance with Code of Ethics Updated Statement of Standards for Taxpayer Services (SSTS) Ethical challenges in selecting appropriate GAAP alternatives
Deep Dive Into Common Auditing Deficiencies
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Review common deficiencies identified by the AICPA and state boards of accountancy.Feature discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment.Review of the areas of concern and how you can overcome them by employing best practices.
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.
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
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
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.
What If Your Client Didn't Take Reasonable Compensation
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Review best practices to help your client evaluate if an S election is an appropriate choiceHow to be proactive and head off common reasonable compensation issues before they happenExplore strategies for cash management if cash isn't available at year endExplore what’s at stake when reasonable compensation isn’t paid timely