CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
DEI From the Inside Out: Part 1
-
Online
3.00 Credits
In this session, participants will delve into a comprehensive exploration of what Diversity, Equity, and Inclusion (DEI) truly entails. Often met with resistance due to its perceived condemnatory nature, this session aims to provide a more nuanced definition of DEI, fostering a better understanding among attendees. By demystifying the language surrounding DEI, participants will be equipped with straightforward approaches to seamlessly integrate these principles into their perspectives. This session will spotlight the distinctive features of our DEI model in comparison to other systems. Attendees will gain valuable insights into the model, understanding its unique perspective on achieving DEI success. At its core, our approach is grounded in the simple premise that we are all human beings sharing the common human experience. The goal is to convey to participants the importance of embracing DEI through this paradigm, effectively humanizing the DEI experience. One of the most remarkable DEI experiences unfolded during my son's 18th birthday celebration in our backyard. The event brought together individuals from diverse backgrounds, spanning various walks of life and races, who interacted in a profoundly humanistic manner— an encounter unlike any I had witnessed before. In this session, we will deconstruct this experience and draw parallels to its relevance in workplace dynamics.
K2's 2023 Introduction To Excel Macros
-
Online
4.00 Credits
You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.
Data Extraction, Transformation, Validation the Right Data Sources for Analysis
-
Online
2.00 Credits
In this course, we will explore the various types of data - both structured and unstructured - used in conducting fraud risk investigations and proactive monitoring. We will explore the various tools available on the market and techniques to confirm completeness and accuracy of the data before the analysis begins. The course will cover the process for selecting the right data sources to align with the various risks as well as pitfalls to avoid when preparing the data for analysis.
2024 Not-for-Profit GAAP Update
-
Online
2.00 Credits
This course will review the Accounting Standard Updates issued by the FASB that impact nonprofit entities. We will also look at the work of the Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on.
2024 Common Deficiencies in SSARS Engagements
-
Online
4.00 Credits
Preparation, compilation and review engagements continue to be a hot topic for peer review despite SSARS 21 having been around for nearly a decade. This course will concentrate on the most common peer review findings with a focus on how to comply in an efficient but practical perspective. This course will discuss the root cause of noncompliance so that overall engagement quality increases.
K2's 2024 Small Business Accounting Shootout
-
Online
4.00 Credits
Small business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.
DEI From the Inside Out: Part 2
-
Online
3.00 Credits
In this session, we will underscore the significance of adopting a growth mindset, as conceptualized by Dr. Carol Dweck, as a cornerstone for achieving success in Diversity, Equity, and Inclusion (DEI) initiatives. A common stumbling block in DEI efforts is the resistance to altering mindsets concerning the goals and objectives of DEI. Through interactive discussions, we will concentrate on dispelling fixed mindsets and cultivating an outlook of continuous growth in the realm of DEI. Achieving success in Diversity, Equity, and Inclusion (DEI) requires a blend of motivation, synergy, and energy. This session aims to dissect the often-overlooked role of motivation in the DEI landscape, demonstrating how it serves as a catalyst for individuals and leaders to surmount obstacles and attain success. Our model disrupts the conventional discourse by placing motivation at the forefront of DEI considerations, emphasizing the importance of understanding the underlying purpose as the true north. The ultimate aim of Diversity, Equity, and Inclusion (DEI) is cultural integration. In the context of our 3M framework, the final "Memorization" component is strategically designed to imprint the necessity of prioritizing DEI and seamlessly weaving it into the organizational culture. This element is pivotal in fortifying our DEI endeavors.
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.
Aligning Analytics to COSO's Fraud Risk Management Principles
-
Online
1.00 Credits
In this course, participants will learn about the five principals of COSO's Fraud Risk Management Guide and the linkages each principal has to the use of forensic data analytics to measurably demonstrate effectiveness and ROI. We will also explore key elements to a successful program that is sustainable as well as pitfalls to avoid. Finally, we will cover several case studies that demonstrate the key concepts discussed.
2024 Deep Dive into Quality Management
-
Online
2.00 Credits
Quality management will have a big impact on CPA firms. This course will cover both SQMS 1 and 2 as well as the related engagement level standards (SAS 146 and SSARS 26). The new standards will require a risk-based approach to quality management as well as the documentation of an information & communication process. This two hour class will provide a deep dive into what you need to know to start your implementation process!
2024 Single Audit Update
-
Online
2.00 Credits
This course will start with a review of the impact of the 2024 Compliance Supplement on Single Audits as well as the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits.
K2's 2023 Microsoft 365/Office 365 - All The Things You Need To Know
-
Online
8.00 Credits
Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment. Isn’t it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.
Long-Term Care Insurance: Make the Switch
-
Online
1.00 Credits
How to pay for the cost of long-term care remains a primary concern for most clients over the age of 50. Explore clients' motivations, misconceptions and objections to purchasing long-term care insurance, and a look at the latest long-term care solutions, including hybrids. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Controllership Series - Managerial Accounting Basics and Costs
-
Online
1.20 Credits
Managerial accounting provides economic and financial information for managers and other internal users. Managerial and Financial Accounting have similarities and differences. Each field of accounting deals with the economic events of a business. Both managerial and financial accounting require that a company’s economic events be quantified and communicated to interested parties. This another course in our series on the controller’s role. The controller’s role encompasses many traditional functions. Within this segment of our controllership series, we discuss the area of managerial accounting and the basic concepts that surround this discipline as it primarily relates to cost accounting issues.
Preparing to be a Forensic Accountant - Focus on Network Forensics
-
Online
1.50 Credits
Network forensics - defined as the investigation of network traffic patterns and data captured in transit between computing devices - can provide insight into the source and extent of an attack. It is used in forensic accounting and with the expansion of information technology it has become a growing field. Network forensics is a relatively new field of forensic science. Computing has become network centric. Data is now available outside of disk-based digital evidence. Network forensics can be performed as a standalone investigation or alongside a computer forensics analysis. When used alongside a computer forensic analysis it is used to reveal links between digital devices or reconstruct how a crime was committed. Network investigations deal with volatile and dynamic information and is a sub-branch of digital forensics. It relates to the monitoring and analysis of computer network traffic for information gathering, legal evidence, or intrusion detection. This course is a complement to our other courses in the series on becoming a forensic accountant.
K2'S 2023 Top Ten Outlook Tips
-
Online
2.00 Credits
Using Outlook for email management is routine for most business professionals these days. But unfortunately, using this tool for so long may cause some to perpetuate bad practices and habits when working in Outlook and exploring new options Outlook offers. In this session, you will discover ten valuable tips to take you to the next level of your email and work management.
2024 Advanced Excel: Hidden Secrets and Gems
-
Online
2.00 Credits
This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.
The Art of Conversation: A Relationship Approach to Networking
-
Online
2.20 Credits
In the fast moving world where everyone is communicating through email, text and instant messaging we have forgotten the power of face-to-face conversation. Communication and connection is the foundation for building a thriving network and business. During this talk, The Connector’s Advantage author, Michelle Tillis Lederman will inspire you to leverage the power of personal connection in the digital age while still incorporating the efficiency of virtual communication.
Surgent's Construction Contractors: Accounting and Financial Reporting Issues
-
Online
4.00 Credits
Accounting and financial reporting for construction contractors may be the most difficult area to be in compliance with the various standards. Also, construction engagements are, in many instances, more "dangerous" than most lines of business due to the many users of the financial statements (especially considering the impact of COVID-19). In this course, we will discuss why construction accounting and financial reporting are so complex and discuss the relationship between the contractor and the surety, both from an underwriting and claims perspective. We will also explore what the surety looks for in order to maximize potential bond credit.
Surgent's Section 199A: Schedule K-1 Reporting by Relevant Pass-Through Entities
-
Online
4.00 Credits
Section 199A is still the hottest tax topic related to the Tax Cuts and Jobs Act of 2017. The Act created new reporting requirements for relevant pass-through entities (RPEs). Each RPE is required to report the relevant data needed to calculate the 199A deduction to each recipient of Schedule K-1. Your clients will trust you to ensure that the relevant data is properly reported. The IRS has added disclosure lines to Schedules K-1 for S corporations, partnerships, and trusts. This course will cover the new reporting requirements on those forms and discuss uncertainties that still exist related to the reporting requirements. The course includes examples and case studies relevant to the new disclosure lines of Schedules K-1. This program will include the latest relevant IRS guidance.This course qualifies for IRS credit.