CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
ACPEN: K2’s Excel Tips, Tricks, And Techniques For Accountants
-
Online
8.00 Credits
Excel is the go-to tool for accountants when it comes to analyzing and reporting financial data. However, many professionals still rely on time-consuming and error-prone methods for everyday tasks. Whether you're a beginner or an experienced user, our course is designed to help you master Excel and transform your workflows. In this course, you'll discover a trove of tips, tricks, and techniques to boost your productivity and streamline your tasks. Say goodbye to mundane formatting and hello to customized Excel solutions that enhance accuracy and efficiency. You'll also learn how to build powerful formulas, link Excel data from various sources, and simplify report generation and printing processes. Our expert K2 instructors will guide you through the program with practical, real-world examples, ensuring you grasp the key concepts and apply them effectively. With over twenty-five years of experience in delivering top-notch spreadsheet training to accounting and financial professionals, we guarantee that the insights and guidance you receive will be both relevant and invaluable. Join us and elevate your Excel skills to new levels. Don't miss out on this opportunity to work smarter, not harder! Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: 2026/27 Single Audit Update
-
Online
1.00 Credits
Stay current on significant developments affecting Single Audits with this focused update on recent regulatory and professional guidance. This course reviews the 2024 Uniform Guidance overhaul, including the increase in the Single Audit threshold to $1 million and other changes impacting audit planning and execution. The course also examines Appendix B of the 2025 GAS/Single Audit Guide issued by the AICPA, highlighting updates that affect audit efficiency and compliance considerations. In addition, participants will receive updates on recent guidance issued through Office of Management and Budget (OMB) memoranda, as well as reporting-related changes, including the transition from the Federal Audit Clearinghouse's prior systems to SAM.gov-based reporting. This course is designed to help auditors understand how these developments affect Single Audit requirements and what to watch for as expectations continue to evolve. Presented by: Melisa GalassoType: Live Webcast Replay
ACPEN: The Ethics of Artificial Intelligence ("AI"): The Interaction of AI and Ethics, featuring Tracy Cooper, CPA and Don Minges, MBA
-
Online
1.00 Credits
Artificial Intelligence ("AI") can do and does amazing things, but there are myriad ethical issues involved with AI. We will discuss the many ethical questions that AI raises and how to prevent them from having an adverse impact. We must be more diligent and aware of the ethical issues. AI has severe ethical pitfalls that we should understand clearly. AI is here to stay and we must understand how to mitigate the ethical issues. Presented by: Don Minges, Tracy CooperType: Live Webcast Replay
ACPEN: The Controllership Series - Addressing Budgeting Uncertainty
-
Online
1.00 Credits
With new accounting standards, the economic landscape and evolving technology, accounting, financial reporting and finance continue to grow in complexity. FASB has tried to address the growing complexity, by working towards making GAAP less convoluted. The struggle to stay on top of accounting financial reporting requirements and finance changes due to the economy continues for several reasons. Lack of in-house SMEs, managing high volumes of transactions, and data and evolving information technology systems. In the future, executives must consider the challenges they will face in future years that will bring their own nuances and complexities. Budgeting is certainly one of those processes that must be evaluated and re-evaluated for efficiency. This session delves into the corporate budgeting process and discusses methods used and which methods may or may not allow for the organization’s to properly plan for a volatile future. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 1
-
Online
1.00 Credits
This course is a continuation of our series on preparing to become a forensic accountant. Within this segment we focus on elements of computer forensics. This session is designed to delve into further investigative procedures used in computer forensics. Presented by: Lynn FountainType: Live Webcast Replay
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