CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Global Internal Audit Standards (GIAS) Domain III - Part 2
-
Online
2.00 Credits
The new Standards emphasize that quality performance requires conformance to the Standards. Each standard within Domain III specifically identifies the responsibilities of the CAE and the board, as well as joint responsibilities. 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
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.
Monthly Federal Tax Updates - February 2026
-
Online
2.00 Credits
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online
2.00 Credits
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
Shortcuts that Excel Users Love
-
Online
2.00 Credits
Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2025 A&A Update With Technology Implementation
-
Online
4.00 Credits
Stay informed and prepared with this comprehensive annual update on the latest developments in accounting and auditing. We'll begin with a deep dive into the Accounting Standards Updates (ASUs) effective in 2025, followed by insights from the FAF's 2024 PCC Review and an overview of FASB's Invitation to Comment - Agenda Consultation, which will shape the future of accounting standards. On the auditing side, we'll tackle the essential changes in quality management standards that firms must implement by the end of 2025. The session will also highlight common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB). Join us to gain practical insights and actionable takeaways to navigate these updates with confidence. Finally, we will close the course by exploring the audit technology adoption process to help transform resistance into resilience as the industry embraces new technologies. We will learn how to overcome common barriers to deliver a successful implementation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Introduction to Not-for-Profit Accounting
-
Online
2.00 Credits
Not-for-profit organizations encounter distinct accounting complexities. This course provides an introduction to the financial statements and specialized accounting principles relevant to nonprofits. Attendees will explore key topics such as net assets, agency transactions, contributions, and endowments, focusing on the unique transactions and account balances that define not-for-profit accounting.
Asset Misappropriation - Let Me Count the Ways
-
Online
2.00 Credits
As discussed in the Association of Certified Fraud Examiners’ Occupational Fraud 2022: A Report to the Nations, 86% of all frauds are misappropriation of assets. Why is the misappropriation of assets so large? Because there as so many of them it creates many, many opportunities. And the asset which is stolen the most? CASH! Because it’s easy to conceal and you don’t have to convert it. During this presentation, the many, many different ways to misappropriate (steal) assets and which assets (besides cash) are most subject to misappropriation are discussed as well as how to recognize such and more importantly, how easy it is to prevent it!
Data Extraction, Transformation, Validation the Right Data Sources for Analysis
-
Online
2.00 Credits
In this course, we will explore the various types of data - both structured and unstructured - used in conducting fraud risk investigations and proactive monitoring. We will explore the various tools available on the market and techniques to confirm completeness and accuracy of the data before the analysis begins. The course will cover the process for selecting the right data sources to align with the various risks as well as pitfalls to avoid when preparing the data for analysis.
Current Audit Environment and ASB Activity
-
Online
2.00 Credits
New pronouncements from ASB are covered so you can be up to date on ASB activities and understand how to apply the guidance.
Generative AI in Practice-Boost Efficiency and Profitability
-
Online
2.00 Credits
Unlock the potential of generative AI to streamline accounting, auditing, tax , and advisory services. This course focuses on practical applications that can save you time and enhance profitability. Learn how to integrate AI tools into your workflows to automate tasks, improve accuracy, and deliver higher-value services. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Invest in Your Mental Health and Avoid Burnout
-
Online
2.00 Credits
For the ambitious female finance professional, working hard and going above and beyond are necessary for success. Sadly, taking time to care for themselves can be seen as counter-productive to meeting their career goals. Over ninety percent of women executives are feeling significantly higher levels of stress that they attribute to increased responsibilities and priorities outside the workplace compared to life before the pandemic. Burnout is a syndrome resulting from chronic workplace stress that causes exhaustion, negativity toward one's job and reduced professional efficacy. It has become so pervasive that it's now recognized as an occupational phenomenon by the World Health Organization. To reignite your enthusiasm at work, you don't necessarily need to find a new job or time for a spa day or bubble bath. You need concrete strategies to invest in your mental health without compromising your ability to rise to the next level in your career. 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 Formatting Excel Spreadsheets The Right Way
-
Online
2.00 Credits
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.
K2's Taking Another Look At PDFs
-
Online
2.00 Credits
We’re all familiar with PDF documents. However, it’s safe to say that most professionals use only a tiny fraction of their features. This circumstance is unfortunate, considering all you can do with PDF documents. Therefore, isn’t it time to take another look at PDF K2’s Taking Another Look At PDFs documents and all you can do with them? Participate in this session to learn more about PDFs and how and why they should be a cornerstone technology in most organizations. Collaboration options, long-term storage and archival, and fillable forms are just a few features you will learn about in this session. If you’re ready to elevate your PDF productivity, this session is for you!
The Seven High Quality Questions that Lead to Success & Solutions
-
Online
2.50 Credits
“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.
K2's Technology For CPAs - Don't Get Left Behind
-
Online
8.00 Credits
How good are you with the technology you use daily? What new technology tools are available that could save you time and make you more effective? Technology continues to accelerate rapidly, and the need to keep pace is essential. If you are not an information technology (IT) expert but need a technology update to maintain and improve your skills to serve your companies or clients more efficiently and effectively, this course is for you! In this fast-paced, update-style course, you will survey today’s IT environment, learning about computer hardware, software (including Microsoft Office), operating systems (including Windows 10), and what they mean for you, and peripheral devices. You will also learn about significant trends in information technology and how to take advantage of the opportunities presented by these trends. Examples include the latest Excel features, working with PDF files, and security and privacy issues. Additionally, you will learn how to improve the overall performance of your IT investment, thereby increasing your return on investment. Throughout this program, you will learn from real-time demonstrations of practical applications of the latest tools, which can provide you with the knowledge you need to harness the power of technology, both now and in the future. Register now for this “don’t miss” opportunity to get the skills required to enhance the value of your IT investment.
Maximizing Fringe Benefits: Strategies for Business and Personal Needs for Today and Beyond
-
Online
8.00 Credits
As tax policies and economic conditions continue to evolve, staying ahead in fringe benefit planning is more essential than ever. This course provides financial professionals with a comprehensive update on fringe benefit strategies, ensuring compliance with evolving regulations while maximizing tax efficiency for businesses and individuals. Participants will explore the latest legislative and regulatory updates impacting employer-sponsored benefits, IRC §132 fringe benefits, cafeteria plans, and retirement healthcare strategies. This course also examines ERISA reporting requirements, tax-efficient compensation planning, and healthcare benefits, offering practical applications to help practitioners navigate compliance and optimize benefits for their clients. *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
Ethics: How to Give and Receive Criticism the Right Way
-
Online
2.00 Credits
How well do you accept criticism? How might it enrich your business - and you - if you did a better job of it? This distinctive webinar will show you why it is in your best interest to accept criticism with gratitude. It's even better to welcome criticism. It's also a good idea to learn how to give criticism the right way. A related topic is the art of giving and receiving apologies, and we'll do a deep dive into this area as well. You'll leave with clear guidelines for how to criticize others, accept criticism from them, give meaningful apologies, and accept apologies with grace and ethical intelligence. The result will be a stronger CPA practice and a better you. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial Acumen for Today's HR Leader
-
Online
1.20 Credits
Financial Acumen for the HR Professional is a part of the series "The HR Professional's Guide to Evolving Business Strategy, Finance and Development." This course identifies how HR Professionals can increase their financial understanding to participate more effectively with management as well as understand the financial results and implications for the business.
K2's 2023 Using OneNote More And Email Less
-
Online
2.00 Credits
OneNote is a fantastic application included in your Microsoft 365 subscription. Yet, it is underutilized and misunderstood most of the time. If you genuinely want to change how you work, embrace OneNote. Stop using Outlook as a filing cabinet for essential emails and move them to OneNote instead. If you share a OneNote notebook with others, you can stop emailing altogether within your group and use OneNote as your collaboration and reference platform.