CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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).
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Online
8.00 Credits
Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.
Walter Haig's GAAP for SMEs, Tax & Cash Frameworks Update
-
Online
8.00 Credits
This course provides an update of the recent changes that have occurred in the financial reporting frameworks commonly used by small and medium-sized entities (SMEs). Troublesome areas in these financial reporting frameworks as identified in peer reviews and litigation will be highlighted. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Emotional Intelligence
-
Online
1.00 Credits
Emotions get us every time. We all feel emotion. It’s what we do after we experience them that defines us. Emotional intelligence is critical in moving you, your teams, and your life forward. It’s all about your awareness and relationships with people. In this course, you will learn what emotional intelligence is and why it is one of the essential factors in determining your success in your career and your life. You will apply the four key areas of emotional intelligence and strategies you can immediately use to increase your emotional intelligence. Emotional intelligence is a skill and practice that promises to influence your life positively. You will learn the value it brings to how you approach your work and your relationships with co-workers, clients, and customers.
Internal Control - Testing for Operating Effectiveness
-
Online
2.00 Credits
Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.