CPE & Event Calendar

This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. 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 taxpayers incurring research and experimentation costs. Emphasis will be placed on compliance with the 2022 change in Section 174 Amortization of research and experimental expenditures. 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 addresses the most recent legislative developments impacting business 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.

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.

Sustainability Accounting is now a recognized professional skill of increasing importance in larger organizations. It is the process of finding, measuring and managing the material metrics for sustainable performance and risk management. The goal is to bring these metrics into regular financial statements so leaders can act on them.  This course teaches Sustainability Accounting basics with example from the restaurant industry.   It is suitable for any professional or student who wants to learn fast about sustainability issues in specific industry sectors and how to integrate sustainability metrics into financial accounting and reporting.

In 2020, 96% of the world’s largest 250 companies published reports on their sustainability performance in accordance with national and international standards.   Now many more companies are committing to sustainability, and Net Zero emissions in particular.   This creates a new responsibility and opportunity for HR leaders.   Staff must be trained in new policies, goals and procedures.  Executives need help as leaders in this new approach.  This one-hour course summarizes SHRM research into HR and sustainability, plus other expert sources and the instructor's own 30-year journey helping companies become more sustainable.   The course presents key concepts, tools and sources to help HR find its role.

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

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.

This course focuses on how to integrate independence and avoid conflicts of interest in situations accounting professionals face daily. Participants will be able to know not just what is the right thing to do according to the AICPA Code of Professional Conduct, but how to put values into action. As part of this course, we also walk through real-world examples of individuals and companies faced with these dilemmas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

When you're working with clients, it's not always smooth sailing (though we wish it was). Often we need to have difficult conversations. Whether it's to overcome objections, negotiate a new contract, or manage a conflict, these conversations can be navigated successfully with the right tools. This workshop gives you those tools and an understanding how how the human mind works when it comes to processing communication in difficult situations.

Audit Risk Assessment in Plain English, is a 2 hour webcast highlighting the AICPA’s clarified risk assessment standards, along with a new Statement on Auditing Standard (SAS 145) related to understanding the entity, the entity’s environment, the entity’s internal controls, and assessing the risks of material misstatement.  This session will attempt to simplify the requirements using common sense examples and language.

Loans, rental agreements, business combinations – what do these all have in common? They all have the potential of creating a related party transaction.  This program presents a detailed analysis of the financial accounting rules for transactions with related parties, as well as compares and contrasts those rules with the AICPA financial reporting framework for small and medium-sized entities.

Excel is the #1 data analysis tool for accountants, yet many accountants have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make analyzing data an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This session is presented using Excel 2013. Regardless of the version you are using, ALL 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 subscription includes two individual sessions for a total of 4 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the 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. *** Managing projects happens every day in accounting firms, but few people are educated on the principles from the field of project management. Take advantage of this project management subscription to learn best practices and then apply the lessons to enhancing ongoing client engagements. Sign up for both webinars and save 20% while having the flexibility to choose the date and time that works best for you! Leverage tips that lead project managers to achieving higher project success rates.

*** This subscription includes three individual sessions for a total of six CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the three courses runs live once a month beginning October 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 is a cutting-edge package designed for forward-thinking accounting professionals who aim to future-proof their careers and drive innovation within their organizations. This all-encompassing suite provides a holistic approach to integrating artificial intelligence across various aspects of accounting practice. Together, these courses offer a 360-degree view of AI applications in accounting, ensuring that participants are well-equipped to lead the technological transformation of their firms or departments. By completing this comprehensive program, accountants will be positioned as technology leaders within their organizations, capable of driving efficiency, accuracy, and innovation through strategic AI integration.

We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We then move to the NFP side of the house with a look at the Accounting Standard Updates issued by the FASB that impacts nonprofit entities. Following that, we review the work of the Not-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on. After the break, we will conduct a deeper dive into Yellow Book and Single Audit engagements. The course closes with a look at the significant changes in the 2024 Compliance Supplement, the changes to the Uniform Guidance and the common deficiencies identified by the federal agencies and peer reviewers. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

*** This subscription includes four individual sessions for a total of 8 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the four 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 an 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for interacting with others. This series covers advanced management skills and proper engagement techniques to deliver success for your team.