CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Business Intelligence (BI) and Business Analytics (BA)
-
Online
2.00 Credits
Volatility and complexity are the new normal. Most organizations are drowning in data, but starving for information. The finance and accounting function has the opportunity to leverage Big Data and the continuum of analytics – descriptive, diagnostic, predictive, and prescriptive. All are useful for better decision making. Collecting, validating, and reporting data is not the same thing as analyzing information where we can glean valuable, actionable insights. In some ways the finance function is many years behind other disciplines such as marketing, sales, and supply chain managers, in applying analytics. How can the CFO’s function catch up?
Ethical Leadership: Power, Influence, Integrity, and Trust
-
Online
2.00 Credits
Leaders naturally wield power and influence. But, to avoid the temptation of abusing power, leaders must apply ethical behaviors for themselves and others. Words, actions and deeds which demonstrate integrity and trust yield the credibility that make others want to follow ethical leaders. Betraying trust can destroy careers, whole organizations, and lives. This is why trust is a top prerequisite for principled and ethical leadership. Positive (and negative) influence is derived from the credibility trust brings. Ethical leaders who continually work to earn and keep trust reap enormous payback in all aspects of business including superior economic, competitive, and strategic performance.
K2's 2023 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 2023 Introduction To Excel Macros
-
Online
4.00 Credits
You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.
K2's 2023 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 2023 Integrating Data for Improved Efficiency and Control
-
Online
4.00 Credits
In today’s business climate, data is king! Organizations of all sizes collect and manage more data than ever, and that trend will continue. The number of apps, services, and platforms we use increases yearly in this environment. Thus, we must standardize, streamline, and optimize our ability to manage the ever-growing list of systems and their data, and in this session, you will learn how to do precisely that. Conquering your data can help improve efficiency and effectiveness and reduce costs and errors within your organization. This course will teach you various ways of sharing data easily between different applications, platforms, and services. Further, you will learn about various tools, desktop application functionalities, and programming tools to manage this process. Participate in this session to truly integrate your data and reap the benefits of improved efficiency and control.
2024 Guide to Deducting Travel, Meals and Entertainment Expenses
-
Online
4.00 Credits
This program will explain the new rules for deducting travel, meals and entertainment expenses and the TCJA disallowance of business entertainment expenses. Documentation requirements and planning opportunities related to travel, entertainment, and automobile expenses 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.
Assessing the Real Ethics of an Organization?, featuring Joe Oringel, MBA, CPA, CIA and Don Minges, MBA
-
Online
1.00 Credits
Every organization claims to be ethical, but words and deeds do not always jibe. How do you assess the real Ethics of an organization? What are the key factors and behaviors to be aware of? Many organizations lack prescriptive policies, but is that an excuse to deviate from the spirit of doing the right thing? How can professionals abuse ‘what is right’ and circumvent policies for their personal benefit. What are some egregious examples of violating policies? How allowing exceptions invites abuse. This seminar outlines steps to gauge the ethics of an organization.
Sticky Ethical Choices, featuring Bob Mims and Don Minges
-
Online
1.00 Credits
If ethics were easy, then why do so many professionals have a Code of Conduct? Some Ethical decisions are easy, others are not. We will discuss several thorny ethical issues and the ramifications. What are the considerations and evaluation criteria to use? The need to carefully deliberate alternatives – is paramount. Be aware.
Internal Control Frameworks for Single Audit
-
Online
1.00 Credits
The Uniform Guidance identifies COSO and Green Book as best practices in internal control. This course will cover the background on COSO and its 2013 update. We’ll also review the application of COSO to Green Book. Attendees will learn how to leverage Part 6 of the Compliance Supplement for documentation of internal controls.
The Ethics Hour: I Can't Believe This Really Happened - Real World Ethics Stories
-
Online
1.00 Credits
You may have read all sorts of stories in books about how bad people steal and make their coworkers and organizations miserable. Come hear veteran Internal Auditor Rob Berry and veteran CFO John L. Daly discuss situations they have seen in the real world.
The Education Advantage: Strategies for Boosting Employee Retention and Engagement
-
Online
1.00 Credits
In the dynamic landscape of modern workplaces, the ability to retain top talent and foster employee engagement is a key determinant of organizational success. "The Education Advantage" is a one-hour program designed to help HR professionals, employers and employees understand: Turnover Costs Cost of Disengaged Employees Professional Development as a Strategic Imperative Employer Hesitations How to Embrace Professional Development Initiatives Types of Educational Opportunities This one-hour session is ideal for HR professionals, managers, and organizational leaders seeking tangible solutions to elevate employee engagement and retention through strategic professional development. Elevate your workforce and organizational success with "The Education Advantage."
The Ethics Hour: Ethics in the Real World
-
Online
1.00 Credits
Business ethics is not just something “nice to do” but can mean the difference between success, failure, and survival in today’s increasingly competitive environment. This seminar outlines steps to create an ethical business culture and provides specific ways for financial managers to make better ethical decisions.
The Great Divide - Successful Collaboration Across Generations for HR Professionals
-
Online
1.00 Credits
In this session, participants will delve into the differences and similarities that coexist between the Baby Boomers, Gen X, Millennials, and Gen Z in the workplace. Guided by generational whisperer, Summer Jelinek, this immersive session will equip HR professionals with actionable strategies to foster understanding, drive productivity, and promote a harmonious working environment, irrespective of generational backgrounds.
The Ethical Side of Trust, featuring Richard A. Karwic and Don Minges
-
Online
1.00 Credits
You and I have a responsibility to our organizations and to the public to be ethical. We cannot forget this responsibility and this responsibility is constant. One lapse can cause profound issues that last. Ethics and trust are intertwined, no one follows a ‘leader’ who is not trusted. We will not focus on the negative and show the problems caused – rather, we focus on what and how to set the example for others to follow. This seminar outlines the seven components of trust, and how we should use these components daily.
2024 Performance Management - Hiring to Retiring
-
Online
1.20 Credits
How you onboard a new employee is critical in ensuring they understand your company culture and are immersed properly in your organization. On the flipside, in the event you are dealing with an employee termination, this too is critical in handling with care and sensitivity.
2024 Resolving Ethical Dilemmas-You Make the Call
-
Online
1.50 Credits
By now, we should all understand the ethical obligations we have as CPAs. So, theoretically, if we just all agree to remain ethical, we should not have CPA ethical violations. But, of course, our professional ethics committees still have plenty of cases to investigate. This session will examine several ethical frameworks, including the AICPA’s Code of Professional Conduct’s and the GAO Yellow Book’s Threats and Safeguards approach to remaining ethical and resolving ethical dilemmas. The session will present several ethical case studies that illustrate the complexities of and challenges to staying ethical. By exercising our “ethical muscles”, we should be better positioned to effectively deal with the ethical dilemmas that we will inevitably encounter.
The Controller Function - Elevating the Role
-
Online
1.50 Credits
This is the beginning of a series that will cover major aspects of the Controllership function. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc., the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. A Controller is an individual who has responsibility for all accounting-related activities including high-level accounting, managerial counting, and finance activities within a company. The duties of a Controller include assisting with the preparation of the operating budgets, overseeing financial reporting, and performing essential duties relating to payroll. However, in today’s evolving world, the Controller function can provide much more in-depth value to their organizations. This series is dedicated to exploring the traditional Controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. In this first course we focus on the typical Controller function and begin to identify ways to elevate the function.
The Civil Advantage: Ethics and Civility in Disquieting Times
-
Online
2.00 Credits
Most people dislike capricious judgment, intolerance, crime, shaming, blaming, punishing, unequal treatment and predatory opportunism. Yet we witness, hear about or directly experience one or more of these uncivil behaviors daily. What’s going on? It used to be that when incivility in our home, neighborhood, schools, or community spaces harmed us, we counted on shared ethical norms to guide and help. We confidently relied on societal guardrails like the law, regulations or corporate policies for fair remedy. But can we still? These days it sometimes feels like up is down, down is up, right is wrong, wrong is right, the sun rises in the west and sets in the east. Even our ethical compass doesn’t seem as reliable as it used to. We’re not crazy to feel unanchored or anxious. Americans live in a moment when our constitutional federal republic and Western ethics face enormous challenge from those who would prefer a different construct. Desiring change is one thing, but abandoning civility in its pursuit results in ethical chaos, societal breakdown, and individual misery. This holds true for human groups small and large, from the family to the federal government.
2024 Excel Tips & Tricks for the Non-Accountant
-
Online
2.00 Credits
You don’t need an accounting degree to harness the power of Microsoft Excel. This course shows how Excel makes sense beyond dollars and cents. We will focus on fundamental concepts for creating, editing, and utilizing Excel content. Participants will learn how to use Excel’s menus and other functions to craft Excel workbooks. Because this course is designed for newer users, we intentionally offer a broad overview of Excel’s numerous capabilities with in-depth coverage of selected resources tailored for non-accounting applications.