CPE Catalog & Events

Are you ready to unlock Excel's full potential? In today's fast-paced world, mastering Excel isn't just a nice-to-have-it';s a must for anyone who wants to work smarter, faster, and with greater accuracy. Make plans to participate in this dynamic, Excel-centric session designed for professionals like you. Discover how you can leverage features like templates, Precision as Displayed, and PivotTables along with new tools such as Dynamic Arrays, advanced data cleaning, PIVOTBY and GROUPBY functions, and seamless Copilot integration. These features will transform the how you and your team analyze data, automate reporting, and deliver actionable insights from Excel.

This program provides in-depth coverage of SAS 145, a major standard that helps auditors enhance risk assessment procedures through improved techniques for identifying and assessing risks of material misstatement. This session is essential for CPAs that perform audits. The discussion will also be insightful for auditees and other professionals who want to maintain awareness of current auditing guidance.

Effective CFOs and CPAs play a critical role in shaping and executing organizational strategy. This session focuses on how strategy is developed, why many strategic plans fail, and how finance leaders can help organizations create focus in an increasingly complex and fast-changing environment. Participants will explore competitive advantage, the use of financial and non-financial metrics, and the importance of aligning strategy with mission, culture, and resources. Through discussion and real-world case examples, attendees will gain practical tools to evaluate, measure, and support successful strategies across for-profit and nonprofit organizations. Use of some video reels will add levity to some of the key points.

For roughly 90% of American retirees, Social Security income will be the foundation of their retirement income. Yet, many are ill-prepared and lack understanding of the critical aspects of making an informed claiming decision. Further challenged to separate fact from fiction, consumers crave accurate information from knowledgeable professionals to make the most out of these coveted monthly benefits. This course dispels common myths about Social Security that lead to confusion and replaces them with the truth to an empowered retirement. Help your clients navigate their claiming age decisions with greater confidence, equipped with the essential truths they should consider before pushing the Social Security "on" button.

We are bombarded with information continually. So how do we determine what is valid and what isn't? This course points out common pitfalls inherent in data interpretation and gives practical tips to overcome those pitfalls by using real life examples. The course incorporates information from key thought leaders including Adam Grant, Alex Edmans, and Hans Rosling. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Peer review deficiencies and professional liability claims result from both audit and nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns for a wide variety of professional services offered by public accountants.

Targets can be a powerful catalyst for remarkable achievements - from landing humans on the moon to eradicating smallpox and repairing the ozone layer. However, poorly designed targets can have severe consequences, potentially leading to executive imprisonment, corporate collapse, or even loss of life. This course uses real-world examples and case studies to guide you through a practical, step-by-step process for crafting robust, effective, and credible targets for your organization. You'll learn how to harness the positive potential of targets whilst avoiding the pitfalls that can derail even the most well-intentioned performance initiatives.

This course is a comprehensive overview of critical Federal tax law updates resulting from changes to current laws, regulations and court cases impacting all business entity types, including S corporations, Partnerships, C corporations and Sole Proprietorships. We will also review recent modifications to tax forms, small business tax law and administrative updates, retirement plan changes and tax practice and procedures.

This comprehensive training is designed to get you quickly up to speed with the different types of Individual Retirement Accounts (IRAs). The cornerstone of the course is an in-depth coverage of the contribution and distribution rules to the Traditional, Roth, Simplified Employee Pension (SEP) and Savings Incentive Match Plan for Employees (SIMPLE) IRAs. The course will also discuss the basics of the Health Savings Account (HSA) as well as any newly enacted tax legislation related to IRAs.

This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of S-corporation taxation. The cornerstone of this course is the preparation of the Form 1120S using a fairly complex trial balance common to most S corporation 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 terri.storer@acpen.com  

This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Poorly handled conflicts can lead to break downs in communication, reduced morale, and higher turnover. However, when managed well, conflict has the potential to bring value to the organization and the team. Conflict is a costly and often mishandled occurrence in the workplace. Successful conflict resolution occurs by listening to and providing opportunities to meet each side needs, and adequately addressing their interests so that they are each satisfied with the outcome. In this you will learn the different conflict modes, how to choose the appropriate strategy for your situation, and how relationships impact your ability to promote the positive outcomes and minimize the negative outcomes of conflict.

The standard also requires information about the following categories:  disaggregation of revenue contract balances performance obligations This webinar will deal directly with disclosure requirements for the standard. Several courses currently exist on the platform related to an overview of the standard and deep dive into individual steps of the standards.   

Frequently, third parties may request certain financial and nonfinancial information to be verified by the external accountant (often referred to as ";comfort letters"). This course will provide insight into how to respond to requests for comfort in a way that will minimize professional liability risk. 

SAS 122, AU 240 requires that auditors determine if there is a significant risk that the financial statements are materially misstated due to either error of fraud.  This presentation is an overview of how to determine if there is a significant risk of a material risk; whether it is due to error or fraud; and what to do in designing your audit program to address such risk.  It’s important to know that without documentation as to such determination, an auditor has no basis for performing any specific audit procedure and thus would be performing a substandard audit.  The standards require that each procedure be designed to decrease the possibility of a material misstatement. This program is an overview of how an auditor determines if there is a risk of a material misstatement; how document such determination; and how to address the risk if it is due to error vs fraud, because there is a big difference.

Transform your data presentation skills with our comprehensive course on creating impactful dashboards and reports using Excel. This workshop is tailored for professionals who: Regularly produce or update dashboards and reports Struggle with confusing or overly complex reporting tools Seek to streamline varied reporting styles across their organization Aim to establish a consistent, replicable "house style" for reporting Want to impress stakeholders with clear, user-friendly data presentations Through a combination of theory and hands-on practice, you'll learn the fundamental principles that make reports and dashboards easy to understand. We'll distill these concepts into a set of practical rules and guide you through their application in Excel.

As part of the Tax Cuts and Jobs Act (TCJA), IRC § 199A was added.  This Internal Revenue Code section allows certain pass-through entities the ability to has made it deduct up to 20% of their qualified business. Although practitioners have had over three years of “experience” utilizing IRC § 100A, many practitioners still do not feel comfortable with this part of the Internal Revenue Code.  The purpose of this presentation is to provide the practitioner with an understanding of the rules of IRC § 199A as well as an understanding of the IRC § 199A regulations. **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.

There is always too much to do and too little time to do it all.  Fortunately, if you know the right ways to manage people, projects and your time, you can get on top of everything by working smarter.  In Part 2 of this seminar we will go into more depth about how to get more done in less time, as well as how to not burnout from all the work you do.  We will discuss additional methods for working smarter through technology, communication, stress reduction, and creating smart and helpful goals.

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 terri.storer@acpen.com