CPE Catalog & Events

This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This webcast is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analysis an easy task for all accountants. You will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. Explore the other webcasts in the Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Create Excel Dashboards for Maximum Impact Power BI - Use Power Query to Transform Your Data Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com

Auditing Inventory - Performing Required Observations and Other Common Procedures will primarily focus on performing the inventory observation, while introducing other risk concepts related to inventory. Assets classified as inventory varies widely with the nature of the entity and industry. Depending on the complexity of the inventory and the related pricing model, risk of material misstatement will vary widely as well. 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 inventory. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Planning may be one of the most important assignments of the finance professional; however, it is often accomplished in a way that can harm the organization. In many cases, huge sums are spent only to have a planning document developed that does not serve to bring the company together, but rather causes internal division. In some situations the budget can actually harm both productivity and alignment. This course is designed to bring planning, budgeting, and forecasting together into one fully aligned process that is easier, more efficient, and fully engages all parts of the organization. Rather than the plan being owned by the finance department, it is owned and followed by everyone from the CEO to the entry-level employee.

Are you familiar with the five workbook design principles that help us build reliable recurring-use workbooks? This session covers them, as well as workbook and worksheet organization ideas. We also discuss how, why and when to hide administrative worksheets. The importance of highlighting input cells, using selection groups and building formulas with nested functions are also explored. 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 webcast, 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.

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.

Ethical behavior is not a destination it is a journey with twists, turns, and bumps in the road. We are faced with ethical dilemmas every day. Do I speed to make it to a meeting? Do I call in sick because I need a break? When does "helping my child with their homework" become "doing it for them"? CPAs are ethical most of the time, but staying ethical is hard. It gets harder when we are under stress. 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 explore significant elements of the FASB's technical agenda, focusing on recent updates to revenue recognition and lease accounting standards. A Special Purpose Framework overview will be provided, which may reveal salient alternatives to U.S. GAAP for certain entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Are you running around with a fire extinguisher permanently strapped to your back? Do everyday crises run your life, both at work and at home? Do you find yourself consistently taking care of everyone else with no time left to take care of you? In this session, we dive into controlling your chaos and managing your energy. Make no mistake, this isn't your father's time management class. It’s an energy management class developed on behalf of and with tired, frustrated, and burned out HR professionals like yourselves! If you find yourself drained and drinking far too much coffee, this is the session for you!

Emerging from the pandemic is a workplace culture governed by values. Far from a soft approach, it can drive significant business results. Organizations that embrace an empathetic culture increase performance and decrease turnover, while their customers report a more positive experience. Additionally, being more “person-focused” strongly correlates with more effective ethics and compliance programs. These insights can provide a roadmap for the "new normal" as the world emerges from the crisis. How employees and management move forward from this experience will shape the workplace for decades to come.

ProActive Response Group's Active Shooter Response Training course educates participants in current trends of active shooter incidents, how to recognize early warning signs of violence, appropriate actions to increase chances of survival in an active shooter event, and how to use basic medical equipment to save the lives of victims.   *****(Warning: This video contains simulated graphic scenes that some viewers may find disturbing)*****

This course provides an in-depth exploration of Form 1120S, the tax return form used by S corporations. Students will learn the intricacies of preparing and analyzing this form, including how to determine the taxable income of the S corporation, how to properly report and allocate income, deductions, and credits, and how to calculate the shareholder's basis in the S corporation. **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.

This course corresponds to our Controllership series. This course 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 discuss the area of cash and investments and explore how the controller can move these responsibilities into more of a strategic role. In today’s world, the role of cash management is often a pivotal role in the organization. In economically difficult times, controllers may find that they spend a great deal of their time on understanding and managing the organizations' cash position. This is certainly important and, in some areas, can be seen as a staple of the lifeblood of the organization’s ongoing viability. This course takes a look at some of the typical objectives involved in Cash management and then evaluates how those objectives can be further stretched into strategic pillars of the organization.   

Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect.

An audit is an investment in reliable financial reporting and compliance, and an increased return on those dollars can be achieved by hiring the right auditors. This course will provide key factors for you to consider when evaluating whether you are getting the most quality and insight from your auditors, to enable them to perform the most value-added audit possible in the given circumstances - while retaining the trust of a CPA. 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 a continuation of our series on preparing to become a forensic accountant. Within this segment we focus on elements of computer forensics. This session is designed to delve into further investigative procedures used in computer forensics.  

The course provides general information on how to identify money laundering activities during the conduct of normal tax audits. Discover key resources and tools available for effective detection and deterrence. Explore the impact of money laundering on ethical decision-making, and how examiners and auditors can assist criminal investigators in countering money laundering. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures, and address challenges within the year. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

These are uncertain times. With constant economic fluctuation, geopolitical uncertainty and inflation pressures, corporations and their professionals are facing challenges at every turn. The Controllership function is accustomed to dealing with changing variables but when the change is constant and every evolving, even the simplest of tasks like cash flow and cash forecasting can become difficult.  This webinar is to focus on what methods the controller can elicit to attempt to address the current uncertainty when working with their cash flow issues and forecasting. Of course, there are basic measures that can be employed such as: Proactively managing receivables and payables Automate your accounts payable and receivables process Keep business expenses at a minimum Work with digital methods of payment from vendors Use credit wisely However, this webinar will explore methods used to create and manage your cash flow and forecasting processes. These methods go one-step past your typical forecasting to enable management to explore various alternatives and scenarios for the business.

Are you frustrated with sending emails back and forth to try and agree on a simple meeting time? If you use Microsoft 365 Outlook, you will want to attend this short course to learn everything you need to know to setup your Microsoft 365 Bookings App to streamline appointment setting. This easy-to-use app lets you provide your meeting guests with a link to a private web page that allows them to view your availability and use self-service to book the meeting in your Outlook calendar and their calendar app. The Booking app is totally integrated with the Outlook calendar, so your availability to schedule a meeting is always completely up to date for your guests to book an appointment based on your availability. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session opens with conditional summing. If you have not explored conditional summing yet, you are in for a surprise. Conditional summing is a game changer and will absolutely improve efficiency in your reporting workbooks. We then move to removing duplicates to create a list of unique report labels. We conclude with lookup basics. We discuss why we prefer lookups to direct cell references and explore the details of the most popular lookup function, VLOOKUP. 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.