CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's 2023 Excel PivotTables for Accountants
-
Online
8.00 Credits
PivotTables are widely considered the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their daily activities. If you are ready to learn how to take advantage of PivotTables or how to extend your existing knowledge of PivotTables, then make plans to participate in this course. In this program, you will learn how to build PivotTables, how to group data inside PivotTables, and how to create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques. Some of these techniques will include consolidating data with PivotTables and linking data from external data sources into PivotTables. Additionally, you will learn how to take advantage of many other features associated with PivotTables. Among them are Slicers, Power Query, and Power Pivot. At the end of the day, you will be a master of Excel PivotTables! If you have been leery of working with PivotTables or have struggled to realize their many benefits, this course is for you. With a little information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables in no time at all. And with just a little practice, you will be able to analyze and report on very large data sets in a fraction of the time you are spending presently to complete such tasks.
IRC 199A: An Up-to-Date Review of the Pass-Through Deduction
-
Online
4.00 Credits
As part of the Tax Cuts and Jobs Act (TCJA), IRC § 199A was added. This Internal Revenue Code section allows certain pass-through entities the ability to has made it deduct up to 20% of their qualified business. Although practitioners have had over three years of “experience” utilizing IRC § 100A, many practitioners still do not feel comfortable with this part of the Internal Revenue Code. The purpose of this presentation is to provide the practitioner with an understanding of the rules of IRC § 199A as well as an understanding of the IRC § 199A regulations. **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 leighanne.conroy@acpen.com.
2024 Risk Assessment - A Common Deficiency
-
Online
1.00 Credits
The AICPA has determined than 1 in 10 firms are not compliant with the risk assessment standards. This course will discuss how to properly identify risks and assess risks under AU-C 315. We will then review how to respond to identified risks under AU-C 330. The course will focus on the inherent risk model. We will also review common deficiencies and how a proper risk assessment can drive a more efficient and effective audit.
Navigating Difficult Conversations with Coworkers
-
Online
1.00 Credits
Conflict is inevitable whenever you have more than one person working together. But conflict doesn't have to be a bad thing. In fact, it's through conflict that some of the most productive conversations, changes, and innovations can occur in organizations...when they're navigated through effective communication. This workshop is designed to help you more strategically approach difficult conversations in the workplace and will arm you with both an understanding of how our minds approach these tough conversations and tools that you can use to approach these conversations more impactfully.
5 Steps to Cultivate a Values-Based Approach to Governance
-
Online
1.20 Credits
Emerging from the pandemic is a workplace culture governed by values. Far from a soft approach, it can drive significant business results. Organizations that embrace an empathetic culture increase performance and decrease turnover, while their customers report a more positive experience. Additionally, being more “person-focused” strongly correlates with more effective ethics and compliance programs. These insights can provide a roadmap for the "new normal" as the world emerges from the crisis. How employees and management move forward from this experience will shape the workplace for decades to come.
ProActive Response: Active Shooter Training - Recognize. Respond. Survive.
-
Online
2.00 Credits
ProActive Response Group's Active Shooter Response Training course educates participants in current trends of active shooter incidents, how to recognize early warning signs of violence, appropriate actions to increase chances of survival in an active shooter event, and how to use basic medical equipment to save the lives of victims. *****(Warning: This video contains simulated graphic scenes that some viewers may find disturbing)*****
2024 Annual Update for Governments and Not-for-Profits
-
Online
8.00 Credits
We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We then move to the NFP side of the house with a look at the Accounting Standard Updates issued by the FASB that impacts nonprofit entities. Following that, we review the work of the Not-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on. After the break, we will conduct a deeper dive into Yellow Book and Single Audit engagements. The course closes with a look at the significant changes in the 2024 Compliance Supplement, the changes to the Uniform Guidance and the common deficiencies identified by the federal agencies and peer reviewers.
K2's 2023 OneDrive's Best Practices
-
Online
1.00 Credits
Although Windows incorporates the OneDrive app, you may not have configured it correctly for your specific needs. Using the OneDrive app and the related Cloud storage service to their fullest potential means you can access your files when and where you need them. Further, sharing your files and collaborating with others is easy when using OneDrive correctly. In this session, you will learn best practices for taking full advantage of OneDrive.
What's New: DOL's Proposed Changes to the Salary Exemption and Best Practices
-
Online
1.00 Credits
With proposed changes to the Fair Labor Standards Act (FLSA) salary exemption pending, knowledge of employee classification becomes crucial, especially for practitioners working with small businesses. This session will provide updates and best practices to stay compliant with laws regarding exempt employees for both your practice and for your clients.
Expand Your Analytical Toolbox More Tools for Success
-
Online
4.00 Credits
Valuation techniques and cash management activities are two other tool categories that can round out your analytical toolbox. In this course we will initially discuss how to turn your financial plan into a powerful valuation engine. We then will discuss the formation of an efficient cash management program based on solid banker relationships. Finally, we will review Ten Steps for keeping your financial toolbox full.
2024 Internal Controls Over Compliance vs Compliance
-
Online
1.00 Credits
Based on an AICPA Enhancing Audit Quality study, 23% of all single audits subject to enhanced oversight were materially non-conforming with professional standards due to failure to properly test controls over compliance. This course will provide an overview of internal controls over compliance specifically related to Single Audits. We will discuss how to apply the concept of internal controls to various compliance requirements. Additionally, a common finding in the audits of governmental entities receiving federal grants is misidentifying controls and mistaking compliance for a control. That's why this course will also focus on identifying compliance versus controls over compliance.
Social Media: The Bare Necessities
-
Online
1.00 Credits
Social media has become a ubiquitous phenomenon in our business world. However, just because it exists is not a good reason to use it. This workshop is designed to give you an overview of the social media landscape to help you decide if you want to engage with and on social media and, if so, what channel(s) are most strategic for you and your business. The workshop ends with a simple framework to help you use social media as a credibility strategy for your business, giving you a strategy for creating a year's worth of social media content in a single day.
2024 Risk Assessment & Internal Control
-
Online
1.50 Credits
The AICPA has determined that one in ten audit firms are not compliant with the risk assessment standards. This course will discuss how to properly identify risks and assess risk under AU-C 315. We will then review how to respond to identified risks under AU-C 330. The course will focus on the audit risk model and cover both inherent risk and internal controls. We review common deficiencies and how a proper risk assessment drives a more efficient and effective audit.
2024 Introduction to Ethics & Professional Skepticism
-
Online
2.00 Credits
Ethics and professional skepticism are a cornerstone of public accounting. This course will review the Code of Ethics for Professional Accountants that practitioners must adhere to. This course will outline the pressures, opportunities, and rationalizations that lead to instances of fraud. In addition, this class will walk through some interactive examples to illustrate various scenarios of noncompliance during engagements.
K2's 2023 Simplifying And Economizing Your Tech Stack
-
Online
1.00 Credits
All business professionals need access to the necessary technology to help them perform their jobs efficiently and effectively. Yet, no one should overpay for their tech stack. Unfortunately, though, many are overpaying and have yet to realize it. In this session, you will learn valuable tips to help you simplify and economize your technology stack. Participate in this session to avoid the risk of overpaying for your tech tools.
2024 The Psychology of Fraud
-
Online
1.75 Credits
We all know that Fraud Happens. But, why? Why do people we think we can trust let us down? This session will explore the minds of white-collar criminals and examine some recent high-profile fraud cases. Why did they do it? How did they do it? What were the warning signs? If you think that fraud cannot happen to your organization, this session might give you pause.
A Better Way to Choose Your KPIs
-
Online
1.00 Credits
Selecting the right KPIs for your organization can be complex and stressful. Rather than resorting to brainstorming and internet searches, there is a better way to discover the best KPIs for your organization - the ROKS method. In this session Bernie Smith, creator of the ROKS method, walks you through the first five steps of this powerful approach, using real-world stories to bring each step to life.
Giving Feedback that Delivers Results
-
Online
1.20 Credits
Many people, when they hear about feedbcak in organizations and the workplace, think immediately of performance reviews. But feedback should not be isolated to these formal structures. This workshop is about the more informal methods of feedback that managers and coworkers can use to have more productive conversations that drive behavioral change. Through understanding the importance of dialogue, strategic questions to drive conversation, and mistakes to avoid, you'll be able to have more productive feedback conversations in your workplace (and maybe even at home, too).
2024 Yellow Book Update
-
Online
2.00 Credits
More and more entities need Yellow Book engagements, including a growing number of for-profit entities. In this course, we will review the unique independence requirements in GAGAS. We'll also review the recent changes to quality management in Yellow Book. We'll close with a reminder of common deficiencies found in Yellow Book engagements.
K2'S 2022 Implementing Data Loss Prevention For Better Security And Privacy
-
Online
1.00 Credits
Data Loss Prevention (DLP) is a means of creating and enforcing security policies in an organization. For example, you can create DLP rules that programmatically block all outbound email messages containing Social Security or credit card numbers. Unfortunately, most business professionals have yet to discover DLP and how it improves security. In this session, you will learn the fundamentals of DLP and, through demonstrations, see how you can use DLP to enhance organizational security. You do not want to miss this chance to learn how to take advantage of one of the most innovative security options available to you!