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!
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
Risk Management in a Post-Covid World
Available Until
On-Demand Only
1.50 Credits
Black Swan Risks Role of Finance, Internal and External Auditors COSO's Risk Management Standards The COSO Cube The COSO Double Helix Risk Management Definitions Event Identification Expected Value Analysis The Heat Map The World Economic Forum Global Risk Reports Alternative Risk Responses Avoidance Reduce/Increase Share Accept Lessons from the Great by Choice Research Personal Risk Management
Schedule C of Form 1040
Available Until
On-Demand Only
2.00 Credits
Schedule C Business Deductions Self-employment taxes Business use of a vehicleSection 179 and Bonus Depreciation
Shorten Month-End Closing Best Practices
Available Until
On-Demand Only
4.00 Credits
Trends in financial statement closings including the Quick Close, Soft Close and Virtual Close Review and discuss information systems' headaches that slow you down Work through examples of close cycle "time killers" and how to resolve them Get inventory and cost of sales under control Identify the improvement projects that will yield the biggest benefit Review what leading edge finance managers are doing to close more quickly
Taxation of Business Entities
Available Until
On-Demand Only
2.00 Credits
Types of business entities (Sole proprietorship, Partnership, Corporation, Limited Liability Company and Limited Liability Partnership) Considerations in choosing a business entity, including taxes, limited liability protection, management & control, funding options & opportunities, tax consequences for the owners and the business. Future tax considerations that will impact various business entities.
An Exhaustive Look At Fraud & Ways To Control It (Part 1)
Available Until
On-Demand Only
4.00 Credits
Fraudulent acts initiated from outside organizationsWhy internal fraud occursThe importance of fighting cyber-fraudSteps that verify anti-fraud activities are working
An Exhaustive Look At Fraud & Ways To Control It (Part 2)
Available Until
On-Demand Only
4.00 Credits
Fraudulent acts initiated from outside organizationsWhy internal fraud occursThe importance of fighting cyber-fraudSteps that verify anti-fraud activities are working
Building Security/Efficiency via Internal Control (Part 1)
Available Until
On-Demand Only
4.00 Credits
An overview of control frameworks and conceptsStrategic considerations that can be incorporated into control developmentUnderstanding and controlling risk that arises when organizations change or choose not toThe COSO Internal Control Framework and the COSO ERM Framework
Building Security/Efficiency via Internal Control (Part 2)
Available Until
On-Demand Only
4.00 Credits
An overview of control frameworks and conceptsStrategic considerations that can be incorporated into control developmentUnderstanding and controlling risk that arises when organizations change or choose not toThe COSO Internal Control Framework and the COSO ERM Framework
Combating Internal Fraud
Available Until
On-Demand Only
2.00 Credits
Recognize why internal fraud occursPolicies, procedures, and control measures designed to fight fraud
Controls to Secure a Growing Digital Footprint
Available Until
On-Demand Only
4.00 Credits
Securing individual documentsProtecting information resident in the CloudSecuring data stored on or accessed by mobile devices