CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Achieving Balance in Work and Life - Part 2
-
Online
4.00 Credits
In trying to achieve life balance, various internal and external obstacles arise. In this course we will look at these obstacles and provide specific ways to overcome them. In addition, we will look at how to excel in every area of your life including your relationships, finances, sense of purpose, level of happiness, and your physical health and leisure time pursuits. You will leave this course with powerful methods and a specific plan to move forward in your life in a balanced, healthy, and productive manner. Don't forget to take Part 1 of this amazing course.
Bounded Ethicality: Exploring the Limits of Ethical Behavior
-
Online
1.00 Credits
Bounded ethicality explores the edges of ethical decision-making and the invisible borders that exist in our ethical judgment. In an entertaining and enlightening session, we will unveil surprising judgment errors we make when we face ethical dilemmas and search for the reasons behind them. We will explore areas of ethical decision-making where people consistently predict they will do the right thing but rarely do so. We will find out why people repeat stubborn errors of ethical judgment, and review steps that behavioral researchers have identified that can help us stop making these errors once and for all. We will identify ways to recognize our own errors and steps we can take to improve our ethical thinking. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Excel Tips & Tricks for the Non-Accountant
-
Online
2.00 Credits
You don’t need an accounting degree to harness the power of Microsoft Excel. This course shows how Excel makes sense beyond dollars and cents. We will focus on fundamental concepts for creating, editing, and utilizing Excel content. Participants will learn how to use Excel’s menus and other functions to craft Excel workbooks. Because this course is designed for newer users, we intentionally offer a broad overview of Excel’s numerous capabilities with in-depth coverage of selected resources tailored for non-accounting applications.
K2's 2023 Case Studies in Fraud and Technology Controls- 4 Hrs
-
Online
4.00 Credits
Fraud continues to plague businesses at epidemic levels, and technology control failures are a big reason fraud occurs. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures that contribute to fraud, and what you can do to mitigate fraud risk. A specific focus of this course is the application of information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general control and application control failures that contributed to each of these frauds. By learning through these real-world case studies, you will be better positioned to reduce fraud risk.
SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit
-
Online
3.00 Credits
When performing a financial statement audit, auditors have always been responsible for the detection of anything that would cause a material misstatement of the financial statements whether caused by error of fraud. However, in the past the audit profession focused on material misstatements due to errors and more or less ignored the possibility of misstatements due to fraud. Now, SAS No. 122, AU 240 requires significant documentation as to what the auditor did in order to determine if there any material risk of a misstatement of the financial statements. This presentation is an overview of what the auditor is to document in there working papers on every financial audit as to the procedures they performed in order to determine the risk of a material misstatement. If a material risk is discovered, they are then required to document what they did in order to determine if the financial statements were misstated.
K2's 2023 Excel Best Practices
-
Online
8.00 Credits
As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.
2024 PowerPoint: Tips & Tricks for Today's Accountant
-
Online
2.00 Credits
PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course’s author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We will also explain how PowerPoint can be used for purposes other than delivering presentations.
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.
Inventory, Expense and Payroll Fraud
-
Online
2.00 Credits
Inventory is a wonderful place to both hide fraud and commit fraud. The reasons that inventory is subject to so much fraud is the it is often very large, spread out over a large area, and many people have access to it. When there are little or no internal controls related to inventory control, you are begging employees to steal it. No with so many ways to dispose of stolen inventory via the internet, i.e., EBAY, inventory fraud is much more appealing to a lot of individuals. The more common ways to commit expense fraud and how to cover it up will also be discussed. Travel and entertainment are some of the favorite areas of committing expense fraud. In addition, payroll fraud will be discussed. Although there are many ways to commit payroll fraud, it is very easy to prevent. This presentation is designed to familiarize the participants with the many ways to commit inventory, expense and payroll fraud, how to detect it, and more importantly, how to prevent it.
2024 A Guide to Sampling - Part 1
-
Online
2.00 Credits
Sampling is often identified as a common audit deficiency in peer review. This course will review when is sampling applicable and basics of planning a sample. We'll then focus on the application of sampling in financial statement audits with a look at sampling for substantive procedures. We'll look at the use of monetary unit sampling and tools that can be leveraged to reduce bias in sampling.
2024 Fiduciary Accounting: Fundamentals & Rules
-
Online
2.00 Credits
This course will dive into the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus.
2024 Internal Control Fundamentals
-
Online
2.00 Credits
AU-C Section 315 requires the auditor to gain an understanding of the entity and its environment and the entity's internal controls in order to design appropriate audit procedures. This course will review the key requirements of COSO which is one of the most widely used internal control frameworks. We'll also review the limitations of internal controls. Additionally, this course will introduce the risk assessment process and the various audit procedures to evaluate controls and to determine whether to test the operating effectiveness of controls.
2024 Taxation of Non-fungible Tokens (NFTs)
-
Online
2.00 Credits
Non-fungible Tokens (NFTs), unique, identifiable digital assets based on blockchain technologies, have become a fast-growing industry. This course will provide a background on how NFTs came into the mainstream marketplace. These materials will assist the practitioner to understand the tax implications of the creation, purchase and sale of these assets. **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.
K2's 2024 The ABCs of Automation With Microsoft's Power Platform
-
Online
2.00 Credits
Microsoft’s Power Platform – incorporated into many Microsoft 365 subscriptions – offers tools to automate common business processes. Learn how to take advantage of the Power Platform in this session.
Tactics to Find Work Life Balance in a Complex World
-
Online
1.00 Credits
This session will explore key aspects of getting more satisfaction out of the work you choose to do and how to find greater balance between the demands of work and other lifestyle choices in an ever more complex and changing world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Ethical Tax Practice Strategies in a Crisis World
-
Online
2.00 Credits
This program addresses the many issues impacting CPA practice with a world in crisis. The unique challenges facing practitioners are related through actual practice situations – and then analyzed for their ethical implications. Based on real life experiences. **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.
Surgent's Yellow Book and Single Audits: How to Stay in Good Graces and Out of Bad Places with Your Peer Reviewer
-
Online
4.00 Credits
If you perform Yellow Book audits and/or single audits, it is a given that a peer reviewer will be looking at your work on those engagements! Why fret and sweat about what peer reviewers are going to be looking for? In this course, we will explore the key audit requirements that peer reviewers focus on, how the auditor complies with those requirements, and common pitfalls seen in Yellow Book and single audits. This course will help you proceed and succeed in your Yellow Book and single audits!This course qualifies for yellow book credit.
Achieve Competency in Three Basic Tool Categories - Master the Fundamentals
-
Online
4.00 Credits
Financial skills needed in many situations are constantly changing. It is prudent to routinely look into your toolbox to restock or revise your tool set. In this course we will examine three tool categories that form the foundation for many analytical processes.
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.
Construction Contractors: Non-Revenue and Non-Lease Accounting Considerations
-
Online
4.00 Credits
The construction industry stands out in its need to adhere to a diverse range of accounting standards. This course explores the essential knowledge required for success in construction accounting, as well as the key issues influencing this field. Discover the implications of recent developments for yourself, your business, or your clients. In addition, we will examine the relationship between contractors and sureties. Given the construction industry's significant and ever-expanding share of the economy, staying up to date with the latest accounting updates in this sector is critical. Note: This course does not address FASB ASC 606, Revenue from Contracts with Customers, or FASB ASC 842, Leases. The AICPA offers a companion course which focuses on revenue and lease accounting for construction contractors. See Contract Accounting and Lease Accounting and Their Impact on Construction Contractors (CCREVL).