CPE Catalog & Events

Improve efficiency with these powerful functions (bold) Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. In this webcast, we will focus on the Logical, Information and Lookup and Reference functions. -In the Logical function section, you will learn to perform logical tests using the IF function along with AND, OR and NOT. -In the Information function section, you will learn various ERROR checking functions that can be combined with the Logical functions. -In the Lookup and Reference section, you will learn to use the various LOOKUP functions and the INDIRECT function. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute. Regardless of the version you are using, ALL concepts covered in this webcast apply to ALL versions of Excel.

Today's businesses have seen a dramatic increase in the use of outsourced providers to assist with executing processes from payroll, accounts payable, information technology, benefit plan administration and many other core processes. These processes ultimately have an impact on an organization's internal control over financial reporting but also could impact compliance and operational issues In 2011, the Statement on Standards for Attestation Engagements (SSAE) 16 replaced the former Statement on Auditing Standards (SAS) 70. In May 2017, a new standard, SSAE 18, superseded SSAE 16 The concepts covered in this course are referred to as a Service Organization Control Report (SOC). Organizations who utilize outsourced providers should understand the various types of SOC reports, their intended use and their implication on a company's financial reporting process, regardless of your status as a publicly traded or privately held organization.  The process can be complicated to understand as a user organization. Currently, several types of SOC Reports exist including: SOC 1 - Type 1 SOC 1 - Type 2 SOC 2 - Type 1 SOC 2 - Type 2 SOC 3 Cybersecurity SOC This course speaks briefly to the transition from SAS 70 to SSAE 16 and now SSAE 18.  However, the focus is on the various Service Organization Control Reports, their purposes and uses

It takes a while for advisors to gain an in-depth understanding of all the changes made to the tax laws that govern IRAs. This course focuses on the top 20 advisor questions about SECURE Act 1.0, SECURE Act 2.0, and other hot topics. The objective is to help the advisor ask the right probing questions when interacting with clients and to provide clients with responses based on their IRA profiles.

One of the important roles of any member of the financial team. Including the controller, may be involvement in the preparation of the company’s financial statements. Even if that responsibility falls within the office of the CFO, the controller and other finance personnel must understand how their transitions recorded impact the financial statements. Financial statements (or financial reports) are formal records of the financial activities and position of a business, person, or other entity. Relevant financial information is presented in a structured manner and in a form which is easy to understand. They typically include four basic financial statements accompanied by a management discussion and analysis: A balance sheet or statement of financial position reports on a company's assets, liabilities and owners’ equity at a given point in time. An income statement may have varying names including profit and loss report (P&L report), statement of comprehensive income, or statement of revenue & expenses. These report on a company's income, expenses, and profits over a stated period. A profit and loss statement provides information on the operation of the enterprise. These include sales and the various expenses incurred during the stated period. A statement of changes in equity or “statement of equity” also called “statement of retained earnings” reports on the changes in equity of the company over a stated period. A cash flow statement reports on a company's cash flow, particularly its operating, investing and financing activities over a stated period. A balance sheet represents a single point in time, where the income statement, the statement of changes in equity, and the cash flow statement each represent activities over a stated period. For large corporations, these statements may be complex and may include an extensive set of footnotes to the financial statements, management discussion and analysis and supplementary information. The notes typically describe each item on the balance sheet, income statement and cash flow statement in further detail. Notes to financial statements are considered an integral part of the financial statements.  

This course provides a comprehensive overview of the ELI5 (Explain Like I'm 5) approach and its application in the accounting profession using ChatGPT, an advanced language model. Discover how to simplify complex financial information and tax regulations using this innovative approach. Explore how practitioners can effectively communicate intricate topics to their clients to add value and build trust. You'll walk away with a foundational understanding of the ELI5 approach and how to use ChatGPT to improve your communication strategies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The procurement function is a critical area of organizations where spend is a top priority. The Controllership function is involved in spend management. It is logical that the Controller should take a role in working with the procurement function. The procurement function may report to various areas within an organization including the Chief Operating Officer (COO), Chief Procurement Officer (CPO), Chief Executive Officer (CEO) and the Chief Financial (CFO) or Accounting Officer (CAO). Regardless of the reporting line of the function, the accounting and controllership functions must have an integral understanding of all processes involved within procurement. This understanding assists the controller and accounting area in properly optimizing and controlling costs associated with the process.  

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session will cover: Avoiding Budget People Issues:  Managing Budgeting’s Soft Side •    Financial plans have a technical component and human component.  We can resolve some of our budget issues by exploring the process’ human aspect.  This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create to a better plan.  

This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many organizations struggle to keep budgets current in an ever-changing business climate.  Twenty-first century performance metrics focus on determining what budgets should be rather than what they were in the past.  Using performance metrics effectively reduces work, reduces politics, provides flexibility and substantially improves the performance management process.  This session will show you powerful techniques to drive your organization’s performance.

In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Whether you are responsible for managing 1 employee or 20, your leadership can make or break your team. Learn practical leadership strategies that you can implement when you return to your office. In today’s competitive market, it’s more imperative than ever that as leaders we are inspiring and motivating our teams to success.  

Today's savvy executives use LinkedIn to accelerate hiring, as well as, to promote employee retention and engagement. This interactive session is for the financial executive who is actively growing and nurturing a team or company and wants to leverage LinkedIn, which is the best digital resource available. Join us for this powerful webinar and unlock the full potential of LinkedIn as your HR secret weapon for recruiting top talent, retaining your best employees, and elevating overall team engagement. 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.  

You are likely familiar with strategies for removing the Trust Fund Recovery Penalty (TFRP) or brokering an installment agreement with a Revenue Officer or ACS Representative, but what should you do and when? What happens when things break down? Who should you contact and when? This topic will help guide practitioners on getting around certain obstacles or roadblocks while working cases with the IRS. This includes best practices for contesting the TFRP, who to contact and how to prepare when negotiating installment agreements, and steps to elevate cases that are seemingly going nowhere. 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 will examine certain qualities a leader must exhibit to set an ethical tone from the top.

Numbers and especially the digits within those numbers can conceal a lot of information.  Benford's Law and other digital analysis techniques can be the keys to unlocking that information.  This session will explain what Benford's Law is, how it works, and how it can be used to reveal bogus information and made-up data.  Accountants and auditors should understand how to use this valuable audit tool as well as other digital analysis techniques.  But, if you attend this session, you must promise not to reveal the secret behind these techniques to any fraud perpetrators.

Most business professionals have used Excel for years, often without the benefit of any formal training. Thus, they don't know about key features in the application and, therefore, don't use them. Of course, this leads to inefficiencies and errors. Isn't it time to stop this madness? This session is for you if you're ready to become more efficient and effective with Excel! You will learn ten critical features that can help you get more work done in less time and improve your accuracy. We encourage you to make plans to join us for this session to learn the best ways of working with Excel!

It is virtually impossible to pick up the daily newspaper and not find an article on some type of fraudulent event. In the wake of the “Era of Fraud, Waste and Excess,” one might suspect that potential fraudsters would think twice before committing illegal acts. However, just the opposite seems to be the case.  Is there really more fraud or is there simply more fraud awareness?  The harsh reality is that it is a little bit of each.  Not only has fraud worldwide reached a level of over $7.0 billion in lost  revenue but savvy C-level executives now realize that it could happen to their companies—very easily. When you put these facts together, it adds up to a completely new era of vigilance.

In today's dynamic economic landscape, staying ahead with effective fringe benefit planning is more critical than ever for both businesses and individual clients. With evolving tax laws and shifting market dynamics, understanding the intricacies of fringe benefit planning is essential to ensure financial well-being and compliance. This course offers a comprehensive overview of essential tools and techniques tailored for financial professionals, allowing them to navigate the complexities of fringe benefit planning with confidence and precision. By attending this course, practitioners will gain invaluable insights into various planning tools and techniques essential for meeting fringe benefit planning objectives. From mastering the subtleties of employee benefit planning, including ERISA reporting and disclosure requirements, to unraveling the complexities of IRC §132 fringe benefit options, attendees will enhance their expertise to deliver superior advisory services. The curriculum also delves into the practical aspects of cafeteria plans, flexible spending accounts, group term life insurance plans, and strategies for financing retiree medical benefits, among others. With a focus on practical application and real-world scenarios, this course equips participants to tackle fringe benefit planning challenges head-on, providing them with the tools and knowledge needed to optimize benefits for both business and personal needs, now and in the future. **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.

In the world of work today, nothing is more critical than Culture.  If people are your competitive advantage, then culture is the best way to help your people realize a great destination. While many leaders and companies talk a lot about culture, few take the time to really plan, build, and invest in a great culture. Today, the world of work could not be more challenging, and the changes that we are seeing in the workforce, such as the rise of remote workers and increasing turnover, are adding to the complexity. Now more than ever, Culture must become your competitive advantage. In this course, you will learn about the key macro changes in the workforce and what some leading companies and leaders are doing to create amazing cultures and high-performing organizations. From LinkedIn to Patagonia to Eventbrite, you will learn from some top organizations ow they have successfully leveraged culture. You will learn what Culture is and can be, and you will learn what culture is not. As you set sail in 2024 and beyond as a leader, you will benefit from this class and learn how to make culture your competitive advantage. Your teacher for the class is Steve Cadigan, whom many credit for being the architect of LinkedIn's world-class and groundbreaking culture.