Professional Development and Event Catalog
Advanced Excel for Staff - Build Reports and Analyze Data
11:30am - 1:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. 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
Ethics: How to Give and Receive Criticism the Right Way
12:30pm - 2:30pm
Online
2.00 Credits
Member Price: $89
See more dates
How well do you accept criticism? How might it enrich your business - and you - if you did a better job of it? This distinctive webinar will show you why it is in your best interest to accept criticism with gratitude. It's even better to welcome criticism. It's also a good idea to learn how to give criticism the right way. A related topic is the art of giving and receiving apologies, and we'll do a deep dive into this area as well. You'll leave with clear guidelines for how to criticize others, accept criticism from them, give meaningful apologies, and accept apologies with grace and ethical intelligence. The result will be a stronger CPA practice and a better you. 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
Resistance to Resilience: Strive for Tech Change Acceptance
1:00pm - 2:00pm
Online
1.00 Credits
Member Price: $55
See more dates
Technology adoption often comes with resistance, but it's possible to transform this challenge into an opportunity for growth. This course explores the journey from resistance to resilience in embracing new technologies, focusing on overcoming barriers and ensuring successful implementation. Participants will examine cutting-edge audit technologies, including AI, data analytics, and automation, and learn how to align these innovations with both organizational and personal goals. Through case studies, insights into the Technology Acceptance Model (TAM), and practical discussions, participants will gain the tools and strategies to foster acceptance, driving seamless integration of new technology into both individual tasks and team workflows. 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
Ethical Performance Management
1:00pm - 3:00pm
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
Surgent's Excel Shortcuts for Accountants
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.
More Dates
Surgent's Guide to Calculating S Corporation Shareholder Stock and Loan Basis
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
This program discusses, in a practical way, how an S corporation shareholder calculates their stock and loan basis on Form 7203. Form 7203 is the IRS Form on which a shareholder is sometimes required to calculate their stock and loan basis. This topic is particularly important when an S corporation has a loss and the shareholders wish to know whether they are entitled to fully utilize the loss that has been allocated to them against their other income.
More Dates
Surgent's Understanding Partnership Taxation: Types of Basis, Contributions, and Distributions
1:00pm - 4:30pm
Online
4.00 Credits
Member Price: $159
See more dates
Calculating partnership basis is one of the most important things that we do as practitioners. However, it is also one of the most confusing. When we use the term "basis," we really could be referring to one of three different things. This course will explore the differences between inside basis, outside basis, and 704(b) basis. Through several examples and practice problems, we will show you how to easily distinguish among these terms. We will also explore the tax implications of initial contributions of property to a partnership as well as the different types of partnership distributions.
More Dates
Navigating IRS Collections: The Collection Process
1:30pm - 3:30pm
Online
2.00 Credits
Member Price: $89
See more dates
This course is designed for tax professionals seeking to understand and navigate the IRS collection process effectively. Participants will gain indepth knowledge of the various collection methods employed by the IRS, including liens, levies and wage garnishments. Additionall, participants will leand strategies to avoid or halt collection actions and the implications of the statute of limitations on tax collection. 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 Navigating Your Client Through the IRS Appeals Process
1:30pm - 5:00pm
Online
4.00 Credits
Member Price: $159
See more dates
Despite the fact that a client's tax matter may be taken directly to court, utilizing the IRS Independent Office of Appeals usually results in saving your client both time and money. Join us as we discuss the misunderstood process of navigating through the complex IRS Appeals.
More Dates
Surgent's Select Estate and Life Planning Issues for the Middle-Income Client
1:30pm - 5:00pm
Online
4.00 Credits
Member Price: $159
See more dates
Clients think that estate planning only applies to the very rich. In truth, there are many issues of critical concern for which the middle-income client needs to plan. This course is a must-attend for all Accounting and Financial Professionals who work with middle-income clients and are looking for ways to provide additional quality services. Updated for developments relative to estate tax changes.
More Dates
Independence for Auditors - AICPA, PCAOB, GAO and DOL
1:30pm - 5:30pm
Online
4.00 Credits
Member Price: $149
See more dates
Independence requirements are foundational to audit quality, yet they vary depending on the applicable regulatory and professional framework. This course provides a practical overview of auditor independence rules and highlights key similarities and differences across major standard setters and oversight bodies. Participants will review independence requirements issued by the AICPA, Government Accountability Office (GAO), Department of Labor (DOL), and the Public Company Accounting Oversight Board / SEC. The course emphasizes common areas of confusion, nuanced differences among the frameworks, and considerations auditors should keep in mind when performing attest services for different types of clients. This overview course is designed to help auditors recognize which independence rules apply in various engagement scenarios and better position themselves to meet applicable independence requirements. 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
The Role of Internal Control in the Risk-Based Audit
2:00pm - 6:00pm
Online
4.00 Credits
Member Price: $149
See more dates
This program addresses the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. Practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers will be explored, with particular emphasis on internal controls of small-to-medium clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available for your questions during the event.
More Dates
The Leadership Skills of Tomorrow: Delegate and Listen
2:30pm - 4:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. 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
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
Selected Ethics Topics 2025 - 2026
3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $89
See more dates
This course will help you to stay current on recent changes to the AICPA Code of Professional Conduct, as well as keep you abreast of emerging trends in ethics standards and regulatory initiatives and their potential impact on your practice. We will also explore frequent practitioner ethics compliance challenges, including competence, due professional care, audit quality, and independence. 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 Agentic AI Foundations for Finance and Accounting
3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $119
See more dates
This course introduces accounting, auditing, and finance professionals to the emerging field of agentic AI: autonomous, goal-driven systems capable of planning, acting, and learning with minimal human intervention. Participants will explore how agentic AI differs from traditional automation (RPA) and generative AI, and how these agents are being deployed in finance and accounting. The course emphasizes foundational concepts such as the Perceive-Reason-Act-Learn (PRAL) loop and ethical decision-making frameworks. To ground abstract ideas in practice, participants will experience a brief agent simulation using basic ChatGPT, showcasing how natural language prompts can emulate agentic behavior, such as goal setting, clarification loops, and structured task execution. The course also highlights real-world agent platforms (e.g., Microsoft Copilot, IBM watsonx, and UiPath) to provide context on enterprise adoption trends and discusses emerging global regulations such as the EU AI Act and the U.S. Executive Order on Safe AI.
More Dates
The AI Revolution in 2026: What CPAs Should Know
4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $89
See more dates
AI is reshaping accounting, tax, and finance. This update surveys the state of AI technology in 2026: core concepts, software tools, risks/controls, and practical CPA use cases. You will leave with an expanded AI vocabulary, a current view of the AI landscape, and actionable talking points for staff, clients, and service providers. 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
Workforce Transformation and Talent Management in 2025
9:00am - 10:00am
Online
1.00 Credits
Member Price: $55
See more dates
The accounting profession faces unprecedented workforce challenges that demand a fundamental rethinking of traditional firm structures. This course examines why the century-old pyramid practice model is becoming obsolete and presents the inverted pentagon framework as a sustainable alternative. Based on comprehensive research showing that 52% of firms expect to shrink by 20% or more in the next five years, participants will learn how to restructure their firms to thrive with fewer entry-level staff while expanding specialized expertise. The course explores the "6 Ps of Business Model Transformation" - Precision Hiring, Proactive Retention, Practical Technology Implementation, Pricing Expertise, Practice Area Expansion/Focus, and People Acceleration. Drawing from success stories in manufacturing, healthcare, and technology industries, attendees will discover proven strategies for accelerating staff development, implementing effective knowledge transfer programs, and building sustainable talent pipelines in an era of technological disruption and demographic shifts. 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
S Corporations: Calculating Shareholder Basis
9:00am - 11:00am
Online
2.00 Credits
Member Price: $89
See more dates
A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. 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
Using ChatGPT with Excel
9:00am - 11:00am
Online
2.00 Credits
Member Price: $89
See more dates
In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.