CPE Catalog & Events

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.

Are you responsible for presenting financial information to your organization, business associates, or clients? If you're a CEO, CFO, CPA, financial analyst or a manager needing to communicate financial information in an impactful way, this workshop will give you the necessary tools to tell more effective stories with your financial data. It is imperative in this fast-paced business environment, accountants need to gain a high-level understanding of the technology advances to help them focus their time on finding the story behind the numbers. Bring financial information to life and use it to communicate a story to an audience, with a focus on simplicity and ease of interpretation. This is accomplished through a mix of financial data, visualization, storytelling theory, best practices, and practical application.

The Internal Revenue Service has targeted complex partnerships it believes are not in compliance with the tax law for audit. One of the abuses the IRS has attacked is transfers of interests in partnerships which result in an increase in the basis of a partner who is subject to a high marginal income tax rate. This perceived abuse results in lower income tax and/or a higher basis in partnership property for the higher marginal income tax partner. The final regulations basically characterize certain partnership-related basis adjustments as transactions of interest on the part of the IRS. In a practical sense, this means that property transfers in a partnership with related party partners may run the risk of IRS scrutiny if audited. It is common for certain types of partnerships, such as real estate limited partnerships, to have related-partner partnerships. The IRS may decide to scrutinize partnerships with related party transfers. Since these final regulations presume an understanding of the rules for partnership distributions and Section 754 elections, the program begins with coverage of those two topics, with time devoted to adjustments under both Section 743(b) and Section 734(b). It would be hard to understand the IRS's claim of abuse without a working knowledge of these transactions.

All organizations are looking for ways to gain an advantage over the competition. This practical and interactive session will present a toolkit of ideas to help CFOs, controllers and finance professionals better position their organizations for the future. We know change is occurring at an exponential rate, and that has proven to be the case in all areas of finance, management, and leadership over the past year. The course deals with these new issues and will continue to be updated as necessary throughout the year. Become the "financial hero" of your organization and make a positive impact on the bottom-line.

Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in the SASs. 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 that contribute to fraud, and what you can do to mitigate fraud risk. A specific focus of this course is the application of information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general control and application control failures that contributed to each of these frauds. By learning through these real-world case studies, you will be positioned better to reduce fraud risk.  

This course begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. We'll then switch gears to review the GASB standards coming down the pike, including major projects of the GASB. When considering the audit side of the house, Yellow Book and Single Audit engagements are considered must-select engagements for Peer Review. This course will cover the Yellow Book independence requirements which are required any time an auditor performs a Yellow Book or Single Audit even when the engagement is for a for-profit entity. The session will also cover the changes to the Uniform Guidance. We'll close with a look at the key changes in the 2024 Compliance Supplement 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 event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course is a great foundation to introduce new preparers to tax rules related to business returns. The course covers tax areas affecting all business entities, providing a solid basis for staff to handle business entity returns. Such business tax topics include the sale of assets used in a trade or business (Form 4797), depreciation (Form 4562), deductible and nondeductible items, and the basics of uniform capitalization. The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare complicated federal corporate income tax returns. It is a hands-on and practical course, with extra emphasis on changes to forms under new tax law.

This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Award winning discussion leader Mark Hugh discusses how to create and capture value with consulting services. Whether you want to consult a little or full time, this valuable course reviews identifying a specialty, growing a practice, capturing value, creating deliverables, and effective marketplace marketing strategies.  

Do you understand the root cause for many professional and personal goals not being achieved? The SMART acronym is valuable in setting goals but insufficient for achieving them. You need two types of goals to boost your chances of success. Outcome goals focus on the results you want to attain. Process goals identify the action steps required to accomplish those desired outcomes. This session explores the essence of both types of goals, and practical examples and tips for the execution of your goals.

This  session provides HR Professionals with scripts for and tactics for coaching leaders in handling an array of employee relations situations with sensitivity, good judgment, and high confidence.  Topics include employee complaints, personality & attitude problems,  performance counseling, personal hygiene problems, disability-related performance issues, misconduct due to mental conditions. You will learn how to use a unique process, “Reset the Clock,” that prevents attorneys from taking something leaders did wrong or did not do in the past and using it to support legal challenges in the future.  Liability is replaced with credibility. Lawsuits are then avoided rather than won.  Financial assets are protected, morale stays high, and bad publicity is averted. HR Professionals avoid hearing from senior leaders:  “You should have anticipated this” after an avoidable legal claim.

This course is a continuation of our series on preparing to become a forensic accountant. Within this segment we focus on elements of computer forensics. This session is designed to delve into further investigative procedures used in computer forensics.  

According to the FBI, “white-collar crime is … synonymous with the full range of frauds committed by business and government professionals … characterized by deceit, concealment, or violation of trust …. The motivation behind these crimes is financial—to obtain or avoid losing money, property, or services or to secure a personal or business advantage.”  CPAs can and should play a crucial role in preventing and detecting white-collar crime, as well as in prosecuting the perpetrators.  This session will explore whether we are up to this challenge, heighten awareness regarding the CPA’s role as a front-line defender of the public interest, and assess whether we are deserving of the public trust we enjoy.

In today's world, AI hype bombards us from every direction. Every system seems to boast magical AI capabilities, leading to confusion and overwhelming information. This course cuts through the noise to reveal the true, practical applications of AI for your business today. Our goal is to give you real world examples of using AI on a day-to-day basis, with a clear understanding of its particular strengths and limitations.

If sales increase, so should profits.  Yet, the opposite result often leaves executive’s scratching their heads.  When organizations work with inferior cost information, they make mistakes in four specific situations.  Bad information causes sellers to overprice easy, high-volume work and under-price difficult, low-volume work.  This session discusses how to use activity-based costing to build accurate costing models that consider far more than just the labor and materials necessary to provide goods and services. 

CPAs can be requested to assist attorneys in litigation support in criminal proceedings. For criminal tax cases, the IRS has recommended prosecution. However, the rules and stakes are different than a simple civil audit. This presentation will focus on how to assist defense attorneys in calculating tax loss, asking the right questions, and probe possible weaknesses in criminal tax investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Please join us for an introductory course in international cross border transactions.    We will discuss typical situations in which a cross-border transaction arises, and how a taxpayer can utilize the rules to potentially decrease an entities effective tax rate.  Other issues, such as documentation and IRS audit risk will also be covered.  These rules will be illustrated by a hypothetical US- Canada transaction.    **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 leighanne.conroy@acpen.com.  

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

Part of the technical competence of most experienced tax practitioners is the ability to advise owners of S corporations and partnerships or multiple-member LLCs treated as partnerships regarding the tax rules that apply when these entities liquidate. Entity liquidations do not occur every day; but they do occur, and often at very critical times in the business life of the entity and its owners. All tax practitioners should be able to advise their clients about the tax issues associated with client businesses that go out of existence and liquidate. This program explains the tax consequences associated with liquidating S corporations, partnerships, and multiple-member limited liability companies treated as partnerships.