CPE Catalog & Events

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

There are numerous federal laws that restrict what businesses can do in terms of hiring and firing employees. Many of these laws impose significant penalties if employers violate them. Accordingly, it is crucial that all employers and their professional advisors understand these laws and apply them to their employment practices.

Learn practical strategies to increase revenue generation using AI-driven ideation methods. This course provides a concise overview of cutting-edge artificial intelligence tools and methodologies that enable professionals to transform innovative ideas into sustainable revenue streams. Through a practical, hands-on approach, participants will explore various AI platforms and workflows that streamline the process of creating digital assets, content, and products. The course emphasizes real-world applications and demonstrates how to leverage AI technology to diversify service offerings and generate new income sources. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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  

This comprehensive session is a must-attend event for any professional accountant who prepares financial statements for either a private enterprise or a firm client. We illustrate best practices for presentation and disclosure by revisiting fundamentals of financial reporting for various industries. This workshop explores best practices for United States GAAP in addition to considerations for special purpose frameworks. Experienced accountants will benefit from a refresher whereas other accountants will appreciate formative skill-building insights.

The Accountant role is evolving from data aggregation to knowledge extraction, with a significant emphasis on understanding and leveraging technological advancements. In this era of rapid digital transformation, it is crucial for accountants to grasp the shift towards more analytical roles, learn the tools, and integrate Business Intelligence (BI) and Data Analytics (DA) in their organization and daily practices. This course will focus on raising the accountant's awareness of BI and DA practices, the impact of AI technologies like ChatGPT, and how these can benefit their organization. By embracing these technologies, accountants can enhance their value proposition by transitioning from traditional accounting roles to becoming strategic advisors and decision-makers.

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.  

This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of partnership, limited liability company (LLC) and limited liability partnership (LLP) taxation. A cornerstone of this course is the preparation of the Form 1065 using a fairly complex trial balance common to most partnership, LLP and LLC income tax returns. **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

This comprehensive 8-hour course explores the pervasive issue of fraud in State and Local governments. Our panel of experts from inside and outside government will provide participants with the tools and knowledge necessary to identify, prevent, and respond to fraudulent activities in State and local governments. The course begins by examining the types of fraud commonly encountered in governmental settings, including financial fraud, procurement fraud, and abuse of power. With our experienced panelists, participants will delve into real-world case studies to understand the tactics used by fraudsters and the impact on public trust, resources, and governance. Special emphasis will be placed on understanding regulatory frameworks and compliance measures designed to mitigate fraud risks.    

Yellow Book and Single Audit reporting entities have complex and unique financial statement audit, compliance and reporting issues. Deficiencies in these types of audit engagements are common. This course will reduce the likelihood of noncompliance with relevant professional and regulatory auditing and reporting standards.

Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.

The mad scramble to remote work and utilize apps like Teams has been trying for most organizations over the past couple of years. With a rush to install and no time to plan, most team members did their best, prioritizing remote meetings as the primary concern. Therefore, as a result, Teams is vastly misunderstood and underutilized in most organizations. Join us in this session to go beyond the remote meetings aspect of Teams and to learn how to optimize efficiency, communication, and workflow with Teams.

The new revenue recognition standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry. Previous courses in this series have covered the standard at a high level and evaluated step one and two of the standard. They are: Understanding the Revenue Recognition Standard Revenue Recognition: Identify the Contract - Part One Revenue Recognition: Identify the Contract - Part Two Revenue Recognition: Identify Performance Obligations – Part One Revenue Recognition: Identify Performance Obligations – Part Two Revenue Recognition: Determine Transaction Price - Part 1 Revenue Recognition: Determine Transaction Price - Part 2 Revenue Recognition: Allocate the Transaction Price Revenue Recognition: Recognize Revenue      This segment is designed to evaluate Step Three of the new model dealing with Determining the Transaction Price.

This course is designed to equip HR leaders, managers and business owners with the knowledge and skills needed to effectively minimize conflicts in the workplace. Participants will learn about the various sources of workplace conflict, how to identify and address conflicts before they escalate, and how to implement effective conflict resolution strategies. The course will also cover topics such as communication skills, active listening, and conflict management techniques. By the end of the course, leaders will be able to create a more positive and productive work environment, reduce turnover, and promote employee satisfaction.

How you say what you say is more important than what you say. According to a UCLA study, 93% of a communicators effectiveness is based on non-verbal cues. This foundational program include a focus on the verbal, vocal and visual delivery techniques appropriate for the business environment, which can improve a speakers credibility, influence and impact. Depending on the course length other topics include; managing fear, organizing your presentation, increasing attention and interaction, handling questions, infusing humor, creating impactful visuals, and more.

The first course in a four-part series, fiduciary accounting and taxation field, has transitioned over the past several years with updated rules and the increased tax cost of accumulating income in a non-grantor trust. The changes in the income tax rate structure at the federal and state levels have pulled income tax planning forward as a prime objective for estate planners. The rules and understanding of fiduciary accounting continue to be in a state of development and challenge. It is an understatement to say that fiduciary accounting and taxation have entered a new and very different phase of complexity and change. We will explore many of these issues in Parts 1-4 of Form 1041 Advanced Series . Be sure to register for all courses in this series: Form 1041 Advanced Series Part 1: Why Complex Trusts are Complicated Form 1041 Advanced Series Part 2: Cash & Property Distribution Issues Form 1041 Advanced Series Part 3: Sec. 199. Sec. 67(g) & Charitable Deductions Form 1041 Advanced Series Part 4: Post Mortem Considerations

So, you've been using Power BI to create fundamental reports and dashboards, and now you're ready for even more advanced reporting & if so, this session is for you. In this session, you will learn how to extend your Power BI environment by incorporating tools such as Data Analysis Expressions, Key Performance Indicators, Hierarchies, and Apps and Content Packs, among others. By taking advantage of the tools and techniques covered in this session, you will be able to move beyond simple reports and dashboards in Power BI and truly leverage the power of this awesome reporting tool.

This two-hour CPE course is designed for accounting professionals and technology enthusiasts seeking to enhance productivity through Microsoft 365's versatile applications. Participants will explore ten key apps - including Shared Mailboxes, Planner, Lists, To Do, Stream, Viva Learning, Forms, Bookings, Approvals, and Places - and learn to integrate them effectively into their workflows. The course emphasizes practical applications within accounting contexts, aiming to streamline operations and foster collaboration.

Significant changes in the audit environment for 401k plans have resulted from recent U.S. Department of Labor reviews of 401k audits and the issuance of Statement of Audit Standards Number 136 (SAS 136), the Auditing Standards Board's new standard for employee benefit plan audits. This course will assist the audit professional with guidance needed to perform 401k audits in the upcoming year. We will discuss the significant changes from SAS 136 and other recent auditing standards, including both the auditor's and plan sponsor's responsibilities when electing and performing an ERISA Section 103(a)(3)(C) audit, which replaced the former limited scope audit. We will also focus on the most common compliance issues identified in 401k audits from both the Department of Labor and peer reviews, along with best practices and recommended corrections.