CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's Mastering Advanced Excel Functions
-
Online
4.00 Credits
With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.
Unlock the Power of AI with Copilot in Excel
-
Online
2.00 Credits
In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Radar Phenomenon
-
Online
1.00 Credits
This session reviews the three elements of fraud, how fraudsters think, how proper internal controls can prevent and detect fraud, and the red flags to look for to identify fraud. It looks at Radar O'Reilly, one of the most beloved characters of the TV show M*A*S*H. He was trusted by his boss to run the administrative side of the US Army medical unit. Were there red flags all around Radar? Did he have the opportunity to steal? Was he a fraudster? We'll find out? Attendees learn to recognize the traits of this type fraudster that are present in many organization. Case studies of various Radars are included.
Combatting Sexual Harassment in the Workplace
-
Online
1.00 Credits
This presentation will review what sex harassment is under the law, company compliance obligations, and describe how promoting a positive company culture can prevent sexual harassment in the workplace.
How to Audit Prepaid Expenses
-
Online
2.00 Credits
Understanding how to effectively audit prepaid expenses is a key skill for audit staff. This course provides a comprehensive overview of the fundamentals, including the applicable audit assertions and common risks and threats associated with the prepaid expense balance. Participants will learn how to perform substantive auditing procedures to ensure accuracy and reliability, with guidance on applying these techniques to real-world scenarios. Designed to enhance practical knowledge, this session equips auditors with the tools and confidence needed to navigate prepaid expense audits with proficiency.
The CFO Series-Artificial Intelligence: A Practical Guide for Financial Leaders and CFOs
-
Online
2.00 Credits
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.
Effectively Responding to IRS Letters
-
Online
2.00 Credits
This course equips tax professionals with the knowledge and strategies needed to handle the most common IRS letters, including general notices, audit requests, collections, return inquiries, and error notices. Participants will learn how to interpret IRS correspondence, adhere to response deadlines, and effectively communicate with the IRS to resolve issues and minimize risks. The session also highlights best practices for ensuring compliance and avoiding penalties or escalation, empowering attendees to navigate IRS correspondence with confidence. *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
Grading Your Auditors - Are You Getting the Most Value?
-
Online
2.00 Credits
An audit is an investment in reliable financial reporting and compliance, and an increased return on those dollars can be achieved by hiring the right auditors. This course will provide key factors for you to consider when evaluating whether you are getting the most quality and insight from your auditors, to enable them to perform the most value-added audit possible in the given circumstances - while retaining the trust of a CPA. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's Excel Charting And Visualizations
-
Online
4.00 Credits
Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.
Critical "Soft" Skills for CFOs and Controllers
-
Online
4.00 Credits
Accounting and finance managers and executives must demonstrate sound soft skills necessary for personal growth and organizational success. This course will provide insights into the most crtical personal skills critical for CFOs and Controllers - or those that want to be!
Data & Predictive Analytics & Business Intelligence for Controllers/CFOs
-
Online
4.00 Credits
The Accountant role is evolving from data aggregation to knowledge extraction, with a significant emphasis on understanding and leveraging technological advancements. In this era of rapid digital transformation, it is crucial for accountants to grasp the shift towards more analytical roles, learn the tools, and integrate Business Intelligence (BI) and Data Analytics (DA) in their organization and daily practices. This course will focus on raising the accountant's awareness of BI and DA practices, the impact of AI technologies like ChatGPT, and how these can benefit their organization. By embracing these technologies, accountants can enhance their value proposition by transitioning from traditional accounting roles to becoming strategic advisors and decision-makers.
Partnership Essentials: Review & Update
-
Online
4.00 Credits
This course examines the critical issues and special opportunities facing partnerships and their partners, as well as the relationship between limited liability companies and partnerships, with a focus on reporting tax basis capital accounts. **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.
Seeing Beyond the Numbers: Analysis for CFOs & Controllers
-
Online
4.00 Credits
Financial statements are a window into what is going on in the day-to-day operations of the company. They help us see what the company's strengths and weaknesses are. However, financial statements can often have different messages depending on the user. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Donating Cryptocurrency and Avoiding Traps for the Unwary
-
Online
2.00 Credits
As the digital asset market continues to mature, more taxpayers may be contemplating blessing their favorite charitable organizations with gifts of cryptocurrency. Beneficiaries unfamiliar with digital assets may find it challenging to properly report any of these types of donations. Likewise, taxpayers will need to ensure that they properly value and substantiate any contributions or potentially risk their charitable deductions being denied. This course will provide a brief overview of digital assets. This will be followed by a discussion of the rules regarding the documentation required when claiming a charitable contribution of digital assets. This course will also cover recent IRS publications and cases discussing taxpayers whose deductions of digital assets charitable gifts was scrutinized. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics - Keeping the Good from Breaking Bad
-
Online
1.00 Credits
Ethics are how groups define right from wrong. Codes of Ethics define good behavior from bad behavior for professionals. When we break those codes, we "break bad." For five seasons, the popular television show "Breaking Bad" explored the transformation of one good man breaking bad. This session provides an overview of ethics and why people break bad, while using examples from the TV show as well as case studies of good people who broke bad.
The Controllership Series - The Future Role of the Controller Part 1
-
Online
1.50 Credits
This is a two-part series that discuss new trends and concepts the financial controller should begin to execute in order to truly become a valued member of the senior leadership team. The rapid pace of the evolving technological landscape has promoted changes in how accountants and financial professionals focus attention on strategy and modernize their roles to leverage digital technology. There is increased demand for enhancing flexibility into finance cycles and initiating real-time reporting and insights. These are the core attributes that will assist in transforming the work that controllership function performs. Is the financial controllership prepared to meet future business demands? The IMA® (Institute of Management Accountants) and Deloitte’s Center for Controllership aimed to better understand the current state of controllership and expectations of future demands for controllers and accounting professionals. They conducted a survey in late 2022 and identified several trends. The survey takes a look at how prepared controllership is to meet future business demands. It also highlights some insights for leaders to consider that may increase their preparedness. It also identified areas of additional insight and questions to answer on the controllership transformation journey. In this segment one, we go through numerous concepts in detail and the remaining concepts will be covered in segment two.
Inventory, Expense and Payroll Fraud
-
Online
2.00 Credits
Inventory is a wonderful place to both hide fraud and commit fraud. The reasons that inventory is subject to so much fraud is the it is often very large, spread out over a large area, and many people have access to it. When there are little or no internal controls related to inventory control, you are begging employees to steal it. No with so many ways to dispose of stolen inventory via the internet, i.e., EBAY, inventory fraud is much more appealing to a lot of individuals. The more common ways to commit expense fraud and how to cover it up will also be discussed. Travel and entertainment are some of the favorite areas of committing expense fraud. In addition, payroll fraud will be discussed. Although there are many ways to commit payroll fraud, it is very easy to prevent. This presentation is designed to familiarize the participants with the many ways to commit inventory, expense and payroll fraud, how to detect it, and more importantly, how to prevent it.
Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
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.
PPP Fraud and Financial Professionals
-
Online
2.00 Credits
Casey Crowther did not have a college education, but he had an outstanding work ethic. With little more than a pickup truck and some hand tools, he built a roofing company that grew. Over time, Casey's company employed more than 100 people and generated more than $20 million in annual revenues. With a company of that size, Casey relied upon advice from his bookkeeper when filling out financial documents. As a result of representations he made on bank statements and loan documents, authorities charged Casey with criminal behavior related to PPP loan fraud. What should an accounting professional learn from Casey's story? Stay tuned to find out! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics and Civility in the Workplace
-
Online
2.00 Credits
The issue of civility, or lack thereof, has garnered much attention from leaders, Human Resource professionals and employees at large. The cost of incivility is high not only to the bottom line but to the human spirit. This webinar, based on ethical principles and values, is designed to look at the fundamental relationship skills that foster workplace civility. Understanding that workplace civility is far more than manners, we will dive into behaviors that help promote a workplace where each individual feels respected and valued. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.