CPE Catalog & Events

Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports, and dashboards, and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports, and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease, and add a valuable credential to your portfolio. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Knowing just a little about the Yellow Book can hurt you! It is important to have a thorough understanding of the standards. This course covers the Yellow Book financial auditing requirements and prepares you to excel in applying the standards. You will learn precisely what the Yellow Book does and does not require auditors to do. Updated for the 2024 Yellow Book revision, the course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced knowledge of the Yellow Book.

Companies that fall victim to fraud schemes need to reassess internal controls in order to prevent future fraudulent activity. In this course, we will review the 18 most prevalent internal controls present as well as designed and operating effectively according to the Association of Certified Fraud Examiners' Occupational Fraud 2022: A Report to the Nations. Then we will tie these controls to the 17 internal control principles offered by the Committee of Sponsoring Organizations of the Treadway Commission (COSO), the framework used by virtually all entities and auditors to assess the design and operational effectiveness of internal controls. Lastly, we will consider the impact of the 2020 pandemic on the internal control environment in the post-COVID pandemic era.

We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We will then switch to the audit side of the house to examine the impact of the 2024 Compliance Supplement on Single Audits and the changes to the Uniform Guidance. We close with a look at common deficiencies found in Single Audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a one-day fast-paced update course focusing on the hottest Federal income tax topics affecting individuals, businesses and their owners with an emphasis of newly enacted income tax legislation. **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

As our business environment shifts, so do trends with fraud schemes and perpetrators. This course will give you the absolutely latest information with how to identify and mitigate shifting fraud risks in any entity. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.

Protecting yourself from ransomware requires more than just anti-virus software. Additional technology protections are necessary. Further, business continuity, legal and regulatory, and cybersecurity insurance considerations should all be a part of your risk abatement strategy. Attend this session to determine if your current level of ransomware protection reduces your risk to an acceptable and identify ways to ensure that you are protected.

Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures, and address challenges within the year. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

If you find yourself working with PDF files consistently throughout the day, this course will teach you how to review, annotate, format and organize PDF files more effectively and in less time. You will also learn how to use Adobe Acrobat for e-signatures to reduce document processing time significantly and enhance confidentiality. Adobe Acrobat has many features that you can take advantage of and this course will explain and demonstrate how to use them. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Discover the real-world power of Artificial Intelligence (AI) and equip yourself with the skills to conquer modern challenges in accounting and finance. In this engaging course, we demystify AI and unveil its practical applications, transforming it from theory into a hands-on tool. Learn the essential AI fundamentals and unlock its remarkable potential to boost your productivity and effectiveness alongside your team. Explore the specific problem-solving capabilities of AI, tailored to address the unique challenges faced by accounting and financial professionals. Gain expertise in leveraging AI features integrated into everyday applications, including the ubiquitous Excel. Uncover how these features enable you to effortlessly detect fraud, identify potential transaction errors, and elevate your financial operations to new heights. Witness firsthand how AI is reshaping the present and future of your profession, positioning you at the forefront of this revolutionary wave.  

In this introductory course, you'll learn the fundamentals of integrating forensic data analytics into your anti-fraud risk management program. We will cover key definitions, use cases, methodologies and some of the leading innovations and techniques driving this ever-evolving field of "finding hidden money."

Collaboration is more important now than ever. In this session, you will learn how to take advantage of today’s collaboration tools to improve accuracy, customer/client service, and organizational efficiency.

The ability to create and ask good questions as well as the ability to know when someone is being deceptive are important skills for managers, auditors, and investigators. This session will improve your interview techniques and your lie detection abilities. Multiple videos from various movies, TV shows, and public figures showcasing the behaviors of liars are included.

This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How much can you contribute to a Roth IRA, Roth 401(k), SEP Roth IRA, or SIMPLE Roth IRA? How will a Roth distribution qualify to be tax-free? How did SECURE Act 1.0 and SECURE Act 2.0 change the Roth rules? These are only some of the key Roth questions advisors must know the answers to. Plus, as Roth accounts have increasingly become an essential component of retirement savings portfolios, with one-third of IRA owners owning Roth IRAs, advisors have even more reasons to be Roth-proficient. To that end, the instructor will simplify critical rules that govern Roth funding and Roth distributions for Roth IRAs, Roth 401(k)s, and sister plans.

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

Please join us for a discussion on Treasury Circular 230 and other ethical issues faced by enrolled agents and other tax preparers.  In addition to covering the practice standards espoused by Treasury Circular 230, there will also be an overview of the applicable provisions in the Internal Revenue Code (IRC) and common law which will affect tax preparers.  The discussion will conclude with other ethical issues, such as avoiding conflicts of interest, proper fee structure and maintaining competency.  Also included will be case studies illustrating dilemmas faced by tax practitioners.   **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.  

How does a forensic accountant calculate financial losses? Federal courts have approved various ways to calculate losses ranging from net worth method of proof to the expenditures method. Each method of proof depends on the available facts to the forensic accountant. This presentation will focus on the various court approved methods of proof, when to use them, and how to calculate the total loss. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

While the pace of FASB's standard-setting has slowed in recent years, the standards that have been issued will be impactful for many organizations. This course will begin with a review of standards effective in 2025 for public, private, and nonprofit organizations. From there, we'll explore upcoming standards, FASB exposure drafts, and ongoing projects to ensure you're prepared for what's next in financial reporting. The second half of the course will shift focus to developments at the AICPA. From quality management to ethics standards and the talent pipeline, there's no shortage of activity. We'll start with a detailed look at the quality management standards effective this year and their impact on firms, including changes to the Peer Review Program. Next, we'll cover essential ethics standards and the latest SSARS updates. We'll also examine common deficiencies in employee benefit plan (EBP) audits and discuss the initiatives of the National Pipeline Advisory Group.