CPE Catalog & Events
K2’s Excel Best Practices
-
Online
8.00 Credits
Member Price: $250
In the ever-evolving world of spreadsheets, staying ahead means mastering the latest and best techniques. Join our comprehensive program and dive deep into the best practices for creating, editing, and auditing Excel workbooks. You'll learn how to secure your workbooks, collaborate seamlessly with others, and effectively report data. Today's Excel best practices are a far cry from those of the past. This "must-see" CPE program will equip you with the knowledge to work smarter, not harder. Our course materials are packed with relevant examples to enhance your learning experience. Don't miss out on this opportunity to fully utilize Excel and elevate your skills to new heights. Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced
Shortcuts to Personal and Professional Success
-
Online
8.00 Credits
Member Price: $250
We all want to be successful and deeply fulfilled, but most of us have not learned what really leads to a life of abundance, happiness, purpose, and great relationships. In this seminar, you will learn the most effective methods for creating the life you really want. In his interviews with such people as Oprah, the Dalai Lama, Deepak Chopra, Tony Robbins, Ted Turner, and dozens of others, Jonathan has learned what really works and what does not. In this seminar you’ll learn the best personal and professional growth techniques he’s acquired over his career. Once you know these great ideas and methods, you'll be able to take your life and career to a whole new level. Delivery Method: Individual webcast CPE Credit: 8Program Level: Update
Creating A Culture of Trust
-
Online
1.00 Credits
Member Price: $39
It is the role of a leader to build and maintain a great culture in the organization. The culture is the driving force that shapes the attitudes and behaviors of everyone in the organization. A relationship driven organization is built on trust and is the most effective way to improve productivity, engagement, and the bottom line. Understand the components that enable trust to be created and maintained throughout teams and organizations. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
The Future of Work - The Landscape of Work Today
-
Online
1.20 Credits
Member Price: $39
The world of work today has never before faced so many simultaneous changes. From rising turnover and rising employee disengagement to the changing psychology of the workforce, the world of work is changing fast. In order to understand how to thrive in this complex landscape - we must begin by understanding the key drivers of change. What is changing in the world of work, why are these changes happening, and what can we expect will continue to change and what may not change. These are the elements we will explore in this class. Delivery Method: Individual webcast CPE Credit: 1.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
Just Ask Why - Searching for Answers: Generating Solutions
-
Online
4.00 Credits
Member Price: $149
Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Triple Your Memory, Prevent Dementia and Halve Your Stress - Part 1
-
Online
4.00 Credits
Member Price: $149
This is not your average CPE course! In this fun and practical course, you'll learn how to remember names, where you put things, what you read, or anything else 300% (or more) effectively than before. You will also learn how to prevent dementia, and halve your stress by using exercises that take under two minutes a day to do. Additionally, you'll receive information on ways to improve your memory by improving your overall health and wellness. This course will give you an overview of natural supplements to enhance your memory as well as share tips to improve your sleep. This course will change your life both now and in the future by making sure you know the best ways to remember information, handle stress and keep your mind sharp until the day you die. The information in this course to help increase your professional efficiency and improve your overall quality of life. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
The Essential Auditing Update with Renee Rampulla
-
Online
4.00 Credits
Member Price: $149
This course is essential and designed to keep you informed of proposed and current authoritative guidance issued by the American Institute of Certified Public Accountants (AICPA). Learn about proposed and final auditing and attestation standards addressing group audits, fraud, and sustainability. Understand the eight quality management components, hear about frequent peer review matters and so much more. Delivery Method: Individual webcast CPE Credit: 4Program Level: Update
K2’s Excel Essentials For Staff Accountants
-
Online
8.00 Credits
Member Price: $250
Staff accountants often face unique challenges when working with Excel, and their existing knowledge might not always meet their needs. This comprehensive eight-hour session is designed to bridge that gap and empower you with the essential skills to maximize efficiency and accuracy. Participate in this dynamic and engaging session, and you will learn how to: • Summarize data quickly and accurately • Generate stunning, professional reports • Create essential accounting calculations for depreciation, amortization, and interest We start with a quick overview of Excel best practices and dive into advanced topics like PivotTables, sophisticated formulas, Tables, formatting, and working with dates. Our course is packed with accounting-centric examples to reinforce key learning points. Plus, you'll enjoy a "laptop-friendly" environment with access to all demonstration files. This seminar is a must for all staff accountants eager to enhance their Excel skills and transform their workflow. Don't miss out on this opportunity to elevate your Excel expertise and take the first step towards mastering Excel today! Delivery Method: Individual webcast CPE Credit: 8Program 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 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
The Value of Conflict
-
Online
1.00 Credits
Member Price: $39
Poorly handled conflicts can lead to break downs in communication, reduced morale, and higher turnover. However, when managed well, conflict has the potential to bring value to the organization and the team. Conflict is a costly and often mishandled occurrence in the workplace. Successful conflict resolution occurs by listening to and providing opportunities to meet each side needs, and adequately addressing their interests so that they are each satisfied with the outcome. In this you will learn the different conflict modes, how to choose the appropriate strategy for your situation, and how relationships impact your ability to promote the positive outcomes and minimize the negative outcomes of conflict. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
The Future of Work - Building a New Model of Work
-
Online
1.20 Credits
Member Price: $39
Most of the models of work that we use today were not built for the pace of change and the dynamism of work today. In this course, you will learn how so many models we use at work are fundamentally broken and no longer useful. Models that rely on people staying a long time in a firm are no longer helpful in a reality where employees are staying for increasingly shorter periods with their employers. This course will reveal how so much of the architecture of work was not built with short tenure in mind: career paths, compensation, and retention objectives. Delivery Method: Individual webcast CPE Credit: 1.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
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
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
K2’s Taking Another Look At Power BI
-
Online
2.00 Credits
Member Price: $89
Although Power BI has been available for ten years, most business professionals don't fully appreciate all it can do and its easy use. Further, many are intimidated by the platform and continue to use less efficient and effective reporting practices. If this describes you, invest some time in this session to learn how to work with Power BI almost immediately. In this session, you will learn how to use Power BI to create compelling dashboard reports. You will also learn how to optimize these reports to enhance their effectiveness. If you want to improve financial and operational reporting processes, this session is for you! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Five Amazing Business Books in 100 Minutes
-
Online
2.00 Credits
Member Price: $89
If you are efficient and want to learn lessons from the best in a short time, this seminar is for you. Popular speaker Don Minges will review the key lessons from five fantastic business books that will help you become more effective. The topics are; leadership, how to create a valuable business, how to turnaround a business, how to make terrific presentations and how do humans think? These lessons are valuable for every business leader. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
K2’s Business Intelligence, Featuring Microsoft’s Power BI Tools
-
Online
8.00 Credits
Member Price: $250
In today's fast-paced business world, staying ahead of the competition means leveraging every advantage. Business Intelligence (BI) is the game-changer that can transform your organization. Imagine uncovering hidden insights and gaining a competitive edge with data that was once out of reach. With tools ranging from Excel add-ins to the revolutionary Power BI, you can now harness your existing skills to create dynamic, interactive dashboards and analyses that were unimaginable just a few years ago. This program will empower you with the skills to implement "yourself business intelligence" using a variety of techniques and tools. You'll start by mastering advanced Excel data query and summarization features to create stunning Excel-based dashboards. Then, you'll take your knowledge to the next level by building even more powerful BI objects using Microsoft's Power BI tools. If you're passionate about gaining better insights into your data to make smarter decisions, this fast-paced program is for you. Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced
Balancing Employee and Employer Rights
-
Online
1.00 Credits
Member Price: $39
Leaders have the right to exercise customary management functions. Employees have the right to be kept free from discrimination. Neither employer rights nor employee rights are absolute. The courts are equally protective of the rights of employees and employers. A courtroom is the wrong place for anyone to find this out. This course provides practical knowledge on how to effectively balancing these two sets of rights, such that employees and leaders stay out of court. Employers avoid lawsuits, rather than win lawsuits. Delivery Method: Individual webcast CPE Credit: 1Program Level: Advanced