CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's 2023 Excel Tips, Tricks, and Techniques for Accountants
-
Online
8.00 Credits
Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.
2024 Annual Update for Accountants & Auditors
-
Online
8.00 Credits
This course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We'll then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. We'll also review year 2 considerations for leases including modification accounting. Then we will switch gears, switching to the audit side of the house. We'll review the impact of the changes to auditing group audits as well as the status of the AICPA's quality management project management. This course will keep auditors up to date on the work of the ASB. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Performing a Single Audit Under the Uniform Guidance
-
Online
8.00 Credits
Performing a single audit Exploring various topics related to single audits will give you the knowledge you need to perform these engagements skillfully. You can learn about: Major program determination Pass-through entity responsibilities SEFA requirements The Compliance Supplement requirements The administrative requirements and cost principles found in the Uniform Guidance Uniform Guidance compliance audit basics Gaining an understanding of the Uniform Guidance basics will prepare you for compliance audit engagements. You can examine various topics, such as: Requirements overview Applying GAAS and the Yellow Book to compliance audits Entities that must undergo this type of engagement Federal awards decoded You can also learn the different types of federal awards, along with audit implications for a recipient or subrecipient. Federal award topics covered include: Becoming aware of the SEFA Major program determination Testing and reporting responsibilities You will acquire a fundamental understanding of your responsibilities related to testing and reporting by examining topics, such as: Testing internal control over compliance Testing compliance Writing an audit finding
Erase the Mark: Best Practices in Penalty Abatement
-
Online
2.00 Credits
If there is a potential error, the IRS will assess a tax and add a hefty penalty, without even knowing the facts. As a tax professional, you will be exposed to the IRS and their methods of penalizing taxpayers for the smallest of violations. This presentation will focus on the rules and regulations that create the penalty, and the reasons that exist that the IRS will consider to remove those penalties. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Coaching & Counseling - Addressing Misconduct
-
Online
1.20 Credits
The objective of corrective action is to change conduct through teaching. Corrective action may be sequential, out of order, repetitive, or not appropriate to take at all. The action selected should reflect the type, frequency, and severity of the misconduct. Changing conduct through teaching requires effective employee relations skills. This course provides practical knowledge and scripts for handling a wide array of sensitive misconduct situations with good judgment, such that personal and employer liability is avoided.
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.
Allison McLeod's 2024 Federal Tax Updates for Business Entities - 8 Hour
-
Online
8.00 Credits
The tax landscape is constantly changing, challenging tax practitioner to stay abreast of these developments. This eight hour program will cover issues unique to business entities, including new court decisions, recent IRS publications, and the latest tax legislation that will impact businesses and individuals. The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner. **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 2024 Excel PivotTables for Accountants
-
Online
8.00 Credits
Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.
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.
2024 Internal Controls for Small and Medium-Sized Entities
-
Online
1.00 Credits
This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities. We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.
Feeling Stressed from Change & Uncertainty? How to Stay Positive when Things Get Tough
-
Online
1.60 Credits
When we’re going through change and life feels out of balance, it’s normal to get stuck focused on all the problems and challenges that stress us out. How will the changes impact our team, our job, our lives? It doesn’t help that our brains are wired to anticipate the worst possible outcome. This wiring can make it difficult to be our best; to provide our best teamwork, our best ideas, and our best leadership. However, studies show that there are things we can do to shift our thinking so we can spend more time in positive emotions, like curiosity, enthusiasm, and optimism. Now everything gets easier and better, including: ~ Productivity ~ Customer relations ~ Change management ~ Teamwork ~ Leadership Join Tina to learn and apply The Path for Positivity™ framework based in Positive Psychology. You will learn strategies and insights to help you experience less stress, a smoother transition, and higher productivity even when the future seems uncertain. Share the framework and strategies with your team, too.
2024 Inflation Reduction Act of 2022: Review and Update
-
Online
2.00 Credits
This program will examine the key provisions of the Inflation Reduction Act of 2022 that was enacted to not only curb inflation, but reduce the deficit, promote clean energy solutions, and much more. Learn how this new legislation can provide tax savings for both your individual and business 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.
Audit 503: Management - Being a Balanced Leader-Manager
-
Online
2.00 Credits
Management Skills - Exhibiting Traits of a Balanced Leader-Manager provides tips and techniques for striking the right balance between managing individuals and engagement teams and leading the overall strategic direction of a firm. Short-term profitability and long-term viability are important objectives of any successful organization. Note: This course is recommended as a part of a 16-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for leading or managing others. 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 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.
Leadershift: Drive Results Through Ethical Performance Mgmnt
-
Online
4.00 Credits
Do you find yourself challenged to achieve the results you want? While leading employees can be one of the most challenging activities, it is also one of the most impactful leadership skills few seem to master. Inspirational leadership looks like lifelong employees reaching their full potential AND impactful business results that are repeated year after year. Striking the balance between these two critical aspects does not have to be rocket science. In this power-packed course, the formula to be an Inspirational leader has been masterfully developed and covers the soft skills of Inspirational leadership and the Results Model: Goal Setting + Coaching + Follow Up with proven results from dozens of both large and small companies. These cornerstones are simple but can be hard to execute because it is HOW you do it first, then WHAT you do second. This exciting course is designed to ignite your leadership skills by putting theory into practice; drilling into real live examples and experiencing first-hand what excellence sounds like through role-playing and building your action plan. Get ready to become an inspirational leader and learn the steps required to get the results you really want. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Ethic of Self-Esteem For Women
-
Online
2.00 Credits
Ethics is ultimately about our relationship to ourself, others, and the world in which we live. Therefore, to enhance our relationships with those around us, we must first start with the regard we hold for ourselves. From an ethical vantage, it can be said that we have a moral obligation to work toward self-love, honor, and respect. Matters of self-esteem are important in every aspect of life including goal setting, relationships, establishing boundaries, handling conflict, levels of productivity, and expressing our needs in respectful and dignified ways. This course explores traps of low self-esteem and ways to minimize those traps. We also explore components of high self-esteem and actions to foster higher regard for self. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Building Trust in Remote Teams: Catalyze Collaboration and Communication
-
Online
1.00 Credits
How do you keep your team connected with the limitations of virtual meetings? Suddenly, it’s more important than ever for each member to understand and appreciate their differences; to see beyond the screen and see each other’s human-side to maintain trust. In this session, Tina Hallis, Ph.D., will explore the neuroscience of trust and why it’s critical for optimum teamwork. But more importantly, you will leave with specific strategies and tools that you can choose from to use with your people.
Prioritizing Mental Health in the Post-COVID Workplace
-
Online
1.20 Credits
Over the last few years, mental health has become more of a mainstream issue. In fact, statistics indicate that approximately one in four adults experience a mental health condition. Therefore, it is more important now than ever for organizations to make mental health and wellness a priority, given all the rapid changes leading to higher levels of stress and uncertainty in the post-COVID workplace. The goal of this course is to outline the signs of mental health challenges in the workplace, such as changes in behavior, mood, or performance, while providing practical strategies for HR Professionals and Business Leaders to build and implement accommodations for a mentally healthy work environment.
Preparing for & Conducting Discharge Meetings
-
Online
1.20 Credits
Over 80% of all employment-related lawsuits relate to termination. Every termination should be treated as a potential lawsuit. The facts supporting a leader's recommendation of discharge must be fully investigated. The discharge of an employee requires prior review and approval. Narrow self-interest, spite, or personal animosity must not play a part in making termination decisions. This course provides practical knowledge and scripts for handling discharges with good judgment such that personal and employer liability is avoided.
Maintaining a Harmonious Working Environment
-
Online
1.20 Credits
A harmonious working environment is one in which people feel safe, seen, heard, and respected. Critical to maintaining it are that employees have high self-esteem, are treated with respect, and work in a safe, non-violent setting. This course provides practical knowledge and scripts on how to take appropriate action and deal effectively with discriminatory comments, sexual harassment, and threats and acts of violence,such that personal and employer liability is avoided.