CPE + Events Catalog

As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.  

Are you ready to maximize the utility of ChatGPT? If so, participate in this session so you can learn the best ways to leverage this tool.

This course is designed to provide learners with an understanding of the Internal Revenue Service (IRS) Cybersecurity Checklist and how it can be used to protect taxpayer data. The course will cover the basics of cybersecurity, including threats, risks, and vulnerabilities. Learners will be introduced to the IRS Cybersecurity Checklist, which provides a framework for organizations to assess and enhance their cybersecurity practices. The course will cover the various elements of the IRS Cybersecurity Checklist, including access control, data protection, and employee training. Learners will gain an understanding of the importance of each element and how it contributes to the overall security of taxpayer data. The course will also cover best practices for implementing each element of the IRS Cybersecurity Checklist. Throughout the course, learners will be presented with real-world examples of cybersecurity threats and breaches, highlighting the importance of effective cybersecurity practices. Learners will also be given practical exercises and assessments to reinforce their understanding of the IRS Cybersecurity Checklist. *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.

Generative AI use is growing, and ChatGPT is leading the way. But what exactly is ChatGPT, and how can it help you increase your productivity? Join us for a one-hour seminar on ChatGPT. We'll guide you through everything you need to know to get started You'll learn to use ChatGPT to: Streamline your workload Save time Boost efficiency Say goodbye to tedious data entry and hello to lightning-fast responses and analysis. As with any new technology, risks and ethical concerns must be considered. Our experts will delve into these topics and provide you with the knowledge and tools you need to use ChatGPT responsibly and effectively. Don't miss this opportunity to stay ahead of the curve and take your CPA game to the next level. Discover the amazing benefits of this groundbreaking technology.

AI is an extremely popular topic these days, and for good reason! However, does AI present yet another threat to your privacy? Get answers to this question and more in this session.

Small businesses have better options now than ever before in the market of accounting solutions. Participate in this session to learn more about these options and which might be best for you or your clients.

The first webcast of the series introduces the PivotTable feature and covers the basics.

This is part 1 of a 4 part series. The first session of the series introduces the PivotTable feature and covers the basics. We start here to ensure that all participants, regardless of previous PivotTable experience, have the skills needed for the remaining sessions. We discuss the four report layout areas, rows, columns, values, and filters. We then discuss how to update PivotTable reports and ensure that any new transactions appended to the data source are included in the report. We explore how to create monthly columns and how to properly format the values in a PivotTable.

AI is an extremely popular topic these days, and for good reason! However, does AI present yet another threat to your privacy? Get answers to this question and more in this session.

Business professionals can automate data collection processes by using today’s electronic forms. Learn about these tools and how to deploy them in this session.

In part 2 of this webcast series, we will compare formula-based reports with PivotTables.

This is part 2 of a 4 part series. This session begins by comparing the formula-based reports we built at the end of the Excel for Accounting Professionals series to PivotTables. We'll dig into the details between these two report types so that you are comfortable applying them to specific workbooks. In this webcast, we create two versions of many reports, one version with formulas and the other with PivotTables. With this interactive practice, you will be comfortable replacing formula-based reports with PivotTables when appropriate.

Does a business have nexus in a particular jurisdiction? At the current rate of change, you can't afford to have out-of-date knowledge of this critical tax area.

Multistate taxation has never been a more relevant topic. This course helps professionals skillfully navigate the maze of multistate corporate tax codes.. Be the one to guide your client skillfully through the maze of multistate corporate tax codes. Rapidly develop a working knowledge of both multistate tax compliance and related planning opportunities.

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.

First-time supervisors face unique challenges as they transition to management. They must supervise work with which they may be unfamiliar, and supervise employees with whom they had previously been co-workers or employees with greater seniority. They must understand the extent of responsibility and decision-making authority they have, finding ways to communicate expectations to their employees and making possibly unpopular decisions. Excellence in technical or financial skills does not automatically translate to excellence in leading and supervising others. This course will give new supervisors, managers, and leaders the skills and understanding needed to successfully navigate the transition.

Governmental entities are the second largest victims of embezzlement.  This seminar examines recent events involving the theft of public money and the circumstances that allowed the fraud to occur.  We will be looking at a variety of case studies to illustrate these points.  

In the course of legal actions, payments may be made pursuant to a final disposition of a court case or a mutually agreed-upon settlement.  This course will cover the tax implications for payments made for personal injury, emotional distress, lost wages, punitive awards, pre- and post-judgement interest, contract claims, among other damages. **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.

Understanding the dynamics of family interaction is one of the most important skills in helping a family business succeed. This course takes a candid look inside the family business, and will help the participant navigate delicate issues while learning to provide counsel that will grow - or protect - the family business and non-family staff.

This session will provide a basic overview of Employee Stock Ownership Plans (“ESOPs”). It will specifically address what companies are well suited for establishing an ESOP, how ESOPs are implemented, and how employees and departing owners alike can benefit from them. The session is intended to provide business and tax advisors with talking points about how an ESOP may be used as a succession planning strategy.