CPE Catalog & Events

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.

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.

Governmental Accounting 101, is a 2 hour webcast that takes the participant of a whirlwind tour of governmental accounting basics, focusing on wetting the participant’s appetite for more.  This session will be the first of a series of webcasts, with each subsequent webcast delving deeper and deeper into the governmental accounting basics. 

Did you know that simply by utilizing the built-in headings found under Styles in Microsoft Word you can create an automatic table of contents that can be updated in a matter of seconds if the body of the document changes? Did you know that Word can be used to open, edit, and re-save PDF documents? How about the fact that by using the Insert Caption tool in conjunction with the Cross-Reference feature, users can rid themselves of the need to manually renumber figures, tables or illustrations and will not even need to update references to these in the document text? This material shows tools and features that are easy to understand and use, will save time, and add consistency to documents. Participants in this session will come away knowing the power of Microsoft Word; this knowledge will benefit them greatly! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

Introductory Session of Borenstein's Form 990 Foundational Series: This "initiation and introduction to" the Form 990's mechanics and importance will prevent you from drowning in the Form 990's force-field! More than 80% of the Form's inputs and relevant definitions are NOT found in the statutes and Regulations that apply to the exempt sector, a reality that can be overwhelming for both novices and more advanced preparers. This session provides an easy-to-digest synopsis of the entirety of the Form's key definitions as well as the mechanics that preparers need embrace from the moment they first approach preparing a 990. Packed with practical tips and perspectives on data gathering, this class is a "must" gateway for beginning (and even more experienced) preparers to learn "how to befriend Form 990 preparation." This webinar will vault preparers past all the initially confounding problems of the Form 990, providing baseline info on the critical nuances the form uses. 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 provides a comprehensive overview of the ELI5 (Explain Like I'm 5) approach and its application in the accounting profession using ChatGPT, an advanced language model. Discover how to simplify complex financial information and tax regulations using this innovative approach. Explore how practitioners can effectively communicate intricate topics to their clients to add value and build trust. You'll walk away with a foundational understanding of the ELI5 approach and how to use ChatGPT to improve your communication strategies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This hands-on workshop offers an analytical approach for designing, executing, and communicating results of a comprehensive financial statement analysis. We will explore numerous techniques and approaches that facilitate in-depth financial statement analysis. Accountants in public practice will obtain insight regarding analytical procedures, additional client services, and enhanced compliance with professional standards. Accountants in private enterprises will develop more robust techniques for understanding their organization’s financial statements to facilitate forward-thinking decisions and communication to internal and external stakeholders.

Tax planning is more than an estimated tax calculation, it's a process.  Where are we now and what can we change?  This timely program will highlight significant 2022-23 tax developments and discuss key tax planning ideas for your clients as you prepare for the upcoming tax season. Don’t wait until late December to start planning for your 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.

This course will provide an overview of 6 key areas of automation that accounting firms can leverage to effectively increase their lead generation and client retention efforts while reducing the burden on their time and budget. These areas include: 1. Social media 2. Content development. 3. Email marketing. 4. Text (SMS) marketing. 5. Chatbots and other interactive AI tools. 6. Drip marketing campaigns. Attendees will receive a practical guide to the technologies and tactics needed to improve marketing efforts with efficiency and ease! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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 CPE course provides an examination of the recent reports from a selection of Single Audit results. The instructor will go over the most common deficiencies found in Yellow Book and Single Audits and common peer review findings and OIG investigations. This course will also provide examples of common controls, best practices, and mitigation techniques. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Managerial accounting provides economic and financial information for managers and other internal users. Managerial and Financial Accounting have similarities and differences. Each field of accounting deals with the economic events of a business. Both managerial and financial accounting require that a company’s economic events be quantified and communicated to interested parties. This another course in our series on the controller’s role. The controller’s role encompasses many traditional functions. Within this segment of our controllership series, we discuss the area of managerial accounting and the basic concepts that surround this discipline as it primarily relates to cost accounting issues.  

Your home is now the digital center of your world, and even if you go to an office every day, you have more options to help you manage everything from shopping lists to email accounts. Unfortunately, many new devices your family connects to your WiFi can create security risks and may make remote work and school less secure. For example, tracking devices and services can help parents monitor children and seniors, but outsiders can use the same tools to stalk their loved ones digitally. This session will help you learn about devices, services, and app suites for families, share files, organize photos, manage passwords, and keep your home secure. Attend this breakout and learn about innovative new tools to help you stay safe and make the most of your time away from the office.

A project doesn't just happen, it takes a dedicated person to help a team create something from nothing. The best project managers incorporate the art of people management and science of execution to guide an initiative from an idea to reality. Not everyone can hire a project manager, so the great news is these skills and techniques can be learned. This class will show how a project manager breaks down a concept and applies techniques needed to effectively lead a team through the visioning, scoping, testing and rolling out of an initiative. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Navigating the challenges of estate and gift taxation can be overwhelming for practitioners, especially those lacking extensive experience in this field. In this comprehensive course, participants will undergo a practical exploration through the preparation of the Federal Forms 706 and 709 - line by line. Through hands-on instruction, attendees will gain invaluable insights into the complexities of tax compliance, equipping them with the skills and confidence needed to seamlessly integrate estate and gift tax preparation into their practice. With a focus on practical application, this course offers participants a unique opportunity to master the preparation of crucial tax returns, enhancing their professional expertise and strengthening client service offerings. From a detailed overview of the Federal Forms 706 and 709 to insights on complying with "Portability" and navigating postmortem estate planning issues, attendees will emerge with a newfound proficiency in estate and gift tax preparation, ready to excel in their practice. **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.

Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The QuickBooks platform is robust with features and capabilities that many users are unaware of or do not know how to utilize effectively. This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues even experienced QuickBooks users struggle with, such as locking down prior periods. This program starts fast with a chapter covering the top issues accountants face with QuickBooks. Then, the day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues like setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features. Also, you will learn how to lock down transactions in prior periods, use the audit trail, customize reports, export reports to Excel, and extend QuickBooks' usefulness with tools such as the Fixed Asset Manager and Loan Manager.

This course is designed for accountants in public practice and industry who focus on nonprofit and governmental entities. We will cover the basics needed to understand what makes nonprofit and governmental accounting & auditing unique. The course starts with the key financial reporting differences for governmental and nonprofit entities and then switches focus to review the fundamentals of Yellow Book and Uniform Guidance audits. This foundational course is perfect for those getting started in the nonprofit and governmental arena and those looking for a refresher. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Also, as many 401(k) plan administrators opt for ERISA Section 103(a)(3)(C) audits, audits of 401(k) plans will be significantly impacted by the now-effective SAS 136, the AICPA's new employee benefit plan auditing standard. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements of SAS 136 through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.