CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's Advanced Excel
-
Online
8.00 Credits
If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.
K2's Ten Must Know Features In Excel
-
Online
2.00 Credits
Most business professionals have used Excel for years, often without the benefit of any formal training. Thus, they don't know about key features in the application and, therefore, don't use them. Of course, this leads to inefficiencies and errors. Isn't it time to stop this madness? This session is for you if you're ready to become more efficient and effective with Excel! You will learn ten critical features that can help you get more work done in less time and improve your accuracy. We encourage you to make plans to join us for this session to learn the best ways of working with Excel!
Understanding the New Forms K-2 and K-3
-
Online
2.00 Credits
Schedules K-2 and K-3 are promulgated by the IRS in order to standardize the reporting of foreign-related tax information for pass-through entities. Even pass-through entities that have no foreign activities, investments, or partners may have a reporting requirement. Schedules K-2 and K-3 for reporting partners' income, deductions, and credits from foreign activity are now required for passthrough returns (Form 1065, 1120-S and 8858). This requirement starts with returns with a tax year that ends in 2021. This course discusses each part of these schedules and explain these new reporting obligations in detail. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Mastering The Three Pillars of Cybersecurity: Team & Compliance
-
Online
1.00 Credits
Are you looking to fortify your practice against the ever-growing threats in the digital landscape? Join us for the third installment of our exclusive webinar series, "Mastering Cybersecurity," brought to you by Practice Protect. In today's digitally connected world, the need for comprehensive cybersecurity is paramount. With cyberattacks becoming more sophisticated, it's crucial to stay ahead of the curve in protecting your sensitive client data. This webinar series is designed to equip CPAs with the knowledge and tools needed to secure their practices and client information effectively.
Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 1
-
Online
1.00 Credits
This course is a continuation of our series on preparing to become a forensic accountant. Within this segment we focus on elements of computer forensics. This session is designed to delve into further investigative procedures used in computer forensics.
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.
K2's Getting Started With Artificial Intelligence
-
Online
2.00 Credits
Much has been written and said about Artificial Intelligence (AI). But for many professionals, AI remains an enigma because they do not know how to get started using tools such as Bard, ChatGPT, and Copilot. If that describes your situation, relax because help is here! Participate in K2’s Getting Started With Artificial Intelligence to learn to use today’s AI tools. This session will teach you how to access and use multiple popular AI tools to improve efficiency and productivity. If you are starting with AI, this is one session you cannot miss!
Real Estate Professionals: Passive Activity Rules
-
Online
2.00 Credits
When do they exist and how to report them? This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. *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
Cost and Pricing Models: Boost Your Bottom Line
-
Online
2.00 Credits
If sales increase, so should profits. Yet, the opposite result often leaves executive’s scratching their heads. When organizations work with inferior cost information, they make mistakes in four specific situations. Bad information causes sellers to overprice easy, high-volume work and under-price difficult, low-volume work. This session discusses how to use activity-based costing to build accurate costing models that consider far more than just the labor and materials necessary to provide goods and services.
Ethics: IRS Behavioral Insights for Accountants
-
Online
2.00 Credits
This course provides a concise overview of how the Internal Revenue Service (IRS) thinks. The session reviews how the agency uses behavioral insights -- the study of how people reflect and behave -- to drive compliance, positively impact taxpayer engagement, and reduce taxpayer burden. While the IRS is governed by federal tax law, it's also shaped by social norms. As part of their mission to collect taxes and administer the Internal Revenue Code, the agency utilizes human psychology to achieve their goals. These activities include public identity (using the IRS logo, seal, and symbol), voluntary compliance (using public shaming and the "Wesley Snipes" effect), trust building (using a Taxpayer Bill of Rights), and error reductions (using alerts and reminders to nudge behaviors). The session reveals how to "get into the head" of the agency and better understand the key psychological factors (individual, environmental, social) that drive leading IRS operations and decisions. The course also spotlights the leading issues and pain-points that are currently "top of mind" for the agency and how practitioners can be more mindful in their interactions with the IRS to improve outcomes. 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.
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.
Creating an Ethical Work Environment
-
Online
2.00 Credits
This session introduces theories on human nature and organizational factors affecting ethical choices. Robbie examines the role of gossip in the workplace, provides tools for ethical decision making and offers concrete actions for creating and sustaining an ethical work environment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Navigating Leaves of Absence
-
Online
1.00 Credits
What obligations does an employer have when an employee needs to take a leave of absence? This presentation will provide an overview of the complicated, intertwined compliance obligations triggered when an employee requests a medical leave of absence (including for pregnancy, mental health, or addiction).
Getting the Most When Selling a Business: Little Details to Get Top Value
-
Online
2.00 Credits
Every business will be sold eventually. When you have built a great business and decide to move on – you want the most you can get for that terrific organization! What are the steps to take to maximize the value realized? What do buyers really want? What are the three levers to achieve maximum value? If you want top dollar, preparing to sell takes years of planning. This seminar helps CEOs, entrepreneurs, CFOs, Board members, controllers, and their advisors prepare for a successful sale of the organization to maximize shareholder value. We will outline the process to get the most bang for the buck. Proper exit planning demands planning and time.
Cryptocurrencies for the CFO: Explaining Blockchain
-
Online
2.00 Credits
What exactly is cryptocurrency and its cousin named blockchain? Are they here to stay? This session will provide a big picture examination of the technologies and currencies by explaining how we got here. We discuss the systems and technical aspects of cryptocurrencies and blockchain. What is the broad view of the technologies that currently do, and will continue to, impact our workplace and lives?
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.
Mastering Microsoft 365 Copilot for CPAs
-
Online
2.00 Credits
Discover how Microsoft 365 Copilot can revolutionize your daily tasks as a CPA. Dive into the specific features and functionalities of this AI-powered assistant. Learn how to leverage Copilot to enhance productivity, automate routine tasks, and improve collaboration within your team. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ask Me No Questions and I Will Tell You No Lies - The Art of Interviewing & Interrogation
-
Online
3.00 Credits
When we verbally communicate with an individual, we must make a conscious decision as to whether we believe what we have heard. Little do we realize that we are not making a decision based on what we have heard; rather we make a subconscious decision based primarily on what we have seen, or how the body was behaving when the subject was speaking. We often walk away from a conversation with a gut feeling that the person was not telling the truth. That gut feeling is your subconscious. Yet we often have no idea as to why we have that feeling. This presentation is designed to provide the participant with the tools to identify those both verbal and nonverbal indicators that we all give off when we are under stress. Normally, telling the truth does not create stress. When we lie, we know that we are not supposed to and that creates stress, and it will manifest itself in some manner, and that is what a trained interviewer is looking to observe. When we observe indicators of deception, how do we deal with it? How do we get the subject to admit to a wrong-doing when it is not in their best interest to do so? That is one of the many things that will be addressed in this presentation. Whether you are a parent dealing with you kids; an employer dealing with employees or and investigation interviewing a suspect, this presentation will provide you with the tools to assist you in finding the truth.
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.