CPE Catalog & Events

Some estimates indicate that business professionals spend almost half their time in Excel applying formats. If you want better formatting results in less time, participate in this session to learn the best practices for formatting your Excel spreadsheets. In this session, you will learn best practices for applying formats in your workbooks. More specifically, you will learn about features such as Custom Format Codes, Templates, Styles, the Accounting Format, Precision as Displayed, date formats, and many others, all of which can save you substantial time when working in Excel.

“How will I EVER get this all done?"  It’s a question I often hear from clients and on a particularly stressful day, I can hear myself saying these words!  Instead of helping us focus, it's a question that leads to stress, anxiety and overwhelm! Regardless of where we are in business and in life, we will run into challenges and problems as we navigate business growth, leadership, work life balance and our quest for success and happiness. This workshop will explore the 7 HIGH QUALITY questions that lead to relief, enthusiasm and success.  It will be an interactive exploration that will leave you with a game plan to use right away, as well as an opportunity to practice the mindset that the most successful and happiest people use daily.    This program is for both the entrepreneur who wants to be more effective in their day as well as team leaders who want to stand out in their organization.  For the business owner or staff member you can expect a new way to work with your day so that it's profitable, productive and happier.  For leaders, you will learn new up- leveled skills to increase your efficiency, communication and productivity.  You and your team will shine.  Your staff will feel appreciated and connected to their value as well as the company's goals. Albert Einstein said 'we can't solve our problems with the same thinking we used when we created them'.  The quality of your question will impact the quality of your solution.  Learn the 7 questions that take you from confused and frustrated to creative and focused. 

In trying to achieve life balance, various internal and external obstacles arise.  In this course we will look at these obstacles and provide specific ways to overcome them.  In addition, we will look at how to excel in every area of your life including your relationships, finances, sense of purpose, level of  happiness, and your physical health and leisure time pursuits.  You will leave this course with powerful methods and a specific plan to move forward in your life in a balanced, healthy, and productive manner.  Don't forget to take Part 1 of this amazing course.

This is not your average CPE course--Part 2! In this second part course (which is equally fun and engaging), you will learn how to feel confident--even in highly stressful situations. You will learn new secrets to great health that take under 10 minutes per week, and you will learn how to know what is most important to you--so you can be happier and healthier in the long run. Tune in for techniques to relieve stress and tips on incorpating meditation into your daily routine. All of which will help improve your memory and overall mental health and wellbeing. In addition, you'll learn an unsurpassed method for making sure you stay consistent with actually implementing these methods in your daily life.

The new revenue recognition standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry. Previous courses in this series have covered the standard at a high level and evaluated step one and two of the standard. They are: Understanding the Revenue Recognition Standard Revenue Recognition: Identify the Contract - Part One Revenue Recognition: Identify the Contract - Part Two Revenue Recognition: Identify Performance Obligations – Part One Revenue Recognition: Identify Performance Obligations – Part Two Revenue Recognition: Determine Transaction Price - Part 1 Revenue Recognition: Determine Transaction Price - Part 2 Revenue Recognition: Allocate the Transaction Price Revenue Recognition: Recognize Revenue      This segment is designed to evaluate Step Three of the new model dealing with Determining the Transaction Price.

Artificial Intelligence (AI) is the hottest topic in technology circles today. And for good reason! AI can help all business professionals – including HR professionals – work more efficiently and effectively. AI tools such as ChatGPT, Gemini, and Copilot are proving themselves daily as valuable assets. These tools can help you automate research, draft documents, summarize emails, analyze Excel data, and even create PowerPoint presentations for you. If you haven't yet explored what today's AI tools can do, you'll want to participate in this session to become more productive and efficient with this very practical technology.

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.  

Building on Part 1, this course will review the application of sampling in financial statement audits with a focus on sampling for tests of controls. We'll also review the requirements for sampling in Single Audits with a focus on tests of controls and tests of compliance. 

This session provides a refresher regarding the fundamentals of activity-based costing (ABC). We will examine theoretical concepts before exploring practical possibilities for implementing ABC. A major focus of the course will be factors to consider when determining whether this managerial accounting tool is an appropriate resource for an organization.

This course presents an overview of tax treaties and how they are used in structuring transactions and determining the tax impact of cross-border transactions.  It discusses the ordering rules for local laws versus treaty laws, and the purpose of the tax treaties in avoiding and eliminating double taxation to promote trade and investment. The participant will learn about  planning opportunities to contemplate when structuring foreign operations.  **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 session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today's popular and software tools and examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements.

The annual budgeting process is often criticized as an accounting exercise that is obsolete soon after it is published, prone to gamesmanship, cumbersome, not volume sensitive, and disconnected from the organization's strategy and risk management processes. You can resolve these deficiencies using capacity-sensitive driver-based projections. Driver-based budgeting allows for quick scenario planning and far easier analysis of a growing organization whose future may look nothing like today. The driver-based budgets can be periodically refreshed to create rolling financial forecasts extending well beyond the fiscal year end. Learn how managerial accounting can become managerial economics.

Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel’s most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you’ll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we’ll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.

This segment is designed to evaluate Step Five of the new model dealing with recognizing revenue which is the final step in applying the new revenue recognition standard. For performance obligations that are fulfilled at a point in time, revenue is recognized at the fulfillment of the performance obligation. For performance obligations to be satisfied over time, an entity must decide how to appropriately measure the progress and completion of the performance obligation. A performance obligation is satisfied when or as control of the good or service is transferred to the customer. There are several issues companies should consider in applying step 5 of the standard: •   Determining if a Performance Obligation is satisfied over time •   Identifying indicators of transfer of control of good/services •   Utilizing input and output methods to measure progress of revenue recognition •   Understanding stand-ready obligations and how to apply discounts

Cloud computing has become a source of cyber-crime. “Cloud forensics is the application of digital forensics in cloud computing as a subset of network forensics to gather and preserve evidence in a way that is suitable for presentation in a court of law.” Cloud forensics is a combination of the varied types of accounting forensics including: •    Digital forensics •    Network forensics. •    Hardware forensics In cloud crime, the cloud is considered the object when the target of the crime is the cloud service provider they are directly affected by the act. It is considered the subject of the crime when the criminal act is committed within the cloud environment. It is considered the tool when it is used to plan or conduct a crime. This course will delve into the many concepts involved in cloud forensics. The course complements other courses in the series of Becoming a Forensic Accountant.  

One of the three major forms of occupational fraud, along with corruption and asset misappropriation, is financial statement fraud. From improper asset valuation to fictitious revenues, this course will review financial statement fraud red flags and examine real-life examples. 

In February 2016, FASB issued ASU 2016-02, Leases, which provides new guidelines that change the accounting for leasing arrangements. To be able to properly account for leases, financial professionals must understand ASU 2016-02 (also referred to as Topic 842). This guidance covers information on how leases should be accounted for. The previous leasing standard (ASC 840) had been in existence for almost 40 years. Under ASC Topic 842, lessors continue to classify leases as operating, direct financing, or sales-type. While lessees now classify leases as operating or financing leases. Previous guidance only required capital leases to be reflected on the BS. The new guidance requires all leases to be reflected on the BS. This is a major change for organizations and will cause their balance sheets to swell as leases must now be disclosed on the balance sheet. The standards original effective dates were prior to 2019. In April 2020, due to COVID-19, FASB voted to defer the effective date for ASC 842 for private companies and certain not-for-profit's for one year. For private companies and private not-for-profits, the leasing standard will be effective for fiscal years beginning after December 15, 2021, and interim periods within fiscal years beginning after December 15, 2022. For public companies the leasing standard is effective for fiscal years beginning after December 15, 2019, including interim periods within those fiscal years. The course covers elements of lease classification for both lessees and lessors. Also, numerous examples are incorporated as reference.  

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.

How you say what you say is more important than what you say. According to a UCLA study, 93% of a communicators effectiveness is based on non-verbal cues. This foundational program include a focus on the verbal, vocal and visual delivery techniques appropriate for the business environment, which can improve a speakers credibility, influence and impact. Depending on the course length other topics include; managing fear, organizing your presentation, increasing attention and interaction, handling questions, infusing humor, creating impactful visuals, and more.

Preparing Form 706 requires a detailed understanding of estate taxation, valuation rules, and compliance requirements. This course provides a step-by-step breakdown of Form 706, helping tax professionals accurately report estate taxes while ensuring compliance with IRS regulations. Participants will explore key components, including gross estate calculations, deductions, tax computation, and portability elections. With real-world examples and practical guidance, attendees will gain confidence in preparing Form 706, even in complex scenarios. This course will also cover any recent legislative changes introduced by the new administration and their impact on estate tax planning and compliance. *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