Professional Development and Event Catalog
From Numbers to Narratives: Mastering Data Analysis for CPAs
4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $89
See more dates
The accounting profession is rapidly shifting from a compliance-centered focus to one that demands insight, foresight, and strategic advisory skills. "From Numbers to Narratives: Mastering Data Analysis for CPAs" explores the "why" behind this transformation and highlights the critical role data analysis plays in helping CPAs remain relevant and competitive. This course provides a high-level overview of the skills and mindset required to move beyond historical reporting and into forward-looking analysis and storytelling. Participants will gain an understanding of how Microsoft 365 applications - such as Excel, Power Query, Power BI, OneDrive, and Teams - can be leveraged to transform raw financial data into meaningful insights. With an emphasis on the advisory role of CPAs, this course empowers professionals at every stage of their career to embrace analytics as a core competency. 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, AI, and Music: What Every CPA Must Know
5:00pm - 6:00pm
Online
1.00 Credits
Member Price: $55
See more dates
You may be surprised to learn how artificial intelligence is transforming the music you love. For example, what happens when AI creates songs based on other people's work without credit or payment? How should musicians disclose the role of AI in their recordings? The challenges that AI poses for music, such as threats to intellectual property, confidentiality, fairness, and professional reputations, are also front and center in accounting. This one-hour ethics course invites you to explore one of your favorite subjects outside of work. You'll discover how the five principles of ethical intelligence can help you listen to music in ways you never considered before. You'll also see how these same principles guide you in making the best decisions in your accounting practice. 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
Exercise Your Ethics: Techniques to Improve Ethical Response
9:00am - 11:00am
Online
2.00 Credits
Member Price: $89
See more dates
Many courses highlight ethical failures - this course goes beyond that. This course identifies the many barriers to ethical behavior, focuses on habits and techniques that improve ethics and offer ways to practice so that the ethical "muscle" is ready for any dilemma. This course incorporates ideas from leading ethical authors and includes data from the ACFE Report to the Nations. 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 Handbook for Mastering Basis, Distributions, and Loss Limitation Issues for S Corporations, LLCs, and Partnerships
9:00am - 5:00pm
Online
8.00 Credits
Member Price: $279
See more dates
The most difficult concepts to master when dealing with flow-through business entities are the basis and distribution concepts. Major error and malpractice issues occur if the CPA does not fully understand the impact of these rules. This course is designed to focus on the practical applications of these rules.
More Dates
Surgent's Latest Developments in Government and Nonprofit Accounting and Auditing
9:00am - 5:00pm
Online
8.00 Credits
Member Price: $299
See more dates
In today's fast-paced environment, keeping up with the latest accounting and auditing requirements for governments and nonprofits can be challenging, but this course makes it easier! Designed to save you time and effort, this comprehensive update provides clear explanations of the most important developments affecting governments and nonprofits. Using a highly illustrative and innovative format, the course features over 25 focused exercises to strengthen your working knowledge and ensure you leave prepared to apply the latest accounting and auditing standards with confidence.
More Dates
You Don't Know What You Don't Know About Microsoft Excel
9:00am - 5:00pm
Online
8.00 Credits
Member Price: $239
See more dates
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. 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
Best Practices: Conducting Meaningful Walkthroughs
9:30am - 11:30am
Online
2.00 Credits
Member Price: $89
See more dates
This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identifying internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough. 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
Avoiding the Most Misapplied Audit Concepts
9:30am - 5:30pm
Online
8.00 Credits
Member Price: $239
See more dates
Recent new auditing standards are designed to improve overall audit quality. The course will address the most common misapplied audit concepts in planning and performing effective and efficient financial statement audits. 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
Supervision/Management Competencies: An Ethical Approach
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Job titles for individuals can vary in different organizations even though the work is the same. This webinar is designed for the individual whose role is to oversee the work of others. This webinar includes an overview of Aristotle's virtue ethics and its application to the responsibility and privilege of developing employees to be their best and for the success of the organization. We will also address issues such as going from "buddy to boss", how to manage if you are newly assigned to an existing employee that was previously supervised by someone else, and critical skill sets necessary for supervisory/managerial positions. 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 Lookups: Moving Beyond VLOOKUP Limitations
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $99
See more dates
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
More Dates
Surgent's Top Individual Tax Planning Strategies
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Individual tax planning strategies for 2026 and beyond will take their cue from the many tax advantageous tax law changes enacted in the One Big Beautiful Bill Act (OBBBA). Many of the OBBBA changes are very favorable to individual taxpayers. Taxpayers and their clients now have the opportunity to utilize these new planning strategies. Tax practitioners must know about these new changes and the planning strategies associated with them to maximize the advantages to their clients. This program will cover tax changes from 2025 that impact individuals and provide individuals with significant tax reduction opportunities for 2026.
More Dates
Surgent's Virtual Currency: Keeping Up with the Tax Code
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $119
See more dates
Whether you are an experienced veteran or new to the industry, one of the toughest parts of being a tax practitioner is keeping up with all of the changes in tax legislation. This course takes a look at recent changes to tax law from a practitioner perspective. In this session, we will explore the nuances of virtual currency and the new Form 8300 reporting requirements.
More Dates
Analyzing IFRS Financial Statements
10:00am - 2:00pm
Online
4.00 Credits
Member Price: $149
See more dates
Evaluating performance for professionals used to GAAP. A strong foundation in financial statement analysis is essential for understanding a company's performance and financial health across reporting standards. This seminar is designed for professionals, particularly those trained in U.S. GAAP, who want to enhance their understanding of IFRS-based financial reporting using a real-world Canadian public company as a case study. We will walk through the company's IFRS-based balance sheet, income statement, and statement of cash flows, highlighting both presentation and interpretation differences compared to U.S. GAAP. Participants will learn key analytical tools such as common-size analysis, trend analysis, and financial ratios covering liquidity, profitability, and leverage for an IFRS reporting company. Throughout the session, comparisons to GAAP will help clarify terminology, classification differences, and measurement principles-including treatment of leases, revenue, financial instruments, and impairment. The seminar also moves beyond basic ratios to explore advanced analytical techniques, such as ROE decomposition, operating vs. non-operating performance measures, and managerial ratios that reveal cost behavior, efficiency, and cash flow dynamics. Participants will see how IFRS disclosure requirements can offer additional insight into performance, risk, and sustainability. This practical and comparative seminar is ideal for accounting, finance, and business professionals who want to sharpen analytical skills, interpret IFRS-based financial statements, and better understand how to bridge IFRS and GAAP for global comparison and decision-making. 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
Tax Depreciation: Review and Update
11:00am - 1:00pm
Online
2.00 Credits
Member Price: $89
See more dates
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. 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
11:30am - 1:30pm
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
How to Build a Custom AI Chatbot and GPT in Plain English
12:30pm - 2:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. 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 Establishing State Residency and Saving Your Clients Money
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Many of our clients are moving to one of the seven states with no personal income tax, particularly Florida and Texas. Others may maintain multiple homes with an eye toward eventually establishing residency in a state with no income tax. This course will give you practical tips for your clients seeking to establish residency in a new jurisdiction. Cash-strapped states are increasingly attempting to assess taxpayers who have declared domicile and residency elsewhere, for example in Florida, to maintain their diminishing tax base. Arm your clients with the tools needed to save money by successfully establishing domicile and residency. As a practitioner, you can't afford to be unaware of the latest issues affecting so many relocating baby boomers and others. Avoid that state audit with the information provided in this entertaining webinar.
More Dates
Surgent's Excel Budgeting Ideas
1:00pm - 3: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 Schedules K-2 and K-3: Preparation of Forms
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Many partnerships and S corporations are now required to complete the voluminous Schedules K-2 and K-3 to report foreign-related tax information. Updated for the 2025 tax year, this course is an essential guide for tax preparers on how to tackle the preparation of these forms. Understanding and preparing these forms requires a basic knowledge of various international tax topics, including sourcing of income, foreign tax credit income categories, effectively connected income, and fixed, determinable, annual, or periodical (FDAP) income. The course includes a brief discussion of key international tax concepts, a detailed walk-through of what information is required to be reported in different parts of the schedules, and practical advice from the field. The course also includes three comprehensive case studies on how the form should be completed for operating, real estate rental, and investment partnerships. Please note: Surgent also offers a companion course, "Schedules K-2 and K-3: Filing Requirements" (KFR2).
More Dates
Surgent's The Accountant as the Expert Witness
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
As litigation becomes more complex, attorneys are relying more on accountants to serve as consulting experts or expert witnesses at trial. Serving as an expert witness is not as difficult as you might expect. Accounting experts educate lawyers and jurors on issues such as valuation, tax liability, and forensics. Learn how accountants become expert witnesses, the role they play during pre-litigation through to trial, and the techniques experts employ to avoid challenges from opposing counsel.