CPE Catalog & Events

Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many business owners need to pay more attention to the financial planning opportunities and implications when starting, growing and successfully running their businesses. This all-inclusive course brings together closely held business owner specifics, focusing on critical structure and financial planning issues, such as identifying those issues that business owners need to keep on the radar. This session will help determine the goals and objectives of the business owner when selecting or changing a form of the organization concerning start-up costs, control over the operation of the business, personal liability for business operations, flexibility in the process of the company, business structure, continuity and compensation. Financial planning issues to be discussed include cash flow management and budgeting, risk management and insurance, investing, income tax, retirement and estate planning issues.

In 2006, Congress passed the Tax Relief and Health Care Act. Prior to the Act's passage, rewards to individuals who provided information to the IRS regarding tax fraud were capped at $10 million. The Tax Relief and Health Care Act authorized the IRS to create a Whistleblower Office dedicated to investigating, processing and recovering claims concerning the underpayment of taxes. Under the IRS' new program, whistleblowers may recover 15 to 30 percent of the amount collected provided the taxes and amounts in dispute exceed $2 million. If the whistleblower's claim does not meet these criteria, the IRS may still consider granting an award under its pre-2006 Tax Relief Act discretionary authority. Given the rapid growth of this program, practitioners should have a basic understanding of the procedure and content for IRS Whistleblower claims, both from the perspective of a claimant's potential to recover and a taxpayer's exposure to liability.

S corporation taxation has a lot of pieces. There are helpful elections you can make that can potentially save your client money, but there are also rigid rules to adhere to. For example, if there is more than one class of stock, it can terminate the S corporation election. Learning how to successfully navigate these rules can make all the difference. In this course, we will discuss some of the more common specialty areas experienced by practitioners - late filing relief for S corporation elections, disproportionate distributions, and selling S corporation shares. While these items may not come up on every single Form 1120-S, you will be able to add more value to clients when they do.

Uncovering financial fraud and irregularities requires more than analyzing numbers?it demands strategic questioning and keen behavioral insight. This course equips CPAs with essential interviewing techniques to detect deception, gather critical information, and strengthen forensic audits. With financial fraud on the rise, mastering investigative interviewing is a crucial skill for CPAs committed to protecting organizations and ensuring financial integrity.

In May 2023, the IIA released a draft of the new Global Internal Audit Standards. The intent was to provide more effective standards for Internal Audit globally. The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service

Unlock the power of multigenerational teams to future-proof your firm. Today’s workplace is more generationally diverse than ever—spanning five, soon to be six, distinct generations. And while this mix can create miscommunication and friction, it also holds untapped potential for innovation, connection, and resilience. This dynamic course helps professionals in accounting, law, banking, insurance, and financial services understand and harness generational dynamics. You'll explore how shared formative experiences shape values, communication styles, and expectations at work—from the frugality of the World War II generation to the digital fluency of Gen Z and the up-and-coming Generation Alpha. Rather than getting stuck in generational stereotypes, you’ll learn to lead, collaborate, and connect more effectively across ages. With insights drawn from workplace psychology, sociological research, and real-world examples, this course equips you with practical tools to bridge the gap—so you can build stronger client relationships, more collaborative teams, and a culture people want to stay in.  

You have more to do than time to do it. When you finally find the time, distractions steal it away again. As a leader with multiple layers of demands on your time, how can you possibly get it all done? In this course, I will help you learn practical productivity strategies so you can tame your to do list and multiply your time. It’s just wrong for a to-do list to rule your life. Learn how to take back your time…and your life.

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.

Cryptocurrency is heading mainstream. According to a recent study conducted by New York Digital Investment Group, there are 46 million bitcoin holders in the US, and institutions have also shown increased interest in this space. The rising popularity of cryptocurrency and the inclusion of the virtual currency question on the front and center of Form 1040 have made cryptocurrency a subject that tax practitioners cannot afford to ignore anymore. This course is designed to walk you through tax implications of common cryptocurrency-related transactions (trading, mining, spending, staking, etc.) and how to successfully service clients affiliated with cryptocurrency by using a tool like CoinTracker. This session also covers current developments surrounding this topic and some of the unique tax planning opportunities in the crypto space such as tax loss harvesting without being subject to wash sale rules, tax lot ID optimization (FIFO, LIFO, and HIFO), self-directed IRAs, etc.

In order not to perform an excessive number of audit procedures (over audit) auditors must perform procedures in order to determine in what areas are there weak internal controls that could result in a risk that the financial statements would be materially misstated and not be detected.  SAS No. 122, AU 300 – 499, Measuring Audit Risk provides guidance as well as required procedures that must be performed in every audit in order to determine the risk of material misstatement.  No longer can the auditor state that they assess the risk of material misstatement at maximum without having a basis for making such assessment.  As a result, the standards now require that the auditor make such an assessment of a material misstatement of the financial statement on every audit in order to have a basis for such assessment.  This program is an overview of the statement documentation requirements in assessing such a risk.

Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service

This course explores the increasingly complex features of Excel that facilitate efficient data analysis.  We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information.

Discover how artificial intelligence is transforming the accounting, tax and finance landscape. This course offers CPAs a comprehensive overview of AI technologies, with a special emphasis on generative AI tools such as ChatGPT and Google Gemini. Learn how these advancements are reshaping business operations and what they mean for your professional role. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Most productivity planners could have been made in 1975. However, we have learned more about the brain in the last 5 years than in the last 500!  If productivity involves filtering out distractions, focusing, and executing on what is most important, shouldn’t there be a brain-based approach that incorporates the new science to help your organization fight distractions and find time?  Yes, there should be, and now there is!  It is time for a new productivity for the new world. In this course, you will learn science-based whole brain approach to help people across your organization boost focus, energy, and motivation toward what matters most so they can increase their opportunity to achieve your organizations most important goals.

Bears are intelligent and motivated to find food. When I left some fried chicken in my Jeep while in Gatlinburg, a bear tore a hole in the top and ate the chicken and part of my Jeep. He was just a bear being a bear. I'm responsible because I left the chicken in the Jeep and gave him the opportunity. Similarly, people are intelligent and motivated to survive. If we give them opportunity by not implementing good internal controls, they will take our assets. This session reviews the investigation and prosecution of the former director of a conference center who took advantage of lax internal controls of a joint-venture and stole thousands. She was just a fraudster being a fraudster.

You often can perform an audit in accordance with all of the standards, and still have a substandard audit IF you did not get out among the clients employees (let them know you are there and where you located), talk to as many people as you can regardless as to whether you may think that they may have any helpful information; constantly observe your surrounding where ever you are at (you never now what you might see) and lastly, listen to not only what people are saying to you but are also saying around you. This presentation is designed to illustrate the importance of making yourself available to your client’s employees, let them know that you are there and where you can be found. Talk with them because if there is a problem, somebody knows and they will often tell you all about it IF you just ask them.  Look at your surrounding everywhere you go.  What are you looking for?  I don’t know but I’ll know it when I see it. Lastly, listen to what they have to say.  Every word is important because they may say something that you had not asked about.  Remember, you never want to discover something and go to an individual who you determined knew about it and ask, why didn’t you tell me about this and their response was, you never asked me!

A discussion of the latest 2021/222 tax developments impacting individual taxpayers, with a focus on important provisions, rules and concepts. 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 recent changes imposed by recent tax legislation that real estate owners and investors need to know, including Section 199A, the new Section 163(j) interest expense limits and the opportunity to elect out.  An introduction to opportunity zones and other important issues will also be addressed. **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.