CPE Catalog & Events

You don’t need an accounting degree to harness the power of Microsoft Excel. This course shows how Excel makes sense beyond dollars and cents. We will focus on fundamental concepts for creating, editing, and utilizing Excel content. Participants will learn how to use Excel’s menus and other functions to craft Excel workbooks. Because this course is designed for newer users, we intentionally offer a broad overview of Excel’s numerous capabilities with in-depth coverage of selected resources tailored for non-accounting applications.

This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

It is the role of a leader to build and maintain a great culture in the organization. The culture is the driving force that shapes the attitudes and behaviors of everyone in the organization. A relationship driven organization is built on trust and is the most effective way to improve productivity, engagement, and the bottom line. Understand the components that enable trust to be created and maintained throughout teams and organizations.

Two conmen used lies and falsified documents to convince the State of Tennessee to give them a $3,000,000 economic development grant to create 1,000 jobs by purchasing and rehabilitating a vacant factory in rural Tennessee. Instead, they spent most of the money on an extravagant lifestyle and invested over $1M in a scheme to defraud the U.S. Federal Emergency Management Agency (FEMA) out of over $30,000,000 pursuant to a contract to provide the tarps for areas such as Puerto Rico, affected by hurricanes. This session provides a detailed case study of how the investigators accumulated, organized, and analyzed hundreds of documents, identified the falsifications and misrepresentations, conducted multiple interviews, and ultimately convicted the conmen. This case study provides multiple takeaways for detecting and investigating grant fraud, which is especially relevant in light of the numerous federal stimulus programs in recent years.

In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers, they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide you through the intricacies of making complex data analysis approachable and engaging. You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. It's not just about learning a tool; it's about enhancing your professional identity as a forward-thinking accounting professional. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

What makes a business valuable? Who determines value? What are the key factors that make businesses valuable? In this course, we explore the different ways to value a business. We will apply foundational valuation and corporate finance concepts to real world examples in an effort to see what makes up an investment's price.

This updated course offers an in-depth look at the FASB leases standard (ASC 842), which requires organizations to recognize lease assets and liabilities on the balance sheet. This comprehensive course will cover recognition, measurement, presentation, and disclosure requirements, while also focusing on a critical area of change which is the proper identification of a lease using a principles-based approach. We will discuss implementation requirements from both the lessee and lessor accounting models.  In addition, we explore a variety of scenarios, including short-term leases, purchase options, variable lease payments, and remeasurement. This course offers practical journal entry examples and lessons learned from implementation, while exploring recently issued amendments to the lease accounting guidance.  

This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This series will offer solutions to the budgeting woes from both the big picture and in the details.    Understanding and Preventing Budget Calamities 2 Hours - Accounting •    Most of us lead or participate in the budget process at least annually.  Inherent flaws exist in the standard budget building process that you can solved by recognizing them and committing to solutions.   Building Flexible Budgeting Models: Walking Through and Crunching The Numbers 2 Hours - Accounting •    We can all learn from others and improve our budgeting process by listening to our colleagues’ wisdom and experience.  This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial planning.  Avoiding Budget People Issues:  Managing Budgeting’s Soft Side 2 Hours - Accounting •    Financial plans have a technical component and human component.  We can resolve some of our budget issues by exploring the process’ human aspect.  This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create to a better plan.   Budgeting:  Presenting and Communicating your Numbers 2 Hours - Accounting •    Now that the budget is complete, how we communicate our plan is critical.  this session reveals some key guidelines in budget presentation and will identify key problems in how people often communicate financial plans.   

This course is designed for tax professionals seeking to understand and navigate the IRS collection process effectively. Participants will gain indepth knowledge of the various collection methods employed by the IRS, including liens, levies and wage garnishments. Additionall, participants will leand strategies to avoid or halt collection actions and the implications of the statute of limitations on tax collection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Poorly handled conflicts can lead to break downs in communication, reduced morale, and higher turnover. However, when managed well, conflict has the potential to bring value to the organization and the team. Conflict is a costly and often mishandled occurrence in the workplace. Successful conflict resolution occurs by listening to and providing opportunities to meet each side needs, and adequately addressing their interests so that they are each satisfied with the outcome. In this you will learn the different conflict modes, how to choose the appropriate strategy for your situation, and how relationships impact your ability to promote the positive outcomes and minimize the negative outcomes of conflict.

Employees drive the written and unwritten culture at your organization. Understanding the key workplace issues and how to solve them in today's environment can maximize the returns that employees provide for an organization. We take a deep dive into the research behind the larger issues with our workforce and discuss multiple practical solutions that will enhance your leadership and growth. How can we realize the most from our staff?

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session will cover: Understanding and Preventing Budget Calamities •    Most of us lead or participate in the budget process at least annually.  Inherent flaws exist in the standard budget building process that you can solved by recognizing them and committing to solutions.  

Critics have claimed that traditional managerial accounting is at best useless and at worst dysfunctional and misleading. Most line managers do not trust their management accounting data. 21st Century management accounting develops cost/unit metrics that are useful for budgeting, cost analysis and control. Activity-based costing (ABC) brings truly accurate fact-based costing visibility. ABC does not broadly allocate overhead, but traces costs by identifying cause-and-effect relationships. Such information can provide the ability to reveal true profit margins for products, service-lines, specific sales channels and customers. The same information also helps reduce costs and improve productivity by reporting unit costs that you can use to monitor cost trends and benchmark against your competition. Removing the barriers caused by your current management accounting techniques can provide huge rewards.

Volatility and complexity are the new normal. Most organizations are drowning in data, but starving for information. The finance and accounting function has the opportunity to leverage Big Data and the continuum of analytics – descriptive, diagnostic, predictive, and prescriptive. All are useful for better decision making. Collecting, validating, and reporting data is not the same thing as analyzing information where we can glean valuable, actionable insights. In some ways the finance function is many years behind other disciplines such as marketing, sales, and supply chain managers, in applying analytics. How can the CFO’s function catch up?

This course provides tools and insights into financial statement analysis - both quantitative and qualitative. We'll look not only at the three main financial statements but also dive into the MD&A and footnotes. We'll also discuss the affect of industry nuances on comparability of different analysis tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This 4-hour program addresses the latest promulgations of FASB ASU impacting privately-held entities, AICPA SAS and selected AICPA ethics interpretations.

As part of the Tax Cuts and Jobs Act (TCJA), IRC § 199A was added.  This Internal Revenue Code section allows certain pass-through entities the ability to has made it deduct up to 20% of their qualified business. Although practitioners have had over three years of “experience” utilizing IRC § 100A, many practitioners still do not feel comfortable with this part of the Internal Revenue Code.  The purpose of this presentation is to provide the practitioner with an understanding of the rules of IRC § 199A as well as an understanding of the IRC § 199A regulations. **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.

With 2026 just around the corner, one of our clients? top concerns is the possible reduction of the $13.61 million transfer tax exclusion to a lower amount. Many advisers are turning to irrevocable trusts to take advantage of the currently high exclusion and freeze their estates. This course will analyze the advantages and disadvantages of using a wide variety of noncharitable trusts, such as spousal lifetime access trusts (SLATs), grantor retained interest trusts (GRATs and GRUTs), qualified personal residence trusts (QPRTs), life insurance trusts (ILITs), domestic asset protection trusts (DAPTs), dynasty trusts, and retirement trusts.

The ability to create and ask good questions as well as the ability to know when someone is being deceptive are important skills for managers, auditors, and investigators. This session will improve your interview techniques and your lie detection abilities. Multiple videos from various movies, TV shows, and public figures showcasing the behaviors of liars are included.