CPE Catalog & Events

Depending on your version, Excel has over 500 functions already built in and ready to use. How many of those do you incorporate into your spreadsheets? After this course, you will learn some powerful functions that will take your calculating power to the next level. In this webinar, we will focus on Financial, Statistical and Math functions. In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. 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.

People all around the world are now working from home, including audit professionals. Despite the change in work environment, auditors are still expected to deliver the same level of services in an audit as they would if they were on-site and must continue to comply with audit standards. In a remote audit, auditors must integrate information and com munication with data analytics to assess the accuracy of financial data and the effectiveness of internal controls while gathering electronic evidence and interacting with clients...all in a virtual setting. This course will go over the basics to consider and explain the challenges and benefits of a remote audit. It will cover the latest standards and how auditors can continue to comply with those standards while doing the work from a distance using technology and thoughtful processes.

If you use Outlook to process your email, you are likely spending a substantial part of your day processing incoming email messages. This course is designed to show you a multitude of tips and tricks to reduce time spent processing emails. We will cover every feature available in Outlook to streamline and automate your email processing. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Professional Skepticism - Creating a Mindset for Finding Fraud and Error is a critical skill for audit and other attest services. The public places a high value on assurance services provided by an external public accountant, as the CPA's involvement directly enhances the degree of confidence intended users can place on the financial statements to make economic decisions. A proper mindset, including professional skepticism, is a critical feature of a high-quality audit or other attest service. Professional skepticism is an essential attitude that enhances the ability to identify and respond to conditions that may indicate possible material misstatement, whether due to fraud or error. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute. In this webinar, we will focus on Logical, Information and Lookup & Reference functions. In the Logical function section, you will learn to perform logical test 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 & Reference section, you will learn to use the various LOOKUP functions and INDIRECT function. 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.

Performance targets and incentives can drive breathtakingly positive results: the moon landings, the eradication of smallpox, or the repair of the ozone layer, for example. They can also have a dark side that can create stress, overload and anxiety and even drive lawbreaking. What is the difference between a healthy ‘stretch’ target and one pushes people too far? How can we spot potential problems in advance and systematically design sensible, humane and effective performance targets? Using practical examples and case studies, Bernie will give you an overview of the essential steps for designing robust, effective, and credible targets for any organization. Designing effective, practical and realistic performance targets will never be easy, but this session will introduce you to the tools that help make the process clearer, simpler and more consistent.

In this introductory course, you'll learn the fundamentals of integrating forensic data analytics into your anti-fraud risk management program. We will cover key definitions, use cases, methodologies and some of the leading innovations and techniques driving this ever-evolving field of "finding hidden money."

In this course, participants will learn about key trends and innovations impacting the field of forensic data analytics.  From generative AI to ChatGPT, machine learning and transaction review, data sharing consortiums and cryptocurrency trends, this course is for the futurist who wants to be leading edge in compliance and anti-fraud technology innovation. 

We see change every day, but we ignore it as a key risk. Even though change is natural, it is also natural for humans to fight it. Why do humans think we can control everything? What are the steps we can take to adapt to change? Learn more about how we can become better at recognizing change and how we can embrace and adapt to the many changes we see every day. Change is inevitable. We can adapt to it or be replaced. We will discuss practical insights that will help you be even more successful in the office and in life. Effective leaders should not miss this course. 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 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, as well an overview of K-2 and K-3 reporting requirements and effective dates. **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.

Running or advising a small business? KPI Bootcamp can help you quickly find and deploy the right KPIs to achieve your, or your client's, goals. Delivered by Bernie Smith, KPI specialist and overloaded small business owner, this course will help you quickly select a handful of powerful measures that apply to your business. The step-by-step approach helps you sharpen your objectives and select the right KPIs to drive growth and profit. Every one of the 412 included KPIs (as free PDF download for every participant) includes a full plain-English definition and also covers business benefits, case-study examples and practical tips.

How to properly account for and audit digital records is increasingly gathering importance as more entities have cryptocurrency and other digital assets on their financial statements. This course will address common questions, risks, and challenges evolving in this area. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Review of the major employment laws governing the workplace, when they are triggered, and key compliance aspects under each law. This presentation is designed to give viewers enough information to issue spot when matters arise in the workplace.   

Various legal tests are used to evaluate whether a worker should be classified as an employee or an independent contractor. There is no uniform standard or bright-line rule for determining whether an individual is properly classified as an independent contractor. Instead, the inquiry is always fact-intensive, and the analysis can vary based what body is performing it, i.e. the Internal Revenue Service (“IRS”), Department of Labor (“DOL”), various state agencies, or the courts. This presentation will review the various tests and highlight some of the common, most important factors for consideration.   

This course focuses on recent FASB updates with an emphasis on implications for private entities. We will also explore significant elements of the FASB’s technical agenda.

Did you know Excel has 400-500 functions depending on your version? Did you know there are 12 different function categories? Did you know you could create your own functions? After you attend this class, you will be in the know! In this webinar, we will focus on proofing and auditing your spreadsheets. You will learn how to build spreadsheets that validate the accuracy of your calculations and techniques to use the Data Validation feature to validate data entry. You will also learn techniques to cross-foot your data to ensure accuracy as well as how to use the various Excel Auditing Tools. 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.

In this course, we will explore the various types of data - both structured and unstructured - used in conducting fraud risk investigations and proactive monitoring. We will explore the various tools available on the market and techniques to confirm completeness and accuracy of the data before the analysis begins.  The course will cover the process for selecting the right data sources to align with the various risks as well as pitfalls to avoid when preparing the data for analysis. 

Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In this webinar, we will focus on Text functions and Date & Time functions. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date & Time function section, you will learn how to perform various date and time calculations. 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.

This program compares and contrasts the financial accounting for partnerships and LLCs, as well as discusses the tax accounting for these entities. It includes a thorough discussion of the important differences between financial accounting for partnership capital accounts and the tax accounting for partnership capital accounts. Financial accounting for operations of a partnership will also be addressed.

If you... - Produce or revise dashboards and reports - Find your current reports and dashboards confusing - Are frustrated by the length, complexity and structure of your existing reports - Have many different styles of dashboards and reports in use and want to simplify things - Need to create a consistent “house style” that can be replicated by different teams - Want to look like a star by creating reports and dashboards that your internal customers love ... this workshop can help. In this session we explore the principles of what makes reports and dashboards easy, or hard, to understand, distil this into a simple set of rules and show you how to apply these rules using Excel.