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.
ACPEN: Making Effective Decisions When You Can’t Get Everything You Want
-
Online
2.00 Credits
Even if managers have incomplete information or constraints, they still must make choices. This session provides advice for navigating rocky decision-making terrain encountered by managers who must make choices despite imperfect information and/or constrained resources. We explore ways to leverage available information to make effective decisions when seemingly critical details cannot be obtained. We also illustrate managerial accounting techniques for optimizing profitability when inputs or resources are constrained by supply chain disruptions or other limitations. Presented by: Dr. Chris HarperType: Live Webcast Replay
Securing Your Data with a Password Management App - Updated
-
Online
2.00 Credits
Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Taxation of Business Entities
-
Online
2.50 Credits
This course will introduce you the different types of business entities and the tax implications of contributions, distributions and earnings, among other 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: Leading for Well-Being: Building Resilient Teams & Thriving Workplaces
-
Online
3.50 Credits
Leaders set the tone for workplace well-being. This program will equip leaders with the tools to build resilient teams. Creating a culture of mental wellness allows employees to feel safe, valued and heard. This will improve productivity, reduce burnout and absenteeism and ultimately, create a workplace where employees can thrive. Leaders will also learn the importance of nurturing their own self-care to prevent burnout for themselves in order to be the best leader possible. Presented by: Ivy WattsType: Live Webcast Replay
ACPEN: Shorten Month-End - Closing Best Practices
-
Online
4.00 Credits
Surveys show that the average North American company completes its monthly financial statement closing in six (6) days. However, some companies can close their books in one day or less. You don't have to sacrifice accuracy for speed. This session will show you how to close month-end faster, better and cheaper. Yes, to all three. Presented by: Don Minges, Anita LaytonType: 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: The Single Audit from Beginning to End Update
-
Online
8.00 Credits
This course is an updated overview of the single audit of state and local governments and not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits. Presented by: J. Michael InzinaType: Live Webcast Replay
Internal Controls Over Compliance vs Compliance
-
Online
1.00 Credits
Accurately identifying and testing controls over compliance is critical, yet it remains a common deficiency highlighted in peer reviews. This course offers a comprehensive overview of internal controls over compliance, with a focus on their application to Single Audits. Participants will learn how to effectively align internal controls with specific compliance requirements. Additionally, we will address one of the most frequent findings in audits of governmental entities receiving federal grants: the misidentification of controls and the confusion between compliance and control processes. This course will help clarify the distinction, equipping you with the tools to enhance audit quality and ensure compliance effectiveness. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Ethics Aren't for the Byrdes in Ozark
-
Online
1.00 Credits
Professional codes of ethics provide guidance to professionals who are frequently required to choose between doing the right thing and the wrong thing. Sometimes, professionals violate their ethical code and do the wrong thing for what they rationalize is the right reason. This session uses the popular television show "Ozark" and its multiple examples of seemingly good people doing bad things for the right reason to define ethics as well as explore why people make unethical choices and how they justify those choices. Presented by: Daniel PorterType: Live Webcast Replay
ACPEN: Global Internal Audit Standards (GIAS) Domain V - Part 2
-
Online
2.00 Credits
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: K2’s CRM – The Ultimate Business Automation Tool
-
Online
2.00 Credits
This course provides an in-depth exploration of Customer Relationship Management (CRM) systems as a critical tool for business automation. Designed for accounting professionals, it emphasizes CRM's role in streamlining workflows, organizing communications, enhancing client relationships, and improving efficiency. Participants will learn about key CRM features, integration with accounting software, and best practices for successful implementation. We will highlight practical applications with actionable insights to help attendees optimize their processes. This two-hour session ensures you walk away with a basic understanding of CRM's transformative potential for business and financial management. Presented by: Brian TankersleyType: Live Webcast Replay
ACPEN: Excelling at Excel: Tips, Tricks and Updates
-
Online
2.00 Credits
Unlock the full potential of Excel with our comprehensive training on shortcuts and formulas. This course is designed for CPAs and financial professionals who want to enhance their efficiency and accuracy in Excel. Learn how to navigate and utilize different versions of Excel, discover powerful new functions, and master the art of creating effective tables and automations. With practical examples and hands-on exercises, you'll transform your Excel skills, making your daily tasks quicker and more precise. Plus, benefit from insider tips and tricks drawn from the instructor's extensive real-world experience. Whether it's mastering keyboard shortcuts that save you time or applying formulas that simplify complex calculations, you'll gain practical knowledge that you can immediately apply in your work. This course isn't just about learning Excel; it's about learning to excel at Excel. Presented by: Tracy CooperType: Live Webcast Replay
ACPEN: Big Picture Mega-Trends, Big Data, and World We Now Face
-
Online
2.00 Credits
It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: Execute Your Strategy: Turn Planning into Results or Destroy it and Start Over…Again
-
Online
2.00 Credits
Organizations that execute a wise strategy succeed; others are executed in the market. Many organizations invest significant time in strategic planning but fall short when it comes to execution. According to McKinsey, most fail to properly execute their strategy. This session explores the critical transition from strategy to performance while challenging outdated planning models and myths. We often do not think of strategy in the same context of longer-term organizational projects like ERP transitions or risk management. Why should you consider “killing” your current plan and building a new plan centered around financial performance? We will dive into the reasons strategy fails, uncover the practical tools for bridging the planning-performance gap, and explore how strong financial integration enables strategy to succeed. We review insight into what works—and what must be stopped immediately. The author uses CocaCola as a baseline to communicate elements of strategy and incorporates funny videos to highlight key points. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: Independence Requirements for Auditors
-
Online
2.00 Credits
Independence is a foundational requirement for CPAs in public practice and is critical to maintaining public trust in the profession. This course provides a practical overview of independence concepts and requirements as outlined in the AICPA Code of Professional Conduct, with an emphasis on real-world application. Participants will review key independence principles and common areas of risk, along with recently issued ethics interpretations from the Professional Ethics Executive Committee (PEEC) that impact independence requirements. The course focuses on how these interpretations apply in practice and discusses practical approaches firms and practitioners can use to implement and maintain compliance. Designed for auditors performing attest engagements, this course helps participants better understand independence requirements and navigate evolving guidance with confidence. Presented by: Melisa GalassoType: Live Webcast Replay
Forgotten Managerial Accounting Tools for CPAs
-
Online
2.00 Credits
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Fraud’s Greatest Hits!
-
Online
3.00 Credits
Fraud has always been a concern for anyone associated with financial statements. In this course, Jeff takes a unique approach to the study of this topic by looking at what are considered to be the top ten accounting fraud cases. In studying the cases, you will gain insight into what to look for in the future. In addition to the cases, Jeff will cover various aspects, both authoritative and guidance, related to fraud to further improve your awareness and skills. He will also cover a couple of other significant fraud cases as well as a couple of interesting historical notes. The entire presentation is packaged into Jeff’s unique blend of teaching with humor. Each case has its own “Greatest hit”, a song parody to help you remember the case as well as other surprises along the way to keep your interest. If you are looking for a course that will keep awake and engaged and will better prepare you for detecting fraud, then this course is a must. Presented by: Jeff SailorType: Live Webcast Replay
ACPEN: K2’s Excel Charting And Visualizations
-
Online
4.00 Credits
Are you tired of struggling to create compelling charts and graphs? Join our session and transform your data into stunning visualizations that captivate and inform your audience. This isn't just another seminar on basic charts; it's a comprehensive guide to mastering advanced, interactive, and dynamic visualizations in Excel. In this session, you'll learn how to create visually appealing charts that are not only informative but also engaging. Discover the secrets to making your data come alive with interactive elements that ensure your audience understands and retains the information you present. Whether you're looking to enhance your communication skills or impress your stakeholders, this seminar is a must-attend. Don't miss out on the opportunity to take your Excel skills to the next level. Sign up now and start creating visualizations that make a lasting impact! Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: K2’s Top PDF Features You Should Know
-
Online
4.00 Credits
Are you tired of struggling with PDFs? Unlock the full potential of Adobe Acrobat and other PDF tools to make working with PDF files a breeze. Join our course and discover how to use powerful features such as PDF forms, redaction, converting PDFs to Word and Excel files, and electronic signatures. You'll also learn how to create and apply tick marks, build indices, catalogs, and portfolios, and secure your PDF documents to the fullest. As the popularity and usefulness of PDFs continue to grow, many users still haven't learned how to manipulate these documents effectively. Don't let this be you! Join us for this timely session and learn the top features necessary to optimize your work with PDF documents. Say goodbye to frustration and hello to efficiency! Presented by: Thomas StephensType: Live Webcast Replay