CPE Catalog & Events
K2’s Mastering Advanced Excel Functions
-
Online
4.00 Credits
Member Price: $149
With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. 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. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Staff Retention Keep the Best People
-
Online
3.00 Credits
Member Price: $109
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! Delivery Method: Individual webcast CPE Credit: 3Program Level: Intermediate
Drive Results with Metrics
-
Online
2.00 Credits
Member Price: $89
Many organizations struggle to keep budgets current in an ever-changing business climate. Twenty-first century performance metrics focus on determining what budgets should be rather than what they were in the past. Using performance metrics effectively reduces work, reduces politics, provides flexibility and substantially improves the performance management process. This session will show you powerful techniques to drive your organization’s performance. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Strategic CFO – Strategic Risk Management
-
Online
2.00 Credits
Member Price: $89
Risk management is no longer a compliance exercise-it is a core strategic responsibility of today's CFO and CPA. This session demystifies Enterprise Risk Management (ERM) by walking through the COSO framework in clear, practical terms. Participants will learn how risk integrates with strategy and performance, how organizations identify and assess risk, and how leaders respond to uncertainty in a disciplined way. Using examples, polling, and case discussions, this session equips financial professionals to communicate risk effectively and help organizations protect and create value. Some funny video clips will be used to focus on the learning material. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
The Controllership Series – The Controller’s Skillset
-
Online
1.00 Credits
Member Price: $39
This another course in our series on the controllership function. The controller's role encompasses many traditional responsibilities. The breadth and depth of the controller skill set has expanded and will continue to expand as the business world evolves. The controller position will typically lead teams of financial and accounting experts. Recognizing that leadership and team management skills are must-haves; they need to be able to command their team's respect, inspire them to act, and ensure that such actions are aligned with your organization's overall vision. These skills, along with tactical knowledge will ensure the controller's success. Delivery Method: Individual webcast CPE Credit: 1Program Level: Update
Preparing for & Conducting Discharge Meetings
-
Online
1.00 Credits
Member Price: $39
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. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 3 (Steganography)
-
Online
1.60 Credits
Member Price: $79
This course is a complement to our series on Becoming a Forensic Accountant and the focus of the course is on steganography techniques. Steganography is the art and science of embedding secret messages in a cover message in such a way that no one, apart from the sender and intended recipient, suspects the existence of the message. The first use of steganography can be traced to 440 BC when ancient Greece, people wrote messages on wood and covered it with wax, that acted as a covering medium Romans used forms of Invisible Inks, to decipher those hidden messages light or heat were used. During World War II the Germans introduced microdots, which were complete documents, pictures, and plans reduced in size to the size of a dot and were attached to normal paperwork. Null Ciphers were also used to hide unencrypted secret messages in an innocent looking message. Given the amount of data being generated and transmitted electronically, it’s no surprise that numerous methods of protecting that data have evolved. There are various types of steganography: Text Steganography - Hiding information inside the text files. This involves changing format of existing text, changing words in a text, generating random character sequences or using context-free grammars to generate readable texts. Image Steganography - Process of hiding text in an image without distorting the picture. Video Steganography - Technique to hide any kind of files into a cover video file. Audio Steganography - The secret message is embedded into an audio signal which alters the binary sequence of the corresponding audio file. Network Steganography - The process of utilizing active network protocols as carriers to transmit a covert message, undetectable by an uninformed party, from a host to its destination. This session will review these methods and also discuss relevant software. Delivery Method: Individual webcast CPE Credit: 1.6Program Level: Basic
The Role of Internal Audit in Enterprise-Wide Risk Management
-
Online
4.00 Credits
Member Price: $149
Those charged with governance, with the assistance of internal audit, are responsible for overseeing the strategic direction of the organization, and ensuring value is delivered to the entity's stakeholders. This course will provide guidance on fulfilling the responsibility for challenging how much risk and uncertainty to accept through the application of COSO's Enterprise Risk Management Framework. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
Excelling at Excel: The Magic of Power Query
-
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Introduction to Forensic Accounting
-
Online
1.80 Credits
Member Price: $79
This course provides a high-level overview and introduction into the world of the forensic accountant. Most accountants have an understanding of the concept of fraud and how it impacts companies, but many individuals do not have a full comprehension of the variance in the work performed by a forensic accountant versus a typical management accountant. This course is meant for those individuals interested in understanding the variances in the job tasks and responsibilities of forensic accountants versus typical financial or management accountants. Forensic accountants or auditors take a unique focus on performing their work. Typically, when a person with forensic experience is called in to examine financial records, it is due to suspicion of fraud, evaluation of assets, or even to track down fundamentally incorrect accounting – intentional or not. As fraud continues to raise its head in business processes, forensic accountants are discovering new and unique ways to identify, examine, and support their hypotheses and investigative techniques. The work performed by a forensic specialist can be interesting and full of potential potholes if evidence isn’t examined according to proper protocols and standards. Delivery Method: Individual webcast CPE Credit: 1.8Program Level: Basic
The Controllership Series - The Treasury Function Part 1 - Cash and Investing
-
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Strategic CFO – Strategic Cash Management
-
Online
2.00 Credits
Member Price: $89
Cash is the lifeblood of every organization, yet many leaders struggle to explain, manage, and plan for it effectively. This session focuses on strategic cash management, capital structure decisions, and financing options available to organizations at different stages of growth. Participants will explore how CFOs balance today's cash needs with long-term strategy, evaluate debt and equity decisions, and communicate cash flow concepts to non-financial stakeholders. The session emphasizes practical frameworks, real-world examples, and modeling approaches that support better cash decisions. A few negotiation videos will be displayed to bring humor and effectiveness to the key points. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Accommodation Requests - Substance Abuse - Contagious Infections
-
Online
1.00 Credits
Member Price: $39
Good judgment works well in handling most employee relations matters. However, there are special situations where legal requirements dictate specific handling to avoid significant personal and employer liability. This course provides practical knowledge and scripts for responding to requests for accommodation regarding religious practices or disabilities, confronting employees in substance-abuse situations, and handling disclosures of contagious infections so that individual is properly helped, and the health of your workforce is protected. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
The Controllership Series - The Controllers Role in Cybersecurity
-
Online
1.00 Credits
Member Price: $39
The controller's role encompasses many traditional responsibilities. The breadth and depth of the controller skill set has expanded and will continue to expand as the business world evolve. In years-gone-by, the concept of information technology and cybersecurity were left to our IT professionals. However, with the prevalent threat that exists in these areas, it is now one of the components of the controller’s skill set that should be in their toolbox. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
What Is Your Brand Reputation?
-
Online
1.00 Credits
Member Price: $39
What do people say about you when you leave the room? Is it what you want them to say? How you show up in the room, get listened to, build trust, and are known amongst your colleagues are all critical components of your future success. In this workshop Michelle Tillis Lederman, CEO and Founder of Executive Essentials, will discuss how to determine you brand attributes, demonstrate the nuances of body language on your professional presence, and discuss how to strengthen trust and the lasting impressions you make on your network, expanding upon lessons from her books The Connectors; Advantage and The 11 Laws of Likability. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
Preparing to be a Forensic Accountant - Focus on Digital Forensics
-
Online
1.80 Credits
Member Price: $79
Forensic accounting, forensic accountancy or financial forensics is the specialty practice area of accounting that investigates whether firms engage in financial reporting misconduct. Forensic accountants apply a range of skills and methods to determine whether there has been financial reporting misconduct. Financial forensic engagements may fall into several categories. For example: Economic damages calculations, whether suffered through tort or breach of contract. Post-acquisition disputes such as earnouts or breaches of warranties Bankruptcy, insolvency and reorganization Securities and tax fraud Money laundering Business valuation Computer forensics/e-discovery This session is designed to delve into further investigative procedures used including digital forensics. Future sessions will focus on computer forensics, network forensics and mobile forensics. Delivery Method: Individual webcast CPE Credit: 1.8Program Level: Basic
Excelling at Excel: Tips, Tricks and Updates
-
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Business Valuation Fundamentals
-
Online
1.00 Credits
Member Price: $39
This course provides a practical overview of business valuation, guiding participants through the key concepts, methodologies, and considerations involved. You will explore the types of valuation reports, the standards governing their preparation, and the step-by-step process of transforming raw data into actionable insights. The course also examines how the intended purpose of a report can influence its conclusions and offers strategies for valuing minority interests. By the end of the course, participants will gain a clear understanding of how to read, interpret, and apply business valuation reports effectively. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
Preparing to be a Forensic Accountant - Cloud Forensics
-
Online
1.40 Credits
Member Price: $79
Cloud computing has become a source of cyber-crime. “Cloud forensics is the application of digital forensics in cloud computing as a subset of network forensics to gather and preserve evidence in a way that is suitable for presentation in a court of law.” Cloud forensics is a combination of the varied types of accounting forensics including: • Digital forensics • Network forensics. • Hardware forensics In cloud crime, the cloud is considered the object when the target of the crime is the cloud service provider they are directly affected by the act. It is considered the subject of the crime when the criminal act is committed within the cloud environment. It is considered the tool when it is used to plan or conduct a crime. This course will delve into the many concepts involved in cloud forensics. The course complements other courses in the series of Becoming a Forensic Accountant. Delivery Method: Individual webcast CPE Credit: 1.4Program Level: Basic
The Controllership Series - Addressing Cash Flow and Forecasting Uncertainty
-
Online
1.50 Credits
Member Price: $79
These are uncertain times. With constant economic fluctuation, geopolitical uncertainty and inflation pressures, corporations and their professionals are facing challenges at every turn. The Controllership function is accustomed to dealing with changing variables but when the change is constant and every evolving, even the simplest of tasks like cash flow and cash forecasting can become difficult. This webinar is to focus on what methods the controller can elicit to attempt to address the current uncertainty when working with their cash flow issues and forecasting. Of course, there are basic measures that can be employed such as: Proactively managing receivables and payables Automate your accounts payable and receivables process Keep business expenses at a minimum Work with digital methods of payment from vendors Use credit wisely However, this webinar will explore methods used to create and manage your cash flow and forecasting processes. These methods go one-step past your typical forecasting to enable management to explore various alternatives and scenarios for the business. Delivery Method: Individual webcast CPE Credit: 1.5Program Level: Basic