CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's The How's And Why's Of Data Analytics
-
Online
2.00 Credits
Increasingly, accountants and auditors are called upon to use data analytics to understand and improve results. Yet, many professionals struggle with the concept of data analytics and remain unaware of how to obtain the results needed using tools they already own. In this session, you will learn about the four primary types of data analytics and when to use each. Further, you will learn how to generate meaningful analytical measurements using Excel, Power BI, and other tools and, more importantly, how to interpret the results. If you seek to use data analytics – and who isn’t – this session is for you.
Taking Advantage of Array Formulas in Excel
-
Online
2.00 Credits
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Learning to Teach "Tax" as a Second Language
-
Online
1.00 Credits
Sometimes the vernacular of accounting seems more challenging than technical aspects. This session offers suggestions for translating the foreign language of taxation into tangible terms for non-accountants. We explore techniques for simplifying the complexity of taxation terminology. This course will equip you with tools for demystifying tax technicalities so you can help clients and other non-tax professionals grasp fundamental concepts. 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 Taking Another Look At Power BI
-
Online
2.00 Credits
Although Power BI has been available for ten years, most business professionals don't fully appreciate all it can do and its easy use. Further, many are intimidated by the platform and continue to use less efficient and effective reporting practices. If this describes you, invest some time in this session to learn how to work with Power BI almost immediately. In this session, you will learn how to use Power BI to create compelling dashboard reports. You will also learn how to optimize these reports to enhance their effectiveness. If you want to improve financial and operational reporting processes, this session is for you!
All About Fraud - Examples, Prevention and Auditing
-
Online
4.00 Credits
Fraud is constantly in the news. Whether it's employee retention credit mills, FTX, or the City of Dixon, it appears that fraud is everywhere. We'll start this session with a review of the common fraud schemes as identified in the 2024 Report to the Nations. We'll also review the commonalities of fraudsters. We'll then look at methods of prevention. We'll close with a look at the auditor's responsibility for the consideration of fraud in AU-C 240.
Independence for Auditors - AICPA, PCAOB, GAO & DOL
-
Online
4.00 Credits
This course will look at the various rules related to Independence and compare and contrast the requirements. This overview course will help auditors understand the nuances of independence and ensure they meet the requirements to perform attest services for their clients. We will review the requirements for the AICPA, GAO, DOL, and PCAOB.
It Is Legal, But Is It Really Ethical?, featuring Rob Berry and Bob Mims
-
Online
1.00 Credits
This discussion outlines situations where ‘legal’ and ‘ethical’ are not necessarily in alignment. How should you handle these issues? We will detail a better thought process to help you avoid ‘crossing the line.’ Each topic and each day stand on its own. If you are not sure about making a multi-day commitment, sign up for just a single day. We think you will come back for more!
Ethical Situations - What to do When?, featuring Allison McLeod and Don Minges
-
Online
1.00 Credits
What would you do when ___? Is would the same as should? Examples; Rashmi Airan-Pace and Yale Law School. What should you do when a vendor offers to give you tickets to the NCAA Final Four basketball tournament and your organization will permit it? Prepare for ‘situations’ before they happen to you.
Securing Executive Buy-In for Your Initiatives: Communication Techniques to Persuade Decision-Makers
-
Online
1.00 Credits
For HR and Business professionals, navigating the intricate dynamics of executive decision-making can often be a daunting task. Despite the meticulous hours invested in research, strategy formulation, and planning, the true challenge often lies in effectively communicating and gaining acceptance for these transformative ideas. A key aspect of this is the art of persuasion, ensuring that the merits of our proposals are not just understood but wholeheartedly embraced by decision-makers. This session is designed to empower leaders with the tools and insights needed to craft persuasive pitches, build a robust business case, and confidently communicate the ROI of their initiatives. Moreover, attendees will gain insights into the common pitfalls that can hinder their pitches and learn techniques to address objections frequently raised by executive leadership.
Public Speaking and Confident Communication in Business
-
Online
1.00 Credits
No matter what role you play in your professional life, being able to command an audience--whether of one or of thousands--is an important skill. Public speaking, no matter how you slice it, is a practice that is worthy of attention. This workshop teaches you approachable strategies to improve your public speaking and presentation skills, recognizing that everyone comes with different comfort levels and experiences. There is no one-size-fits-all speaking style, and trying to force yourself into a specific presentation persona can be more harmful than helpful. Learn actionable tips to help you be more confident next time you need to take the proverbial (or literal) stage.
The Controller Function - Strategic and Annual Planning
-
Online
1.20 Credits
This course corresponds to our Controllership series. Within this course, we specifically address the Controllers role and pro-active potentials in organization Strategic and Annual Planning. This series of courses 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. 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. When it comes to the task of strategic planning, many feel this role is primarily the responsibility of the executive team and board. However, in this course, we delve into the various steps of the strategic plan and explore where the Controller can add strategic value through providing functional input and insight. Strategic planning is a process used to identify goals, the strategies necessary to accomplish those goals, and the internal performance management system that will be used to monitor and evaluate progress.
AICPA Statements on Standards for Tax Services: Ethical Considerations
-
Online
2.00 Credits
The AICPA revised the Statements on Standards for Tax Services, providing the framework for the AICPA ethical guidance for tax practitioners. This program will review the new standards that apply to all members who provide tax services, effective January 1, 2024. This course does not quality for IRS credit.
Roadmap to Ethical Decision Making
-
Online
2.00 Credits
Practitioners need to exercise caution to ensure they maintain independence as they assist their clients with reviews, audits, and compilation engagements. This course provides a roadmap to best practices and guidance provided by the AICPA's Code of Professional Conduct and analyzes and applies it to actual scenario-based case studies, providing accounting professionals with ethical standards to integrate into their practices.
Ethical Intelligence for Artificial Intelligence
-
Online
2.00 Credits
Organizations and individuals enticed by the siren song of artificial intelligence cannot ignore ethical considerations. Professionals must consider accuracy of information, data privacy, independence, source citations, organizational policies, security, data retention, and other ethical matters. This course discusses ethical issues associated with the utilization of AI in a professional setting and provides suggested best practices.
Keys to Building an Inclusive and Culturally Competent Workplace: A Guide for HR Professionals and Business Owners
-
Online
1.80 Credits
HR Professionals are business leaders who, regardless of their level of experience, are responsible for maintaining a high level of interpersonal proficiency in their job function. The willingness to gain a genuine understanding and respect for diversity and the incorporation of a safe and inclusive environment of employees in the workplace, is a strong measure of the HR Professionals’ efficacy in this area. This training is geared towards improving and/ or elevating the HR Professionals’ knowledge of cultural competence in the workplace and what it means to truly adopt a culture of diversity and inclusivity. When HR professionals take responsibility for teaching others about the differences and benefits that multiple cultures and diverse backgrounds bring to the organization, research shows that companies are more likely to win top talent and yield improvement in customer orientation, employee satisfaction and decision making, as well as a cycle of increasing returns.
Forgotten Managerial Accounting Tools
-
Online
2.00 Credits
This session explores managerial accounting techniques with an emphasis on internal decision-making tools. You will appreciate a reminder regarding concepts you may not have considered since your college days. We will revisit managerial accounting concepts by illustrating practical examples that you can immediately bring back to the office!
K2's CRM - The Ultimate Business Automation Tool
-
Online
2.00 Credits
This course provides an in-depth exploration of Customer Relationship Management (CRM) systems as a critical tool for business automation. Designed for accounting professionals, it emphasizes CRM's role in streamlining workflows, organizing communications, enhancing client relationships, and improving efficiency. Participants will learn about key CRM features, integration with accounting software, and best practices for successful implementation. We will highlight practical applications with actionable insights to help attendees optimize their processes. This two-hour session ensures you walk away with a basic understanding of CRM's transformative potential for business and financial management.
Common Deficiencies in SSARS Engagements
-
Online
4.00 Credits
Preparation, compilation and review engagements continue to be a hot topic for peer review despite SSARS 21 having been around for nearly a decade. This course will concentrate on the most common peer review findings with a focus on how to comply in an efficient but practical perspective. This course will discuss the root cause of noncompliance so that overall engagement quality increases.
Depreciation and Capitalization Guide: Optimizing Business Assets
-
Online
4.00 Credits
This presentation highlights the latest legislative changes affecting depreciation and capitalization rules, including inflation increases and Section 179 and 168(k) deductions. Planning and potential pitfalls will also be presented. **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.
Real Estate Tax Update
-
Online
4.00 Credits
This program addresses the recent changes imposed by recent tax legislation that real estate owners and investors need to know, including Section 199A, the new Section 163(j) interest expense limits and the opportunity to elect out. An introduction to opportunity zones and other important issues 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.