CPE Catalog & Events

This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data such as: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level. Although our focus will be on using Power Pivot, we will review some of the other Power BI Tools including: Power Query (Get & Transform), Power BI Desktop and Power BI Services (PowerBI.com). NOTE: If you want to apply the concepts presented, you will need Excel 2013, 2016 or 2019/Office 365 AND the Power Pivot add-in pre-installed. To see our full prerequisite recommendations, see PROGRAM CONTENT section below. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most 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.

Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using the ones that are already built into Excel? Then this class is for you! In this webinar, we will focus on Debugging and Troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn techniques to resolve issues when you receive errors. This session will also discuss the 9 built-in error checking options and demonstrate resolution techniques. We will also review techniques to resolve rounding errors. 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.

The Uniform Guidance identifies COSO and Green Book as best practices in internal control. This course will cover the background on COSO and its 2013 update. We’ll also review the application of COSO to Green Book. Attendees will learn how to leverage Part 6 of the Compliance Supplement for documentation of internal controls.

Although organizations are trying to create and manage diverse and inclusive workplaces, many are not aware of some of the best practices and simple strategies they can incorporate to promote such an environment. We are currently living in unprecedented times. Division, bias, and exclusion, based on factors associated with social injustice and a general lack of appreciation for diversity, seems to have become our current societal norm. With the high stress and anxiety created by these current trends in society, it is even more important for organizations to provide a safe space for their employees where there is a genuine sense of belonging and fair access to opportunity. The goal of this course is to outline the relationship between diversity and inclusion, while providing very practical strategies for HR Professionals in their role to promote a culture of diversity and inclusion in the workplace.  

Accounting and finance professionals have used different forms of automation over the years to improve the efficiency and accuracy of their work. So far, technology has not been able to replace the knowledge, experience, and decision-making of seasoned professionals. Times are rapidly changing. Today, systems easily exceed humans in accuracy and consistency. Artificial intelligence (AI) brings opportunities for accountants and finance professionals in the short term to improve efficiency and accuracy, while providing more value for businesses and customers alike. In the long term, AI will offer profound changes to how professionals work and process data. This course is designed to review where we are and where we are headed in the world of AI.

Part of one's duty as a CPA working in industry is to safeguard the assets of the organization. Cost cutting is one way to preserve assets and maintain a company's competitive position in the industry. However, what keeps us from ridding our organizations of unnecessary costs? In this course, we will look at the factors that prevent our companies from being as streamlined as they could be. By using statistics and survey data, we will attempt to show how to better negotiate and navigate budgeting and contracting decisions. We will also discuss financial statement analysis techniques, benchmarking, and cash flow management in an effort to better cut costs and maintain the long-run viability of an organization.

This course uses the lives of the rich and famous as a template to better understand the realm of estate planning. With stories ripped from the headlines, we will examine pitfalls and best practices. Did you know that Prince died without a will, opening the door for 45 people claiming to be his beneficiaries? Or that Michael Jackson was not careful in properly funding his trust, leading to delays and legal battles in the administration of his estate? Even Abraham Lincoln, it turns out, did not have a will. In discussing an array of celebrities, from Jackie Kennedy, Joan Rivers, Jimi Hendrix, and Whitney Houston to Aretha Franklin, Barry White, Leona Helmsley, and Florence Griffith Joyner, the course is designed as an enjoyable learning experience with tips for all levels of expertise. We may not have their fame or fortune, but we can certainly walk the red carpet when it comes to estate planning.

This course provides a high-level overview of the most important issues facing nonprofit entities and their auditors.  The focus of this course is on explaining the theory behind major issues and trends, enabling professionals to understand the most important aspects of relevant professional and regulatory standards related to reliable financial reporting for nonprofit entities.      

When federal prosecutors contemplate charges against business owners, two of their most potent and readily available tools include charges for mail fraud and wire fraud. The elements to convict for these crimes are clear: 1) The defendant devised or intended to devise a scheme or artifice to defraud, and, 2) in executing or attempting to execute the scheme, the defendant used or caused the use of mail or an interstate wire or wireless transmission. Mail, emails, cell phone calls, text messages, Internet transmissions, and even tweets could form the basis for charges of wire fraud or mail fraud. The crime of wire fraud is a reason that many business owners go to prison. In this course, we'll learn about a few people who've experienced a conviction for wire fraud. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Accountants are expected to demonstrate a questioning mindset. While such professional skepticism is an obvious requirement for assurance engagements, it is applicable elsewhere in the practice of public accounting. In fact, a skeptical mindset offers benefits to both public accountants and those who work in industry. This course provides specific examples of professional skepticism while suggesting best practices.

Creating Culture Benefits Your Organization It's important to dedicate time and resources in: Evaluating the company's current culture Communicating the company's values Creating processes and risk avoidance activities for a healthy corporate culture Prioritizing and monitoring risks This course will help you evaluate your organization's current culture, and teach you strategies for building a thriving corporate culture.

Tax rates, personal liability, operations – these are all factors to be weighed when advising clients about their choice of entity decision.  This session provides a comparison of the multiple entity choices to start the discussion with clients and selecting the best tax efficient option for them. **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.

Arthur Werner will provide financial professionals with the information their teams will need to successfully plan and execute mergers and acquisitions. For major topics covered, see below. This course may be customized or tailored based on the needs of your organization.

When asked, most people would say they are an ethical person. So why is it that every month there are reports of ethical breaches at major companies? The concept of ethics is easy to understand, easy to talk about, but incredibly hard to implement on a consistent basis. In this course, we will discuss current ethical issues, and walk-through a nine-step ethical decision-making model. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

Estate planning continues to evolve, and staying informed about the latest trends and strategies is crucial for professionals in the field. This forward-looking course delves into the intricacies of estate planning, with a specific focus on current issues. Participants will explore cutting-edge techniques, emerging legal considerations, and industry developments to ensure they are equipped with the knowledge and skills to create effective estate plans that withstand the test of time and safeguard their clients' legacies.  

Auditing Accounts Receivable - Focusing Procedures for Testing Existence and Valuation will explain tips and best practice techniques for auditing common accounts receivable risks, primarily focusing on existence and valuation. Accounts receivable tends to carry higher risk of material misstatement due to the complexity and subjectivity involved with initial recognition, subsequent measurement, and valuation. In addition, revenue recognition is presumed to be a significant fraud risk. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for auditing accounts receivable. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. This audit standard amends AU-C 315, making many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315.

Now more than ever, navigating loss, grief and crisis in the workplace is a skillset that leaders must possess. Keeping the heart in human resources is so important, especially in this post-pandemic state we are living in. We will explore ways that you can show empathy to your employees while also balancing your business needs.