CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Digging Deep with Excel Pivot Tables
-
Online
1.00 Credits
This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables.
K2's The Best Kept Secrets Of Microsoft 365
-
Online
2.00 Credits
Many organizations have implemented Microsoft 365/Office 365 at a basic level, but few have truly explored the breadth and depth of tools included with their subscriptions. Some less commonly known apps help you manage shared email boxes, create and use web forms, schedule appointments, trade shifts, create real-time closed captions, and translate presentations. Attend this session and learn more about the hidden features in Microsoft 365 that you can use to level up your productivity.
Excelling at Excel: Tips, Tricks and Updates
-
Online
2.00 Credits
Unlock the full potential of Excel with our comprehensive training on shortcuts and formulas. This course is designed for CPAs and financial professionals who want to enhance their efficiency and accuracy in Excel. Learn how to navigate and utilize different versions of Excel, discover powerful new functions, and master the art of creating effective tables and automations. With practical examples and hands-on exercises, you'll transform your Excel skills, making your daily tasks quicker and more precise. Plus, benefit from insider tips and tricks drawn from the instructor's extensive real-world experience. Whether it's mastering keyboard shortcuts that save you time or applying formulas that simplify complex calculations, you'll gain practical knowledge that you can immediately apply in your work. This course isn't just about learning Excel; it's about learning to excel at Excel.
How to Audit Prepaid Expenses
-
Online
2.00 Credits
Understanding how to effectively audit prepaid expenses is a key skill for audit staff. This course provides a comprehensive overview of the fundamentals, including the applicable audit assertions and common risks and threats associated with the prepaid expense balance. Participants will learn how to perform substantive auditing procedures to ensure accuracy and reliability, with guidance on applying these techniques to real-world scenarios. Designed to enhance practical knowledge, this session equips auditors with the tools and confidence needed to navigate prepaid expense audits with proficiency.
Building Your Personal Net Worth: Invest in Your Future
-
Online
2.00 Credits
By the nature of our work and training, financial professionals have more personal finance knowledge than the general population. However, sometimes we spend so much time planning our company's future that we neglect or defer taking steps to build our own personal net worth. If you are dissatisfied about the speed that you are accumulating savings, this session will help put you on the right track. Even if you are meeting your goals, this session will provide insights and ideas which will add to and reinforce what you may already be doing.
Ethics at Work: Diversity, Equity and Inclusion
-
Online
2.00 Credits
Embracing and cultivating Diversity, Equity and Inclusion (DEI) in the workplace IS Ethics at Work! This session explores ethical values and principles related to these initiatives and examines workplace behaviors, individually and collectively, that foster and promote organizational well being. Robbie offers findings on strategies that work to improve DEI efforts based on best practices and interviews with experts in the field. Please note that for those of you who have taken courses from Robbie there will be some duplication and much new content. This session is designed for people who wish for a more fair and just world and workplace. 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 Excel Tables and Conditional Summing
-
Online
2.00 Credits
In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.
Critical "Soft" Skills for CFOs and Controllers
-
Online
4.00 Credits
Accounting and finance managers and executives must demonstrate sound soft skills necessary for personal growth and organizational success. This course will provide insights into the most crtical personal skills critical for CFOs and Controllers - or those that want to be!
K2's Improving Productivity With Microsoft 365/Office 365 Cloud Applications
-
Online
4.00 Credits
Many Microsoft 365/Office 365 subscriptions include robust Cloud services for improving productivity. Foundational services, such as SharePoint Online, OneDrive for Business, and Exchange Online, join with other powerful tools such as Teams, Planner, Power Automate, Forms, and Power Apps to provide a productivity platform second to none. Unfortunately, most users will never benefit from working with these tools simply because they remain unaware of these features. Plan to attend this session to learn about the “rest of 365” and how these Cloud-based applications can enhance personal and team productivity while simultaneously facilitating remote working arrangements. Don’t miss this opportunity to get all the knowledge and guidance necessary to leverage your investment in Microsoft 365/Office 365 fully.
Building a Better Budget in a Time of Uncertainty
-
Online
4.00 Credits
Most financial leaders would agree that budgeting is easy when business and the economy are stable. When revenues and expenses are expected to remain the same, the process becomes merely an exercise in carrying over what was done before to the current year. However, what happens when we are not sure about how the market will react to our product? What happens when the competitive landscape changes? In this course, we will discuss budgeting techniques and considerations when business lacks stability. Through a combination of theory and real-world examples, we will explore how to build flexibility into our budget - so that it can inform and drive decision-making when we don't quite know what is ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Consulting Services Secrets
-
Online
1.00 Credits
Award winning discussion leader Mark Hugh discusses how to create and capture value with consulting services. Whether you want to consult a little or full time, this valuable course reviews identifying a specialty, growing a practice, capturing value, creating deliverables, and effective marketplace marketing strategies.
Criminal Tax: How CPAs Bring Value to Defense Attorneys
-
Online
2.00 Credits
CPAs can be requested to assist attorneys in litigation support in criminal proceedings. For criminal tax cases, the IRS has recommended prosecution. However, the rules and stakes are different than a simple civil audit. This presentation will focus on how to assist defense attorneys in calculating tax loss, asking the right questions, and probe possible weaknesses in criminal tax investigations. 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 Saving Time With Electronic Forms
-
Online
1.00 Credits
Web portals, "low-code/no-code" data collection, and survey tools have changed how we collect data. Modern solutions like Microsoft 365 Forms, Zoho Survey, SurveyMonkey, Microsoft PowerApps, and legacy tools like Adobe Acrobat Forms allow users to create web forms and integrate the resulting data into business process workflows. This session introduces the range of available tools, demonstrates standard features, and shows how tools permit users to expose or conceal questions based on answers given earlier in the survey. Attend this session to learn how to use tools you already own to efficiently collect data from your team, customers, and vendors.
Casualty Losses: Disaster Relief Act of 2024
-
Online
1.00 Credits
Literally thousands of individual taxpayers may have increased deductions or exclusions from gross income as a result of the Disaster Relief Act of 2024! Casualty provisions of the Act are retroactive to December 19, 2019 through early 2025. Both low and high income taxpayers may benefit from the Act through exclusions of payments received as compensation for wildfire damages - retroactive to 2014! This course will review the provisions of this new act. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
SOC Mastery for CPA Firms: Your Roadmap to Starting a SOC Practice
-
Online
1.00 Credits
In the realm of modern business, the trend of outsourcing functions or activities to third-party service providers is on the rise. While this strategy can enhance efficiency and cost-effectiveness, it also introduces inherent risks that necessitate careful identification, assessment, and management. As a result, those utilizing such outsourced services, along with their auditors, increasingly demand comprehensive insights into the effectiveness of controls within these service organizations. To fulfill this need, the AICPA offers a range of SOC (System and Organization Control) for service organizations engagements, providing assurance reports that offer vital information for evaluating and mitigating the risks tied to outsourcing, thereby fostering trust and transparency. This webcast serves as an introduction for CPA firms who are new to SOC for service organizations engagements or as a refresher for those already acquainted. It does not delve into the specifics of conducting a SOC examinations; however, it offers a general understanding of how to start up a SOC practice.
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.
Ethics in Communicating & Reporting
-
Online
1.00 Credits
This course on ethics in communication and reporting covers essential topics to ensure integrity and professionalism in our interactions. We begin with the fundamentals of ethical communication, emphasizing the importance of honesty, transparency, and respect. We then explore four must-have communication skills crucial for effective and ethical exchanges. The session also provides practical application steps on how to improve these ethical communication skills in daily practice. Finally, we discuss the problems associated with unethical behavior in reporting and communication, highlighting the potential consequences and the importance of maintaining ethical standards to build trust and credibility.
Revenue Recognition - Allocate the Transaction Price
-
Online
1.80 Credits
The updated revenue recognition standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry.
The Controllership Series - The Treasury Function Part 1 - Cash and Investing
-
Online
2.00 Credits
This course corresponds to our Controllership series. This course is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we discuss the area of cash and investments and explore how the controller can move these responsibilities into more of a strategic role. In today’s world, the role of cash management is often a pivotal role in the organization. In economically difficult times, controllers may find that they spend a great deal of their time on understanding and managing the organizations' cash position. This is certainly important and, in some areas, can be seen as a staple of the lifeblood of the organization’s ongoing viability. This course takes a look at some of the typical objectives involved in Cash management and then evaluates how those objectives can be further stretched into strategic pillars of the organization.
K2's Backups Done Right
-
Online
2.00 Credits
Where is your data? Do you have it controlled and backed up? If all your data is in the Cloud, how do you verify that the backup recovery is rapid? If your data is in various silos from your application providers, how do you ensure you have the protection and disposal approaches needed? This session will help you understand and guide your IT team and providers to take the right actions to protect your business. Backup considerations, including Cloud, backup appliance, disaster recovery, and business continuity approaches, are included. If you are from the "trust but verify" school of thought, this session will help you ask the right questions.