Professional Development and Event Catalog
This will generate a PDF of the current filtered catalog
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups
Friday, Feb. 26 12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Boosting productivity with Excel For those unfamiliar with conditional summing, you're in for a revelation —it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by managing duplicates, selecting appropriate shortcuts, and performing lookups. Practical hands-on Excel learning exercises taught by highly engaging expert in the field You'll also deepen your skills and tackle real-world Excel workbooks that address the following: Benefits of using lookup functions over direct cell referencing A comprehensive exploration of the popular VLOOKUP function Techniques for removing duplicates to create a distinct set of report labels *Session 4 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Surgent's Marijuana: A Generalized Business Viewpoint
Friday, Feb. 26 12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Each year, more states legalize cannabis (i.e., marijuana) for medical or recreational purposes. As legalization grows, so too does the cannabis industry. While some financial professionals have stayed away from this growing sector of the economy, others have embraced the opportunities the cannabis industry has to offer. The legalization of cannabis brings with it a complex regulatory landscape, which includes strict compliance with federal and state regulations. However, the complexity of this emerging market provides opportunities for accountants and other financial professionals. Behind the cannabis dispensaries are scores of related business sectors including food production, retail, farming, and chemical production, as well as facilities, design, and construction. Simply stated, the commercialization of marijuana offers financial professionals an opportunity to participate in an industry expected to reach $73 billion worldwide within six years.
More Dates
Audit Skills for Beginners
Friday, Feb. 26 12:00pm - 3:38pm
Online
4.00 Credits
Member Price: $149
See more dates
Learn the basic skills new staff need to hit the ground running and efficiently complete assigned tasks, including what new auditors are expected to know and do, including the nature, timing, and extent of common audit procedures. Focus on why certain procedures are performed and perform typical procedures.
More Dates
Effective Governance for Nonprofit Success
Friday, Feb. 26 1:00pm - 1:57pm
Online
1.00 Credits
Member Price: $39
See more dates
Effective governance is the cornerstone of any nonprofit organization. This course delves into the foundational elements of nonprofit governance, emphasizing fiduciary duties, board responsibilities, and best practices for board operations. Participants will explore key compliance requirements, risk management strategies, policy development, and regulatory obligations. By the end of the session, you'll be equipped with practical tools and insights to confidently navigate the complexities of nonprofit governance.
More Dates
What If Your Client Didn't Take Reasonable Compensation
Friday, Feb. 26 1:00pm - 2:00pm
Online
1.00 Credits
Member Price: $55
See more dates
Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures, and address challenges within the year. 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
Working Through Grief and Loss - How to Build a Supportive Workplace
Friday, Feb. 26 1:00pm - 2:01pm
Online
1.00 Credits
Member Price: $39
See more dates
Now more than ever, navigating loss, grief and crisis in the workplace is a skillset that leaders must possess. Keeping the heart in human resources is so important, especially in this post-pandemic state we are living in. We will explore ways that you can show empathy to your employees while also balancing your business needs.
More Dates
How to Audit Cash
Friday, Feb. 26 1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Cash is essential to every business, and is often one of the first accounts audit staff are exposed to. This course will cover the basics of auditing cash, including the related audit assertions, risks, & threats to the cash balance. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through some real-world examples. 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
K2's AI Accounting and Fraud Detection
Friday, Feb. 26 1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $89
See more dates
As accounting software evolves, AI-native systems are transforming how firms manage data and measure results. This session explores emerging AI-integrated general ledger platforms such as Digits, Puzzle.io, and Docyt. It examines how new technologies, like vibe coding and low-code/no-code automation, are reshaping efficiency and improving fraud detection. Attendees will learn to assess ROI across accounting tools, identify key performance metrics, and develop an automation strategy that enhances accuracy, productivity, and profitability. This course equips professionals to make smarter technology investments and prepare for the next wave of AI-driven accounting transformation.
More Dates
K2's Ripped From The Headlines: Lessons Learned From The Most Interesting Tech Crimes
Friday, Feb. 26 1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $89
See more dates
This session dives into real-world cases of financial fraud, cybercrime, and ethics breaches that captivated the business and accounting world. This session analyzes how these crimes unfolded, the warning signs that were missed, and the internal control and technology failures that enabled them. Participants will explore modern threats, including AI-enabled deception, and learn practical steps to strengthen fraud prevention, data protection, and governance. From shocking embezzlements to headline-making cyberattacks, this course turns true stories into powerful lessons for today's accounting and finance professionals.
More Dates
Professional Ethical Considerations for CPAs
Friday, Feb. 26 1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Every CPA must comply with a Code of Professional Conduct, which is a hallmark of the CPA designation. CPAs in public practice must overcome higher barriers, such as when attest service providers must also retain independence. This course will provide an overview of the core principles from which the CPA profession is built upon. 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 Excel for Accountants: Using Excel to Cleanse and Prepare Data
Friday, Feb. 26 1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.
More Dates
Taxation of Judgements and Settlements
Friday, Feb. 26 1:00pm - 3:05pm
Online
2.40 Credits
Member Price: $99
See more dates
In the course of legal actions, payments may be made pursuant to a final disposition of a court case or a mutually agreed-upon settlement. This course will cover the tax implications for payments made for personal injury, emotional distress, lost wages, punitive awards, pre- and post-judgement interest, contract claims, among other damages. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.
More Dates
Mastering Rapport Skills for Fun and Profit
Friday, Feb. 26 1:00pm - 4:35pm
Online
4.00 Credits
Member Price: $149
See more dates
You only have one chance to make a good first impression. In the fast paced world we live in, being able to create immediate rapport and a sense of trust with people is more important than ever. Fortunately, this is an easily learnable skill that can serve you in both business and in life. People who can master the one minute relationship end up making more money, being better liked, and enjoying their clients more.
More Dates
Al Capone to Cybercrime: The Journey of IRS Special Agents
Friday, Feb. 26 1:30pm - 5:30pm
Online
4.00 Credits
Member Price: $149
See more dates
Since 1919, the Internal Revenue Service had a civil and criminal function in the United States tax system. Little do people know, the IRS has an elite criminal function that started with five United States Postal Inspectors. From its early days in taking down Al Capone to now solving cybercrimes, the IRS special agents are tasked with investigating tax fraud, money laundering, and other white collar crimes. This presentation will show you the importance of this law enforcement function, the training, techniques, expertise, and actions that cause them to be known as the "world's finest financial investigators." This presentation has been prepared by a 20 year veteran with the IRS-Criminal Investigation. The presenter investigated crimes, and trained and mentored other special agents. 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
Big Picture Mega-Trends, Big Data, and World We Now Face
Friday, Feb. 26 2:00pm - 3:48pm
Online
2.00 Credits
Member Price: $89
See more dates
It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize.
More Dates
Risk Wrangling: Surviving the Modern Business Rodeo
Friday, Feb. 26 2:00pm - 3:51pm
Online
2.00 Credits
Member Price: $89
See more dates
Risk-based factors are becoming exponentially important considerations for accountants in both public practice and industry. We examine the nature of risks for today’s enterprises while exploring the role of internal controls for mitigating business risks. We also explore SAS 145 and other guidance aimed at risk considerations for professional engagements. Public and private accountants will enhance their capabilities for assessing and addressing risks faced by today’s organizations.
More Dates
Tax Procedure
Friday, Feb. 26 2:00pm - 3:54pm
Online
2.00 Credits
Member Price: $89
See more dates
This seminar will introduce the process from filing a tax return to the IRS audit, IRS Appeals, Collections and litigation at courts of original jurisdiction. We will discuss the options taxpayers have at any point in the process with reference to real-life stories from the trenches. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.
More Dates
Ethics without Fear for Accounting and Finance Professionals
Friday, Feb. 26 2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Finance and accounting professionals are on a pedestal and are often held to a higher standard. Keeping your ethical skills sharpened is crucial to reducing your fear and raising your courage as you solve tough decisions in real-time. This fast-paced and interactive presentation will help you practice exactly that. What will you gain? The ability to choose the most effective path in daily situations, so that when a significant crisis hits you are comfortable in your actions. Be ready, be courageous, be fair, and be consistent.
More Dates
Steps to Stop External Fraud
Friday, Feb. 26 2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $89
See more dates
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.
More Dates
Surgent's Tax and Advisory with Agentic AI
Friday, Feb. 26 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.