CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Create Measures in Power BI that Define Your Metrics
-
Online
4.00 Credits
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 305: Strengthening Substantive Analytic Procedures
-
Online
2.00 Credits
Substantive Analytic Procedures - Strengthening Evidence to Satisfy Audit Objectives will provide the tips and best practice techniques for strengthening substantive analytic procedures in order to reduce over-reliance on tests of details. One of the ways to perform a more effective and efficient audit is to maximize the use of substantive analytic procedures in the detailed audit plan. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for analytical procedures. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Cultural Transformation
-
Online
1.00 Credits
This course provides a complete framework for transforming the culture in your organization. Key topics covered include: - What is organizational culture - A self assessment - Why culture matters - How to change your culture This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Auditing Financial Statements of ERISA Plans
-
Online
4.00 Credits
Conduct a compliant audit Identify proper audit procedures to test the line items of the statement of net assets available for benefits, including investments. Identify proper audit procedures to test the activity in the statement of changes in net assets available for benefits, including participant testing. Plan investments Differentiate plan investment procedures based upon the type of audit and risk assessment. Identify types and classifications of common plan investments. Identify audit procedures required for investment activity, contributions and benefit payment or withdrawals at the participant level. GAAP presentation and disclosure Understand GAAP requirements for presentation and disclosure for employee benefit plan financial statements. Other audit considerations Recognize procedures needed to determine the plan's tax status Learn how to identify related parties, parties in interest, and prohibited transactions. Recognize additional audit procedures needed for Form 11-K filers.
Tax Planning for Small Businesses - Tax Staff Essentials
-
Online
4.00 Credits
Clients want help with present and future business services. Which tax planning strategies will you provide for your corporate and small business clients? Updated for the latest legislation and IRS guidance on tax reform, this course answers the tough questions and shows you what strategies are best for your clients We use a case-study approach to explore opportunities for businesses and how the tax practitioner can continue to add value for their clients. Discussions will include traditional and new planning opportunities as a result of the latest tax legislation, including the SECURE 2.0 Act, and IRS guidance.
Excel - Functions and Formula Shootout
-
Online
2.00 Credits
Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. Most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Make Resilience Work for You - An Accounting Leader's Guide to a Holistic Approach for Managing Teams
-
Online
2.00 Credits
Resilience training was originally developed to strengthen individuals in high-risk groups like law enforcement, firefighters, and the military. This course also speaks to accounting and finance experts in a very challenging discipline. Resilience training is based on the intriguing assumption that resilience can be learned. A resilience leader possesses mental toughness, competence, and confidence. A confident accounting or finance person makes better decisions and thinks in deliberate ways to meet adversity and pressure. Resilience is the ability to exercise tenacity, bounce back from tough times, or even triumph in the face of adversity. Today's accounting professionals will experience challenges but are able to reframe then as learning opportunities. Resilient accounting and finance professionals push their limits, learn from their mistakes, and are able to transform an organization and themselves.
Surgent's Successfully Completing a Gift Tax Return -- Form 709
-
Online
2.00 Credits
Since the early 2000s, the estate tax burden on taxpayers has gradually decreased along with the number of practitioners specializing in the field. Nevertheless, some of your most wealthy clients will have a taxable estate. For these select clients, making large gifts before death can be extremely tax efficient for the client and profitable for the practitioner filing the gift tax return. Learning how to file a basic gift tax return can help you attract and retain clients, increase your value-add, and generate revenue.This course qualifies for IRS credit.
ChatGPT Bootcamp for CPAs with John Higgins
-
Online
4.00 Credits
ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Common Deficiencies in EBP Audits
-
Online
2.00 Credits
During this presentation, the most common mistakes made by employee benefit plan auditors, as well as plan sponsors will be identified. Best practices for handling specific issues that arise during the course of the engagement will also be explored. This discussion will help auditors recognize potential pitfalls in audit procedures/documentation and assist plan sponsors with compliance issues. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Engagement Management with the Microsoft 365 Planner App
-
Online
2.00 Credits
Are you using Excel to keep track of progress and task completion for your engagements? Or, are you using a sophisticated engagement management app that takes too much time or requires too much information to keep your task completion progress up to date? Worst of all, are you relying primarily on email communications to keep track of your engagement task completion progress? If any of these scenarios apply to your practice, this course will show you a better way to manage engagements from simple 1040 tax preparation to comprehensive audits. The Microsoft 365 Planner app, which you are likely already paying for as part of your Microsoft 365 subscription, provides a comprehensive, yet simple solution for all of your client engagements and internal projects. John Higgins, a nationally recognized strategic accounting technology advisor will guide you through the process of how to deploy this app to effectively manage all your projects. This app is effective for sole practitioners and firms of all sizes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's IRS Tax Examinations and Hot Issues
-
Online
4.00 Credits
Due to IRS issue focused examinations, Accounting and Finance Professionals need to understand what types of returns are selected for examination and ways to help clients survive an IRS audit with little or no change. As a result of issue focused examinations, Accounting and Finance Professionals must understand what the high audit risk area issues are and what the IRS is focusing on when a return is examined. In addition, because tax-related identity theft is a common issue for many taxpayers, it is critical for Accounting and Finance Professionals to understand the procedures necessary to resolve this matter for their clients.This course qualifies for IRS credit.
A&A Cluster: Fraud Case Studies: Schemes and Controls - A Virtual Event
-
Online
4.00 Credits
Save a minimum of $50 when you purchase any 4 or more of MOCPA's Cluster Events. USE CODE "CLUSTER24" AT CHECKOUT. Fraud is prevalent - especially since COVID-19 relief packages passed by legislatures around the world opened the till. The overwhelming majority of fraud cases are never publicized. In this course we will build on our knowledge of why people commit fraud to dissect the schemes and discuss transactional controls to help stop fraud faster.
Audit 306: Reviewing Workpapers - A Role in Quality Control
-
Online
2.00 Credits
Reviewing Workpapers - Embracing Responsibilities for Quality Control will provide the tips and tools for satisfying important workpaper reviewer responsibilities. Audit documentation provides the principal support for an auditor's report. Therefore, it is critical for workpaper reviewers to perform quality control procedures to ensure that technical, professional, and regulatory standards are met. In addition, the workpaper review process should be used as a tool for professional development and promoting efficient audits. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has workpaper review responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Implementing the New Risk Assessment Standard
-
Online
2.00 Credits
The auditor's responsibilities related to risk assessment have changed! This power-packed course will empower you with the working knowledge of SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, to successfully apply the standard.This course qualifies for yellow book credit.
Change: Embrace & Enjoy - It Is Inevitable
-
Online
2.00 Credits
We see change every day, but we ignore it as a key risk. Even though change is natural, it is also natural for humans to fight it. Why do humans think we can control everything? What are the steps we can take to adapt to change? Learn more about how we can become better at recognizing change and how we can embrace and adapt to the many changes we see every day. Change is inevitable. We can adapt to it or be replaced. We will discuss practical insights that will help you be even more successful in the office and in life. Effective leaders should not miss this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Power BI - OLAP Formulas & More Time Intelligent Functions
-
Online
2.00 Credits
This course is an extension of the Power BI series of courses that specifically explores using OLAP formulas and advanced time intelligent functions. OLAP formulas provide the ability to create a calculation in a cell that is based upon the measure in the data model. This powerful tool provides the ability to create calculations in an Excel worksheet without using a PivotTable to perform the calculation. Gone are the days of creating a PivotTable, then using those values in the PivotTable for additional calculations. When using Power BI to build a data model that connects to data files, you may want to know the date of these files. This class teaches you how to create a measure based upon the refresh date of your data. In the class "Power BI - Use Advanced Calculations with DAX Formulas," you learned the basics of time intelligent functions, the ability to calculate measures based upon dates. In THIS course, we will take it to the next step and teach you how to perform many more date-based calculations. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ChatGPT and Complex Financial and HR Conversations
-
Online
2.00 Credits
The course provides a concise overview of how accountants can use ChatGPT to assist with communications involving intricate and often sensitive topics that require a deep understanding of both financial principles and human resource policies. These conversations can range from budgeting and compensation to ethical considerations and regulatory compliance. The course also explores the use of ChatGPT in crafting clear, accurate, and empathetic responses to complex queries related to financial audits, tax planning, and employee benefits. It emphasizes the importance of balancing technical financial knowledge with effective communication skills to address diverse stakeholders' needs in various scenarios, from internal team discussions to client consultations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Owning an Electric Vehicle: Costs and Considerations
-
Online
2.00 Credits
With governments worldwide pushing the automotive industry towards electric vehicles (EVs), there might be an EV in your future or for your corporate fleet. Today, some vehicles are all gas, all electric or hybrid. How much do EVs cost to purchase, maintain and charge? Most EV owners charge at home but need public charging when venturing beyond their vehicle's range. Not all EVs can use every public charger and various charger types recharge at different speeds. This session will simplify the issues and tell you what you'll want to know if there is an EV in your future. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Digging Deep with Excel Pivot Tables
-
Online
1.00 Credits
This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.