CPE Catalog & Events

Business intelligence efforts continue to grow, and Microsoft's Power BI platform is central to many of these efforts. Participate in this session to learn more about business intelligence and how to create dashboards using Power BI.

This course offers an in-depth look at retirement needs models, their flaws, and ways to overcome associated drawbacks. You'll explore holistic retirement planning while reviewing threats to a successful retirement. You'll also hear about recent retirement planning changes, including the elimination of the "Stretch IRA" by the SECURE Act and the new SECURE Act 2.0 changes. We'll address key questions to plan a comfortable retirement and discuss strategies to draw down retirement assets over an extended period.

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 of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables – including grouping options for fiscal periods – and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.

Between 2010 and 2020 a parade of Court Cases, IRS Factsheets, Job Aids and Internal Memos, plus Heightened IRS scrutiny and Preparer Penalties has brought the issue of 'Reasonable Compensation for S Corp's out of the shadows and placed it forefront as a priority issue for CPA's, EA's, Tax and Financial advisors to cover with their clients. We will explore key court cases, IRS guidelines, preparer penalties and some of the obscure tools the IRS has put in place. We debunk common myths and fiction on how reasonable compensation should be calculated and replace it with facts and methodologies that the IRS relies on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

An operational audit is a method of examining how an organization conducts business. It identifies areas where an entity can improve to be more effective and efficient. This course will focus on how to plan and perform operational audits, as well as delivering value-added recommendations as a result.

Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.  

This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The path from CPA to CFO has evolved dramatically in recent years, with only 43% of S&P 1000 CFOs holding CPA licenses in 2022, down from 55% a decade earlier. This comprehensive course, based on groundbreaking research from the Pennsylvania Institute of CPAs surveying over 320 CEOs and hiring executives, reveals what today's leaders truly seek in CFO candidates and provides a roadmap for CPAs to secure their seat at the executive table. Participants will discover the five critical competencies that distinguish successful CFO candidates: forward-looking financial acumen that goes beyond traditional reporting, strategic leadership skills including critical thinking and strategy creation, the evolving role of emotional intelligence, industry-specific expertise requirements, and the balance between technical proficiency and visionary leadership. Through practical frameworks, real-world examples, and actionable strategies, attendees will learn how to transform their CPA foundation into a comprehensive skill set that meets the dynamic demands of modern CFO roles, whether in high-growth companies, nonprofits, or traditional corporations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Until recently, a percentage of organizations discounted the risk related to external fraud attempts. Most were only concerned with protecting physical assets such as inventory or fixed assets. However, because of the many highly publicized corporate hacking events, such as the ones that affected the Colonial Pipeline and JBS Meats, more attention is being paid to external fraud risk of all types. In this session, we look at what is included in a definition of external fraud and then delve into specific control issues that can give rise to increased risk. We then discuss measures that organizations can employ to help reduce exposure to external attacks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course will provide a general understanding of the current and prospective reporting and disclosure requirements for employee benefit plans. Participants will be provided with an insight into the common errors and mistakes made by auditors and plan administrators. Results from the Department of Labor's ("DOL") audit quality study will be discussed and reviewed. This material will provide auditors and plan administrators with up-to-date information regarding defined contribution plans auditing, reporting and disclosure requirements.

This business coaching course is designed to enhance your coaching effectiveness by integrating innovative tools like ChatGPT (Generative AI) to support and elevate your coaching practice. You'll explore the key differences and similarities between coaching and managing, uncover the most important skill every coach should master, and learn how to get to the root cause of any problem. With hands-on coaching strategies, including neuro-linguistic programming (NLP) techniques, you'll enhance your ability to drive results. Additionally, you’ll discover how to use performance gap analysis to identify and bridge gaps, ensuring the success and growth of the individuals you coach.

Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today’s business climate. Increasingly, organizations of all sizes seek to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools – from Excel add-ins to dedicated solutions such as Power BI – now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyzes unthinkable until recently. This program will teach you to implement “do-it-yourself business intelligence” using various techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools. 

In today's challenging talent market, accounting firms face unprecedented pressure to retain their best performers. This course provides actionable, research-backed strategies to help firms keep their top talent from leaving. Based on comprehensive surveys of both current accounting professionals and those who have recently left the profession, participants will learn the real reasons employees stay or go-and what firms can do about it. The course goes beyond simple solutions like "pay more, expect less" to explore comprehensive retention strategies including whole-person compensation, work-life balance improvements, career development pathways, and necessary business model transformations. Participants will discover why 73% of surveyed professionals want to stay with their current firm, yet many still leave-and how to bridge that gap. Key topics include understanding the true cost of turnover versus retention, implementing flexible work arrangements that actually work, creating meaningful career paths for non-partner track professionals, and transforming firm operations to support both profitability and employee satisfaction. Special attention is given to retaining diverse talent and adapting to the expectations of younger professionals who will comprise 27% of the workforce by 2025. Whether you're a firm leader, HR professional, or manager responsible for team retention, this course provides the insights and tools needed to build a sustainable talent strategy in an evolving profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course builds on the foundational knowledge from Part 1, Fundamentals of the 1040 - Core Concepts. It expands into business income taxation and additional reporting requirements. Participants will learn how to accurately report self-employment income, income from pass-through entities on Form 1040. This course covers Schedule C, Schedule E, and essential forms such as Form 7203 and Form 7217 to ensure accurate tax preparation for clients with business activities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

When it comes to hiring, using a conventional hiring process may not be as reliant as flipping a coin. A coin flip may often be better because it would bypass a lot of hidden biases and inefficient processes. We need to get back with a clean sheet of paper and do it better. In this course we will look at improving a process that is deeply flawed, and we will look objectively and outside the box on things we can do to identify and hire high performers.

Companies reporting under International Financial Reporting Standards (IFRS) continue to face a steady flow of new standards and interpretations. The resulting changes range from significant amendments of fundamental principles to some minor changes from the annual improvements process. The changes will affect different areas of accounting, such as recognition, measurement, presentation and disclosure.  It can be time-consuming and confusing to keep up-to-date on the resulting impact on financial statements and disclosures. This course will provide an executive summary of recent IFRS updates with current and upcoming effective dates.