CPE Catalog & Events
K2’s Excel Tips – Today’s Best Features
-
Online
2.00 Credits
Member Price: $89
Wow! So many new Excel features and so little time! Microsoft continues to add tremendous functionality to Excel - the business professional's tool of choice. Yet most Excel users have not discovered these new tools and remain mired in yesterday's practices for working in Excel. In this session, you will learn how to use many of Excel's latest features to work more efficiently and effectively with your spreadsheets. Participate in this session to learn about recently released features such as PIVOTBY, GROUPBY, Office Scripts, integration with Copilot, new ways to share and collaborate in Excel, and data entry and formula improvements. If you work with Excel - and who doesn't - this session is necessary to help you improve your efficiency and effectiveness when using Excel. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Introverts Have Real Power, Why Quiet Leaders are So Successful
-
Online
2.00 Credits
Member Price: $89
Leaders were once chosen for their character, but today we live in an age where loudmouthed extroverts seem to take center stage in everything, including business, politics and entertainment. While the talkative, charismatic leader makes the front page of business magazines, recent research shows that successful business leaders tend to be more reserved, pensive and sometimes outright shy. Learn why your desire to spend significant time inside your own head may be your greatest asset. Whether you are introverted or not, you likely work with, manage or are a related to an introvert. We will discuss proven methods to better understand introverts, how to manage them, and how to get the most out of their amazing talents. If you want to enhance your leadership skills, this seminar is for you. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Cash Flow Clarity: Effectively Communicate Cash Flows for your Board and C-Suite
-
Online
2.00 Credits
Member Price: $89
The cash flow statement is one of the most confusing financial reports—yet it has the potential to deliver the essential keys to understand business performance. After all, cash is still both king and queen! This session explores how to present, interpret, and communicate cash flows effectively to help CEOs, boards, and decision makers drive smarter results. By using the Sources and Uses format, professionals can make the statement more intuitive and actionable. Learn how to simplify cash flow information and focus discussions on what matters most: how cash is generated and deployed? We will demonstrate how to confidently present this powerful financial statement to non-financial leaders. The cash flow statement is misunderstood, and we will show you how to fix that, and include some amusing videos to drive the points home. We will use the Apple Corporation as an example company in presenting. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Global Internal Audit Standards (GIAS) Domain IV - Part 1
-
Online
2.40 Credits
Member Price: $99
The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service Delivery Method: Individual webcast CPE Credit: 2.4Program Level: Update
K2’s Implementing Internal Controls In QuickBooks Online Environments
-
Online
4.00 Credits
Member Price: $149
The QuickBooks Online (QBO) ecosystem is rapidly expanding, with millions of small businesses now relying on it for their accounting and business management needs. However, many QBO implementations lack adequate internal control infrastructures, which can lead to potential risks and inefficiencies. This is often due to a lack of understanding of the internal control options available in the cloud-based version of QuickBooks and how to implement them effectively. Join our session to learn about the four common types of internal controls and how to assess the internal control structure of a small business. We'll guide you through the opportunities to enhance internal controls in QBO environments using features found within the application. Additionally, you'll discover additional internal control procedures for situations where adequate controls cannot be established in QBO. Contrary to popular belief, QBO-based organizations can indeed benefit from strong internal controls, and this session will show you how. Don't miss this opportunity to strengthen your QuickBooks Online implementation and ensure your business is safeguarded against risks. Sign up now and take the first step towards a more secure and efficient QBO environment! Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
K2’s Excel PivotTables For Accountants
-
Online
8.00 Credits
Member Price: $250
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge, then this course is for you! In this dynamic and engaging session, you'll master how to: • Build PivotTables from scratch • Group data inside PivotTables, including options for fiscal periods • Create user-defined calculations in your PivotTables We start with the fundamentals and quickly move to advanced techniques, including: • Building PivotTables that consolidate data from multiple ranges • Connecting PivotTables dynamically to external databases and financial accounting systems • Leveraging other Excel features associated with PivotTables, such as Slicers, Power Query, and Power Pivot This seminar is a must for anyone eager to enhance their Excel skills and transform their workflow. With guidance and coaching from your K2 instructor, you'll be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks. Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced
Wired Differently - An Introduction to Neurodivergence
-
Online
1.00 Credits
Member Price: $39
Neurodivergence isn't just something that shows up in childhood or in headlines. It's already in your workplace, quietly shaping how people communicate, create, and collaborate. From autism to ADHD to dyslexia and beyond, neurodivergence shows up in many forms, and chances are, you're already working alongside neurodivergent employees... whether you realize it or not. This session gives professionals a clear, candid introduction to what neurodivergence really is (and isn't), what it can look like in adults, and why many traditional assumptions just don't hold up. We'll bust some big myths, explore real-world examples, and give you a fresh, more human lens for understanding the full spectrum of how brains work. Whether you're brand new to the topic or just want a better foundation, this is your crash course in neurospicy thinking. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
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
Ultimate Small Business HR Guide: Essential Tips for Success
-
Online
1.00 Credits
Member Price: $39
As a small business owner or manager, navigating the complexities of HR can be challenging, but it's crucial for your company's success. This comprehensive webinar will provide you with practical, informative, and encouraging tips to help you build a strong HR foundation for your small business. From recruitment strategies to employee retention, legal compliance to company culture, we'll cover all the essential aspects of HR that will contribute to your business's growth. Let's create a thriving workplace where both your business and your employees can flourish. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Common Sense CFO: Crisis Management, Innovation, and Other Expectations Put on CFOs
-
Online
2.00 Credits
Member Price: $89
The role of today's financial leader, including CFO, transcends traditional financial stewardship; it demands agility, innovation, crisis management, and strategic foresight. This seminar will discuss the new, multifaceted skills and insights needed to excel in the dynamic role of modern finance. Through a blend of theory, research, and practical exercises, participants will explore the diverse roles of a CFO as innovation champions, technology evangelists, crisis managers, and change agents - leveraging practical principles to drive organizational success. Financial leaders can adapt or be left behind. Whether you are a seasoned CFO or aspiring to step into a leadership position, this seminar will discuss the essential tools and insights to navigate the newer demands of financial managers with confidence and competence. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
K2’s Advanced Excel
-
Online
8.00 Credits
Member Price: $250
Elevate your Excel expertise with K2's Advanced Excel program! This laptop-friendly course is designed for experienced Excel users who are ready to take their skills to the next level. In this session, you will master critical advanced Excel skills in six key areas: 1. Collaborating seamlessly with other users and securing your workbooks 2. Utilizing tables to analyze and report data efficiently 3. Integrating and manipulating data from external sources with ease 4. Creating and auditing complex formulas 5. Harnessing advanced data analysis tools for deeper insights 6. Employing visualization techniques to communicate information effectively Drawing from over thirty years of experience in delivering Excel training to accountants and business professionals, this program is packed with relevant, real-world examples that reinforce the topics presented. Don't miss this opportunity to become more efficient and proficient in Microsoft Excel, the go-to tool for accounting and financial professionals. This course covers advanced Excel topics that are essential for business success. Participate in this session to elevate and transform your Excel skills! Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced
Revenue Recognition Topic 606 - Identify the Contract Part 1
-
Online
1.20 Credits
Member Price: $39
On May 28, 2014, the Financial Accounting Standards Board (FASB) and International Accounting Standards Board (IASB) issued converged guidance on recognizing revenue in contracts with customers (ASC 606). The objective of the guidance is to establish principles to report useful information to users of financial statements about the nature, amount, timing and uncertainty of revenue from contracts with customers. The new guidance provides several benefits to financial statement users. This is one in a series of courses that outline the updated revenue recognition standard. Delivery Method: Individual webcast CPE Credit: 1.2Program Level: Intermediate
Change Management: Your Leadership Role for Aligning Profits & Culture
-
Online
2.00 Credits
Member Price: $89
This is a dynamic course tailored for seasoned accountants who are looking to elevate their skills in navigating and leading through organizational change. This advanced program focuses on enhancing agility by providing the tools and techniques necessary to manage and adapt to rapid shifts in the accounting landscape. Participants will explore theoretical frameworks alongside practical strategies that support effective change management for diverse business environments. Delivery Method: Individual webcast CPE Credit: 2Program Level: Advanced
Budget Mastery: The Human Side of Budgeting-Navigating People's Issues with 360 Insight
-
Online
2.00 Credits
Member Price: $89
You have a fantastic budget, but certain players are not pleased. Financial plans have a technical component and human component. We can resolve some of our budget issues by exploring the process’ human aspect. Understanding what makes you and others operate can enhance your understanding of the entire organization and build upon the respect and influence needed to navigate and lead the budgeting cycle. This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create a better budget process and quite frankly maybe a better you. This is a great and fun course on its own, but is also part three of a four part series on budget mastery. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
K2's Taking A Fresh Look At Teams
-
Online
2.00 Credits
Member Price: $89
Just because Microsoft Teams is no longer a new tool doesn't mean it hasn't evolved & it certainly has! Since its introduction in 2016, Teams has become the de facto business productivity platform for organizations worldwide. Yet, many users barely scratch the surface of all that Teams offers. Participate in this session to learn how to get more from Teams and enhance your ROI on the platform. In this session, you will learn about the core options available in Teams and how to leverage them. You will also learn about new enhancements in Teams, including threaded conversations, enhanced meeting features, and integration with Microsoft's Copilot platform. If you use Teams and want a deeper understanding of the platform, don't miss your opportunity to participate in this session. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Global Internal Audit Standards (GIAS) Domain IV - Part 2
-
Online
2.00 Credits
Member Price: $89
The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service Delivery Method: Individual webcast CPE Credit: 2Program Level: Update
Accounting for People: Workforce Trends, Costs, and Talent
-
Online
2.00 Credits
Member Price: $89
Leaders are increasingly responsible for the human resources function, despite limited formal training in people management. This seminar explores how to account for people as a valued asset rather than an expense. Managing the costs, trends, and risks associated with today’s ever-changing workforce has changed. From recruiting and retention to engagement and compensation alternatives. The modern leader must understand how employee-related decisions drive both performance and profitability. This session will examine the financial implications of HR trends, workforce planning, and the evolving role of talent strategy. We will also explore how to influence investments in people through accounting and reporting tools. Successful organizations have moved employees to the left side of their balance sheet. Have you? Join for some interesting research and entertaining mix of videos to understand the people around you in the workforce. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
2026/27 Not-for-Profit Accounting & Auditing Update
-
Online
4.00 Credits
Member Price: $149
This comprehensive annual update brings together key accounting, auditing, and compliance developments affecting not-for-profit organizations. The course integrates recent standard-setting activity, audit and attestation updates, and Single Audit developments to provide a practical view of changes impacting nonprofit financial reporting and oversight. Participants will begin with an overview of accounting developments affecting not-for-profit organizations, including recently issued Accounting Standards Updates (ASUs) from the Financial Accounting Standards Board and an introduction to the International Non-Profit Accounting Standard (INPAS). Emphasis is placed on understanding the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. The course then shifts to auditing and attestation developments from the AICPA, including the next phase of quality management with a focus on monitoring and remediation responsibilities. Participants will also review recent and upcoming standards affecting audit, attestation, and consulting engagements, including updates related to SSAEs, SSARSs, exposure drafts on confirmations and fraud, and changes affecting group audits. Delivery Method: Individual webcast CPE Credit: 4Program Level: Update
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
Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
Online
2.00 Credits
Member Price: $89
GAAP is changing at an increasing rate. Every successful organization has a sound strategy. Financial leaders are faced with the dual challenge of navigating evolving accounting standards while strategically guiding their organizations toward sustainable growth and profitability. What are the newer accounting changes that will impact professional accounting? This seminar will equip finance professionals with the critical skills and practical insights needed to effectively manage the complexities of ever-changing accounting standards and upgrade your essential strategic planning skills. Strategic skills are mandatory today. Strategies that do not keep pace with the market are doomed to fail. If we do not keep up, our successor will. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate