Professional Development and Event Catalog
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $118
Let us ask you a question. What function do you use most? Is it the SUM function? It shouldn't be - well, at least if efficiency is your goal. This session covers the function that sums better than the SUM function for accounting professionals. In addition, we review the data validation feature, which enables us to control what a user enters into a cell. We'll discuss the conditional formatting feature, which enables us to format a cell based on its value. Lastly, we'll conclude by reviewing a technique that addresses a major pitfall of Excel. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook, and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
IRS Strategic Plan 2023-2026 and Impacts on US Tax Pros
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $89
This course is designed to provide an overview of the IRS Strategic Plan 2023-2026 and its impacts on the accounting profession and regulatory ethics. The course will cover the key goals and priorities of the IRS Strategic Plan, including improving service to taxpayers, enforcing the tax law fairly, transforming IRS operations, and fostering an inclusive and well-equipped workforce. Participants will learn about the specific measures the IRS plans to take to achieve these goals and the implications of these measures for tax professionals. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's 2024 Office Scripts - The New Macros
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $79
Office Scripts are an exciting new development for Excel and other applications. Although they are like macros in some respects, most users will likely find them easier to work with. Learn how to put this powerful automation tool to use!
Achieving Balance in Work and Life - Part 1
2:00pm - 5:35pm
Online
4.00 Credits
Member Price: $129
Due to the constant stress of a fast paced life, overwork, and family demands, it’s easy to feel one’s life is out of balance. When this happens, all areas of your life can suffer. By learning key methods for setting priorities and goals, overcoming stress, and deciding what’s most important to you, you can achieve new levels of balance and greater results. Having more balance in your life will allow you to do less of what you don’t want and more of what is truly important to you.
Individual Tax Update: Recent Developments
2:30pm - 4:30pm
Online
2.00 Credits
Member Price: $89
A discussion of the latest 2021/222 tax developments impacting individual taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Controller Function - Cash and Investments
3:00pm - 4:16pm
Online
1.40 Credits
Member Price: $39
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.
Preparing to be a Forensic Accountant - Cloud Forensics
3:00pm - 4:17pm
Online
1.40 Credits
Member Price: $59
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.
Triple Your Memory, Prevent Dementia and Halve Your Stress - Part 1
3:00pm - 6:36pm
Online
4.00 Credits
Member Price: $129
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.
K2's 2023 Best Word, Outlook, and PowerPoint Features
3:00pm - 6:37pm
Online
4.00 Credits
Member Price: $129
Most professionals routinely use Word, Outlook, and PowerPoint, but many are self-taught and, as a result, have not been exposed to the best features of these three applications. Consequently, they often use “brute force,” inefficient means when working with these three components of Microsoft Office. If that describes you, ensure you carve time out of your schedule to participate in this fourhour session. In it, you will learn how to work much more efficiently when using these tools to get better results in less time.
2024 Deep Dive into Quality Management
4:00pm - 5:48pm
Online
2.00 Credits
Member Price: $79
Quality management will have a big impact on CPA firms. This course will cover both SQMS 1 and 2 as well as the related engagement level standards (SAS 146 and SSARS 26). The new standards will require a risk-based approach to quality management as well as the documentation of an information & communication process. This two hour class will provide a deep dive into what you need to know to start your implementation process!
2024 Single Audit Update
4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $79
This course will start with a review of the impact of the 2024 Compliance Supplement on Single Audits as well as the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits.
Cognitive Biases for Accountants
4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $89
The course provides a concise overview of cognitive biases - thinking errors and "brain bugs" that may distort perceptions, compromise ethics, trigger inaccurate judgments, and spark illogical interpretations in your accounting work. Discover the most common types of cognitive biases in the profession, and how to recognize and address these flaws and blindspots in your "mental firmware". This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's 2024 Optimizing Your Tech Stack for Efficiency and Cost-Effectiveness
4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $79
Is your tech stack aligned with your organizational goals? Is there duplication among software titles? Is your hardware where it needs to be? Get answers to these and other questions in this session!
Ask Me No Questions and I Will Tell You No Lies - The Art of Interviewing and Interrogation
4:00pm - 6:51pm
Online
3.00 Credits
Member Price: $99
When we verbally communicate with an individual, we must make a conscious decision as to whether we believe what we have heard. Little do we realize that we are not making a decision based on what we have heard; rather we make a subconscious decision based primarily on what we have seen, or how the body was behaving when the subject was speaking. We often walk away from a conversation with a gut feeling that the person was not telling the truth. That gut feeling is your subconscious. Yet we often have no idea as to why we have that feeling. This presentation is designed to provide the participant with the tools to identify those both verbal and nonverbal indicators that we all give off when we are under stress. Normally, telling the truth does not create stress. When we lie, we know that we are not supposed to and that creates stress, and it will manifest itself in some manner, and that is what a trained interviewer is looking to observe. When we observe indicators of deception, how do we deal with it? How do we get the subject to admit to a wrong-doing when it is not in their best interest to do so? That is one of the many things that will be addressed in this presentation. Whether you are a parent dealing with you kids; an employer dealing with employees or and investigation interviewing a suspect, this presentation will provide you with the tools to assist you in finding the truth.
Achieving Balance in Work and Life - Part 2
4:00pm - 7:34pm
Online
4.00 Credits
Member Price: $129
In trying to achieve life balance, various internal and external obstacles arise. In this course we will look at these obstacles and provide specific ways to overcome them. In addition, we will look at how to excel in every area of your life including your relationships, finances, sense of purpose, level of happiness, and your physical health and leisure time pursuits. You will leave this course with powerful methods and a specific plan to move forward in your life in a balanced, healthy, and productive manner. Don't forget to take Part 1 of this amazing course.
Prevention and Detection of Fraud In Small Businesses
4:00pm - 8:00pm
Online
4.00 Credits
Member Price: $129
As reported in the Association of Certified Fraud Examiners Occupational Fraud 2022: A Report to the Nations, on average, small businesses lose 5% of their revenue due to fraud. Can the average small business owner afford to lose 5% of their revenue due to fraud? I think not. This presentation is designed to illustrate the numerous ways employees commit fraud in small businesses, how to detect it, and most importantly, how to prevent it. Both auditors and small business owners would both benefit from this presentation.
Accounting of the Soul: Making the World a Better Place
5:00pm - 6:00pm
Online
1.00 Credits
Member Price: $55
This workshop explores how each of us can play a part in helping to make the world a more fair and gentler place. This one-hour webinar includes an overview of Aristotle's virtue ethics and its application to present day life. We will focus on the virtue of compassion both individually and organizationally and its impact on individual, organizational and world wellbeing. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's 2023 Using OneNote More and Email Less
5:00pm - 6:46pm
Online
2.00 Credits
Member Price: $79
OneNote is a fantastic application included in your Microsoft 365 subscription. Yet, it is underutilized and misunderstood most of the time. If you genuinely want to change how you work, embrace OneNote. Stop using Outlook as a filing cabinet for essential emails and move them to OneNote instead. If you share a OneNote notebook with others, you can stop emailing altogether within your group and use OneNote as your collaboration and reference platform.
Communication Miracles At Work and In Life - Part 2
6:00pm - 9:34pm
Online
4.00 Credits
Member Price: $129
Following on Part 1 of this course, in Part 2 you will learn advanced ways to solve problems without bruising egos, how to create profound trust quickly, and how to motivate clients and co-workers to do your bidding with a minimal amount of wasted time or hassles. The bottom line will be better client and co-worker relationships, leading to increased enjoyment and productivity at work.
The Controller Function - Strategic and Annual Planning
7:00pm - 8:14pm
Online
1.20 Credits
Member Price: $39
This course corresponds to our Controllership series. Within this course, we specifically address the Controllers role and pro-active potentials in organization Strategic and Annual Planning. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc. the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. When it comes to the task of strategic planning, many feel this role is primarily the responsibility of the executive team and board. However, in this course, we delve into the various steps of the strategic plan and explore where the Controller can add strategic value through providing functional input and insight. Strategic planning is a process used to identify goals, the strategies necessary to accomplish those goals, and the internal performance management system that will be used to monitor and evaluate progress.