CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's 2024 Business Intelligence, Featuring Microsoft's Power BI Tools
-
Online
8.00 Credits
Business intelligence efforts continue to grow, and Microsoft’s Power BI platform is central to many of these efforts. Participate in this session to learn more about business intelligence and how to create dashboards using Power BI.
AICPA A&A Focus (12/11/2024)
-
Online
1.00 Credits
Get accounting, auditing and assurance updates The AICPA A&A Focus Series is designed to keep members up to date in the accounting, auditing and assurance space, prepared for today and tomorrow. Each live broadcast communicates the latest news and information, taking a deeper look at the topics and issues affecting your daily work. This series is your resource for tailored and timely information, including: Real-time interpretation and analysis Discussion of timely topics Insights from experts in the field ## As an AICPA member benefit, after registering for any single event, you will be automatically registered for the remaining events in the series. You may opt-out of the series at any time by contacting us at A&AFocus@aicpa-cima.com.
2024 Accounting Update in a Post COVID-19 World
-
Online
2.00 Credits
The COVID-19 pandemic has altered corporate and public accounting in ways we could never have imagined. This broad-based course will discuss accounting and auditing implications that have arisen as a result of the pandemic.
Surgent's The Accountant as the Expert Witness
-
Online
2.00 Credits
As litigation becomes more complex, attorneys are relying more on accountants to serve as consulting experts or expert witnesses at trial. Serving as an expert witness is not as difficult as you might expect. Accounting experts educate lawyers and jurors on issues such as valuation, tax liability, and forensics. Learn how accountants become expert witnesses, the role they play during pre-litigation through to trial, and the techniques experts employ to avoid challenges from opposing counsel.
Tax Implications of Cryptocurrency
-
Online
2.00 Credits
This course presents an overview of blockchain and the tax implication of cryptocurrency transactions. The IRS has provided some recent guidance, but potentially conflicting pronouncements by other regulatory agencies have created uncertainty on reporting issues. The practitioner will be helped to understand when a taxable transaction has occurred and what reports to file to satisfy IRS requirements. We will also identify tax traps for the unwary. This information is suitable for Corporate tax and finance executives, directors, managers and staff, CPAs, Enrolled Agents, accountants, attorneys and business/financial advisors who work with and advise individuals or businesses that use or invest in cryptocurrency. All in-house and public practice professionals involved with tax compliance and planning will benefit from this timely and insightful seminar. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's 2023 Mastering Advanced Excel Functions
-
Online
4.00 Credits
With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.
Data & Predictive Analytics & Business Intelligence for Controllers/CFOs
-
Online
4.00 Credits
The Accountant role is evolving from data aggregation to knowledge extraction, with a significant emphasis on understanding and leveraging technological advancements. In this era of rapid digital transformation, it is crucial for accountants to grasp the shift towards more analytical roles, learn the tools, and integrate Business Intelligence (BI) and Data Analytics (DA) in their organization and daily practices. This course will focus on raising the accountant's awareness of BI and DA practices, the impact of AI technologies like ChatGPT, and how these can benefit their organization. By embracing these technologies, accountants can enhance their value proposition by transitioning from traditional accounting roles to becoming strategic advisors and decision-makers.
Audit 208: Audit Reporting Basics - Report Issuance Process
-
Online
2.00 Credits
Audit Reporting Fundamentals - Introducing Core Concepts in the Audited Financial Statement Drafting and Issuance Process will provide tips and techniques necessary for issuing and reporting on high-quality financial statements prepared under any applicable financial reporting framework. The ultimate objective of a financial statement audit is to issue an auditor's report. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for drafting and issuing audit reports. 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 Government and Nonprofit Frauds and Controls to Stop Them
-
Online
4.00 Credits
George Washington once wrote, "We ought not to look back, unless it is to derive useful lessons from past errors, and for the purpose of profiting by dear bought experience." The cost of fraud, dearly paid by governments and nonprofits, is too severe not to learn and profit from. In this course, we will look back at real-world government and nonprofit frauds and derive useful controls to stop them. The course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced working knowledge of fraud and anti-fraud controls to both auditors and industry professionals.This course qualifies for yellow book credit.
Small Firm Update
-
Online
0.00 Credits
Join us for Small Firm Update webcasts so you can: Stay ahead with insights into the latest trends shaping the profession Avoid common pitfalls Embrace best practices derived from successful firms across the country Engage with us by submitting your questions and challenges, and our experts will address them in each session. *This webcast series is free and does not offer CPE credit. View and sign up for Small Firm Issues, the companion series to this webcast, here: https://www.aicpa-cima.com/cpe-learning/webcast/small-firms-issues Have a question or topic you would like covered at the next Small Firm Update webcast? Email our PCPS team at pcps@aicpa.org. View the full webcast schedule for both free and paid Small Firm webcasts here: https://us.aicpa.org/interestareas/peerreview/cpeandevents
HR Guide to Evolving Business Strategy, Finance and Development
-
Online
1.20 Credits
To move beyond the HR realm it is essential for HR professionals to understand planning at the strategic and tactical level. This session is designed to help HR professionals understand the overall strategic planning process so they can contribute at the executive level.
The Future of Work - The Landscape of Work Today - Micro-Credential Series Part 1
-
Online
1.20 Credits
The world of work today has never before faced so many simultaneous changes. From rising turnover and rising employee disengagement to the changing psychology of the workforce, the world of work is changing fast. In order to understand how to thrive in this complex landscape - we must begin by understanding the key drivers of change. What is changing in the world of work, why are these changes happening, and what can we expect will continue to change and what may not change. These are the elements we will explore in this class.
2024 Common Deficiencies in Employee Benefit Plans
-
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.
Ethics in Today's World and Practical Application Tips
-
Online
2.00 Credits
The topic of ethics has seemed to permeate every aspect of today’s business including occupying a significant spot in today’s business, educational and professional curriculum. Yet with all the discussion and awareness on the topic, why is it that significant ethical dilemmas and incidents continue to impact our daily lives? The concept of ethics is based in moral philosophy. In part, that is why it is such a difficult issue to “manage”. We often get caught between our independent moral ethical duty, the legal or compliance viewpoint of an issue and management concerns around reputation and ramifications. This course is dedicated to examining a time-line of historical ethical issues that have plagued the business world, evaluating the moral and perceived concepts around ethics, and taking a practical look at how moral and ethical concepts impact the creation of an ethical culture.
Accounting Fraud & Embezzlement: Case Studies from the Trenches
-
Online
2.00 Credits
Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving the theft of public money and the circumstances that allowed the fraud to occur. We will be looking at a variety of case studies to illustrate these points.
Predictive Accounting: Driver-Based Budgeting & Rolling Financial Forecasts
-
Online
2.00 Credits
The annual budgeting process is often criticized as an accounting exercise that is obsolete soon after it is published, prone to gamesmanship, cumbersome, not volume sensitive, and disconnected from the organization's strategy and risk management processes. You can resolve these deficiencies using capacity-sensitive driver-based projections. Driver-based budgeting allows for quick scenario planning and far easier analysis of a growing organization whose future may look nothing like today. The driver-based budgets can be periodically refreshed to create rolling financial forecasts extending well beyond the fiscal year end. Learn how managerial accounting can become managerial economics.
Planning in an Uncertain World
-
Online
2.00 Credits
We all make predictions in our personal and professional lives. We base our decisions to marry, buy a house, launch a new product or hire staff on expectations about the future. In the past few years, research into improving predictions has advanced. We will look at this research and current best practices in forecasting to help us prepare better budgets and projections.
Introduction to Single Audit
-
Online
2.00 Credits
Single Audits are an area of focus for the AICPA's Enhancing Audit Quality Initiative. The Uniform Guidance provides very unique audit requirements when auditing federal funds. This course will look into the unique performance and reporting requirements in Single Audits. Participants will have a basic understanding of internal controls over compliance, compliance requirements, how to use the Compliance Supplement, and the elements of a finding in a Single Audit.
2024 The New AICPA Statements on Standards for Tax Services
-
Online
2.00 Credits
The SSTS are tax standards that apply to all members who provide tax services and provide the framework for the AICPA ethical guidance for tax practitioners. This program explores the revised AICPA Statements on Standards for Tax Services, effective January 1, 2024. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.
Excel - Auditing Your Spreadsheets for Maximum Accuracy
-
Online
2.00 Credits
Did you know Excel has 400-500 functions depending on your version? Did you know there are 12 different function categories? Did you know you could create your own functions? After you attend this class, you will be in the know! In this webinar, we will focus on proofing and auditing your spreadsheets. You will learn how to build spreadsheets that validate the accuracy of your calculations and techniques to use the Data Validation feature to validate data entry. You will also learn techniques to cross-foot your data to ensure accuracy as well as how to use the various Excel Auditing Tools. This session is presented using Excel 2013. Regardless of the version you are using, ALL 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.