CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
ACPEN: K2’s Mastering Advanced Excel Functions
-
Online
4.00 Credits
With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. But if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features-some new and some legacy-to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel. Presented by: Thomas StephensType: Live Webcast Replay
Seeing Beyond the Numbers: Analysis for CFOs & Controllers
-
Online
4.00 Credits
Financial statements are a window into what is going on in the day-to-day operations of the company. They help us see what the company's strengths and weaknesses are. However, financial statements can often have different messages depending on the user. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics: How to Give and Receive Criticism the Right Way
-
Online
2.00 Credits
How well do you accept criticism? How might it enrich your business - and you - if you did a better job of it? This distinctive webinar will show you why it is in your best interest to accept criticism with gratitude. It's even better to welcome criticism. It's also a good idea to learn how to give criticism the right way. A related topic is the art of giving and receiving apologies, and we'll do a deep dive into this area as well. You'll leave with clear guidelines for how to criticize others, accept criticism from them, give meaningful apologies, and accept apologies with grace and ethical intelligence. The result will be a stronger CPA practice and a better you. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Unleashing Creativity in the Workplace
-
Online
1.00 Credits
In today's fast-paced and competitive business landscape, the ability to foster creativity is more crucial than ever. Unleashing Creativity in the Workplace is a CEU course designed for HR professionals who are eager to cultivate an environment where creativity drives productivity, innovation, and engagement. Through this course, you will learn how to leverage creativity to enhance individual, team, and organizational performance-ultimately achieving your company’s goals faster and more efficiently. Christine Wilson, a counselor turned coach and the creator of the Think Time planner, will guide you through a comprehensive approach to fostering creativity and innovation in your organization. Whether you're looking to inspire new ideas, improve employee engagement, or create a culture of innovation, this course offers actionable strategies and insights to help you unlock the full potential of your workforce. Presented by: Christine WilsonType: Live Webcast Replay
ACPEN: Schedule C of Form 1040
-
Online
2.00 Credits
Many self-employed or sole proprietors find themselves having to navigate Schedule C in reporting business income. While this attachment to Form 1040 seems straightforward on the surface, there are many traps for the unwary. This course is ideal for CPAs, EAs, or other tax professionals. **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. Presented by: Allison McLeodType: Live Webcast Replay
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Autonomous Agents in Audit and Assurance
-
Online
2.00 Credits
This course explores how autonomous agents are transforming internal and external audit functions. Agentic AI is redefining how auditors perform risk assessments, gather evidence, test controls, and issue reports. Participants will examine real-world examples, including audit bots from Big Four firms, and consider the impact on assurance quality, auditor judgment, and documentation standards. Key frameworks from the PCAOB, ISA, and AICPA will be discussed, along with governance strategies to ensure audit agents operate reliably, securely, and ethically. This redefines the CPA's role in ensuring the integrity and reliability of audit evidence when leveraging AI agents, impacting audit quality and professional skepticism.
Fraud Busters: Controls to Prevent & Detect Fraud
-
Online
2.00 Credits
This course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Before You Let Them Go: A Whole Brain Approach to Helping Team Members with ADHD Thrive in Your Organization
-
Online
1.00 Credits
Many employees with ADHD struggle with productivity. It’s heart-breaking to feel you have to let a team member go due to lack of performance. This course is for HR Professionals and Team Leaders who want more tools in their tool belt to help improve retention with ADHD team members. You will learn whole brain strategies to help your team members with ADHD improve performance, so they can not only survive but thrive. This innovative science-based approach is designed to help people with ADHD get more done in less time with a process designed with their creative brain in mind. Presented by: Christine WilsonType: Live Webcast Replay
ACPEN: The SECURE Act 2.0 – Planning Opportunities for Individuals
-
Online
1.20 Credits
The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that individuals need to know about contributions to accounts and new ways of accessing these funds. This course will provide a concise look at these hot topics. **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. Presented by: Allison McLeodType: Live Webcast Replay
ACPEN: Revenue Recognition Topic 606 Contract with Customers - Identify the Contract Part 2
-
Online
1.20 Credits
This course is a continuation of discussion over Step One in the revenue recognition process of Identify the Contract. Specifically, this session delves further into the considerations surrounding contract modifications, change orders, unpriced change orders, cancelations, non-finalized changes and accounting treatment when a contract does not exist. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Communicating in a Virtual and Live Environment – Numbers Matter But So Do Words
-
Online
2.00 Credits
People fear presenting more than they do “death”. Communicating numbers is a scary proposition to overcome for both the presenter and the recipients. This course is designed to enhance the communication skills of CPAs and CFOs by emphasizing the importance of understanding and mastering the facts before delivering any presentation, understand the key elements of presenting a narrative, and provide examples to engage live and virtual teams in effective numbers presenting. The goal is to equip financial professionals with the tools needed to overcome fears and provide the best practices research on all types of presentations-from communicating complex financial information effectively to conducting a casual virtual meeting. This is a fun session intended to be interactive with participation either live, virtual or both. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: Leaders Eat Last. Why? The Characteristics of Great Leaders
-
Online
2.00 Credits
If a great leader is someone we are willing to sacrifice for – what do those leaders do that makes us want to do more? Many of us work in dysfunctional organizations that want followers, but have no leaders that lead. What makes a leader effective? True leaders sacrifice, they are trustworthy and they empathize. We discuss the steps to take so you can become a true leader: including, integrity, humility, communication, self-control and self-awareness. With diligence, you can become a better leader and we will discuss how. Presented by: Don MingesType: Live Webcast Replay
ACPEN: Budget Mastery: Walkthroughs and Real World Calculations Towards Tying Budgets To Value
-
Online
2.00 Credits
This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial modeling. From the beginning of the accounting process – ‘the chart of accounts’ to the end of the process – ‘the valuation of the company’, the budgeting cycle via a live case model to learn best practices common to successful companies. This course stands on its own but is part two of a four part budget mastery series. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: K2’s Collaboration – Best Platforms And Practices
-
Online
2.00 Credits
Collaboration remains one of today's hottest topics. Technology has fueled today's collaboration options, and work-from anywhere environments virtually demand collaboration platforms. In this session, you will learn today's best tools and practices to facilitate more effective collaboration in your organization. In this session, you will learn about today's mainstream collaboration platforms & Microsoft 365, Google Workspace, and Zoho - and how these options are similar and differ. You will also learn about other collaboration options, including Slack, Zoom, and Webex, and you can incorporate these tools into your collaboration environments. Further, you will learn about some of the best practices and procedures that must be in place to optimize your collaborative environments and experiences. Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Estimates, Contingencies and Going Concern
-
Online
2.00 Credits
This course covers a broad range of topics involving uncertainty in accounting and auditing. It addresses accounting standards related to going concern, contingencies, guarantees, and credit losses, along with auditing standards applicable to auditing accounting estimates and evaluating going concern. The course provides a practical overview of how these areas are addressed under current standards and how they impact financial reporting and audit procedures. Jeff presents the material in an engaging manner to reinforce key concepts and maintain focus. Presented by: Jeff SailorType: Live Webcast Replay
ACPEN: Rethinking Your Customers to Maximize Profitability: Identifying the Right Clients
-
Online
2.00 Credits
Some customers are unprofitable from an economic or time perspective – but many organizations do not differentiate or know the difference. When an organization has a unique, well-differentiated service or product, understanding value from the customer’s perspective becomes a crucial factor in profitable pricing. We must take the time to fully understand what our customers value - from the customer’s point of view. What is value? Why do brand, value, and customer focus matter? Developing a deep understanding of our customers is vital. Our most important customer might be someone we have not yet recognized. Understanding both external clients and internal stakeholders - including the evolving role of the finance department, is critical to long-term success. Using humorous video clips, memes, and vetted research, your understanding of customer bases will improve. Presented by: Bob MimsType: Live Webcast Replay
Entertainment, Meals & Travel Expenses: Review and Update
-
Online
2.00 Credits
This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Common Yellow Book & Single Audit Deficiencies
-
Online
4.00 Credits
Yellow Book and Single Audit engagements are routinely selected for peer review and continue to be areas of heightened scrutiny by peer reviewers and federal oversight agencies. This course examines common deficiencies identified in governmental and Single Audit engagements, with a focus on understanding why these issues arise and how they can be avoided. Participants will review frequent deficiencies related to Yellow Book requirements issued by the U.S. Government Accountability Office, including independence, CPE, and reporting considerations. The course also addresses common Single Audit deficiencies, including internal controls over compliance, compliance testing, and major program determination. Designed for auditors performing governmental and Single Audit engagements, this course helps participants recognize recurring problem areas and better understand the requirements that continue to drive peer review findings. Presented by: Melisa GalassoType: Live Webcast Replay
ACPEN: K2’s Securing Your Data: Practical Tools For Protecting Information
-
Online
4.00 Credits
In today's digital landscape, security is non-negotiable. Yesterday's techniques cannot keep up with today's threats. It's time to elevate your knowledge and protect your sensitive data with our comprehensive security program. Join us to discover the latest tools and techniques for securing your data, including encryption, virus protection, safe communications, electronic signatures, secure authentication, and more. You'll also learn how to implement a practical, five-step approach to securing your PC and the critical questions to ask your staff to ensure server-based information remains protected. Security failures, such as client or customer data breaches, can be devastating and even drive your company out of business. So, what security tools do you need, and how should you use them to safeguard your sensitive data and systems? Can you afford to manage today's threats with outdated techniques? Participate in this valuable session to learn how to identify viable and practical solutions to mitigate today's security threats. Don't miss this opportunity to fortify your defenses and ensure your business's success. Sign up now and take the first step towards a more secure future! Presented by: Thomas StephensType: Live Webcast Replay