CPE Catalog & Events

This course addresses the most recent legislative developments impacting individual taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client 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.

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.

Being consistently ethical is a challenge. Most of us have had to make tough choices.  This session will discuss real world cases involving thorny ethical dilemmas and how to resolve them. Being ethical is not the same as complying with the law and ethical issues are not always black and white. This session will review different professional ethical standards.  What does integrity mean in the office? If you want to learn lessons from the best in a short time, this session is for you.  Participate in engaging dialogue about how to prepare for the inevitable ethical situations.  These lessons are valuable for every business leader.

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.

The HR role is full of communicative opportunities to multiple audiences. From communicating with partners, management, and stakeholders in the business, to onboarding new talent, to training existing employees and beyond. In fast-paced business environments, it's often overwhelming to keep up with the changes and making sure all of your communication and training is up-to-date and accurate. That's where AI and synthetic media can intervene. By leveraging these tools and technologies, HR professionals are able to change the way they communicate and create new content. This session will uncover ways to make this happen, providing attendees with knowledge of new tools and strategies to use these technologies.

This course addresses the most recent legislative developments impacting business taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client 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.

It’s a whole new world for lessees under ASC topic 842.  Soon nearly all leases will need to be disclosed as a liability on the balance sheet – from buildings right down to autos and copiers.  Although the greatest impact will be on large entities, this will affect the financial statements of small and mid-size entities as well.  This program will dive into the new standard on leases, effective dates, and address what you need to know now.

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.

Every business has risks, but some myths seem to damage or kill more enterprises than others do. This session will review ten of the most problematic myths that may doom a business and discuss action steps to prevent these myths from holding your business back. This session discusses the common myths, mistakes, risks, and hidden landmines inherent in every business. We will learn from the mistakes of others who often paid a steep price so that we may learn valuable lessons. If you are a leader who wants your business to become even more successful, this session is for you.

What would you do if you only had one workday to complete a financial statement audit? How would you optimize just a handful of hours? What would you test? More importantly, what would you minimize or eliminate? Although one day is unrealistically short, it illustrates how risk-based auditing can help auditors optimize professional effort. This course emphasizes the importance of risk assessment for enhancing both the effectiveness and efficiency of audit procedures.

Following the ever-changing tax deprecation rules is not a game for the faint hearted!  This course analyzes the current landscape of depreciating, capitalizing and disposing of business assets, with examples and illustrated case studies to enhance the CPAs understanding of the most current tax depreciation provisions.  **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.

Microsoft Teams is one of the most exciting personal and organizationally productivity tools to ever appear on the business landscape. With Teams, you can communicate and collaborate easily and securely with others, including colleagues outside your organization. Further, you can extend the already-robust functionality in Teams by incorporating add-in solutions with just a few clicks of the mouse. Unfortunately, despite Teams’ power and relatively simple interface, many organizations struggle with deploying and using Teams.  In this session, you will learn how you can get up and running quickly in Teams so that you can take full advantage of this powerful tool. More specifically, you will learn how you can get started in Teams and critical decisions that will affect your deployment. Also, you will learn how to work in Teams, including how to take advantage of the chat, voice, and video call services and how to share documents securely with others. Moreover, you will learn how to extend your Teams platform to external organizations for improved communication and collaboration. Additionally, you will identify how you can add other applications into Teams and optimize Team's configuration for the best overall efficiency and security. If you are working with Teams or plan to do so, this is one CPE session you can’t afford to miss!

In this webinar, accountants will discover how to double their firm's revenue through CFO and advisory services. Many accounting firm owners are stuck in what we call The Accountant's Trap. It's where the firm owner is trapped working for low fees, dealing with high-demanding clients, all the while being burnt out on compliance and transactional work. To make matters worse, these firm owners can't raise their fees because there is always another accountant or bookkeeper willing to do the work for less -- not to mention all the tech companies trying to get into our space. Does this sound familiar? If so, this webinar is for you. This course is for any practice owner looking to transform their practice - and double their revenue - by offering a productized CFO/Advisory service. We'll cover the systems you need to transform your practice and the services you should offer to double your firm's revenue. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many practitioners dealing with government and not-for-profit issues are asked to serve as expert witnesses in courts of law or other adjudicatory venues.  This session will discuss key issues you need to know when you are asked to serve in this capacity, including: Applicable standards and other engagement acceptance considerations. Preparation requirements and techniques. Dos and don'ts of testifying. Avoiding commons traps and tricks designed to undermine your effectiveness. The session will conclude with a “mock cross-examination” with participants serving as the jury to identify what our witness does right and what he does wrong.

This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The control and compliance requirements for single audits differ from the requirements for GAAS audits. As a result, sometimes it's difficult to tell where the auditor's responsibilities start and stop in a single audit. This course is designed to help you proceed and succeed in applying the single audit control and compliance requirements. Over 15 focused exercises are included to provide an enhanced working knowledge of the most critical challenges in single auditing today.

Storytelling makes wisdom stick.

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.  

Surveys show that the average North American company completes its monthly financial statement closing in six 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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

We are now officially in the era of digital communications, collaboration and knowledge sharing. Is your organization prepared to embrace it? This course will show you how to do just that by strategically deploying the Microsoft Office 365 ecosystem of applications with the Teams app at the core. Office 365 provides the tools to digitally transform your workflows to increase efficiency, as well as to provide the ability for your team to work from anywhere, at any time, on any device. We will review how you can leverage specific Office 365 apps to foster online communication, collaboration and knowledge sharing among your team members, as well as externally with clients, customers and service providers. You will leave this course with a solid understanding of how to tap into Office 365 to take your business digital. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.