CPE + Events Catalog

Over the years, Excel has added MANY new features and functionality, yet most people still use it the same way they first learned it. Many of the features were added to Excel to enhance your ability to create spreadsheets more efficiently and with more accuracy. However, if you aren't aware of these new features, how can you use them? This class will focus on walking through each ribbon (menu) to explain the capability of various features in Excel. It is a great overview for both new and advanced Excel users to make sure you know all the capabilities of Excel. You may have seen many of the features but had no idea what they could do for you. This class will help you to understand these features and determine how you might take advantage of their capabilities. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most 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 course explores the latest tax provisions impacting non-profit entities, including charities, hospitals, and universities, with a focus on common issues CPAs may face when completing their clients Form 990. **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.  

In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. 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 Section 199A deduction for flow-through entity income, including a review of the major provisions, forms reporting, and recent developments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Learn why creating an employer brand is so important and instrumental in competing in today's competitive marketplace. Elevate your recruiting experience for candidates and onboarding process for new hires to enhance your employer's brand.

Today’s economy and all of the digital enhancements have impacted the way companies engage with their customers as well as how the company manages their internal practices. The business control function needs to keep pace. The rising importance of analytical capability is critical when defining the role of the modern controller. Execution of analytics can vary but there are still key questions that must be asked. What are the options and what we need to understand to decide the best way forward? This course focuses on the value that can be brought by the Controller when becoming involved with data analytics powered by technology and also Big Data. The digitized world we live in has made it important for the Controller function to evolve and take on this advanced task.  

This course provides a high-level overview and introduction into the world of the forensic accountant. Most accountants have an understanding of the concept of fraud and how it impacts companies, but many individuals do not have a full comprehension of the variance in the work performed by a forensic accountant versus a typical management accountant.   This course is meant for those individuals interested in understanding the variances in the job tasks and responsibilities of forensic accountants versus typical financial or management accountants. Forensic accountants or auditors take a unique focus on performing their work.  Typically, when a person with forensic experience is called in to examine financial records, it is due to suspicion of fraud, evaluation of assets, or even to track down fundamentally incorrect accounting – intentional or not. As fraud continues to raise its head in business processes, forensic accountants are discovering new and unique ways to identify, examine, and support their hypotheses and investigative techniques.  The work performed by a forensic specialist can be interesting and full of potential potholes if evidence isn’t examined according to proper protocols and standards.  

This course provides a concise overview of the Dark Web, a part of the internet that isn't indexed by search engines, and is often associated with anonymous transactions and nefarious activities. Discover the leading threats and risks that the Dark Web poses to accounting firms. Explore how practitioners can effectively mitigate the risk of data breaches, ransomware attacks, financial fraud and other risks connected to the Dark Web. You'll walk away with a foundational understanding of leading cybersecurity strategies that can help you maintain client trust and protect your firm's sensitive data in this complex and ever-changing threat landscape. 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 revisits useful, but potentially underutilized, managerial accounting techniques. You will appreciate a fresh look at concepts you may not have considered since your college days. We will illustrate practical ways you can immediately implement managerial accounting analysis in your professional endeavors. 

This program addresses the critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions. **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.

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 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.  **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 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.

This course is one of the courses dedicated to our Controllership Series. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we continue our discussion on inventory from segment one. This specific segment focuses on areas of inventory valuation, the types of physical inventory methods, and inventory fraud. These areas are critical for the controller to have a strong comprehension of and also participate in the development of policies and procedures.      

SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. The audit standard amends AU-C 315, including many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315. Attendees will have an opportunity to evaluate the impact on audit methodology and documentation.

Award winning discussion leader Mark Hugh discusses both nexus basics and new developments in the dynamic, ever changing world of state income and sales tax nexus. This valuable course answers your frequently asked questions, reviews key factors in examining potential nexus consequences, takes a tour through the rules in states comprising 50% of the US, and identifies free, online multistate resources. 

Fraud is constantly in the news. Whether its employee retention credit mills, FTX, the City of Dixon, it appears like fraud is everywhere. We'll start this session with a review of the common fraud schemes as identified in the 2024 Report to the Nations. We'll also review the commonalities of fraudsters. We'll then look at methods of prevention. We'll close with a look at the auditor's responsibility for the consideration of fraud in AU-C 240.

Navigating the complexities of estate and trust administration is a vital skill for professionals, who play an integral role in the administration team. This comprehensive course is designed to equip professionals with a thorough understanding of their responsibilities and the processes involved in estate administration, enhancing their ability to address estate settlement issues effectively. Participants will be provided with a detailed overview of the professional’s role in estate and trust administration, emphasizing practical insights and strategies for managing assets, addressing the legitimacy of debts and creditors, and ensuring the proper distribution of assets. **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.

Looking to stay ahead in tax matters? Join our 2025 Individual Tax Update course for an essential deep dive into Form 1040 essentials. Designed for tax pros eager to sharpen their skills, this course unpacks recent tax code changes and equips you with the know-how to navigate them effortlessly. From mastering IRS Form 1040 to leveraging new tax benefits, you'll emerge ready to optimize returns for your clients while staying compliant with the latest regulations. Don't miss out on this opportunity to boost your expertise and ensure financial success for both you and 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.

Get ready to elevate your tax game with the 2025 Business Tax Update, designed exclusively for tax practitioners looking to sharpen their skills in business income taxation. This course doesn't just scratch the surface – it thoroughly explores the complexities of the tax code, ensuring you're equipped to navigate the ever-evolving tax landscape with confidence. From recent legislative updates to complex tax considerations like COVID-19-related subsidies, this course covers it all. Gain practical strategies and insights that you can immediately apply to assist your clients in optimizing their business income tax planning. Don't miss this opportunity to stay ahead in business taxation and enhance your expertise in a rapidly changing regulatory environment. With a focus on real-world application and comprehensive exploration of essential topics, the 2025 Business Tax Update promises to be a game-changer for your tax practice. Whether you're dealing with partnership, corporation, or LLC taxation issues, this course provides precise guidance tailored to diverse business clients. Plus, you'll gain invaluable insights into recent legislative changes, including their implications on tax code sections like Section 199A. Stay at the forefront of business taxation and ensure you're delivering top-notch advice to your clients by enrolling in this essential course today. **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.