Professional Development and Event Catalog
Surgent's Use the Data Model to Build More Powerful PivotTables
10:00am - 12: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
Unlock the Power of AI with Copilot in Excel
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $89
See more dates
In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft Excel. 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
Steps to Stop External Fraud
10:30am - 12:30pm
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
Volume to Value: A New Era of Precision Hiring in Accounting
11:00am - 12:00pm
Online
1.00 Credits
Member Price: $55
See more dates
Volume to Value: A New Era of Precision Hiring in Accounting examines how accounting firms are shifting from high-volume recruiting models to "precision hiring" as AI adoption accelerates and talent scarcity continues. Participants will explore why traditional hiring processes often overemphasize technical accounting knowledge while under-assessing the competencies that most impact performance-critical thinking, professional communication, and AI ethics awareness. The course explains how AI-enabled recruiting tools can support candidate screening, assessment, and retention forecasting, and why firms that do not modernize their hiring approach may struggle to compete for top talent. Participants will leave with practical approaches to competency-based assessment, ethical guardrails for AI use in hiring, and a high-level implementation roadmap with metrics to evaluate quality of hire, performance, and retention. 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 and Technology for CPAs
11:00am - 1:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Explore the ethical principles included in the Code of Professional Conduct that address the emerging practice issues created by new technologies. Consider how technologies may impact audit quality and the integrity of the financial systems, and whether they create a need for CPAs to adjust their skill sets to address those challenges. Look at the potential ethical challenges created by the data related to privacy, security, and its application. Discuss the changes being proposed to address emerging ethics challenges. 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
AI Lessons Learned for Accountants
11:30am - 1:30pm
Online
2.00 Credits
Member Price: $89
See more dates
This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. 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 Audit: Property, Plant, and Equipment
12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Property, Plant, & Equipment is often one of the largest balances on the financial statements. This course will cover the foundation of auditing PP&E, including the related audit assertions, risks, & threats to the PP&E 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
What You Can Learn From the Statement of Cash Flows
12:30pm - 2:30pm
Online
2.00 Credits
Member Price: $89
See more dates
This course allows you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-basis financial statements. 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 Excel Best Practices
12:30pm - 8:30pm
Online
8.00 Credits
Member Price: $289
See more dates
As spreadsheets evolve, so must your creating, editing, and auditing practices. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today's best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this "must-see" CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel fully.
More Dates
CPA to CFO: Essential Competencies for Finance Leaders
1:00pm - 2:00pm
Online
1.00 Credits
Member Price: $55
See more dates
The path from CPA to CFO has evolved dramatically in recent years, with only 43% of S&P 1000 CFOs holding CPA licenses in 2022, down from 55% a decade earlier. This comprehensive course, based on groundbreaking research from the Pennsylvania Institute of CPAs surveying over 320 CEOs and hiring executives, reveals what today's leaders truly seek in CFO candidates and provides a roadmap for CPAs to secure their seat at the executive table. Participants will discover the five critical competencies that distinguish successful CFO candidates: forward-looking financial acumen that goes beyond traditional reporting, strategic leadership skills including critical thinking and strategy creation, the evolving role of emotional intelligence, industry-specific expertise requirements, and the balance between technical proficiency and visionary leadership. Through practical frameworks, real-world examples, and actionable strategies, attendees will learn how to transform their CPA foundation into a comprehensive skill set that meets the dynamic demands of modern CFO roles, whether in high-growth companies, nonprofits, or traditional corporations. 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
Becoming a Fractional CFO: What to Do and How?
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Are you considering becoming a fractional CFO, or possibly a public CPA firm or consulting practice that wants to offer fractional CFO services or advisory services? Either way, do you truly know what to do and how? Are you aware of the many pitfalls? Becoming a successful fractional CFO is complicated and it is not a trivial career change! Review the lessons learned from experienced fractional CFOs on how to enter, engage and run a thriving fractional CFO practice. Whether you are in public practice, a consultant, or in industry - be prepared for this as a possibility. Many fractional CFOs do not execute their practice as they could, and that is why they are not very successful. This discussion includes over fifty (50) recommendations to strengthen your fractional CFO practice. What do clients typically need? Are you better as a solo practitioner or should you join a firm? How to manage the relationship(s)? Every effective organizations make plans and if you want a winning fractional CFO business, come join us and learn how. 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 The Essential Multistate Tax Update
1:00pm - 4:30pm
Online
4.00 Credits
Member Price: $159
See more dates
With the largest overhaul of the federal income tax code in 30 years and the repeal of the physical presence nexus standards for sales tax in the Wayfair case, the states are working fast and furious to overhaul their tax laws. As some states scramble to fund their budgets, they continue to look for additional forms of revenue. Plan to attend this fast-paced class that covers developing topics in state taxation, ranging from individuals to pass-through entities to corporate taxpayers. This class will focus on issues of small and middle-market companies and offer guidance for minimizing tax liability and negotiating the treacherous waters of compliance.
More Dates
Ethics Based Leadership for Women
1:30pm - 3:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Glantz and Associates is pleased to offer "Ethics Based Leadership for Women," a webinar designed to empower any woman who wishes to consider the privileges, responsibilities and challenges of holding leadership positions. We believe that leadership and ethics are intrinsically connected and will explore women in leadership through an ethics-based lens. The reality is, despite women representing approximately half of our world's population, they are significantly underrepresented in the workforce and most notably in leadership positions. In fact, not only do women have to cross more hurdles to advance into leadership positions, but when they do, they are burning out at a much faster rate than their male counterparts. In this course, we will discuss both the external societal barriers as well as the internal barriers that sabotage women from moving into leadership positions. We will examine common believes ("I should be nice," "I am an imposter", etc.) as well as behaviors that can hold women back and then offer suggestions for moving forward. We will provide tools to enhance one's self-awareness, create openings for self-reflection as well as provide opportunities to take on new perspectives. 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
Cybersecurity: Protecting Your Firm's Data and Reputation
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Cybersecurity protection of digital data continues to be a top priority for CPAs. The cyber threats continue to increase and are becoming more sophisticated with the advent of AI technology. The first step is to understand what the primary threats are, the potential damage they can inflict, and, most importantly, how to mitigate the risks. This course will prepare you have informed conversations with your IT service providers to ensure you are employing best practices in cybersecurity protection. 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 Nuts & Bolts of Cryptocurrency Taxation & 1099-DAs
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $99
See more dates
With over 40 percent of Americans owning digital assets and a single bitcoin now valued at over $100K, cryptocurrency is no longer a niche subject, yet few tax professionals understand how to help individuals and businesses who are dealing with digital assets. This session walks you through the tax implications of common cryptocurrency-related transactions and how to successfully service clients dealing in digital assets. We will also cover current developments surrounding this topic, such as Form 1099-DAs, the updated version of the digital assets question on Form 1040, and a series of chief counsel memorandums related to digital assets and tax planning opportunities.
More Dates
Surgent's Trump Accounts Created by OBBBA: A Comprehensive Guide for Accounting and Finance Professionals
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $119
See more dates
Many clients are asking their advisors about Trump Accounts, one of the most anticipated yet misunderstood provisions of the One Big Beautiful Bill Act (OBBBA). This program will provide practitioners with the background to be able to advise their clients regarding how Trump Accounts operate. The course will also discuss the comparison between Trump Accounts and other accounts, such as 529 Plans and Roth IRAs. In addition, coverage will be provided on how the pilot program will function to give $1,000 to newborns.
More Dates
Improve Spreadsheets by Building Controls in Excel
2:30pm - 4:30pm
Online
2.00 Credits
Member Price: $89
See more dates
In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy. 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
ChatGPT and IRS Taxation Law Research
4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $89
See more dates
The course provides a concise overview of how to use ChatGPT to more effectively and efficiently research IRS taxation law. It delves into techniques for extracting precise information from complex tax legislation, interpreting IRS guidelines with AI assistance, and utilizing ChatGPT's advanced language models for nuanced legal analysis. Participants will learn how to streamline their research process, identify relevant tax law precedents, and apply AI insights to real-world tax scenarios, enhancing their professional proficiency in navigating the intricate world of IRS taxation. 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
Overcoming Tech Adoption Challenges in CPA Firms
5:00pm - 6:00pm
Online
1.00 Credits
Member Price: $55
See more dates
The accounting profession stands at a critical inflection point where artificial intelligence and emerging technologies are reshaping how firms operate, serve clients, and compete in the marketplace. This course, based on the 2025 CPA Firm Tech Report, provides expert guidance on overcoming the five key challenges that prevent firms from successfully adopting transformative technologies: decision paralysis from overwhelming choices, leadership resistance to change, difficulty proving ROI, growing cybersecurity risks, and critical skills gaps. Through real-world case studies and insights from industry leaders, participants will learn practical strategies for evaluating AI solutions, implementing change management frameworks, and building a technology-forward culture that enhances both efficiency and client value. Participants will explore the CPA Firm Digital Maturity Model to assess their firm's readiness for transformation, examine the evolving AI ecosystem specifically designed for accounting applications, and discover how leading firms are leveraging AI to move beyond traditional compliance work toward high-value advisory services. The course addresses critical considerations for firms of all sizes, from solo practitioners to large regional firms, providing actionable frameworks for prioritizing technology investments, measuring success beyond traditional ROI metrics, and developing the hybrid talent needed to thrive in an AI-enhanced future. Whether you're a firm leader hesitant about technology adoption or a forward-thinking professional ready to champion change, this course equips you with the knowledge and tools needed to navigate the technology revolution transforming the accounting profession. 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
Mining Your Firm Client Database for Revenue
9:00am - 10:00am
Online
1.00 Credits
Member Price: $55
See more dates
Your client database is more than a record of past engagements-it's a goldmine of untapped opportunity. In this practical and forward-thinking session, accounting professionals will learn how to strategically analyze and segment their existing client data to uncover new service opportunities, deepen relationships, and drive sustainable revenue growth. From identifying cross-selling potential to leveraging automation tools for proactive outreach, this webinar will equip firm leaders and client managers with actionable strategies to turn dormant data into dynamic business development. Whether you're a solo practitioner or part of a larger firm, you'll walk away with a roadmap for transforming your client list into a revenue-generating engine. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.