CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's Excel Essentials For Staff Accountants
-
Online
8.00 Credits
Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.
K2's Excel PivotTables for Accountants
-
Online
8.00 Credits
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables – including grouping options for fiscal periods – and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.
S Corporations: Key Issues, Compliance, and Tax Strategies - Tax Staff Essentials
-
Online
8.00 Credits
Tax planning strategies for new businesses considering electing S corporation status, and the pros and cons of switching from a C corporation to an S corporation.
Fraud & Embezzlement: Case Studies from the Trenches
-
Online
2.00 Credits
Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving theft of public money and circumstances that allowed the fraud to occur. Case studies we examine include the 2012 $54 million embezzlement from the City of Dixon by Rita Crundwell. The events that impacted the small Illinois town of 16,000 residents was the largest governmental fraud case to date, and spanned an astonishing 20 years. This remarkable story inspired an award-winning documentary, "All the Queen's Horses." We will also examine factors that led to scandals involving the Baptist Foundation of Arizona, World Com, Collin Street Bakery and the Ohio American Cancer Society, among others. This course is ideal for CPAs, government finance personnel, all Internal Auditors, lawyers, governance professionals, accountants and human resource personnel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
A Fox in the Henhouse/Courthouse
-
Online
1.00 Credits
The ancient Romans had a saying about using caution when appointing someone to a position of trust, "don't set a wolf to watch the sheep". That saying is in use today and has changed to include "don't put a fox to guard the henhouses";. The thought is similar, but the wolf and fox are vastly different animals. Wolves rely upon their strength to survive while foxes rely on their cunning. Like foxes, fraudsters rely upon their cunning to defeat or circumvent internal controls. This session reviews the investigation of a deputy court clerk who exploited a weakness in internal controls and committed fraud in the courthouse.
Emotional Intelligence for Professionals: Mastering the Human Side of Success
-
Online
1.00 Credits
Technical expertise may get you in the door—but emotional intelligence (EQ) is what builds trust, earns loyalty, and sustains lasting success. For CPAs, attorneys, financial professionals, bankers, and insurance agents, your ability to navigate emotions—your own and others'—is often the difference between a good client interaction and a great one, between a team that functions and a team that thrives. This interactive course goes beyond theory and dives into real-world application. You’ll uncover what emotional intelligence really is, why it matters more than ever in today’s professional world, and how to strengthen your EQ to improve performance, strengthen relationships, and manage stress with confidence. You’ll walk away with tools you can use immediately to transform how you lead meetings, manage conflict, build client trust, and drive results—while also enriching your personal life. Whether you're looking to become a better leader, communicate with more clarity, or create meaningful client connections, this course gives you the insight and strategies to make it happen.
Supervision/Management Competencies: An Ethical Approach
-
Online
2.00 Credits
Job titles for individuals can vary in different organizations even though the work is the same. This webinar is designed for the individual whose role is to oversee the work of others. This webinar includes an overview of Aristotle's virtue ethics and its application to the responsibility and privilege of developing employees to be their best and for the success of the organization. We will also address issues such as going from "buddy to boss", how to manage if you are newly assigned to an existing employee that was previously supervised by someone else, and critical skill sets necessary for supervisory/managerial positions. 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 Unconscious Bias for Managers, Supervisors, and Executives
-
Online
2.00 Credits
Understanding unconscious bias is key to creating an inclusive workplace and to making the best business decisions. This course explores the concept of unconscious bias, the science behind it, and how it can affect the way employers hire, evaluate, and treat employees. We will also discuss strategies employers can use to reduce unconscious bias and create a more inclusive workplace.
Global Internal Audit Standards (GIAS) Domain IV - Part 1
-
Online
2.40 Credits
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
Fiduciary Accounting & Tax Planning for Estates & Trusts
-
Online
4.00 Credits
This course will review the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus. Critical issues, rules, and special opportunities when preparing your clients' Form 1041 U.S. Income Tax Return for Estates and Trusts will be examined, including what is considered taxable income and allowable deductions. Planning and potential pitfalls will also be explored. This course only qualifies for 2 IRS credits. *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
Business Tax Update: Recent Developments
-
Online
2.00 Credits
A discussion of the latest 2021/222 tax developments impacting business 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.
ChatGPT: What Every CPA Should Know-Updated
-
Online
2.00 Credits
Don't look now, but ChatGPT is taking the business world, including the accounting profession, by storm. Every CPA, whether in public accounting or working in corporate, should have a fundamental understanding of ChatGPT and generative AI applications more broadly. This course will provide you with a foundation of knowledge about ChatGPT technology that will prepare you to have conversations with clients, customers, colleagues and service providers. More importantly, you will learn how to leverage ChatGPT to increase your personal productivity. If you feel your ChatGPT knowledge is lacking, that will not be the case after you attend this course, taught by John Higgins, one of the leading technology strategists and thought leaders for the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Balancing Employee and Employer Rights
-
Online
1.00 Credits
Leaders have the right to exercise customary management functions. Employees have the right to be kept free from discrimination. Neither employer rights nor employee rights are absolute. The courts are equally protective of the rights of employees and employers. A courtroom is the wrong place for anyone to find this out. This course provides practical knowledge on how to effectively balancing these two sets of rights, such that employees and leaders stay out of court. Employers avoid lawsuits, rather than win lawsuits.
Organizational Effectiveness and Communication
-
Online
1.00 Credits
When asked the question, “What would you like to improve about your leadership and communication style?” more than 65% of leaders say they want to be more confident and assertive in their communication. Confidence and clarity communicate leadership. If you are responsible for growing a profitable company or a productive team, you want team members who have the ability to reach goals, make sales, finish projects, and serve customers. Being a confident, compelling leader helps to inspire better relationships, promotes trust, and reduces stress in the workplace. Lack of confidence and assertiveness can lead to resentment, depression, low self-esteem, and loss of respect from colleagues and employers. Confident communication cultivates cooperation, goal achievement, and a more respectful work environment. Clear and compelling leaders are better equipped to move projects forward and make things happen while improving cooperation and respect from partners and subordinates.
K2's Time To Advance Automation - Strategies And Tools For Efficiency
-
Online
2.00 Credits
Increasingly, automating business processes is a necessity. In this session, you will learn about real-world examples of automating business processes. Remember, the survival of your business might depend upon successful automation!
Excelling at Excel: The Magic of Power Query
-
Online
2.00 Credits
Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before.
Sampling - Avoiding Common Mistakes on Financial Statement and Compliance Audits
-
Online
2.00 Credits
Sampling is an important method for determining the extent of testing controls, testing compliance, and tests of substantive details. It allows the auditor to apply procedures to less than 100% of the population yet extend results to project likely conclusions about the entire population. This module will describe the proper process for both attribute testing and variable sampling in financial statement and compliance audits.
When Leadership Fails
-
Online
2.00 Credits
When the leadership in any organizations carries out their responsibilities of establishing, maintaining and monitoring internal controls, it significantly reduces the possibility of fraud occurring. When and if it does occur, a good system of internal controls will often detect it early on. This presentation is an illustration of what can happen when top management fails to carry out their responsibility of protecting an entity’s assets through a good system of internal controls.
AI Lessons Learned for Accountants
-
Online
2.00 Credits
This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Exploring the New Lease Accounting Standard
-
Online
2.00 Credits
It's a whole new world for lessees under ASC topic 842. This program will dive into the new standard on leases and its impact on every size entity, review effective dates, and address what you need to know now. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.