CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Introduction to Ethics & Professional Skepticism
-
Online
2.00 Credits
Ethics and professional skepticism are a cornerstone of public accounting. This course will review the Code of Ethics for Professional Accountants that practitioners must adhere to. This course will outline the pressures, opportunities, and rationalizations that lead to instances of fraud. In addition, this class will walk through some interactive examples to illustrate various scenarios of noncompliance during engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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
Ethics, AI, and Music: What Every CPA Must Know
-
Online
1.00 Credits
You may be surprised to learn how artificial intelligence is transforming the music you love. For example, what happens when AI creates songs based on other people's work without credit or payment? How should musicians disclose the role of AI in their recordings? The challenges that AI poses for music, such as threats to intellectual property, confidentiality, fairness, and professional reputations, are also front and center in accounting. This one-hour ethics course invites you to explore one of your favorite subjects outside of work. You'll discover how the five principles of ethical intelligence can help you listen to music in ways you never considered before. You'll also see how these same principles guide you in making the best decisions in your accounting practice. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Relationship Networking: The Art Of Conversation
-
Online
1.00 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. Presented by: Michelle Tillis LedermanType: Live Webcast Replay
ACPEN: It Is Legal, But Is It Really Ethical?, featuring Rob Berry and Bob Mims
-
Online
1.00 Credits
This discussion outlines situations where ‘legal’ and ‘ethical’ are not necessarily in alignment. How should you handle these issues? We will detail a better thought process to help you avoid ‘crossing the line.’ Presented by: Rob Berry, Bob MimsType: Live Webcast Replay
ACPEN: Maintaining a Harmonious Working Environment
-
Online
1.00 Credits
A harmonious working environment is one in which people feel safe, seen, heard, and respected. Critical to maintaining it are that employees have high self-esteem, are treated with respect, and work in a safe, non-violent setting. This course provides practical knowledge and scripts on how to take appropriate action and deal effectively with discriminatory comments, sexual harassment, and threats and acts of violence, such that personal and employer liability is avoided. Presented by: Mike MirarchiType: Live Webcast Replay
ACPEN: Coaching Leaders to Handle Sensitive Employee Relations Situations
-
Online
1.20 Credits
This session provides HR Professionals with scripts for and tactics for coaching leaders in handling an array of employee relations situations with sensitivity, good judgment, and high confidence. Topics include employee complaints, personality & attitude problems, performance counseling, personal hygiene problems, disability-related performance issues, misconduct due to mental conditions. You will learn how to use a unique process, “Reset the Clock,” that prevents attorneys from taking something leaders did wrong or did not do in the past and using it to support legal challenges in the future. Liability is replaced with credibility. Lawsuits are then avoided rather than won. Financial assets are protected, morale stays high, and bad publicity is averted. HR Professionals avoid hearing from senior leaders: “You should have anticipated this” after an avoidable legal claim. Presented by: Mike MirarchiType: 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: The Controllership Series: The Controller's Role in Debt Management
-
Online
1.50 Credits
Debt Management: Debt management often involves administering loan agreements and ensuring bank compliance. Compliance: Controllers help ensure compliance with federal and local laws, provisions, and financial regulations. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Yellow Book Ethics
-
Online
2.00 Credits
The Yellow Book outlines essential ethical principles for governmental auditors, including serving the public interest, maintaining integrity, objectivity, and professional behavior. This course provides a focused review of these key concepts and their practical application in governmental auditing. Participants will also explore the independence standards, gaining insights on maintaining objectivity and avoiding conflicts of interest to ensure unbiased and professional audits. Presented by: Alex RomeroType: Live Webcast Replay
ACPEN: IFRS vs. US GAAP - Major Accounting Differences
-
Online
2.00 Credits
Whether a financial statement preparer or user is more familiar with IFRS or U.S. GAAP, it is important to be familiar with the important differences between the two financial reporting frameworks. This course will highlight some of the more significant differences between the standards. Presented by: Jennifer LouisType: Live Webcast Replay
ACPEN: K2’s Eight Awesome PivotTable Features
-
Online
2.00 Credits
Unlock the full potential of Excel's most powerful feature-PivotTables! While many users rely on them daily, few tap into the advanced capabilities that can transform data into dynamic insights. Join us for an eye-opening session where you'll discover eight game-changing PivotTable techniques that go far beyond the basics. From custom calculations and KPI integration to multi-source consolidation and advanced reporting tricks, we'll show you how to elevate your analytics and impress stakeholders. Whether you're a seasoned Excel user or just getting started, this session will equip you with the tools to turn ordinary PivotTables into extraordinary decision-making engines. Don't just use PivotTables-master them! Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Failure to Detect Fraud and the Reasons Why
-
Online
2.00 Credits
SAS 122, AU 240, Consideration of Fraud in A Financial Audit state that auditors fail to detect fraud for two reasons. One, they haven’t been trained to look for it and two, they don’t know what it looks like. I would like to add a third reason: they don’t want to find fraud because it causes problems for the audit. This session is designed to familiarize auditors with the many faces of fraud; where and how to look for them and what to do if you think you have found fraud. Not everyone is able to recognize fraud. During this program, the attributes a fraud auditor (frauditor) will be discussed. In order to recognize fraud, an auditor must understand their client’s operation. What is an indicator in one client’s operation may be business as usual in another, and you have to know the difference. After viewing this program, chances are you will never look at your client the same way! Presented by: Dennis DycusType: Live Webcast Replay
ACPEN: Real World Business Ethics Scenarios
-
Online
2.00 Credits
Most business ethics courses focus on concepts like “tone at the top”, “integrity”, “code of conduct”, “values”, and “ethical culture." These are extremely important concepts and must be understood But often, when a professional finds they are in a potential “ethical” situation, they question “What should I do?” It is not as easy as flipping a coin. Ethics aren’t always black and white and there are many variables that can impact both the issue and the outcome This course presents real-life ethical scenarios then challenges you to put yourself in the place of the professional to truly think about “What would I do?” The scenarios are all true…. the names have been changed to protect the innocent You will come away from this training with a new view of putting ethics into practice Presented by: Lynn FountainType: Live Webcast Replay
Google Gemini AI for Accountants
-
Online
2.00 Credits
This course provides a concise overview of Gemini AI, Google's advanced multimodal artificial intelligence model. It explains how Gemini is integrated into different Google products, including Gmail, Docs, Sheets, Slides, and as a stand-alone chatbot. Participants will learn how Gemini enhances productivity by summarizing email threads, suggesting responses, drafting emails, generating formulas, creating tables, and more. By the end of the course, students will have a solid foundation in understanding Gemini AI's role in the evolving landscape of artificial intelligence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Fiduciary Accounting for Estates and Trusts
-
Online
4.00 Credits
Financial accounting for trusts and estates is one of the least understood branches of accounting. It is not particularly concerned with recording income and expenses but is obsessed with determining whether receipts and expenditures are assigned to income or principal/corpus. This course will dive into this tricky area and provide a reporting guide for fiduciary accounting. Presented by: Doug Van Der AaType: Live Webcast Replay
ACPEN: Not Just Your Everyday FASB Update
-
Online
4.00 Credits
This course highlights significant updates that affect financial reporting and related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting and revenue recognition standards. This course will provide reminders regarding both GAAP and non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review, and compilation engagements. Presented by: Dr. Chris HarperType: Live Webcast Replay
ACPEN: Eliminating Busy Season: Transforming Your Practice to Year- Round Advisory Services
-
Online
8.00 Credits
This course provides tax and accounting professionals with a comprehensive framework for transitioning from a compliance-driven busy season model to a sustainable, year-round advisory practice. Participants will explore strategies for expanding services into tax, financial, and estate planning. The course addresses both transitioning existing clients and attracting new, higher-value clients while improving efficiency, client value, and revenue stability. Presented by: Arthur WernerType: Live Webcast Replay
ACPEN: Better Forecasts: Be a Better Predictor
-
Online
2.00 Credits
Imagine being able to see into the future with confidence. The ability to be a great forecaster is not innate but learned. By examining great forecasters, we can learn to improve our ability to predict the future. We will examine best practices and current research to improve our ability to predict events that will affect our business. Presented by: John LevyType: Live Webcast Replay