Professional Development and Event Catalog
K2's Excel Tips, Tricks, and Techniques for Accountants
10:00am - 5:37pm
Online
8.00 Credits
Member Price: $225
See more dates
Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.
More Dates
Preparing and Reviewing Workpapers - Essential Tips for Avoiding Deficient Audit and Other Attest Engagements
10:00am - 5:40pm
Online
8.00 Credits
Member Price: $225
See more dates
Workpapers are the primary support for findings, conclusions and opinions on any audit or other attest engagement. This course will provide the essential tips and techniques for ensuring workpaper documentation is of a high quality, yet efficient, nature.
More Dates
K2's Microsoft Teams
10:30am - 2:30pm
Online
4.00 Credits
Member Price: $129
Microsoft Teams is one of the most exciting personal and organizationally productivity tools to ever appear on the business landscape. With Teams, you can communicate and collaborate easily and securely with others, including colleagues outside your organization. Further, you can extend the already-robust functionality in Teams by incorporating add-in solutions with just a few clicks of the mouse. Unfortunately, despite Teams’ power and relatively simple interface, many organizations struggle with deploying and using Teams. In this session, you will learn how you can get up and running quickly in Teams so that you can take full advantage of this powerful tool. More specifically, you will learn how you can get started in Teams and critical decisions that will affect your deployment. Also, you will learn how to work in Teams, including how to take advantage of the chat, voice, and video call services and how to share documents securely with others. Moreover, you will learn how to extend your Teams platform to external organizations for improved communication and collaboration. Additionally, you will identify how you can add other applications into Teams and optimize Team's configuration for the best overall efficiency and security. If you are working with Teams or plan to do so, this is one CPE session you can’t afford to miss!
Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 1
11:00am - 12:11pm
Online
1.00 Credits
Member Price: $39
See more dates
This course is a continuation of our series on preparing to become a forensic accountant. Within this segment we focus on elements of computer forensics. This session is designed to delve into further investigative procedures used in computer forensics.
More Dates
Five Ways to Improve Your Leadership Skills
12:00pm - 12:54pm
Online
1.00 Credits
Member Price: $39
See more dates
This course provides practical suggestions for improving leadership skills, including self-awareness, communication, delegation, empowerment, coaching, and counseling.
More Dates
Educators Group Meeting
12:00pm - 1:00pm
Online
0.00 Credits
This virtual College Educators meeting will provide a focused update on key developments impacting accounting education. Topics include CPA Evolution exam performance trends as of 2025 Q3, discipline-level insights, and an overview of recent changes to Connecticut’s CPA education and eligibility requirements adopted by the State Board of Accountancy. Obtain practical insights to support academic advising, curriculum alignment, and student readiness for the CPA Exam, along with the opportunity to engage in peer discussion with fellow educators from across the state.
The Ethics Hour: Heartfelt Leadership: How Ethical Leaders Build Trust, featuring John F. Levy, MBA, CPA, CIA and Don Minges, MBA
12:00pm - 1:00pm
Online
1.00 Credits
Member Price: $39
See more dates
The best leaders are always ethical. Every great leader has heart and readily shows that they care. What is the true value of a trustworthy leader? Why do we need trustworthy leaders? How do we examine ethical issues - what is the process? Trust provides a safety net that enables innovation to flourish. Be the best leader you can be by caring about others and remaining ethical. Ethics is fundamentally how we treat others. Do we measure up to that standard?
More Dates
Navigating Leaves of Absence
12:00pm - 1:07pm
Online
1.00 Credits
Member Price: $39
See more dates
What obligations does an employer have when an employee needs to take a leave of absence? This presentation will provide an overview of the complicated, intertwined compliance obligations triggered when an employee requests a medical leave of absence (including for pregnancy, mental health, or addiction).
More Dates
Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 2 (Cryptology)
1:00pm - 1:56pm
Online
1.00 Credits
Member Price: $39
See more dates
This is a continuing part of our series on forensic accounting. Within this segment we discuss the concepts that are part of computer forensics known as cryptology. The term cryptography is from Ancient Greek and means “hidden secret”. It is the practice and study of techniques for secure communications in the presence of adversarial behavior. Cryptography is about constructing and analyzing protocols that prevent third parties or the public from reading private messages. Cryptography starts with secrets. Various aspects in information security such as data confidentiality, data integrity, authentication and non-repudiation (where a statement’s author cannot successfully dispute its authorship) are central to modern cryptography.
More Dates
K2's Ten PDF Tips You Need To Know
1:00pm - 2:00pm
Online
1.00 Credits
Member Price: $39
See more dates
Portable Document Format (PDF) documents are everywhere! Yet few know how to work effectively with these documents. If you are interested in working more effectively and efficiently with PDFs, this session is for you. In this session, you will learn valuable tips you can use to assist you with creating, editing, and securing PDFs. You will also learn how to convert PDFs to fillable forms and secure PDFs, among other features. Don't miss this chance to learn ten PDF tips you need to know to increase your ROI on PDFs.
More Dates
Surgent's Bankruptcy Basics: Understanding the Reorganization and Liquidation Process in These Uncertain Economic Times
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Consumers and businesses file for bankruptcy to seek protection from creditors and to reorganize or liquidate debts. Bankruptcy filings rise and fall with the economy. Surveys show that loss of income is the leading cause of consumer bankruptcies, followed by medical expenses and foreclosure. Corporate bankruptcies, on the other hand, are often the result of several factors, including excessive debt, decreased demand, increased costs, lawsuits or poor accounting practices. It is no secret bankruptcy filings will see a tremendous uptick in the wake of the Covid-19 pandemic. As an accountant, CFP, attorney or other professional, you need to be able to discuss the process and different available courses of action with your clients. Both landlords and tenants will be influenced tremendously. Individuals will look to your advice for a discharge and new start. Businesses will do the same and will also need to advise loyal employees. Creditors will receive proofs of claim and look to you for your expertise. Take this course and make sure you can speak fluently to both creditors and debtors. As trusted advisors, then, professionals should have a basic understanding of the bankruptcy process. This course provides a thorough review of the consumer and corporate bankruptcy practice. Participants in this course will gain an understanding of how consumer and corporate bankruptcy proceedings begin and end, as well as learn about key issues that affect debtor and creditor rights during bankruptcy. This course provides information from the perspective of both debtor and creditor. Although bankruptcy concerns the debts of the debtor, the Bankruptcy Code provides substantial protections to creditors. Creditor rights, however, vary widely depending on the status afforded the creditor under the Bankruptcy Code. Do yourself, your clients and your profit margin a favor and sign up for this invaluable program.
More Dates
Surgent's Excel: Mastering PivotTables
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.
More Dates
Surgent's Lessons Learned from Successful Companies
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Why do some companies fail while others grow and succeed for generations? Common perceptions often attribute organizational success to great leadership, timing, or unique ideas. Although these traits certainly play a role in helping companies grow, research shows that corporate success often hinges on whether a company is value driven. Such companies have core ideologies that drive almost every major decision. In this course, we look at empirical data on why some companies succeed while others fail. By looking at companies that were created prior to 1950 (e.g., Disney, Marriott, or 3M), we can understand why certain organizations have been able to grow and achieve exceptional success through many different eras in the American economy. The lessons learned from these visionary companies can be broadly applied to organizations of all sizes, including accounting and financial service firms.
More Dates
The Ethics Hour: Ethics is the Engine to Better Leadership: Taking Action, featuring Bob Mims and Don Minges
2:00pm - 3:00pm
Online
1.00 Credits
Member Price: $39
See more dates
Ethics is grounded in leadership and the finest leaders are always ethical. Every effective leader is ethical, in words and actions. The best leaders communicate effectively. Being trustworthy is more than being honest and fair. In today’s turbulent environment, leadership matters more than ever as the talented staff will readily move to ethical leaders. We must enhance our leadership skills to remain valuable. Simple stated - we all want to work for, and with, an ethical leader.
More Dates
Surgent's Excel Budgeting Ideas
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.
More Dates
Surgent's Tax and Advisory with Agentic AI
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $119
See more dates
This course examines how agentic AI is revolutionizing tax compliance, planning, and advisory services. Participants will explore real-world deployments by leading firms such as EY, which has developed agents that handle millions of global tax transactions. The course also delves into cross-border compliance issues, transfer pricing automation, and emerging advisory models powered by agent-led simulations. Risks related to bias, unauthorized practice, and data privacy will be addressed, with guidance on aligning autonomous operations with professional and regulatory standards. CPAs must understand these advancements to ensure tax compliance, manage client expectations, and mitigate professional liability risks when providing agent-assisted advisory services.
More Dates
K2's Excel Charting And Visualizations
2:00pm - 5:37pm
Online
4.00 Credits
Member Price: $129
See more dates
Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.
More Dates
Excel Accounting Tools: Most Useful Formulas and Pivot Tables
2:30pm - 6:30pm
Online
4.00 Credits
Member Price: $180
Financial professionals can transform their daily workflow with this comprehensive training designed specifically for accountants and business analysts. Participants will discover how to leverage advanced Excel formulas, including VLOOKUP, XLOOKUP, dynamic arrays, and logical functions that streamline complex calculations and automate routine tasks. This practical approach focuses on real-world applications, showing professionals how to reduce hours of manual work into efficient, automated processes that minimize errors and maximize productivity. Beyond powerful formulas, participants will gain hands-on experience with pivot tables, the cornerstone of modern business reporting. The course demonstrates how to create dynamic reports, implement advanced calculations, and design intuitive data visualizations that enhance decision-making capabilities. Professionals will walk away with immediately applicable skills that strengthen their analytical capabilities, improve reporting efficiency, and add significant value to their organization. This course bridges the gap between basic Excel knowledge and the advanced techniques needed in today's data-driven business environment, making it an essential investment for accounting professionals seeking to enhance their technical capabilities and career growth.
K2's After QuickBooks, What's Next?
3:00pm - 4:00pm
Online
1.00 Credits
Member Price: $39
See more dates
Accounting professionals face a critical technological shift with the discontinuation of QuickBooks Pro and Premier sales in 2024. This course explores the transition to modern platforms, including QuickBooks Online, Xero, Zoho Books, FreshBooks, and more. Participants will gain insights into key features, integration capabilities, add-on solutions, and payroll and reporting functionalities. Learn strategies for seamless implementation and discover how to guide clients effectively through this change. Comparative tables and expert insights will equip you to make informed recommendations for your practice or small business. Attend this session and learn more about platforms available for small businesses.
More Dates
Defining Lines: Advanced Professional Boundaries
3:00pm - 4:47pm
Online
2.00 Credits
Member Price: $79
See more dates
This is a specialized course designed for experienced accounting professionals who are looking to strengthen their interpersonal and professional skills in maintaining appropriate boundaries within and beyond the workplace. This course delves deep into the complexities of workplace relationships, personal practices, & ethical dilemmas, providing participants with advanced strategies to effectively manage professional distances and avoid problematic conflicts of all kinds. Through interactive sessions, case studies, and expert guidance, attendees will learn how to navigate sensitive situations with tact and integrity, ensuring that their professional conduct remains impeccable, and their careers continue to thrive in an increasingly complex business environment.