CPE Catalog & Events

The COVID pandemic changed the way many people worked, yet others have had remote teams for decades and little changed.  Many organizations trying to bring people back to the office have experienced significant turnover.  Some practices have changed forever while some principles will always remain the same.  Keeping your people happy equals keeping your best people.  Learn the changes you should make now and the things you should do forever!

This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **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.

Ethics involve relationship to self, others, and the world in which we live. In the busyness of our world we often act out of habit without realizing that what we do truly matters. We matter! This session explores ethical values and principles as they apply to creating an Ethic of Care in the workplace with specific emphasis on compassion, accountability and respect. 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 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.

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.

Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. 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 will address the important provisions, rules and concepts related to business tax 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.

Small business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.

The insurance industry has unique accounting and regulatory requirements. This course provides an introduction to those unique requirements, including the multiple layers of regulation, statutory vs. GAAP accounting, non-admitted assets, special treatment of taxes, and more! 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 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.

You spent your life building retirement savings.  Now you want to make sure your savings last the rest of your life and perhaps pass some on to the next generation.  Come hear a veteran financial educator talk about money management and planning issues for this phase of your life.  

Our session will include a discussion regarding indirect rate strategies for cost recovery.  We will cover negotiating indirect rates with pass-through entities and alternative indirect cost recovery methods. A look at applying the PPP Loan Forgiveness credit.  Understanding the definition of sub-awards and the MTDC allocation base, and where best  to allocate bonus expense.  Included in this session will be a selected review of the Uniform Guidance FAQs regarding indirect rates for States and Municipalities, as well as recently issued FAQs that impact indirect rates and cost recovery.  

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 subscription includes eight individual sessions for a total of 16 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the eight courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This subscription consists of a 16-hour audit skills curriculum for beginning auditors and attest providers, while it is also appropriate for anyone who has assurance responsibilities under the SSARS. This series covers the fundamentals of auditing, including internal controls, auditing cash, and discovering fraud.

*** This subscription includes eight individual sessions for a total of 16 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the eight courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This subscription consists of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has audit or attest engagement responsibilities. This series covers intermediate audit skills, internal controls, and analytical procedures.

*** This subscription includes eight individual sessions for a total of 16 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the eight courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This subscription consists of a 16-hour audit skills curriculum for supervisory and managerial auditors, while it is also appropriate for anyone who has responsibilities by finding creative audit solutions. This series covers critical audit skills including fraud trends, designing internal controls, as well as management skills for coaching staff on conducting thorough audits.

*** This subscription includes eight individual sessions for a total of 16 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the eight courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This subscription consists of a 16-hour audit skills curriculum for experienced staff, while it is also appropriate for anyone who has the need to better understand how to link risk assessments to the detailed audit plan. This series covers common risks, as well as analytical procedures, sampling, and proper reporting methods during an audit.

How to pay for the cost of long-term care remains a primary concern for most clients over the age of 50. Explore clients' motivations, misconceptions and objections to purchasing long-term care insurance, and a look at the latest long-term care solutions, including hybrids. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.