CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
ACPEN: Excelling at Excel: The Magic of Power Query
-
Online
2.00 Credits
Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before. Presented by: Tracy CooperType: Live Webcast Replay
ACPEN: K2’s Next Generation Excel Reporting
-
Online
8.00 Credits
Unlock the full potential of Excel and transform your operational and financial reports like never before. With cutting-edge tools such as Data Models, Power Query, Data Analysis Expressions, and Power Pivot, you can create powerful summaries and schedules in record time. Combine these with Excel's legacy features, and you have a game-changing opportunity to elevate your reporting environment. Join our fast-paced seminar to discover the magic of Power Query and how it seamlessly links data into Excel data models, enabling more efficient and insightful reporting. Learn to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance data analytics and understandability. Plus, master best practices for quickly and efficiently formatting your spreadsheets, giving them a polished and professional appearance. This course is a must for anyone using Excel for reporting processes. Elevate your skills and stay ahead of the curve with our expert guidance. You will truly learn how you can revolutionize your Excel-based reporting practices by participating in this session. Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: K2’s QuickBooks Online For Accountants
-
Online
8.00 Credits
Discover the power of QuickBooks Online (QBO)! Intuit's cloud-based accounting platform has evolved and thrived over the past decade, now generating approximately five times the revenue of its desktop counterpart. Yet, many accountants and business professionals are still unaware of the extensive features QBO offers. Unlock the advantages of the subscription model and learn how to leverage QBO to manage inventory, enhance internal controls, create presentation-quality financial statements, and seamlessly migrate from QuickBooks Desktop or other accounting platforms. Join our dynamic session to explore the best practices for implementing, using, and excelling with QuickBooks Online. Don't miss out on the opportunity to elevate your accounting game with this surprisingly robust platform! Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 2 (Cryptology)
-
Online
1.00 Credits
This is a continuing part of our series on forensic accounting. Within this segment we discuss the concepts that are part of computer forensics known as cryptology. The term cryptography is from Ancient Greek and means “hidden secret”. It is the practice and study of techniques for secure communications in the presence of adversarial behavior. Cryptography is about constructing and analyzing protocols that prevent third parties or the public from reading private messages. Cryptography starts with secrets. Various aspects in information security such as data confidentiality, data integrity, authentication and non-repudiation (where a statement’s author cannot successfully dispute its authorship) are central to modern cryptography. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Two Types of Goals You Need to Be Successful
-
Online
1.00 Credits
Do you understand the root cause for many professional and personal goals not being achieved? The SMART acronym is valuable in setting goals but insufficient for achieving them. You need two types of goals to boost your chances of success. Outcome goals focus on the results you want to attain. Process goals identify the action steps required to accomplish those desired outcomes. This session explores the essence of both types of goals, and practical examples and tips for the execution of your goals. Presented by: Jon LokhorstType: Live Webcast Replay
ACPEN: Promote Internal Whistleblowing and Succeed in Creating a Strong Speak Up Culture
-
Online
1.00 Credits
The Department of Justice updated guidance regarding their evaluations of Corporate Compliance Programs in March 2023: “Prosecutors should assess whether the company’s complaint-handling process includes proactive measures to create a workplace atmosphere without fear of retaliation, appropriate processes for the submission of complaints, and processes to protect whistleblowers.” This course offers recommendations for employers to consider when developing or augmenting an internal complaint handling process. Organizations benefit when whistleblowers trust the process and choose to promptly report their concerns internally. The measures offered promote a strong speak up culture and align with the Department of Justice's guidance. Presented by: Robin RohmerType: Live Webcast Replay
ACPEN: Sticky Ethical Choices, featuring Bob Mims and Don Minges
-
Online
1.00 Credits
If ethics were easy, then why do so many professionals have a Code of Conduct? Some Ethical decisions are easy, others are not. We will discuss several thorny ethical issues and the ramifications. What are the considerations and evaluation criteria to use? The need to carefully deliberate alternatives – is paramount. Be aware. Presented by: Don Minges, Bob MimsType: Live Webcast Replay
ACPEN: The Controllership Series: The Controllers Role in Internal Controls
-
Online
1.50 Credits
This course in part of our series on the Controllership Role. Internal control is relevant to everyone in the workplace. It represents our moral responsibility to understand and comply with organization policies and procedures. It also provides the means to hold individuals accountable for their work. The controller is an impactful position that affects a company's processes including financial, compliance and operational. Controller functions vary across companies often following the size and complexity of the business and the industry. Smaller companies require more versatility for the controller Larger companies are more able to segregate job responsibilities across other employees. The controller should be knowledgeable of the various controls to create a control system that will appropriately safeguard company assets and processes. Internal controls are typically comprised of control activities such as authorization, documentation, reconciliation, security and segregation of duties. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Introduction to Governmental Accounting 102
-
Online
2.00 Credits
Intro to Governmental Accounting 102 is the natural follow up course to the original Intro to Governmental Accounting 101. In this session, we will tackle unique things like what makes a fund a major fund, what are the differing basis of accountings used, why geography matters in the world of state and local governmental reporting, and many other intermediate type topics. A great course to take after you have taken Intro to Governmental Accounting 101. Presented by: Frank Crawford, Christopher PembrookType: Live Webcast Replay
ACPEN: Global Internal Audit Standards (GIAS) Domain III - Part 1
-
Online
3.00 Credits
The new Standards emphasize that quality performance requires conformance to the Standards. Each standard within Domain III specifically identifies the responsibilities of the CAE and the board, as well as joint responsibilities. The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Using Psychology Secrets to Love your life and Get More Done
-
Online
4.00 Credits
The new field of Positive Psychology offers many methods and ideas for helping people be happier, healthier, and better at what they do. Nowadays, the ability to be at your best and get clients to enjoy working with you is critical to growing your business or getting ahead. Studies show that happy people make $750,000 more over the course of their life than unhappy people, have half the number of sick days, and live 9 years longer. In this fun and fascinating seminar, you’ll learn how to not only be happier, but help your clients be happier in working with you. Presented by: Jonathan RobinsonType: Live Webcast Replay
ACPEN: Business Ethics: Cases from the Real World
-
Online
4.00 Credits
Being consistently ethical is a challenge. Most of us have had to make tough choices. This session will discuss real world cases involving thorny ethical dilemmas and how to resolve them. Being ethical is not the same as complying with the law and ethical issues are not always black and white. This session will review different professional ethical standards. What does integrity mean in the office? If you want to learn lessons from the best in a short time, this session is for you. Participate in engaging dialogue about how to prepare for the inevitable ethical situations. These lessons are valuable for every business leader. Presented by: Don MingesType: Live Webcast Replay
ACPEN: 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. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: The Controllership Series - Sales, Collections and Customer Credit
-
Online
1.50 Credits
Why do for profit organizations exist" To make money!!!!! What a great concept. But if the organization does not have the proper collections and credit procedures in place, they may not be able to access that money. Hence the importance of the credit and collection process.Credit and collections are critical areas for the financial statement controllers. Customer credit is a form of payment that allows small business customers to purchase a product or service before paying for it in full. The process works similarly to the way a credit card does - you procure something and pay it back later. Collections is a term used by a business when referring to money owed to that business by a customer. When a customer does not pay within the terms specified, the amount of the bill becomes past due and is sometimes submitted to a collection agency. The sales and collection process includes business activities related to selling products and services, maintaining customer records, billing customers, and recording payments from customers. It also includes activities necessary to manage accounts receivable, such as aging accounts and authorizing credit. This course delves into the topics that impact the sales, credit and collections process for management. We discuss strategic steps management can take to ensure their processes are efficient and that they are able to actually collect their revenue. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Awesome Business Lessons from the Past: Learn from the Best!
-
Online
2.00 Credits
Why not learn, or re-learn, some amazing business lessons from the past that are still effective today? What did Henry Ford do when annual employee turnover was 370% and workers demanded more pay? Sound familiar to today’s world? Ford’s solution worked! We see today’s problems and believe that these problems have never occurred before. Not true. We will discuss timeless business lessons that are as practical today as when they were written decades ago. We will review; ‘How to Win Friends and Influence People,’ ‘Today and Tomorrow,’ and ‘The Art of War.’ Let's learn from the very best, as these lessons have been battle-tested and proven over time. Presented by: Don MingesType: Live Webcast Replay
ACPEN: Forensic and Fraud Interviewing Techniques and Skills
-
Online
2.20 Credits
In forensic accounting, interviewing is used to obtain important information from witnesses and suspects. An important aspect is the ability of investigators to obtain accurate and reliable information from victims, witnesses and the suspects or any interviewee. The interview process is an essential part of information gathering for any investigation. The importance of improving the quality of the interviewing with the potential for visual recording of all interviews should be placed high on the agenda of all organizations across the globe. A properly conducted forensic interview can result in an extreme benefit regarding collection of information. The interviewer’s role is to develop a full understanding of the facts. There is a distinct difference between a forensic interview and a criminal interrogation. Typically, forensic auditors will not be involved in interrogations. The Canadian or U.S. forensic accounting profession does not have a standardized interview model to truly equip its professionals with the interview tools required to elicit confessions ethically. Majority of their skills are developed through experience, and not through a standardized model of training. This session focuses on various interview concepts and methods. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Accounting for Software
-
Online
2.00 Credits
Software-related transactions continue to evolve, requiring careful analysis under U.S. GAAP. This two-credit course examines the accounting treatment of software costs, with a primary focus on internal-use software and emerging guidance. Participants will walk through the lifecycle of software development, including capitalization and expense recognition, amortization, and impairment considerations. The course includes a focused review of ASU 2025-06 and its impact on accounting for internal-use software. Additional topics include accounting for website development costs, Software-as-a-Service (SaaS) arrangements, and other cloud computing arrangements (CCAs), including implementation and hosting considerations. The course also addresses accounting for external-use software, including technological feasibility, capitalization thresholds, and related revenue considerations. Through practical examples and case-based scenarios, participants will strengthen their ability to interpret authoritative guidance and analyze the financial reporting implications of software-related transactions. Presented by: Melisa GalassoType: Live Webcast Replay
ACPEN: What's Going on at the FASB (2026/27)
-
Online
2.00 Credits
This course provides an efficient update on recent and upcoming accounting standard-setting activity issued by the Financial Accounting Standards Board. The course focuses on Accounting Standards Updates (ASUs) effective for December 31, 2026 year-ends for public companies, private entities, and not-for-profit organizations. Participants will also review issued ASUs with future effective dates, along with high-level insights into recent exposure drafts. Emphasis is placed on understanding timing, scope, and areas of change that may affect financial reporting and implementation planning. Designed as a practical update for preparers, auditors, and financial professionals, this course helps participants stay current on FASB activity and better anticipate the impact of evolving accounting standards. Presented by: Melisa GalassoType: Live Webcast Replay
ACPEN: The Controllership Series – The Controller’s Skillset
-
Online
1.00 Credits
This another course in our series on the controllership function. The controller's role encompasses many traditional responsibilities. The breadth and depth of the controller skill set has expanded and will continue to expand as the business world evolves. The controller position will typically lead teams of financial and accounting experts. Recognizing that leadership and team management skills are must-haves; they need to be able to command their team's respect, inspire them to act, and ensure that such actions are aligned with your organization's overall vision. These skills, along with tactical knowledge will ensure the controller's success. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: How Prevalent Is Retaliation Within Your Culture?
-
Online
1.00 Credits
Does your organization encourage timely reporting? Does your organization provide substantive protection for those who report? Organizations should be aware of characteristics indicative of a retaliatory culture - one in which bad actors are provided ample opportunity and cover to retaliate. Presented by: Robin RohmerType: Live Webcast Replay