Professional Development and Event Catalog

The tax landscape is constantly changing, challenging tax practitioner to stay abreast of these developments.  This eight hour program will cover issues unique to business entities, including new court decisions, recent IRS publications, and the latest tax legislation that will impact businesses and individuals.  The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner.  **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.

The ACFE/COSO Fraud Risk Management Guide (FRMG) was published in 2016 (and updated in 2023).  It has quickly gained acceptance as the set of best practices for preventing, detecting, and thus deterring fraud. The fraud landscape is constantly changing and evolving. The FRMG sets out a rigorous set of principles and leading practices for managing fraud risk for forward-thinking organizations to follow.  It covers: How to establish fraud risk management governance. How to conduct rigorous fraud risk assessments. How to design and implement fraud control activities. How to establish reporting mechanisms and investigative procedures. How to monitor the overall fraud risk management program. Fraud risk can be managed.  All anti-fraud and accountability professionals will benefit from this session's focus on effective fraud risk management.

Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.

Are you looking to fortify your practice against the ever-growing threats in the digital landscape? Join us for the third installment of our exclusive webinar series, "Mastering Cybersecurity," brought to you by Practice Protect.  In today's digitally connected world, the need for comprehensive cybersecurity is paramount. With cyberattacks becoming more sophisticated, it's crucial to stay ahead of the curve in protecting your sensitive client data. This webinar series is designed to equip CPAs with the knowledge and tools needed to secure their practices and client information effectively.

In today's dynamic business environment, preserving a unified and engaged team culture is more challenging than ever. As the rhythm of work accelerates and organizational structures evolve, silent threats can begin to undermine our established team dynamics. These undercurrents, if left unaddressed, can erode morale, dampen productivity, and weaken the team's cohesion. This session offers a deep dive into strategies that can help identify, address, and neutralize these challenges, ensuring a positive, resilient, and inclusive workplace culture. Attendees will be equipped with a blend of insights and actionable strategies, enabling them to both recognize and respond to these potential pitfalls.

This course will review the Federal Trade Commission's proposed rule banning non-competes. It will also briefly go over the rule making process and timeline for the proposed rule to go into effect. In the second half, the presentation will review the patchwork quilt of state laws that have curtailed enforcement of non-competes, as well as best practices for businesses to consider when implementing non-competes in the workforce. 

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.

Strategic Planning for SMEs

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. 

A comprehensive review of the newest version of the U.S. Government Accountability Office’s Government Auditing Standards, otherwise known as “the Yellow Book.”  The standard will affect all auditors who perform audits of government and nonprofit organizations who receive federal funds, or where application of GAO standards is required by law, regulation or contract.  It does not address the standards applicable to performance audits.

A multitude of tax changes have are currently taking place, challenging tax practitioner to stay well-informed. This 4 hour program will cover tax developments specific to business, including new court decisions, recent IRS publications, and the latest tax legislation that will impact individuals.  The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner.  **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.  

According to the Gallup Organization, only 10% of employees believe that their organization does a good job onboarding new employees. This means most organizations are overlooking this crucial phase of the employee lifecycle, which not only includes the often-neglected pre-boarding stage but also the continuous efforts to reduce uncertainty, bolster excitement, and foster connections for their new recruits. By streamlining these processes and crafting impactful moments from pre-boarding through the initial weeks, HR and Business leaders can significantly enhance efficiency, foster trust, and establish a foundation of psychological safety for years to come. In this session, attendees will discover strategies and resources that craft a holistic onboarding experience, mitigating risks like employee ghosting, and paving the way for heightened engagement and retention.

Overview of the most important labor and employment policies and practices that every business should have. The review will go over confidentiality agreements, arbitration agreements, restrictive covenants, training, and severance agreements, as well as compliance issues related to each of them. 

Numbers and especially the digits within those numbers can conceal a lot of information.  Benford's Law and other digital analysis techniques can be the keys to unlocking that information.  This session will explain what Benford's Law is, how it works, and how it can be used to reveal bogus information and made-up data.  Accountants and auditors should understand how to use this valuable audit tool as well as other digital analysis techniques.  But, if you attend this session, you must promise not to reveal the secret behind these techniques to any fraud perpetrators.

Enterprise Risk Management for SMEs

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment.  Isn’t it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

This course will review the Federal Trade Commission's proposed rule banning non-competes. It will also briefly go over the rule making process and timeline for the proposed rule to go into effect. In the second half, the presentation will review the patchwork quilt of state laws that have curtailed enforcement of non-competes, as well as best practices for businesses to consider when implementing non-competes in the workforce. 

This session will focus on the most common types of fraud in the procurement and contracting arena, with a focus on fraud in construction.  The session will examine fraud vulnerabilities in the four key phases of the procurement process: Presolicitation. Negotiation. Performance. Closeout and Claims.  Within each phase, “red flags” will be discussed.  These are the indicia of possible fraud that managers should be alert for.  Also, within each phase, the most common fraud schemes will be highlighted and discussed.  Finally, the session will describe the generally accepted safeguards or controls that should be established to prevent the various fraud schemes that can occur.  This part of the program will make extensive use of actual fraud case studies designed to demonstrate fraud risks and fraud detection strategies.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. 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. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

Isn’t it time you learned how to take advantage of critical features available in your Microsoft 365/Office 365 subscription? In this session, you will learn to use tools such as Teams, Planner, Power Automate, and others to enhance productivity and efficiency.