CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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.
Social Media: The Bare Necessities
-
Online
1.00 Credits
Social media has become a ubiquitous phenomenon in our business world. However, just because it exists is not a good reason to use it. This workshop is designed to give you an overview of the social media landscape to help you decide if you want to engage with and on social media and, if so, what channel(s) are most strategic for you and your business. The workshop ends with a simple framework to help you use social media as a credibility strategy for your business, giving you a strategy for creating a year's worth of social media content in a single day.
Giving Feedback that Delivers Results
-
Online
1.20 Credits
Many people, when they hear about feedbcak in organizations and the workplace, think immediately of performance reviews. But feedback should not be isolated to these formal structures. This workshop is about the more informal methods of feedback that managers and coworkers can use to have more productive conversations that drive behavioral change. Through understanding the importance of dialogue, strategic questions to drive conversation, and mistakes to avoid, you'll be able to have more productive feedback conversations in your workplace (and maybe even at home, too).
2024 Performance Auditing Made Easy
-
Online
1.50 Credits
Unlike a traditional financial audit objective (Are the financial statements materially misstated), performance auditing can address a wide variety of objectives. Is this program working? Can it be improved? Where can we save money? How can we operate more efficiently and effectively? Are management’s assertions supported? And so forth. This session will explain what a performance audit is, describe the applicable standards, and provide examples that indicate the value of a performance audit. Performance audits can add value to any entity and practitioners can profit from adding these assurance services to their practices.
GASB 96 -SBITA, GASB 94 P3, and GASB 87 Leases (Year 2)
-
Online
2.00 Credits
This is a 2 hour webcast that will focus on the similarities between all three of these GASB accounting standards that deal with contractual arrangements such as leases, Subscription-Based Information Technology Arrangements (SBITA) and P3s. Compare and contrast these standards as you prepare for implementation this year of GASB 94 and GASB 96, and review the implementation efforts of Leases in Year 2.
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
In this comprehensive course, practitioners gain a deep understanding of strategic planning considerations and potential hurdles encountered when clients face difficult circumstances. Delving into an array of scenarios often classified as "challenging," the course offers tax insights. From divorce and personal bankruptcy to intricate personal relationship matters, participants will equip themselves to adeptly guide clients through these challenging scenarios by understanding the tax implications.
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?
Advanced Cost Accounting
-
Online
2.00 Credits
Organizations that use primitive costing methods make predictable mistakes. They allocate too much cost to easy, high-volume "gravy" products and too little cost to difficult, low-volume "dog" products. This puts the organization with inferior information at a significant disadvantage against a competitor who has a better cost model. The secret to having a great cost model is learning how to deal with overhead. This webinar will show you how to assign 16 key categories of overhead. Whether you work in a wholesale, retail, health care, service or manufacturing business. This session will give you important insights into how to handle overhead. If you get your costing right, you will be able to give the "dogs" to your competitors and keep the "gravy" for yourself.
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.
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.
Governmental Accounting 101
-
Online
2.00 Credits
Governmental Accounting 101, is a 2 hour webcast that takes the participant of a whirlwind tour of governmental accounting basics, focusing on wetting the participant’s appetite for more. This session will be the first of a series of webcasts, with each subsequent webcast delving deeper and deeper into the governmental accounting basics.
The ABCs of Advisory Services
-
Online
2.00 Credits
Over the next decade, the area of “Advisory Services” has the greatest potential for growth in your practice. Complexities within your clients’ financial, estate, and asset protection plans coupled with the ever-changing Internal Revenue Code has created an opportunity for the CPA, the EA, and other advisors to expand their client offerings. This course provides the practitioner with the framework for practice expansion as well as an understanding of a variety of necessary issues and techniques.
2024 White-Collar Crime: What Every CPA Should Know
-
Online
2.00 Credits
According to the FBI, “white-collar crime is … synonymous with the full range of frauds committed by business and government professionals … characterized by deceit, concealment, or violation of trust …. The motivation behind these crimes is financial—to obtain or avoid losing money, property, or services or to secure a personal or business advantage.” CPAs can and should play a crucial role in preventing and detecting white-collar crime, as well as in prosecuting the perpetrators. This session will explore whether we are up to this challenge, heighten awareness regarding the CPA’s role as a front-line defender of the public interest, and assess whether we are deserving of the public trust we enjoy.
Big Picture Mega-Trends, Big Data, and World We Now Face
-
Online
2.00 Credits
It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize.
Devious Ethics: Avoiding Snakes in Suits
-
Online
2.00 Credits
Good people believe everyone else is just like them. They cannot imagine someone could con them or their company and have no guilt or remorse about what they have done. Lack of guilt and empathy are key traits of a psychopath. Most of us envision psychopaths to be cold-blooded serial killers who are locked away in prison. However, experts estimate that 4% of corporate executives are psychopaths who may initially appear to be more normal than the rest of us. Psychopaths may present a convincing picture of virtue while helping themselves to money, status and sex while leaving a path of shattered expectations, empty wallets, and broken hearts in their wake. Learn how to recognize and deal with others who have no conscience.
Cost and Pricing Models: Creating an Effective Tool
-
Online
2.00 Credits
If sales increase, so should profits. Yet, the opposite result often leaves executives 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 underprice difficult, low-volume work. This session discusses how to use activity-based costing data to build accurate costing models that consider far more than just the labor and materials necessary to provide goods and services.
Managing Your Money in Retirement
-
Online
3.00 Credits
You spent your life building retirement savings. Now you want to make sure your savings last the rest of your life and perhaps pass some on to the next generation. Come hear a veteran financial educator talk about money management and planning issues for this phase of your life.
Navigating Difficult Conversations with Clients
-
Online
1.00 Credits
When you're working with clients, it's not always smooth sailing (though we wish it was). Often we need to have difficult conversations. Whether it's to overcome objections, negotiate a new contract, or manage a conflict, these conversations can be navigated successfully with the right tools. This workshop gives you those tools and an understanding how how the human mind works when it comes to processing communication in difficult situations.
Audit Risk Assessment in Plain English
-
Online
2.00 Credits
Audit Risk Assessment in Plain English, is a 2 hour webcast highlighting the AICPA’s clarified risk assessment standards, along with a new Statement on Auditing Standard (SAS 145) related to understanding the entity, the entity’s environment, the entity’s internal controls, and assessing the risks of material misstatement. This session will attempt to simplify the requirements using common sense examples and language.
Staff Retention Keep the Best People
-
Online
3.00 Credits
The COVID pandemic changed the way many people worked, yet others have had remote teams for decades and little changed. Many organizations trying to bring people back to the office have experienced significant turnover. Some practices have changed forever while some principles will always remain the same. Keeping your people happy equals keeping your best people. Learn the changes you should make now and the things you should do forever!