CPE Catalog & Events

The first session in the series covers one of the most significant enhancements rolled out with Excel 2007, Tables. Tables are used to store data and can absolutely revolutionize our workbooks because they solve one of the biggest pitfalls Excel users have faced for over 20 years. The webcast also covers named references, which will be used throughout the series. In addition, the five most important shortcuts are explored, so that you can improve your personal productivity. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook, and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.

This course is designed to provide accountants with a comprehensive understanding of the subscription pricing model. As the business world increasingly shifts toward subscription-based models, it's crucial for accountants to understand the financial implications and strategies associated with this pricing approach. This course will cover the basics of subscription pricing, how to set prices, and how to analyze the financial impacts of these decisions, as well as the specific impacts to your business. By the end of this course, participants will be equipped with the knowledge and skills to effectively manage the implementation of subscription pricing to their practice.

In a competitive economy, CPA's  and their firms need a way to stand out. The best way to do this is to give outstanding service to your clients. In this experiential workshop, you’ll learn skills that lead to dramatic client satisfaction. In addition, you'll learn several specific ways to guarantee you'll get a lot of word of mouth referrals that will lead to a dramatic increase in your number of clients.

Our guidance on ethics comes from the AICPA and other groups, but it does not fully address the “why” behind ethics. This session will examine and define what ethics is and what it means to varying people in the workplace. Understanding what motivates people and understanding those people are key to both solving ethical dilemmas and workplace issues that can lead to greater job satisfaction and efficiency. To correct an issue, you need to delve into the root cause – the why?

Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In this webinar, we will focus on Text functions and Date & Time functions. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date & Time function section, you will learn how to perform various date and time calculations. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Professional Codes of Conduct make Ethics seem easy and clear cut. However, this is not so in real life. This session discusses five cases where the ethics is not so clear cut.  What should be considered?  We will explain how you can be more diligent and maintain awareness of ethical issues to become more effective and enhance the reputation of the profession.    

Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

When you're working with clients, it's not always smooth sailing (though we wish it was). Often we need to have difficult conversations. Whether it's to overcome objections, negotiate a new contract, or manage a conflict, these conversations can be navigated successfully with the right tools. This workshop gives you those tools and an understanding how how the human mind works when it comes to processing communication in difficult situations.

Sustainability Accounting is now a recognized professional skill of increasing importance in larger organizations. It is the process of finding, measuring and managing the material metrics for sustainable performance and risk management. The goal is to bring these metrics into regular financial statements so leaders can act on them.  This course teaches Sustainability Accounting basics with example from the restaurant industry.   It is suitable for any professional or student who wants to learn fast about sustainability issues in specific industry sectors and how to integrate sustainability metrics into financial accounting and reporting.

Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You only have one chance to make a good first impression.  In the fast paced world we live in, being able to create immediate rapport and a sense of trust with people is more important than ever.  Fortunately, this is an easily learnable skill that can serve you in both business and in life.  People who can master the one minute relationship end up making more money, being better liked, and enjoying their clients more.  

Running or advising a small business? KPI Bootcamp can help you quickly find and deploy the right KPIs to achieve your, or your client's, goals. Delivered by Bernie Smith, KPI specialist and overloaded small business owner, this course will help you quickly select a handful of powerful measures that apply to your business. The step-by-step approach helps you sharpen your objectives and select the right KPIs to drive growth and profit. Every one of the 412 included KPIs (as free PDF download for every participant) includes a full plain-English definition and also covers business benefits, case-study examples and practical tips.

This course will help you develop a strategic marketing and business development plan for your firm using 7 key principles to help maximize lead generation. You will learn how to establish and grow your B2B business in any niche using time-tested strategies, proven processes for attracting and retaining customers, and how to measure your results so you can spend your money and time effectively to own your market and attract higher ROI clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

Identify and eliminate risk Understand how risk affects all areas of business-from hiring and onboarding to customer fulfillment and customer support, and everything in between. Gain the knowledge to make informed decisions about risk assessment. Understand the importance of fully integrating risk assessment techniques into other elements of enterprise risk management. Tools and techniques With the assistance of 17 tools and techniques, learn how to assess and manage risks in your organization. Compare SWOT analysis and PESTLE analysis in analyzing risks. Understand how enterprise risk management (ERM) can help protect and enhance stakeholder value. Learn how ERM can be used by businesses of all sizes.

Are you an accountant or finance professional working in the state and local government space? Are you an auditor with state and local government clients? If you answered "yes" to either of these questions, you're aware that to succeed at your job and to uphold the public trust, you need a solid understanding of governmental accounting and reporting. This course will walk you through GASB standards and look to the future by exploring current GASB projects.

In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand they need the best skills to motivate, manage, and lead people. Being pigeon-holed into one area or another is neither good for career building nor good for the organization. This reality has proven to be even more true with the advent of COVID-19. We'll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations. The program is focused on organizational success and will concentrate on ways to manage risk and achieve greater productivity.

This two-part interactive workshop reviews the hottest accounting topics and recent changes in areas such as private company accounting, revenue recognition, going concern and other specialized subjects. Refresh research skills and practice using codification. Case studies and real-life examples will help attendees readily apply the information covered. This course is one of two parts of Financial Accounting Standards: A Comprehensive Review. Please be sure to also register for Part 2.

This course will cover all pronouncements of the FASB relevant to nonpublic entities. It will be presented in two distinct sections: First, we will identify all Accounting Standards Updates (ASUs) issued by the FASB in 2023 and 2024, as well as those ASUs issued in prior years that become effective in 2024. For each pronouncement, we will identify the topic or topics affected, the most significant provisions, how the provisions affect financial reporting and disclosure, and, when possible, the reasons for the change. This will enable those associated with the GAAP financial statements of nonpublic entities to determine which pronouncements affect them or their clients, requiring further research. In the second segment, we will look at the most common financial statement elements that have changed in recent years. It will include an in-depth analysis that will demonstrate how these elements have traditionally been accounted for and how they have evolved, concluding with the current requirements for reporting and disclosing.