Professional Development and Event Catalog

Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.  

Please join us for a discussion on like-kind exchanges (LKE), known as one of the last great tax legal "shelters" available to those buying and selling real property. We cover the basic structure of a LKE, and ways a taxpayer can utilize qualified third-party intermediaries (QI), and tenancy-in-common structures including Delaware Statutory Trusts (DST). We also explore creative solutions to sticky situations a taxpayer may find itself in obtaining replacement property. This course is ideal for CPAs, EAs, lawyers, real estate professionals, accountants or other tax professionals. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Welcome to a course that makes the process of M&A easy to understand and easy to implement within your organization or your clients' organization. The course will provide an intensive overview of the M&A process. Focus will be on practical techniques to guide you through the M&A jungle and avoid the traps that have befallen many organizations.

This course focuses on the key federal tax issues affecting business from the internal accountant's point of view, with a focus on the major ramifications of the TCJA and other recent tax legislation and developments.  Planning alternatives and the potential risks associated with those strategies will also be discussed.    **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 program addresses the most recent developments impacting taxpayers incurring research and experimentation costs. Emphasis will be placed on compliance with the 2022 change in Section 174 Amortization of research and experimental expenditures. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program explores the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. We offer practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers, with particular emphasis on internal controls of small-to-medium clients.

This program addresses the recent changes imposed by recent tax legislation that real estate owners and investors need to know, including Section 199A, the new Section 163(j) interest expense limits and the opportunity to elect out.  An introduction to opportunity zones and other important issues will also be addressed. **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.

At its height, LIBOR was the benchmark for over US $350 trillion in financial contracts worldwide. Yet, due to concerns over the manipulation of the rate, standard setters determined that LIBOR should be discontinued. The global response to reference rate reform required financial reporting standard setters to provide practical expedients and exceptions to current modification guidance. This course will provide an overview of the standards issued (including amendments) from both the FASB and GASB to address the transition away from LIBOR.

This program addresses the most recent developments impacting taxpayers incurring research and experimentation costs.  Emphasis will be placed on compliance with the 2022 change in Section 174 Amortization of research and experimental expenditures. **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.

We know that effective communication is essential to growing a career and a business. But we often don't take time to think through, concsiously, about how we communicate and how small changes could change the trajectory of our messages. This workshop is designed to give you a survey of multiple communication strategies and mistakes to avoid. We start by discussing how people make decisions--which is important to understand in the context of business communication and communication in the workplace. We then transition into common communication mistakes and actionable tools and tactics that you can use to overcome and avoid these mishaps.

Did you know that AI can now write your marketing copy? Create videos with your digital likeness? Provide subjective advice to your clients? Produce training for your employees? Even if you're on the fence about trusting artificial intelligence tools, knowing about these technologies, especially when combined with forms of synthetic media (think deep fakes, but not nefarious), is important for any business leader. Imagine being able to have your likeness communicate in over 40 languages. Think about how amazing it would be to create customized content for every situation without building each piece from scratch. Marvel at how that *perfect* image can manifest from typing just a few keywords. In this session you'll learn about the evolution of communication technologies, how artificial intelligence has expanded our range of connective possibilities, and what possibilities exist for leveraging these channels of communication in your business.  

This course explores the multitude of issues that taking on a new client can bring with it, and then interprets them using three sets of ethical rules.  A group of “players” reveal real-life challenges faced by the CPA firm in bringing the new client into compliance, as well as proper financial and tax compliance issues. **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.

Ethics and professional skepticism are a cornerstone of public accounting. This course will review the Code of Ethics for Professional Accountants that practitioners must adhere to. This course will outline the pressures, opportunities, and rationalizations that lead to instances of fraud. In addition, this class will walk through some interactive examples to illustrate various scenarios of noncompliance during engagements. 

More and more entities need Yellow Book engagements, including a growing number of for-profit entities. In this course, we will review the unique independence requirements in GAGAS. We'll also review the recent changes to quality management in Yellow Book. We'll close with a reminder of common deficiencies found in Yellow Book engagements.

Technology continues to revolutionize our professional and personal lives. Stay up to date on key technologies that may affect you in the very near future so that you may position you and your organization for success.

Microsoft’s Power Platform – incorporated into many Microsoft 365 subscriptions – offers tools to automate common business processes. Learn how to take advantage of the Power Platform in this session.

Participate in this session to learn about key emerging technologies, including quantum computing, artificial intelligence, and selfsupervised learning.

Fraud continues to plague businesses at epidemic levels, and technology control failures are a big reason fraud occurs. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures that contribute to fraud, and what you can do to mitigate fraud risk. A specific focus of this course is the application of information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general control and application control failures that contributed to each of these frauds. By learning through these real-world case studies, you will be better positioned to reduce fraud risk.  

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.

This course explores the increasingly complex features of Excel that facilitate efficient data analysis.  We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information and dive into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.