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.
Accounting Industry Update 25-26
-
Webcast Only
8.00 Credits
FASB Technical Agenda and upcoming changes ASUs Implementation dates and methods Audit quality initiatives Changes to AICPA auditing standards; and PCAOB standards
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
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.
Surgent's Data Analytics for Accountants and Financial Managers
-
Webcast Only
2.00 Credits
Definition of data analytics and big data; challenges and goals; establishing an environment for success; governance; common uses of analytics and current examples Behavioral forces that impact decisions; examples of inaccurate forecasts; identifying strategic measurements (KPIs); data sources Statistical tools, including median, mode, moving average, ratio analysis, Pareto analysis, trend analysis, regression, z-score, and simulation Software tools that are readily available and can assist in visually exploring data, expanding the scope of available data, as well as collecting, analyzing, and presenting results Specific ideas for using data analytics for accountants and financial managers, including current examples and areas for further consideration Lists of readings and next-level software for a participant’s future reference
Surgent's Ethics for Tax Professionals
-
Webcast Only
2.00 Credits
What does practicing before the IRS mean? Who may practice before the IRS? What should a tax preparer do if he or she has knowledge of a client's omission of income from a tax return? May a tax preparer rely on the work of other tax return preparers? May a tax preparer rely on and use client-provided information? Standards associated with giving advice to clients Abolition of the disclaimer requirement When must a tax preparer examine a client’s books and records?
Surgent's Lessons Learned from Successful Companies
-
Webcast Only
2.00 Credits
Creating a visionary company Traits of successful, visionary companies Goal setting to create a successful organization The role of experimentation and failure in achieving success How successful organizations emphasize learning new skills The role of effective communication in achieving corporate success The importance of emotional intelligence in building corporate culture How leadership can direct a company toward success
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
Surgent's Individual and Financial-Planning Tax Camp
-
Webcast Only
8.00 Credits
Comprehensive coverage of the SECURE Act 2.0 Understanding the environment: what’s new, what’s expired or expiring, and what’s likely to change Reading a tax return for developing client-specific tax strategies Changes to the lifetime estate tax exemption in light of proposed regulations The net investment income tax: planning for compliance Family income-splitting strategies that need to be considered Income tax issues: impact on timing of other income Selling a principal residence Two principal residences at the same time Use of life insurance to protect families: Whole Life Insurance, Term Life Insurance, Universal Life Insurance, and Variable Life Insurance Using Roth IRAs and Roth contribution programs to best advantage Conversions: do they still make sense? Taking distributions: matching timing to client requirements Qualified plan contributions to reduce current income and Social Security tax: implications for business owners and self-employed Social Security solvency issues Incentive Stock Options and Employee Stock Purchase Plan considerations What to do about itemized deductions Trans-generational planning: conversions, income, and gain-splitting Tax benefits of HSAs and other tax-advantaged accounts Identifying tax opportunities: reviewing the prior-year return to develop a plan for the future Planning for middle-income taxpayers: financial planning for the young, the working, and those approaching or in retirement Best financial planning ideas for young people
Surgent's Perplexing Financial and Economic Issues for the CFO/Controller
-
Webcast Only
8.00 Credits
Regulatory, fiscal, and monetary policies impact on the organization Dodd-Frank Bill and impact on financial reform Health insurance reform and the impact on the employer Managing risk in an uncertain economic climate
Surgent's Single Auditing Made Simple
-
Webcast Only
8.00 Credits
The key requirements and responsibilities related to the schedule of expenditures of federal awards and the determination of major programs The processes of determining the direct and material compliance requirements, obtaining an understanding of and testing the related internal controls, and performing compliance testing The development and reporting of findings in the schedule of findings and questioned costs Additional performance and reporting responsibilities
ChatGPT and Complex Financial and HR Conversations
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Complex and nuanced communications related to:Budget Allocation and Negotiation TechniquesCompensation and Benefits StructuringManaging Financial Performance and LayoffsFinancial and HR Aspects of Mergers and AcquisitionsRegulatory Compliance and Ethical Financial PracticesStrategies for Financial Crisis ManagementEffective Performance Management Systems
Surgent's Schedules K-2 and K-3: Preparation of Forms
-
Webcast Only
2.00 Credits
How to read and complete Parts II and III for Foreign Tax Credit Practical tips on how to tackle Parts IV and IX for corporate partners How to correctly fill out Parts X and XIII for foreign partners Comprehensive examples for operating, real estate rental, and investment partnerships with filled-in sample forms
Tax Depreciation: Review and Update
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Recent tax legislation and developments related to capitalizationEligible property for Section 179 and Section 168(k)Discussion of the Section 179 deduction and its use to depreciate real propertyThe Section 168(k) deduction and its use to depreciate real propertyDisposition of segments of real propertyExchanges of tangible personal property after repeal of the like-kind exchange rulesOther related topics
Lease Implementation for Private Entities 25-26
-
Webcast Only
4.00 Credits
Analysis of requirements for lease accounting under ASC 842, including detailed schedules showing journal entries and computations Analysis of internal control and fraud risk aspects Identification of high-risk areas of lease accounting and reporting Suggested audit and review procedures for identified risks
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
Accounting Industry Update 25-26
-
Webcast Only
8.00 Credits
FASB Technical Agenda and upcoming changes ASUs Implementation dates and methods Audit quality initiatives Changes to AICPA auditing standards; and PCAOB standards
Leadershift Ethics: Things Must Change!
-
Webcast Only
2.00 Credits
The major topics covered in this course include:The litmus test for all of your decisions and actionsEthical principles when managing through changePressures that threaten ethical change managementCase studies of what can go sideways when ethics are not part of every stage of changeWinning strategies for ethical self-regulation
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
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