Professional Development and Event Catalog
Complete Guide to Analyze Data with Excel PivotTables
2:00pm - 6:00pm
Online
4.00 Credits
Member Price: $149
See more dates
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Disrupt to Dominate: Mastering Change Leadership
2:00pm - 6:00pm
Online
4.00 Credits
Member Price: $149
See more dates
In an era defined by rapid change and uncertainty, effective leadership requires more than just managing teams; it demands the courage to disrupt and innovate. This course is your blueprint for transforming potential chaos into a strategic advantage and is designed for leaders at all levels-whether you're a seasoned CEO, an ambitious small business owner, or an individual contributor aspiring to influence greater change. You'll gain the insights and tools needed to not only adapt to change but to lead it effectively and confidently. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Performance Auditing Made Easy
2:30pm - 3:54pm
Online
1.50 Credits
Member Price: $59
See more dates
Unlike a traditional financial audit objective (Are the financial statements materially misstated), performance auditing can address a wide variety of objectives. Is this program working? Can it be improved? Where can we save money? How can we operate more efficiently and effectively? Are management’s assertions supported? And so forth. This session will explain what a performance audit is, describe the applicable standards, and provide examples that indicate the value of a performance audit. Performance audits can add value to any entity and practitioners can profit from adding these assurance services to their practices.
More Dates
How Much Are Your Ethics Worth?
2:30pm - 4:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Ethics are of central importance to the CPA profession. But what do we mean by ethics? Is it just appropriate behavior, compliance with laws, or is it more than that? In this course, we'll discover what sets ethics apart and, therefore, sets the profession apart as well. We'll explore the tools available, the role of bias, and dive into real life case studies. We'll apply the AICPA's ethical framework and detect where bias was involved in the case studies. We'll even discover that one person set the price tag on their ethics at $53.7 million, only to lose it all in the end. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Achieve Competency in Three Basic Tool Categories - Master the Fundamentals
2:30pm - 6:03pm
Online
4.00 Credits
Member Price: $129
See more dates
Financial skills needed in many situations are constantly changing. It is prudent to routinely look into your toolbox to restock or revise your tool set. In this course we will examine three tool categories that form the foundation for many analytical processes.
More Dates
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
Forensic and Fraud Interviewing Techniques and Skills
3:00pm - 4:58pm
Online
2.20 Credits
Member Price: $79
See more dates
In forensic accounting, interviewing is used to obtain important information from witnesses and suspects. An important aspect is the ability of investigators to obtain accurate and reliable information from victims, witnesses and the suspects or any interviewee. The interview process is an essential part of information gathering for any investigation. The importance of improving the quality of the interviewing with the potential for visual recording of all interviews should be placed high on the agenda of all organizations across the globe. A properly conducted forensic interview can result in an extreme benefit regarding collection of information. The interviewer’s role is to develop a full understanding of the facts. There is a distinct difference between a forensic interview and a criminal interrogation. Typically, forensic auditors will not be involved in interrogations. The Canadian or U.S. forensic accounting profession does not have a standardized interview model to truly equip its professionals with the interview tools required to elicit confessions ethically. Majority of their skills are developed through experience, and not through a standardized model of training. This session focuses on various interview concepts and methods.
More Dates
Mastering the Excel Lookup Functions
3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $89
See more dates
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Work-Life Balance: Maximizing Productivity and Understanding Related Tax Issues
3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Working as a financial professional is an accomplishment that offers the potential for a good salary with long-term growth. Despite being a sought-after career, studies show that being overworked is the greatest source of anxiety and dissatisfaction among financial professionals. Left unchecked, a life centered exclusively around the demands of work can be both physically and emotionally detrimental. Establishing a work-life balance is difficult in any profession, yet financial professionals confront unique challenges that make this goal seem even more elusive. Technology results in being "always on," with no true time to disconnect and genuinely enjoy family, exercise, or hobbies. Lack of balance comes with costs, including poor health and lower productivity. Why are some professionals able to establish a successful balance between career demands and family while others are not? How are some firms able to achieve both high employee satisfaction and strong productivity? This course looks at research, surveys, and simple anecdotal information to provide a better understanding of how to achieve a realistic work-life balance in the modern world. The program also discusses the tax consequences that arise when professionals seek balance by working from home in one state while their employer is located in a different state.
More Dates
Planning for Small Business Success
3:00pm - 6:44pm
Online
4.00 Credits
Member Price: $129
See more dates
Ethical Performance Management
3:30pm - 5:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Today, more than ever, effective performance management is critical to the well-being of an organization, as well as the engagement and satisfaction of staff. Unfortunately, performance management is also often one of the most dreaded responsibilities managers face. This session will provide insight into what performance management is, how to prepare and conduct performance appraisals, how to coach the marginal employee, legal considerations to be aware of when conducting an appraisal, and ways to engage and motivate staff. In addition to providing tools to conduct effective appraisals, we will also look at the ethical implications of employee reviews. When done well, performance management has the power to improve communication between managers and their staff as well as help foster stronger career paths and routes for growth. It can motivate, re-engage, and energize everyone involved. Ethical values such as fairness, accountability, respect, intellectual honesty, and trust will be incorporated into this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Minimizing Workplace Warfare
4:00pm - 5:03pm
Online
1.20 Credits
Member Price: $39
See more dates
This course is designed to equip HR leaders, managers and business owners with the knowledge and skills needed to effectively minimize conflicts in the workplace. Participants will learn about the various sources of workplace conflict, how to identify and address conflicts before they escalate, and how to implement effective conflict resolution strategies. The course will also cover topics such as communication skills, active listening, and conflict management techniques. By the end of the course, leaders will be able to create a more positive and productive work environment, reduce turnover, and promote employee satisfaction.
More Dates
Data Analytics: Practical Insights for Today's Accountant
4:00pm - 5:46pm
Online
2.00 Credits
Member Price: $79
See more dates
This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today's popular and software tools and examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements.
More Dates
Keeping Up with the FASB
4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $89
See more dates
This course will explore significant elements of the FASB's technical agenda, focusing on recent updates to revenue recognition and lease accounting standards. A Special Purpose Framework overview will be provided, which may reveal salient alternatives to U.S. GAAP for certain entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Business Partnerships: Managing Supplier Relationships
4:30pm - 5:30pm
Online
1.00 Credits
Member Price: $55
See more dates
As financial leaders, CPAs are often tasked with managing organizational risk. In this respect, the supplier relationship can be a tricky one. It is often one of the more familiar and comfortable business relationships we have, yet it may also be the one that presents the most significant risk to our company. In this course, we will explore how to manage the supplier relationship from onboarding to termination. Through case studies and best practices, we will discuss how to continue being a good partner to our suppliers while also understanding where potential risks exist. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Introduction to Forensic Accounting
5:00pm - 6:37pm
Online
1.80 Credits
Member Price: $59
See more dates
This course provides a high-level overview and introduction into the world of the forensic accountant. Most accountants have an understanding of the concept of fraud and how it impacts companies, but many individuals do not have a full comprehension of the variance in the work performed by a forensic accountant versus a typical management accountant. This course is meant for those individuals interested in understanding the variances in the job tasks and responsibilities of forensic accountants versus typical financial or management accountants. Forensic accountants or auditors take a unique focus on performing their work. Typically, when a person with forensic experience is called in to examine financial records, it is due to suspicion of fraud, evaluation of assets, or even to track down fundamentally incorrect accounting – intentional or not. As fraud continues to raise its head in business processes, forensic accountants are discovering new and unique ways to identify, examine, and support their hypotheses and investigative techniques. The work performed by a forensic specialist can be interesting and full of potential potholes if evidence isn’t examined according to proper protocols and standards.
More Dates
K2's Taking A Fresh Look At Teams
5:00pm - 7:00pm
Online
2.00 Credits
Member Price: $79
See more dates
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.
More Dates
The Controllership Series - The Treasury Function Part 1 - Cash and Investing
9:00am - 10:50am
Online
2.00 Credits
Member Price: $79
See more dates
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.
More Dates
Estate and Financial Planning for the Older Client
10:00am - 5:42pm
Online
8.00 Credits
Member Price: $225
See more dates
Enter the complex world of elder planning with this comprehensive course tailored for financial professionals. Gain invaluable insights into estate and financial strategies designed specifically for older clients, equipping you with the knowledge and skills to address their unique needs and challenges. Throughout the course, participants will explore a wide range of topics, from understanding the complexities of Medicare and various life insurance types to navigating Social Security considerations and exploring Medicaid planning details. With a focus on practical application, attendees will learn to customize estate planning strategies, explore housing and care alternatives, and address gifting complexities relevant to older clients. By the end of the program, you'll develop expertise in executing specialized planning requirements for mature clients, ensuring you're well-prepared to provide informed counsel and support in this important aspect of financial practice. Join us and enhance your knowledge in estate and financial planning for the older client today. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com
More Dates
HR Investigations - Episode 2 - Interview Techniques
11:00am - 1:00pm
Online
2.00 Credits
Member Price: $79
See more dates
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for interviewing to gather accurate information, such as creating and asking open ended questions, effective listening, and understanding verbal and non-verbal communication. Attendees will end the session with takeaways to immediately implement in future HR investigations. Two of three Episodes in the series.