CPE + Events Catalog

Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.

This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities.  We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.

This program will examine the key provisions of the Inflation Reduction Act of 2022 that was enacted to not only curb inflation, but reduce the deficit, promote clean energy solutions, and much more.  Learn how this new legislation can provide tax savings for both your individual and business clients.  **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.

Explore the ethical principles included in the Code of Professional Conduct that address the emerging practice issues created by new technologies. Consider how technologies may impact audit quality and the integrity of the financial systems, and whether they create a need for CPAs to adjust their skill sets to address those challenges. Look at the potential ethical challenges created by the data related to privacy, security, and its application. Discuss the changes being proposed to address emerging ethics challenges. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Combatting today's cybercriminals takes everyone working together. The Internal Revenue Service works with state tax agencies and the tax industry to fight these 21st-century identity thieves. Unfortunately, data thefts at tax professionals' offices are on the rise. Online providers also must follow the six security and privacy standards in Publication 1345, Handbook for Authorized IRS e-file Providers of Individual Income Tax Returns. In addition, you fall under the PTIN and 4557 mandates if you prepare tax returns. Learn how to fulfill your obligations by participating in this session.

The final step in a tax controversy is Tax Court. Over 70% of all Tax Court cases are filed by taxpayers representing themselves. Most of these "pro se" taxpayers have a non-lawyer assisting them. There can be significant advantages to filing a Tax Court case to resolve a dispute. This class will explore these strategic uses of the Tax Court process and provide a basic understanding of navigating your client through the case.

Good writing is good business. Studies show that the average business worker receives 121 emails per day. That's a lot of emails. Are your emails effective? Are they being read? Are they professional and tone-smart? In this course, you will learn techniques and skills to get your emails to stand out and improve their effectiveness and professionalism.

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.

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.

Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. 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 start with a review of the impact of the 2024 Compliance Supplement on Single Audits, as well as, the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Fraud continues to plague businesses at epidemic levels, and technology control failures are a significant reason fraud occurs. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures contributing to fraud, and what you can do to mitigate fraud risk.A specific focus of this course is applying information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general and application control failures that contributed to each fraud. By learning through these real-world case studies, you will be positioned better to reduce fraud risk.

Security is not optional, and yesterday’s security techniques do not minimize today’s security threats. Therefore, now is the time for you to tune up what you know about protecting sensitive data. This program will teach you the latest tools and techniques for securing your data, including encryption, virus protection, safe communications, electronic signatures, secure authentication, and more. You will also learn how to implement a practical, five-step approach to securing your PC and the questions you should ask your staff to ensure server-based information remains protected. Security failures, such as a breach of client or customer data, are costly – they can even drive your company out of business. So, what security tools do you need, and how should you use them to secure your sensitive data and systems? Can you afford to risk attempting to manage today’s threats using yesterday’s techniques? Participate in this program to learn how to identify viable and practical solutions to mitigating today’s security threats.  

Isn’t it time you learned how to take advantage of critical features available in your Microsoft 365/Office 365 subscription? In this session, you will learn to use tools such as Teams, Planner, Power Automate, and others to enhance productivity and efficiency.

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 program provides in-depth coverage of SAS 145, a major standard that helps auditors enhance risk assessment procedures through improved techniques for identifying and assessing risks of material misstatement. This session is essential for CPAs that perform audits. The discussion will also be insightful for auditees and other professionals who want to maintain awareness of current auditing guidance.

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 addresses the most recent legislative developments impacting individual taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns.    **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.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

This course provides a concise overview of Google Sheets, a cloud-based spreadsheet application by Google. Similar to Excel, the tool allows users to enter numbers, apply formulas, prepare graphs, create charts, use pivot tables and more. While Excel is the default tool and industry standard for most accountants, Sheets has many underrated capabilities which are clearly superior to Excel. These include online collaboration, team communications, mobility, version control, revision history, cloud storage, translation, Google integration, and scores of third-party add-ons. You'll walk away knowing how to use a whole new array of spreadsheet features not found in Excel that can boost your analytical powers and accelerate your financial workflow. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.