CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
A Practical Guide to Trusts
-
Online
8.00 Credits
This course provides financial professionals with a comprehensive understanding of trusts and their role in estate planning. Participants will learn how to determine whether a trust aligns with a client's financial goals and explore strategies to maximize tax efficiency. The course covers various trust structures and their potential to reduce income, estate, and generation-skipping taxes at both federal and state levels. Additionally, it delves into trustee responsibilities and the benefits of irrevocable life insurance trusts and dynasty trusts. With a focus on practical applications and real-world scenarios, this course equips CPAs, EAs, attorneys, bankers, and financial planners with the expertise to navigate probate avoidance, streamline asset distribution, and manage complex tax considerations. Whether working with revocable or irrevocable trusts, participants will gain the tools to enhance their clients' financial well-being across generations. *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
K2's Advanced Excel
-
Online
8.00 Credits
If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.
Ethics for CPAs: The Practical and the Possible
-
Online
2.00 Credits
Award winning discussion leader, former AICPA Council Member, and former state accountancy board member Mark Hugh will review the AICPA Code of Professional Conduct and its interpretations; discuss new developments in regulation at the national and state level; and discuss examples of best practices, case studies, and disciplinary actions.
What's Changing in Risk Assessment
-
Online
2.00 Credits
SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. The audit standard amends AU-C 315, including many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315. Attendees will have an opportunity to evaluate the impact on audit methodology and documentation.
K2's Expense Reporting Automation
-
Online
2.00 Credits
Managing and auditing employee spending on personal and corporate credit cards is a challenge everywhere. Legacy manual expense reporting preparation and approval processes are tedious and repetitive and are an excellent place to start your company's use of business process automation solutions. This session will cover a variety of expense workflow tools which use technologies and features like bank feeds, mobile receipt capture, OCR data extraction/filling, automated policy enforcement, and artificial intelligence-based validation to automate and eliminate the tedium. Attend this session and learn how to use automation and cure the expense reporting blues for you and your employees.
K2's Ethics and Technology
-
Online
4.00 Credits
With the explosion of technology over the past thirty years, one fair question is, “what are the ethical considerations and impacts related to this technology?” Of course, practical technology issues such as data privacy and security undoubtedly carry ethical K2’s Ethics And Technology considerations. However, technology also affects the ethics associated with work-life balance, the digital divide, training needs, copyrights, and fraud, to name a few. This course will teach you about “technoethics” and its implications for individuals and organizations. To that end, you will explore many current and emerging issues associated with ethics and technology, such as copyrights, cybercrimes, privacy versus security, and geo-tracking technologies. Given the profound implications of ethics and technology, this could be the most impactful session you will ever attend.
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.
K2's Advanced QuickBooks Tips And Techniques
-
Online
4.00 Credits
QuickBooks remains one of the leading accounting solutions for small and growing businesses and Intuit has added numerous advanced features to the application over the past few releases. In this seminar, you will learn how to take advantage of many of QuickBooks’ new and advanced features to solve important issues. For example, you will learn advanced inventory management techniques, including the ability to change the default costing methodology in QuickBooks, and implementing lot and serial number tracking. You will also learn how to build complete sets of financial statements in Excel that link in real-time to underlying QuickBooks data files and how to create multi-company financial statements. Additionally, you will learn how to put the Client Data Review feature to work to streamline the process of identifying and correcting errors and closing accounting periods in QuickBooks. Knowing how to take advantage of the advanced tools and features available can determine your level of success when working with QuickBooks. Take advantage of this opportunity to learn about QuickBooks’ “deep” features so that you maximize your effectiveness with the application.
Promoting Mental Health in the Workplace to Prevent Violence
-
Online
1.00 Credits
Employees, now more than ever, are experiencing stress, anxiety and other mental health challenges and all of those come with them each day to the workplace. In order to ensure the safety and security of their workplace, employers need to address these issues and support their employees. Join us to discuss the challenges to providing mental health support to employees, the potential risks of deprioritizing mental health, and tangible actions employers can take to support the mental health of their work group. The cost of providing mental health resources and support pales in comparison to the cost of NOT providing it. Make a plan. Be ProActive.
Cryptocurrency Transactions: Navigating Federal Tax Rules
-
Online
1.00 Credits
As cryptocurrencies like Bitcoin, Ethereum, and others become more popular, tax authorities around the world are working to create regulations for their use and transactions. This session will address cryptocurrency tax issues and their complexities and challenges that individuals and businesses face when dealing with the taxation of digital currencies. *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
Budget Mastery: Process, Problems, and Solutions
-
Online
2.00 Credits
The budgeting process can be a mundane one for accountants. Let’s be realistic and agree that even the word “budget” does not bring excitement to you and your departmental colleagues. The constraints and pressures can lead to poor decisions in both the technical and human components. This session is the first part of a four part series and will cover the big picture of keeping the process fresh, pragmatic and useful. We discuss these keys in an engaging manner by discussing both our flaws and strengths, including how to build on these characteristics towards an enjoyable solutions-based method that should deliver effective results for your organization.
2025 Tax Legislation: The One Big Beautiful Bill
-
Online
2.20 Credits
Congress passed on July 3, 2025, one of most consequential tax legislation in recent years. The well-informed tax practitioner will want to stay abreast of these developments! This course will start with a short background of this legislation as it made its way through Congress and to the President's desk. We will then review the final provisions that was approved by the Senate and passed by the House. We will also cover key issues that had been dropped from the initial House version and provide observations for possible future legislation.
Preparing and Reviewing Workpapers for Higher Quality Audits
-
Online
4.00 Credits
This course will focus on preparing financial statement audit documentation critical for high quality audits that can pass peer review.
Retirement Planning Issues: Where We Stand Now
-
Online
4.00 Credits
This course is designed to equip CPAs, EAs, attorneys, and tax professionals with the essential knowledge and strategies needed to navigate the latest developments. Explore innovative approaches to maximize retirement savings, discuss tax- efficient retirement plan options, and align estate planning techniques with current trends. Gain a thorough understanding of altered rules for Required Minimum Distributions (RMDs) and discover how to optimize estate plans in response to changing regulations. This update is tailored for professionals seeking practical insights in the realm of contemporary retirement planning. **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.
K2's Implementing Internal Controls In Quickbooks Environments
-
Online
4.00 Credits
The QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications used by small businesses. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions. In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. In sum, while many believe that QuickBooks-based organizations will forever face weak internal control structures, by participating in this session, you will learn how QuickBooks-based businesses can benefit from strong internal controls.
K2's Microsoft Teams
-
Online
4.00 Credits
Microsoft Teams is one of the most exciting personal and organizationally productivity tools to ever appear on the business landscape. With Teams, you can communicate and collaborate easily and securely with others, including colleagues outside your organization. Further, you can extend the already-robust functionality in Teams by incorporating add-in solutions with just a few clicks of the mouse. Unfortunately, despite Teams’ power and relatively simple interface, many organizations struggle with deploying and using Teams. In this session, you will learn how you can get up and running quickly in Teams so that you can take full advantage of this powerful tool. More specifically, you will learn how you can get started in Teams and critical decisions that will affect your deployment. Also, you will learn how to work in Teams, including how to take advantage of the chat, voice, and video call services and how to share documents securely with others. Moreover, you will learn how to extend your Teams platform to external organizations for improved communication and collaboration. Additionally, you will identify how you can add other applications into Teams and optimize Team's configuration for the best overall efficiency and security. If you are working with Teams or plan to do so, this is one CPE session you can’t afford to miss!
K2's Case Studies in Fraud and Technology Controls - 4 Hours
-
Online
4.00 Credits
Fraud continues to plague businesses at epidemic levels, and technology control failures are a big 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 better positioned to reduce fraud risk.
K2's Best Word, Outlook, And PowerPoint Features
-
Online
4.00 Credits
Most professionals routinely use Word, Outlook, and PowerPoint, but many are self-taught and, as a result, have not been exposed to the best features of these three applications. Consequently, they often use “brute force,” inefficient means when working with these three components of Microsoft Office. If that describes you, ensure you carve time out of your schedule to participate in this fourhour session. In it, you will learn how to work much more efficiently when using these tools to get better results in less time.
How to Make Difficult People Disappear...Without Going to Jail
-
Online
1.00 Credits
Have you ever found yourself wondering why people won't just listen to you? Or maybe you have found yourself surrounded by people that make your jaw clench...you know the people...the challenging people. HR Professionals walk a tight rope of being strong, but not aggressive, polite, but not a push over. It is exhausting! In this session, you will uncover the secrets to working with (and overcoming) challenging people derived from the decades of experience Summer brings from her time on the frontlines and as an HR Professional working with companies such as Walt Disney World, H-E-B and even a dude ranch.
Listen to Lead: The HR Champion's Guide to Building an Employee Listening Strategy
-
Online
1.00 Credits
When it comes to assessing your organization's employee experience, it's no longer enough to administer an annual survey and call it a day. Rather to engage and retain today's talent, it's all about an integrated, strategic approach to employee listening woven throughout the entire employee lifecycle. While this thought can overwhelm many HR professionals, the good news is that this is an area where you can start to see big ROI in a short period of time. In this session, we'll break down where to start, steps to improve your existing efforts, and strategies you can use to move the needle in your organization and drive HR and business success.