CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Taking Advantage of Array Formulas in Excel
-
Online
2.00 Credits
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Avoiding Legal Liability and Peer Review Deficiencies in Nonaudit Services, Including Bookkeeping and Preparin
-
Online
8.00 Credits
The majority of peer review deficiencies and malpractice claims result from nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns.
Build a Data Model for Analysis in Power BI
-
Online
4.00 Credits
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
AI Revolution: The Big Picture for CPAs
-
Online
2.00 Credits
Discover how artificial intelligence is transforming the accounting, tax and finance landscape. This course offers CPAs a comprehensive overview of AI technologies, with a special emphasis on generative AI tools such as ChatGPT and Google Gemini. Learn how these advancements are reshaping business operations and what they mean for your professional role. 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 Getting Ready for Busy Season: Key Changes Every Tax Practitioner Should Know
-
Online
4.00 Credits
Getting ready for busy season involves not only knowing what's new for the current year, but also understanding how the changing limits, phaseouts and other rules apply to current-year returns. With major legislation enacted over the past few years, the present course will constitute a one-stop "shop" that brings you the essential individual tax information. In addition, this course provides an up-to-date review of important tax form changes, new tax forms, new limitations, key developments as they are reflected in the IRS forms, and IRS filing issues and deadlines that will be invaluable to attendees who prepare tax returns during busy season.This course qualifies for IRS credit.
2024 Revision to Government Auditing Standards Impact
-
Online
4.00 Credits
This course will provide an update of Government Auditing Standards as a result of the GAO's issuance of the 2024 Revision to Government Auditing Standards. The course will focus on the Revisions impact on financial statement audits. The course will also focus on the impact of Quality Management Standards as well as clarify as to when the concept of reporting key audit matters might apply for financial audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Rewards & Recognition Strategies for Leaders
-
Online
1.00 Credits
Whether you are responsible for managing 1 employee or 20, your leadership can make or break your team. Learn practical leadership strategies that you can implement when you return to your office. In today’s competitive market, it’s more imperative than ever that as leaders we are inspiring and motivating our teams to success.
Employees Today and Tomorrow: Understanding and Improving The Employee Life Cycle
-
Online
2.00 Credits
Many organizations have a process documented for their employment life cycle but do not look at it wholistically. Having a longer view of the employee life cycle can provide more value to your company that you might think. Join us for an interactive discussion around the entire life cycle of employees with best practices discussed on continuous improvement for your organization. This session will provide an overview of each of the steps in the timeline from multiple perspectives, to provide keen insights on actionable ideas to take back to your workplace and implement today.
The Motives and Mystery of Ethics-Understanding the Why
-
Online
2.00 Credits
Our guidance on ethics comes from the AICPA and other groups, but it does not fully address the “why” behind ethics. This session will examine and define what ethics is and what it means to varying people in the workplace. Understanding what motivates people and understanding those people are key to both solving ethical dilemmas and workplace issues that can lead to greater job satisfaction and efficiency. To correct an issue, you need to delve into the root cause – the why?
The Role of Internal Audit in SOX Compliance
-
Online
2.00 Credits
The Sarbanes Oxley Act (SOX) continues to pose challenges with compliance. Companies must continue to evaluate whether they have designed and implemented an adequate system of internal controls over financial reporting (ICFR). This course will address the best practices that ensure an effective and efficient approach to SOX compliance.
Ethical Leadership: Power, Influence, Integrity, and Trust
-
Online
2.00 Credits
Leaders naturally wield power and influence. But, to avoid the temptation of abusing power, leaders must apply ethical behaviors for themselves and others. Words, actions and deeds which demonstrate integrity and trust yield the credibility that make others want to follow ethical leaders. Betraying trust can destroy careers, whole organizations, and lives. This is why trust is a top prerequisite for principled and ethical leadership. Positive (and negative) influence is derived from the credibility trust brings. Ethical leaders who continually work to earn and keep trust reap enormous payback in all aspects of business including superior economic, competitive, and strategic performance.
Love it or Leave It: Engagement and Retention at Work
-
Online
2.00 Credits
One of the biggest challenges, if not the most critical challenge in business, is attracting and keeping an engaged and productive workforce. Navigating the world of engagement and retention requires an understanding of human needs as well as deliberate and intentional actions to strengthen an employee's investment and connection to their place of work. For all the HGTV lovers out there, this session mirrors a television show where an individual/family must decide if they want to stay in their current home (after renovations and home improvements) or move to a new space. This webinar title seems apt in describing the current issues around engagement and retention. When an employee chooses to "love it" or stay with their current employer, it typically means they are engaged in their work and they feel seen, heard and valued- they are content. Conversely, the notion of "leaving it" typically symbolizes an employee who cannot wait to get out of their current job. These employees often have negative attitudes and/or behaviors at work. The purpose of this webinar is to recognize the significance of attracting and retaining employees, building your brand as an employer of choice and developing a culture where individual employees feel valued, cared for and ultimately engaged, all though an ethical lens. 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 Excel Charting And Visualizations
-
Online
4.00 Credits
Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.
What's Behind the Data?
-
Online
2.00 Credits
We are bombarded with information continually. So how do we determine what is valid and what isn't? This course points out common pitfalls inherent in data interpretation and gives practical tips to overcome those pitfalls by using real life examples. The course incorporates information from key thought leaders including Adam Grant, Alex Edmans, and Hans Rosling. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
SAS 145 - Risk Assessment
-
Online
1.00 Credits
SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. This audit standard amends AU-C 315, making many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315.
Everyday Ethics: Ethics is Everywhere, All the Time! featuring Richard A. Karwic and Don Minges
-
Online
1.00 Credits
Ethical situations occur more often than many realize. We must stay vigilant. Sometimes a seemingly simple situation may seem innocuous at first, but it can lead to large complications in the near future. In today’s competitive environment, one error posted on social media can damage a reputation forever. Social media posts can cause havoc.
Revenue Recognition Topic 606 - Identify the Contract Part 1
-
Online
1.20 Credits
On May 28, 2014, the Financial Accounting Standards Board (FASB) and International Accounting Standards Board (IASB) issued converged guidance on recognizing revenue in contracts with customers (ASC 606). The objective of the guidance is to establish principles to report useful information to users of financial statements about the nature, amount, timing and uncertainty of revenue from contracts with customers. The new guidance provides several benefits to financial statement users. This is one in a series of courses that outline the updated revenue recognition standard.
Powerful Public Speaking
-
Online
1.50 Credits
How you say what you say is more important than what you say. According to a UCLA study, 93% of a communicators effectiveness is based on non-verbal cues. This foundational program include a focus on the verbal, vocal and visual delivery techniques appropriate for the business environment, which can improve a speakers credibility, influence and impact. Depending on the course length other topics include; managing fear, organizing your presentation, increasing attention and interaction, handling questions, infusing humor, creating impactful visuals, and more.
Forgotten Managerial Accounting Tools for CPAs
-
Online
2.00 Credits
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
How to Audit Cash
-
Online
2.00 Credits
Cash is essential to every business, and is often one of the first accounts audit staff are exposed to. This course will cover the basics of auditing cash, including the related audit assertions, risks, & threats to the cash balance. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through some real-world examples. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course qualifies for yellow book credit.