CPE Catalog & Events

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

The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Stay current on the latest accounting developments affecting not-for-profit organizations with this timely GAAP update. This course reviews recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline. The course also introduces the International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025. Participants will gain perspective on the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. This course is designed to help practitioners, financial leaders, and auditors of not-for-profit organizations understand both current GAAP requirements and emerging global developments shaping the future of nonprofit financial reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course is one of the courses dedicated to our Controllership Series. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we continue our discussion on inventory from segment one. This specific segment focuses on areas of inventory valuation, the types of physical inventory methods, and inventory fraud. These areas are critical for the controller to have a strong comprehension of and also participate in the development of policies and procedures.      

We all make predictions in our personal and professional lives. We base our decisions to marry, buy a house, launch a new product or hire staff on expectations about the future. In the past few years, research into improving predictions has advanced. We will look at this research and current best practices in forecasting to help us prepare better budgets and projections. 

Microsoft 365 is one of the most widely used business applications software suites used in business today. Microsoft Copilot is the generative AI application that is integrated directly into the Microsoft 365 ecosystem. If your firm or business is a Microsoft 365 user, this course will teach you how to use Copilot AI to optimize the use of your Microsoft 365 apps. This course will provide a comprehensive review and demonstration of how to put Microsoft Copilot AI to work for you and your clients. It is designed as a "hands-on" course that facilitates following along with the presenter to apply the features of Microsoft Copilot on your computer. Practice files will be provided so that you don't have to expose your confidential data. 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 will address recent legislation, rulings and developments affecting business taxpayers and provide practitioners with a comprehensive update for the upcoming tax season.   *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 course examines the critical issues and special opportunities facing partnerships and their partners, as well as the relationship between limited liability companies and partnerships, with a focus on reporting tax basis capital accounts.   *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    

Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports, and dashboards, and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports, and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease, and add a valuable credential to your portfolio. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for gathering and analyzing evidence and reporting the investigation results. Attendees will end the session with takeaways to immediately implement in future HR investigations. Three of three Episodes in the series.

This course is a continuation of discussion over Step One in the revenue recognition process of Identify the Contract. Specifically, this session delves further into the considerations surrounding contract modifications, change orders, unpriced change orders, cancelations, non-finalized changes and accounting treatment when a contract does not exist.

This is the beginning of a series that will cover major aspects of the Controllership function. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc., the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. A Controller is an individual who has responsibility for all accounting-related activities including high-level accounting, managerial counting, and finance activities within a company. The duties of a Controller include assisting with the preparation of the operating budgets, overseeing financial reporting, and performing essential duties relating to payroll. However, in today’s evolving world, the Controller function can provide much more in-depth value to their organizations. This series is dedicated to exploring the traditional Controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. In this first course we focus on the typical Controller function and begin to identify ways to elevate the function.  

If a great leader is someone we are willing to sacrifice for – what do those leaders do that makes us want to do more? Many of us work in dysfunctional organizations that want followers, but have no leaders that lead. What makes a leader effective? True leaders sacrifice, they are trustworthy and they empathize. We discuss the steps to take so you can become a true leader: including, integrity, humility, communication, self-control and self-awareness. With diligence, you can become a better leader and we will discuss how.  

This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial modeling.  From the beginning of the accounting process – ‘the chart of accounts’ to the end of the process – ‘the valuation of the company’, the budgeting cycle via a live case model to learn best practices common to successful companies.   This course stands on its own but is part two of a four part budget mastery series.

Collaboration remains one of today's hottest topics. Technology has fueled today's collaboration options, and work-from anywhere environments virtually demand collaboration platforms. In this session, you will learn today's best tools and practices to facilitate more effective collaboration in your organization. In this session, you will learn about today's mainstream collaboration platforms & Microsoft 365, Google Workspace, and Zoho - and how these options are similar and differ. You will also learn about other collaboration options, including Slack, Zoom, and Webex, and you can incorporate these tools into your collaboration environments. Further, you will learn about some of the best practices and procedures that must be in place to optimize your collaborative environments and experiences.

This course covers a broad range of topics involving uncertainty in accounting and auditing. It addresses accounting standards related to going concern, contingencies, guarantees, and credit losses, along with auditing standards applicable to auditing accounting estimates and evaluating going concern. The course provides a practical overview of how these areas are addressed under current standards and how they impact financial reporting and audit procedures. Jeff presents the material in an engaging manner to reinforce key concepts and maintain focus.

Some customers are unprofitable from an economic or time perspective – but many organizations do not differentiate or know the difference. When an organization has a unique, well-differentiated service or product, understanding value from the customer’s perspective becomes a crucial factor in profitable pricing. We must take the time to fully understand what our customers value - from the customer’s point of view. What is value? Why do brand, value, and customer focus matter? Developing a deep understanding of our customers is vital. Our most important customer might be someone we have not yet recognized. Understanding both external clients and internal stakeholders - including the evolving role of the finance department, is critical to long-term success. Using humorous video clips, memes, and vetted research, your understanding of customer bases will improve.

Nobody is immune to fraud risk. This course opens with stories of real fraud perpetrators then examines the similarities between the fraud perpetrators, discovering that they all have many common traits. It finishes with techniques accountants can use to deter these behaviors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course provides a focused analysis of the individual and small business provisions in Pub. L. 119-21 (H.R.1), "One Big Beautiful Bill." Tailored for tax professionals working with Form 1040 filers, the course explores impactful updates, from the no-tax-on-tips provision to enhanced bonus depreciation. Designed to inform planning strategies and compliance for the 2025 tax year and beyond. Participants will gain actionable insight into newly proposed deductions and expanded credits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In February 2016, FASB issued ASU 2016-02, Leases, which provides new guidelines that change the accounting for leasing arrangements. To be able to properly account for leases, financial professionals must understand ASU 2016-02 (also referred to as Topic 842). This guidance covers information on how leases should be accounted for. The previous leasing standard (ASC 840) had been in existence for almost 40 years. Under ASC Topic 842, lessors continue to classify leases as operating, direct financing, or sales-type. While lessees now classify leases as operating or financing leases. Previous guidance only required capital leases to be reflected on the BS. The new guidance requires all leases to be reflected on the BS. This is a major change for organizations and will cause their balance sheets to swell as leases must now be disclosed on the balance sheet. The standards original effective dates were prior to 2019. In April 2020, due to COVID-19, FASB voted to defer the effective date for ASC 842 for private companies and certain not-for-profit's for one year. For private companies and private not-for-profits, the leasing standard will be effective for fiscal years beginning after December 15, 2021, and interim periods within fiscal years beginning after December 15, 2022. For public companies the leasing standard is effective for fiscal years beginning after December 15, 2019, including interim periods within those fiscal years. The course covers elements of lease classification for both lessees and lessors. Also, numerous examples are incorporated as reference.