CPE Catalog & Events

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.

Social media - it's a buzzword, but is it beneficial for your firm's brand? And more importantly, your bottom line? This course focuses on the latter and takes a deep dive into which social media platforms are best for accounting firm lead generation, recruitment, client retention and more. Attendees will take away a practical framework and actionable tactics for integrating social media into your firm's overall marketing and communications strategy to help you grow your revenue without having to spend hours on social media or even be on it personally if you don't wish to! This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.

Selecting the right KPIs for your organization can be complex and stressful. Rather than resorting to brainstorming and internet searches, there is a better way to discover the best KPIs for your organization - the ROKS method. In this session Bernie Smith, creator of the ROKS method, walks you through the first five steps of this powerful approach, using real-world stories to bring each step to life.  

What obligations does an employer have when an employee needs to take a leave of absence? This presentation will provide an overview of the complicated, intertwined compliance obligations triggered when an employee requests a medical leave of absence (including for pregnancy, mental health, or addiction).  

This session explores managerial accounting techniques with an emphasis on internal decision-making tools. You will appreciate a reminder regarding concepts you may not have considered since your college days. We will revisit managerial accounting concepts by illustrating practical examples that you can immediately bring back to the office!