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 courses!
How SASs No. 134-145 Improve Risk-Based Audits (Governmental)
Available Until
On-Demand Only
4.00 Credits
Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement audits Enhanced required by-product communications with management and those charged with governance to promote more reliable financial statements Clarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimates New definitions and requirements related to identifying and evaluating risks of material misstatement Other important matters contained in SAS Nos. 134-145
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
Independence and Conflicts of Interest
Available Until
On-Demand Only
1.00 Credits
AICPA Code of Conduct: Independence, Conflicts of Interest, Case Study: Olympus Case Study: Buca di Beppo
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 - Testing for Operating Effectiveness
Available Until
On-Demand Only
2.00 Credits
Generally accepted audit requirements related to testing controls for operating effectivenessIdentifying key controls that may prove effective and efficient to test in a control reliance strategyResponses when deviations are discovered when evaluating the design or operating effectiveness of internal controlLeveraging audit evidence available for Service Organization Control (SOC1) ReportsGeneral computer control considerations when evaluating the design and operating effectiveness of internal control over financial reporting
Internal Controls to Mitigate Financial Reporting Risk
Available Until
On-Demand Only
2.00 Credits
Evolution of internal control conceptsRevamped 2013 COSO Internal Control - Integrated FrameworkDesigning an adequate "umbrella" of internal controls over financial reporting to prevent, or detect and correct, material misstatement due to fraud or errorSpecific internal control considerations and sample documentation for smaller entitiesAdditional responsibilities for audits in accordance with Sarbanes-Oxley Act, Government Auditing Standards, and Single Audit Act requirements
Like-kind Exchanges in Real Estate Transactions
Available Until
On-Demand Only
2.00 Credits
Like-kind exchanges have been hailed as one of the few "legal tax shelters" still available for real property investments, but it is really a result of favored tax policy. These relatively straight-forward concepts can help a company significantly improve cash flow by deferring its tax liability. These concepts will be illustrated by real-life examples that present a novel approach to like-kind exchanges as a useful and practical tax-planning idea.
Nonprofit Taxation: Key Tax Rules
Available Until
On-Demand Only
2.00 Credits
Recent tax legislation and developments related to non-profit entities such as charities, hospitals, universities and other non-profits A discussion of the basics of unrelated business income tax Excise tax on salaries exceeding $1 million Denial of fringe benefits and taxation of their value as UBIT Separating businesses for purposes of UBIT Excess parachute payments
Partnership/LLC Taxation: Tax Basis Capital Accounts
Available Until
On-Demand Only
2.00 Credits
Discuss the impact of the Section 199A flow-through entities deduction on partnerships and their partners The meaning of a "tax basis capital account" How the financial accounting and tax capital accounts differ from one another Determine a partner's share of the partnership's liabilities Distinguish "recourse" loans from "nonrecourse" loans What are "qualified nonrecourse financing" loans and how they affect partners Section 704 "built-in gain or loss" rules and how they impact Schedule K-1 reporting Section 4655 "at risk" rules and how they impact Schedule K-1 reporting
Partnerships: How to Calculate Partner Basis
Available Until
On-Demand Only
2.00 Credits
How to calculate the basis when the entity is formed, including the impact of contributed property Explains the use of both "inside" and "outside" basis determination Clarifies the importance of partnership capital accounts and partnerships debt on partner's tax basis Comprehensive example to illustrate the mechanics of the basis determination process Explanation of how basis is impacted by distributions of partnership property and sale and/or liquidation of the partnership interest
Power BI - Analyze Your Data With Excel PivotTables (Course 3)
Available Until
On-Demand Only
4.00 Credits
The advantages of PivotTable for Data AnalysisStep-by-Step PivotTable creationCreating PivotCharts
Power BI - Create Excel Dashboards for Maximum Impact (Course 4)
Available Until
On-Demand Only
2.00 Credits
Dashboard design guidelinesUsing Excel features to create visualsUsing visuals to create dashboardsIntroduce new Power BI tools that enhance visual and dashboard creation
Power BI - Go Beyond PivotTables with Power Pivot (Course 6)
Available Until
On-Demand Only
4.00 Credits
Data modeling in Power PivotUsing basic DAX to create calculationsWhat are and when to use calculated columns and measuresUsing the data model in Power Pivot to create PivotTablesHierarchies in Power Pivot
Power BI - Introduction to MS Power BI Tools (Course 1)
Available Until
On-Demand Only
2.00 Credits
The challenge of using Excel for Data AnalysisAn overview of the various Power BI ToolsAn overview of when and why to use each Power BI ToolA tour of each tools interface
Power BI - OLAP Formulas & More Time Intelligent Functions
Available Until
On-Demand Only
2.00 Credits
OLAP functions to create custom calculations on an Excel worksheetMeasures that help determine the date of your refreshed dataAdvanced time intelligent functions to create date-based measures
Power BI - Prepare Your Data Efficiently for Excel Analysis (Course 2)
Available Until
On-Demand Only
2.00 Credits
Getting data into the correct structureData sources that you can accessWorking with multiple tables and data sourcesSteps to import data for analysisIntroduction to Power Query and Get and Transform
Power BI - Share Your Data Analysis using PowerBI.com (Course 9)
Available Until
On-Demand Only
2.00 Credits
A tour of the PowerBI.com interfaceSharing data with Power Pivot and Power BI DesktopCreating visualizations and turning them into dashboardsSharing visualizations and dashboards with others
Power BI - Use Advanced Calculations with DAX Formulas (Course 7)
Available Until
On-Demand Only
4.00 Credits
Review Power Pivot calculations (column calculations vs. measures)Create advanced DAX formulasUsing a Date / Calendar table for data analysisThe DAX calculation process
Power BI - Use PBI Desktop to Create Reports and Dashboards (Course 8)
Available Until
On-Demand Only
4.00 Credits
Tour of the Power BI Desktop interfaceUsing Power BI Desktop to connect to data sourcesAvailable visualizations in Power BI DesktopBuilding interactivity into visualizations
Power BI - Use Power Query to Transform Your Data (Course 5)
Available Until
On-Demand Only
2.00 Credits
Append files Combine multiple files from a folderAdd custom columnsUnpivot a tableCreate a lookup table from a table