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!
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.
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
Securing Your Data with a Password Management App - Updated
-
Webcast Only
2.00 Credits
The major topics covered in this course include:Introduction to the world of password management apps and what makes them so secureReview and demonstration of top selling password management appsSoftware features that will be reviewedPassword generationEmergency user accessEntity vs. individual password managementDesktop vs. cloud basedMulti device synchronizationPII (personally identifiable information) forms fillerCredit card storageDigital data vault
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.
Financial Decisions that Led Two Businessmen to Prison
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
Surgent's Annual Update for Defined Contribution Plans
-
Webcast Only
2.00 Credits
Common risks and pitfalls associated with defined contribution plans Nuances of the fair value disclosures New reporting and disclosure requirements for the current year Results of DOL Audit Quality Study
Surgent's Excel: Mastering PivotTables
-
Webcast Only
2.00 Credits
Explore PivotTable capabilities and functionality Retrieve data from a database and feed it into the PivotTable Pull web tables from web pages into Excel
Surgent's Guide to Calculating S Corporation Shareholder Stock and Loan Basis
-
Webcast Only
2.00 Credits
Introduction to Form 7203 Introduction to the calculation of stock basis Introduction to the calculation of loan basis Taxable and nontaxable S corporation distributions to shareholders The election to reduce basis by deductible losses and expenses before reducing basis by nondeductible expenses
Surgent's Understanding S Corporation Taxation: Compensation Issues and Entity-Level Taxes
-
Webcast Only
2.00 Credits
Reasonable compensation Fringe benefits for S corporation shareholders Built-in gains tax Excess passive income tax Notice 2020-75: PTE elections
Surgent's Work-Life Balance: Maximizing Productivity and Understanding Related Tax Issues
-
Webcast Only
2.00 Credits
Discuss how productivity strategies may improve work-life balance Understand the state tax consequences that may arise when working from home Identify and discuss challenges unique to financial professionals Review how some organizations are providing support to improve work-life balance Explore the role of alternative work arrangements Examine challenges unique to auditors versus tax professionals A comparison of work-life balance between public and industry accountants How work-family conflict varies among financial professionals Recommendations for improving work-life balance
Surgent's Coaching Skills for Managers and Supervisors
-
Webcast Only
4.00 Credits
The definition of “coaching” and the coaching process Characteristics of effective coaches Coaching strategies to support and assist others as they change ineffective behaviors Conducting one-on-one coaching sessions for setting goals and improving performance
Becoming Conflict Competent
-
Webcast Only
2.00 Credits
Major topics covered in this course include:Levels of conflictStrategies to de-escalate conflictDistinction between miscommunication and conflictResponses to conflictTactics to address, rather than avoid, conflict
Create Visuals in Power BI to Successfully Analyze Data
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Tour of the Power BI Desktop Interface: Understand the layout, tools, and features of Power BI Desktop.Tour of PowerBI.com Interface: Familiarize with the online environment of Power BI for report creation.Importing Power Pivot Data Model: Understand how to integrate Power Pivot models into Power BI for more complex data analysis.Building Visuals: Learn the step-by-step process to create compelling visuals and understand the importance of visual context in data storytelling.Review of Available Visuals: Explore the variety of visuals available in Power BI and their appropriate applications.Power BI Desktop Features: Delve into the advanced features of Power BI Desktop, enhancing data manipulation and visualization capabilities.Building Interactivity into Visuals: Learn to create dynamic and interactive reports that engage and inform.Publishing Reports to PowerBI.com: Gain skills in uploading and managing reports on PowerBI.com for wider access and collaboration.
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
Surgent's Implementing Subscription Pricing to Your Practice
-
Webcast Only
2.00 Credits
The basics of subscription pricing Pricing strategies, with an eye toward a modern model for your business How to implement subscription pricing The need to look back and assess the financial impact of the implementation How to manage customer retention The optimum subscription pricing for your business
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
2025 AICPA Regulatory Ethics Update
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:The Professional Ethics Executive Committee's updated ethics rules.An overview of recently issued ethics rules that CPAs need to know to be compliant.
Ethics of AI: A CPA's Guide
-
Webcast Only
2.00 Credits
The major subjects that will be covered in this course include:A primer on AI technology applications in the accounting professionEthical dilemmas that originate from the use of AI by CPAsPractical guidelines for using AI technology ethicallyStep by step guide for creating an AI usage policy for your organizationReview of a variety of reference materials to assist you in using AI ethically
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
Create Paginated Reports with Power BI Report Builder
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Introduction to Power BI Report Builder: Overview of the tool, its interface, and integration with the Power BI ecosystem.Designing Report Layouts: Techniques for setting up professional layouts, including headers, footers, and managing pagination.Data Connection and Management: Connecting to various data sources and preparing data for reporting.Creating Visualizations: Utilizing Power BI’s visualization tools for impactful data presentation.Advanced Report Features: Exploring sub-reports, drill-through capabilities, and dynamic expressions.Publishing and Sharing: Guidelines for publishing reports to the Power BI service and sharing them with relevant stakeholders.