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!
Fraud Busters: Controls to Prevent & Detect Fraud
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Fraud motivators - the fraud triangle, typical profiles of fraud perpetratorsRevisiting the basics of controls - design vs effectiveness, preventative vs. detectiveEntity-wide controls and how they can assist in fraud deterrenceSpecific fraud types and the controls that could prevent and detect them
Surgent's Excel Shortcuts for Accountants
-
Webcast Only
2.00 Credits
Explore the function that sums better than the SUM function Discover a variety of time-saving features, functions, and techniques Learn the workaround to a major Excel pitfall
Surgent's The Risks and Benefits of ChatGPT and Artificial Intelligence
-
Webcast Only
2.00 Credits
What are AI tools? Where are we with AI tool development? What is ChatGPT? ChatGPT – what kind of queries are possible? Copyright and intellectual property issues Benefits of AI tools Concerns with AI tools Impact on business use of AI Policy on AI tools
Controls to Secure the Growing Digital Footprint
-
Webcast Only
4.00 Credits
The major topics covered in this course include:Securing individual documentsProtecting information resident in the CloudSecuring data stored on or accessed by mobile devices
Exploring Internal Controls That Could Have Prevented Frauds
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Examination of actual fraudsDiscussion of internal controls that could have prevented the fraudsContemplation of epiphanies for your own professional scenarios
Surgent's Select Estate and Life Planning Issues for the Middle-Income Client
-
Webcast Only
4.00 Credits
Changes to the lifetime estate tax exemption in light of proposed regulations SECURE 2.0 updates More than 20 documents that should be reviewed that are neither a will nor trust Provisions you need in a will Trusts and other arrangements for children Durable powers of attorney for healthcare and for financial matters Realistic retirement goals Developments relative to estate tax, and the implications for planning
Money Laundering 101 for CPAs
-
Webcast Only
4.00 Credits
The major topics covered in this class include:The theory of money launderingCommon money laundering statutesExamples from court cases of money laundering statutesCommon occurrences with CPAsPossible money laundering transactionsApplying the money laundering statutes in real life scenarios
Surgent's Introduction to Required Minimum Distributions
-
Webcast Only
2.00 Credits
How SECURE Act 1.0 and SECURE Act 2.0 changed the RMD rules What is an RMD? Who is subject to RMDs? The types of accounts subject to RMDs How to calculate an RMD How to determine if a distribution can be an RMD How to determine which life expectancy table must be used when calculating an RMD The rollover and transfer rules during an RMD year IRS penalties for non-compliance with RMD regulations Applying RMD strategies to different plan types When RMDs can and cannot be aggregated How to correct an RMD shortfall How to get a waiver of the excise tax on an RMD failure The tax implication of an RMD How to donate an RMD tax-free How to determine the RMD rules that apply to a beneficiary
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.
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
Surgent's Data Security: Best Practices to Protect Your Business and Yourself
-
Webcast Only
1.00 Credits
Ethical duty to safeguard employee, client, and litigant data Common threats, including phishing, ransomware, and bad password management Security management of business and personal electronic devices Best practices for creating and securing passwords Insight into how our personal information is exploited in our daily lives
Shortcuts that Excel Users Love
-
Webcast Only
2.00 Credits
The major topics covered in this course include:The power of keyboard shortcutsOft used features with more capability than meets the eyeNew helpful featuresNote: This session is taught using Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Webcast Only
2.00 Credits
Creating a data model/Power Pivot Building PivotTables from multiple tables Creating Measures Using named sets
Using AI to Instantly Transform Ideas into Revenue Streams
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:AI-powered ideation and opportunity identification techniquesDigital asset creation workflows using generative AI toolsAudio and video content generation using AI avatars and synthesisE-commerce integration and product development strategiesAI-driven presentation and visual content creationSocial media content optimization and distributionMulti-format content transformation (articles, songs, comics, storyboards)
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
Ethical Considerations in Working with Cannabis
-
Webcast Only
1.00 Credits
The major topics covered in this class include:Framework for assessing the propriety of offering services within the state legal, regulated cannabis industryAssist in identifying key stakeholders to be considered in conjunction to providing cannabis industry services, including:partnersstaffclientsBanking relationshipsMalpractice insurance
Integrity, Objectivity and Judgment: Values in Action
-
Webcast Only
1.00 Credits
The major topics covered in this class include:AICPA Code of Conduct: Integrity and ObjectivityCase Study: Mortgage crisis of 2007-2010Case Study: World Com
Surgent's Contract Law for Accounting and Finance Professionals
-
Webcast Only
2.00 Credits
Contract formation The necessary components of an enforceable contract Common defenses to enforcement Legal capacity requirements Contract interpretation
Surgent's Getting Ahead: The Art of Marketing for CPAs
-
Webcast Only
2.00 Credits
Challenges of marketing CPA firms Developing marketing strategy Elements of a marketing plan Example: CPA firm marketing plan Marketing regulatory/AICPA issues Picking the right marketing channels Marketing channel statistical analysis Developing marketing metrics
Microsoft Teams - Everything You Need to Know from A to Z
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Understanding the "big picture" of the role the Teams app plays in your Microsoft 365 ecosystemHow to effectively design your teams / channels configurationDetailed review of all the features for creating conversation postsDetailed review of all the features for creating, editing and managing Office files within the Teams appHow to use the search features to find Teams content instantlyStep by step review of how to host and participate in Teams online meetingsUsing Teams calling features for your phone systemHow to manage your notification settings in TeamsAnd more