CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Fraud Busters: Controls to Prevent & Detect Fraud
-
Online
2.00 Credits
This course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
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.
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.
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.
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.
Ethics - Regulatory and Standards Update
-
Online
2.00 Credits
Stay current on recent changes to the AICPA Code of Professional Conduct and keep abreast of emerging trends in ethics standards and regulatory initiatives and their potential impact on your practice. Explore frequent practitioner ethics compliance challenges, including competence, due professional care, audit quality, and independence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
CFO Solutions to IRS Problems
-
Online
4.00 Credits
Many CPAs are becoming full-time or fractional CFOs for small businesses. In that position, they are the resident expert in finances, cash flow planning, and budgeting. But what about dealing with the IRS? The IRS has broad powers to administer the assessment and collection of taxes. From removing penalties to criminal prosecutions, this presentation focuses on how CFOs can prevent problems with the IRS and how to develop winning strategies if the IRS knocks on the door. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Understanding the Form 990 and its Preparation Prerequisites
-
Online
2.00 Credits
Introductory Session of Borenstein's Form 990 Foundational Series: This "initiation and introduction to" the Form 990's mechanics and importance will prevent you from drowning in the Form 990's force-field! More than 80% of the Form's inputs and relevant definitions are NOT found in the statutes and Regulations that apply to the exempt sector, a reality that can be overwhelming for both novices and more advanced preparers. This session provides an easy-to-digest synopsis of the entirety of the Form's key definitions as well as the mechanics that preparers need embrace from the moment they first approach preparing a 990. Packed with practical tips and perspectives on data gathering, this class is a "must" gateway for beginning (and even more experienced) preparers to learn "how to befriend Form 990 preparation." This webinar will vault preparers past all the initially confounding problems of the Form 990, providing baseline info on the critical nuances the form uses. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Keeping Up with the FASB
-
Online
2.00 Credits
This course will explore significant elements of the FASB's technical agenda, focusing on recent updates to revenue recognition and lease accounting standards. A Special Purpose Framework overview will be provided, which may reveal salient alternatives to U.S. GAAP for certain entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Improve Spreadsheets by Building Controls in Excel
-
Online
2.00 Credits
In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Leadershift: How to Embrace Disruption and Lead Change
-
Online
1.00 Credits
Leading change now ranks in the top three leader skills of the future. As audit, risk management, and governance are relied on more and more in organizational decision-making, the need to lead change is paramount. Leaders and practitioners at all levels must oversee or manage change in today's environment. Whether you are a CEO, small business owner, or individual practitioner, you lead change in your environment. In this session, learn how to lead change BETTER because everyone is a leader of someone. Build alignment with those you lead and work with, motivate and inspire, and model the behaviors that drive change. This session breaks down strategies into manageable steps that anyone can cultivate. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.