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!
Excel - Functions and Formula Shootout
Available Until
On-Demand Only
2.00 Credits
Review of formula creation best practicesDemonstration of various Excel functions to enhance calculationsUsing Excel functions to perform advanced calculations
Excel - Fundamentals, Data Entry and Basic Formulas
Available Until
On-Demand Only
2.00 Credits
Review of the Excel interfaceBasic data entry tasks using the fill command, range selection and copy & pasteBasics to creating formulas (absolute/relative reference, auto-computer, functions)
Excel - New Features That Benefit Excel 2019 & O365 Users
Available Until
On-Demand Only
2.00 Credits
The new capabilities of Array FormulasNew formula functions, including XLOOKUP, XMATCH, SEQUENCE and moreUsing the Ideas featureMany more new features
Excel - Using Charts for a Non-Financial Audience
Available Until
On-Demand Only
2.00 Credits
Selecting the right type of chartCreating dynamic chartsChoosing what data to display as a chartCustomizing charts using various optionsPrinting and sharing charts
Excel - Using PivotTables for Data Analysis
Available Until
On-Demand Only
4.00 Credits
The advantages of PivotTable for Data AnalysisStep-by-Step PivotTable creationCreating PivotCharts
Excel - Working With Text, Date and Time Functions and Formulas
Available Until
On-Demand Only
2.00 Credits
Using Text functions to join and separate text entriesInserting Text functions to work with imported dataPerforming date and time calculations with the Date and Time functions
Exploring Internal Controls: That Could Have Prevented Fraud
Available Until
On-Demand Only
2.00 Credits
Finding Errors in Excel Spreadsheets
Available Until
On-Demand Only
2.00 Credits
Fraud & Embezzlement; Case Studies from the Trenches
Available Until
On-Demand Only
2.00 Credits
How organizations can find themselves defrauded due to lax oversight and weak internal controls. How the existence of the "trusted advisor" creates situations where CPAs can drop their professional skepticism. illustrations of the issues companies should look for in preventing fraud and embezzlement.
Fraud Trends - Applying Real-Life Lessons to Small and Mid-Size Entitie
Available Until
On-Demand Only
2.00 Credits
GASB 87: Are You Ready?
Available Until
On-Demand Only
1.50 Credits
Leases GASB 87 Financial reporting
How AI is Automating Internal Control
Available Until
On-Demand Only
4.00 Credits
How Changes in Business Methods Affects Internal Control (Part 1)
Available Until
On-Demand Only
4.00 Credits
How Changes in Business Methods Affects Internal Control (Part 2)
Available Until
On-Demand Only
4.00 Credits
How Fraud Can Affect Smaller Organizations
Available Until
On-Demand Only
4.00 Credits
The reasons for fraudFraudulent acts that are initiated against smaller organizationsMethods to stop fraud attempts against small businesses
IRS Penalties and Abatements
Available Until
On-Demand Only
2.00 Credits
Various types of penalties: Accuracy related, fraud, understatement of valuation, reporting requirement, failure to pay, and pay or deposit penalties Rules on waiver of penalties and interests Various forms and procedures for requesting relief First Time Abatement: Requirements and procedures How an individual taxpayer qualifies for Reasonable Cause abatement Procedures for requesting refund of paid penalties Available administrative options
Implementing and Maintaining an Internal Controls (Part 1)
Available Until
On-Demand Only
4.00 Credits
Control creation and implementation basicsImplementation and update procedures for an Internal Control systemMaintaining existing internal controls
Implementing and Maintaining an Internal Controls (Part 2)
Available Until
On-Demand Only
4.00 Credits
Control creation and implementation basicsImplementation and update procedures for an Internal Control systemMaintaining existing internal controls
Integrity, Objectivity and Judgment; Values in Action
Available Until
On-Demand Only
1.00 Credits
AICPA Code of Conduct: Integrity and Objectivity Case Study: Mortgage crisis of 2007-2010 Case Study: World Com
Internal Control Changes for Remote Workers
Available Until
On-Demand Only
2.00 Credits
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.