Professional Development and Event Catalog
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 New and Expanded Tax Benefits Associated with Section 1202 – Qualified Small Business Stock
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
This program reviews and analyzes the important changes made by the One Big Beautiful Bill Act (OBBBA) to qualified small business stock (QSBS) covered under Section 1202. Effective for stock issued after July 4, 2025, there are important changes that make Section 1202 much more appealing to clients willing to run the risks associated with doing business as a C corporation. These enhanced provisions could potentially lead to exclusion of capital gains if very strict compliance rules are followed. Section 1202 application is particularly attractive for start-ups and entrepreneurial endeavors. For taxpayers willing to confront the technical challenges of this provision, Section 1202 may produce impressive tax advantages.
More Dates
Surgent's Use the Data Model to Build More Powerful PivotTables
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
More Dates
Surgent's Social Security: Dispelling Common Myths with Essential Truths
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $119
See more dates
For roughly 90% of American retirees, Social Security income will be the foundation of their retirement income. Yet, many are ill-prepared and lack understanding of the critical aspects of making an informed claiming decision. Further challenged to separate fact from fiction, consumers crave accurate information from knowledgeable professionals to make the most out of these coveted monthly benefits. This course dispels common myths about Social Security that lead to confusion and replaces them with the truth to an empowered retirement. Help your clients navigate their claiming age decisions with greater confidence, equipped with the essential truths they should consider before pushing the Social Security "on" button.
More Dates
Surgent's Advising a Client Regarding the Tax Consequences Associated with Buying or Selling a Business
2:00pm - 5:00pm
Online
3.00 Credits
Member Price: $149
See more dates
Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Accounting and finance professionals who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.
More Dates
Surgent's Current Issues in Accounting and Auditing: An Annual Update
9:00am - 12:30pm
Online
4.00 Credits
Member Price: $159
See more dates
Designed for accounting, auditing, and attestation practitioners at all levels in public accounting and business and industry, this course provides a detailed review of the multitude of FASB and AICPA standards and reports issued over the past few years, including a discussion of the FASB's Stage 3 PIR report on ASC 606. It also provides an overview of recent PCAOB inspection report findings and SEC rulemaking activity. Through hands-on examples and illustrations, this course will help you apply the guidance in practice. We further discuss other important A&A practice matters to be aware of, including an update on the quality management standards and soon-to-be-effective requirements for engagement quality reviews.
More Dates
Surgent's Anatomy of a Ransomware Event and Incident Response
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $99
See more dates
The past two years have ushered in an explosion of ransomware attacks affecting businesses and individuals. Many of us read or hear about these attacks, but there is little understanding of how they occur, how a response is undertaken, and how the chances of experiencing one can be reduced. Join us to learn about these topics so you can be prepared with the best response and the knowledge to avoid common mistakes in a ransomware event.
More Dates
Surgent's Business Writing: Professional & Effective Emails
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Good writing is good business. Studies show that the average business worker receives 121 emails per day. That's a lot of emails. Are your emails effective? Are they being read? Are they professional and tone-smart? In this course, you will learn techniques and skills to get your emails to stand out and improve their effectiveness and professionalism.
More Dates
Surgent's Business Law for Small Business Owners
1:00pm - 4:30pm
Online
4.00 Credits
Member Price: $159
See more dates
One of the most intimidating aspects of going into business for yourself is compliance. Tax, employment, and regulatory laws are difficult to navigate, so it often falls on the CPA to know the basics in these areas to help their clients avoid costly litigation. In this course, we will cover basic compliance areas for small business owners. We will look at the main elements of a contract, taxation of entity types, worker classification, property law, and many of the other areas that are often overwhelming for small business owners. By being able to speak to these issues, practitioners will be able to add value and help their small business owner clients grow and thrive.
More Dates
Surgent's Making Sense of Essential OBBBA Provisions
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $119
See more dates
When clients ask questions about the impact of new tax legislation embodied in OBBBA, it is important that accounting and finance practitioners can reply with accurate and relevant planning strategies. This program prepares accounting and finance practitioners with the knowledge and insights to help their clients apply the new law to their advantage. This program is an introduction and review of some of these critical changes and their impact on individual and business taxpayers. By taking this program, accounting and finance practitioners will have a broader, deeper understanding of many of the OBBBA changes that impact their clients. This course is a two-hour review and analysis of what we consider some of the most important changes from the OBBBA impacting clients and perhaps their businesses.
More Dates
Surgent's Real Estate for Accounting and Finance Professionals
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $119
See more dates
Explore the intricacies of federal income taxation as it intertwines with rental real estate activities. This course delves into the calculation of rental income, understanding the nuances of deductions, and unraveling the complexities of passive activity loss rules. Whether it's mastering Schedule E or understanding Congress' intent behind tax laws, professionals will leave with an enriched understanding.
More Dates
Surgent's Unconscious Bias for Managers, Supervisors, and Executives
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Understanding unconscious bias is key to creating an inclusive workplace and to making the best business decisions. This course explores the concept of unconscious bias, the science behind it, and how it can affect the way employers hire, evaluate, and treat employees. We will also discuss strategies employers can use to reduce unconscious bias and create a more inclusive workplace.
More Dates
Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
9:00am - 12:30pm
Online
4.00 Credits
Member Price: $159
See more dates
In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand, they need the best skills to motivate, manage, and lead people. Being pigeonholed into one area or another is neither good for career building nor good for the organization. We'll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations.
More Dates
Surgent's Ethics for the Industry Accountant
9:00am - 12:30pm
Online
4.00 Credits
Member Price: $159
See more dates
While ethics training is required by many states, the true value of the CPA license is in understanding how critically important ethical behavior is to one another, our customers, our firms, and the public. This course will explore the basic tenets of ethical behavior and use case studies to explore ethical dilemmas in various companies and organizations with a focus on dilemmas that may face CPAs in the industry.
More Dates
Surgent's How to Effectively Represent Clients Under IRS Audit
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Increased funding resulting from the enactment of the Inflation Reduction Act will allow the IRS to target many more wealthy individuals and large businesses for audit. These efforts will become more intense over the next several years as the IRS employs artificial intelligence in more of its audits. This program discusses how and when the IRS's energized audit efforts will result in more audits of taxpayers and what attendees need to know to effectively represent clients that the IRS audits.
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
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 The Road Ahead: Critical OBBBA Changes Impacting Accounting and Finance Professionals
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $119
See more dates
It is important for accounting and finance practitioners to help their clients understand and apply the many new provisions of OBBBA. Many of these changes are effective for the 2025 tax year and beyond. This program is an introduction to and review of some of these critical changes and their impact on taxpayers. This program is a two-hour review and analysis of what we consider some of the most current and important changes from the OBBBA. If you want the latest OBBBA information to relay to your clients, this course is for you.
More Dates
Surgent's Top 20 Questions Advisors Ask About the SECURE Acts and Other IRA Rules
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Advisors often ask clarifying questions as they increasingly gain an understanding of new and existing tax laws that govern IRAs. Some provisions see more questions than others due to their complexity, popularity, and level of impact on tax benefits. This course focuses on the top 20 of these questions and on SECURE Act 1.0, SECURE Act 2.0, and other hot topics. This course aims to help the advisor provide clients with the correct responses based on their IRA profiles.
More Dates
Surgent's Engagement and Client Retention Best Practices
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $119
See more dates
Positive client relationships require work. Miscommunication, unrealistic expectations, and differing personality styles may strain a client's relationship with professional advisors. Fortunately, there are tested strategies that foster and strengthen client relationships. Creating appropriate boundaries early on is one of many effective strategies that can help. This course explores actions accounting and finance professionals can take to create and grow their client relationships. This webinar provides actionable insights on how to engage new and old clients alike. Strained client relationships can harm both the client and the firm's profitability. Yet automation, for example, allows some firms to remain more engaged while others miss the mark. There is a science underlying client retention that involves understanding the client journey, ensuring consistent client interactions, and equipping employees with the tools needed to satisfy client needs. Understanding these skills should help you protect the relationships that sustain your business.