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!
Excel - Functions & 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 - 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
Accountants and Malpractice; Can We Get Sued for This?
Available Until
On-Demand Only
2.00 Credits
How accountant liability is a very real threat in today's litigious society.A discussion of scenarios in which accounting professionals can find themselves inadvertently involved in a lawsuit.Pitfalls in which the accountant may find him- or her- self while dealing with clients.Real-life examples from the speaker's extensive experience as a practitioner and as an expert witness in accounting malpractice cases.
Advanced Excel: Hidden Secrets and Gems
Available Until
On-Demand Only
2.00 Credits
Awareness of advanced functions Creative methods for data manipulation Using intellectual curiosity and professional skepticism to develop a problem-solving mentality Real-life examples of innovative ways to analyze and report data with Excel Using Excel to perform e-mail merges Many other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolbox Enhance creativity in your approach to developing Excel models
Advanced Planning: Balance Sheet and Cash Flow Projections
Available Until
On-Demand Only
1.00 Credits
Accounts Receivable Inventory Capital Budget Depreciation Accounts Payable Accrued Liabilities Working Capital Loans Debt Project interest expense more accurately Solving for Cash Projecting Covenant Calculations Create a Projected Statement of Cash Flow Choose your format How to make your Statement of Cash Flow maintenance free Debugging a statement of Cash Flow
Aligning Budgets to Strategy
Available Until
On-Demand Only
2.00 Credits
A Proper Practical Planning Process (P4) The steps to planning The results of strategic planning Examples of budgets
Cases in Corporate Ethics
Available Until
On-Demand Only
4.00 Credits
We introduce new case selections to this seminar every year. Past cases have included these issues: Can you protect the public interest without violating our profession's confidentiality rules? How can a corporate world CPA get in trouble with their board of accountancy? Is a culture of fear and intimidation particularly susceptible to corporate fraud? How can using the CPA credential get a corporate accountant in trouble? Is exaggerating your CPE hours a violation of our professional codes of conduct? What are your options when your employer is clearly breaking the law? Does any legislation provide effective Whistleblower protection?
Communicating Financial Information to Non-Accountants
Available Until
On-Demand Only
2.00 Credits
The math literacy barrier The financial literacy barrier What to say and how to say it Communicating ideas graphically
Compilations, Reviews and Audits: How They Differ
Available Until
On-Demand Only
1.00 Credits
Review of differences of compilation, review and audit engagements Compare and contrast major considerations of each type of engagement Provide practical tips and strategies Professional standards that govern each type of engagement
Corporate Ethics: Cases in Diversity and Inclusion
Available Until
On-Demand Only
1.00 Credits
Everyone can experience discrimination or harassment What the AICPA Code of Professional Conduct says about harassment and discrimination Other sources of ethical guidance Recent EEOC CasesLearning about each other
Dream Wide Awake
Available Until
On-Demand Only
2.00 Credits
The three promises to live and achieve by A different way to approach goals that brings out what is really holding you back The five areas of wishful thinking and how to surpass with inspired action The six areas of fearful thinking and how to overcome with courageous intent
Entertainment, Meals & Travel Expenses: Review & Update
Available Until
On-Demand Only
2.00 Credits
Definition of what qualifies as an entertainment expense Strategies to deduct business entertainment expenses Deductibility of meals Situations not subject to the 50% meals and entertainment reduction How to handle automobile issues related to employer-provided parking Proper accounting for deductible vs. non-deductible expenditures The four steps to analyze business expenses The latest federal legislation, cases and rulings
Ethics: 10 Crucial Qualities of High-Character CPAs
Available Until
On-Demand Only
2.00 Credits
Discover why the ten crucial qualities of high-character CPAs are essential to your success Learn how to evaluate these qualities in job candidates and why you must do so
Ethics: Get Rich, Lose Weight, and Enjoy True Love
Available Until
On-Demand Only
2.00 Credits
We will begin with a "What would you do?" quiz with five challenging scenarios. You'll be asked to choose among several options in each situation (don't worry, we won't collect the results). Next we'll do a deep dive into the five principles of ethical intelligence: Do No Harm Make Things Better Respect Others (by keeping confidences, telling the truth, and keeping your promises) Be Fair CareComplete a few fun writing exercises (optional) during the webinar. After which, Bruce shows how the principles of ethical intelligence reveal which option in each scenario is best. We'll conclude with a Call to Action so that some of the lessons from this webinar can be put into practice immediately. Even doing one of the things Bruce suggests will enrich your accounting practice and your life.
Ethics: How to Build and Keep Your A-Team
Available Until
On-Demand Only
1.00 Credits
Advertise for character Hire for character Promote and fire for character Walk the talk
Ethics: How to Ensure Zombie Ethics Won't Kill Your Business
Available Until
On-Demand Only
2.00 Credits
We'll closely examine several myths about ethical leadership that continue to plague businesses like yours. You'll learn why these ideas deserve to be put to rest for good and what should take their place. This will be an ethics webinar unlike any you have ever taken-because it will be both entertaining and rich in content!
Ethics: Lead Like a Superstar and Build a Rocking Business
Available Until
On-Demand Only
1.00 Credits
We'll closely examine several superstars from movies, TV, music, sports, and business. What makes them so successful? What can you learn from their mistakes? Yes, there will be one or two superstars you don't care for--perhaps even loathe--but you can still learn a lot from them.
Excel - Advanced Defined Names & Excel Tables
Available Until
On-Demand Only
2.00 Credits
Using the INDIRECT function with Defined NamesThe importance of Consistent Column CalculationsWays to create Consistent Column CalculationsUsing Structured Table References in formulas
Excel - Advanced Financial and Statistical Calculations
Available Until
On-Demand Only
2.00 Credits
Identifying and demonstrating financial functions "best practices" for creating amortization schedules and calculating annual interest paymentsCalculating and summarizing data with SUMIF and SUBTOTAL functionsUsing statistical functions to analyze data
Excel - Advanced Formatting to Improve Your Spreadsheets
Available Until
On-Demand Only
2.00 Credits
Customizing cell formatting and cell stylesUsing number and custom number formattingUsing Conditional Formatting to format cells based upon a defined criteriaProtecting a worksheet and workbook to prevent changes