CPE + Events Catalog
View or download your copy of The Resource today!
Taking Advantage of Array Formulas in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in 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
Build a Data Model for Analysis in Power BI (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. 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
Comprehensive FASB & AICPA Update for Tax Professionals 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
This 8-hour program covers recent promulgations of the FASB and AICPA with broad applicability. In addition, the course includes the 2-hour Tax Basis Financial Statements, 2-hour SSARS Highlight Reel and 2-hour SQMS programs available as stand-alone courses.
More Dates
Financial Accounting Standards: A Comprehensive Review 25-26 (16 hours)
-
Online
16.0 Credits
Member Price: $589
See more dates
This two-day, interactive workshop reviews the hottest accounting topics and recent changes in areas such as private company accounting, revenue recognition, going concern and other specialized subjects. Refresh your research skills and practice using the Codification. Case studies and real-life examples will help attendees readily apply the information covered.
More Dates
ChatGPT Bootcamp for CPAs with John Higgins (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. 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
Everyday Ethics at Work: Don't be the Next News Story! (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
When asked, most people would say they are an ethical person. So why is it that every month there are reports of ethical breaches at major companies? The concept of ethics is easy to understand, easy to talk about, but incredibly hard to implement on a consistent basis. In this course, we will discuss current ethical issues, and walk-through a nine-step ethical decision-making model. 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 Ethical Management of Conflict (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Conflict is as natural as breathing air. For many, the thought of dealing with conflict is difficult and horrifying, and yet unresolved conflict can damage relationships, cause pain and suffering as well as hinder workplace productivity. When addressed, however, conflict has the power to be transformative in strengthening workplace relationships, shared understanding, and increased productivity. This workshop will provide an intimate understanding of how to deal with conflict in collaborative and constructive ways. Using ethical values and principles, we will explore how to move conflict from an obstacle to an opportunity. This workshop is geared toward individuals who are wanting to improve their conflict management skills and create more harmonious and positive working environments. 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
SEC Case Studies: Ethical Dilemmas in Finance and Accounting (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Overview: Ethical challenges in finance and accounting can be complex and far-reaching, impacting not only individual careers but also entire organizations and the public trust. This webinar will provide a practical exploration of the ethical considerations professionals face in today's financial landscape. Through real-world case studies, participants will examine common ethical issues, learn to navigate conflicts between financial performance and ethical integrity, and gain tools for making sound decisions under pressure. 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: IRS Criminal Investigations: Key Lessons for Accountants (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of recent IRS criminal investigations and what practitioners can learn from these cases to help fight economic crime and even avoid personal criminal prosecution. While accountants are numbers people by training (not detectives per se with the exception of forensic accountants), practitioners are increasingly being called upon by governments and economic organizations at all levels to step up and help law enforcement battle financial impropriety. The stakes are huge. In the United States alone, the OECD estimates that 5% to 10% of the annual budget of the US health care programs, Medicare and Medicaid, is wasted as a result of corruption. Every dollar lost to monetary malfeasance has a crippling effect that ripples through countries, industries, companies, communities and individual lives. Government resources are wasted, public services are compromised, companies are financially destabilized, shareholders are cheated, employers are swindled, charities are undermined and much more. By increasing their awareness of what and how the IRS investigates and prosecutes, accountants can heighten their "spidey sense" of what doesn't look right in financial records. This includes honing skills to more readily notice -- and report -- ledger anomalies and irregularities, and even rethink a "silence is always safer" mindset. As technology disrupts and automates many fundamental accounting functions, practitioners can add value by more diligently scanning for "creative accounting" red flags on the frontlines. Prioritizing transparency and behaving ethically -- the core of the profession -- not only helps society and the economy as a whole, it can help accountants boost their reputation as highly trusted business advisors and even supercharge their bottom line. 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
Nonprofit A&A Series Part 2: Revenue Recognition 25-26 (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Part 2 of a 2-part series is an overview of GAAP requirements for nonprofit organizations and will help you become proficient in nonprofit financial reporting. This session focuses on revenue recognition. Be sure to register for part 1 in the series: Nonprofit A&A Series Part 1: Financial Statement Presentation & Disclosure
More Dates
PFP Update: Issues, Exposures and Developing Client Strategy 25-26 (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Our clients' personal financial planning issues are quickly developing and keep us challenged in a new operating environment! Many new approaches are needed in working through, understanding, diagnosing and then adopting innovative and proven strategies. Additional ways of experiencing these client situations are entering the picture. With information overload, part of the CPA's challenge is to help clients stay focused on goals while managing expectations in a rapidly changing environment. This course will update you on the newest personal financial planning changes related to insurance, investments, education, retirement, estate, cash flow management, divorce, closely held businesses and other relevant topics. We'll discuss critical issues, including planning for education, divorce, charitable, exceptional circumstances, business owners and highly compensated executives. Be sure to register for all of our PFP updates: PFP Update: Income Tax, Retirement, and Estate Planning PFP Update: Issues, Exposures, and Developing Client Strategy PFP Update: Investment Planning in This New Era
More Dates
Surgent's Excel Shortcuts for Accountants (2 hours) [NT]
-
Online
2.0 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 (2 hours)
-
Online
2.0 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 (4 hours)
-
Online
4.0 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
Becoming Conflict Competent (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. 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 (4 hours)
-
Online
4.0 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 the complex IRS Appeals.
More Dates
Surgent's Select Estate and Life Planning Issues for the Middle-Income Client (4 hours)
-
Online
4.0 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
Understanding Internal Control Constructs (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Organizations of all sizes often fail to successfully install needed foundational components of an internal control system. Whether large or small, entities must view policies, procedures, and all controls in a wholistic manner in order to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. It provides an understanding of the interrelated nature of all controls created by any organization. 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
Getting Comfortable with Being Uncomfortable (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $125
Organizations must be intentional in cultivating environments where diverse team members can thrive, feel empowered to make recommendations and take chances. Initiatives to help leaders, both men and women, identify unconscious bias will benefit the morale and increase the retention and advancement of diverse leaders. The instructor will use various scenarios and their own lessons learned as a STEM leader as well as a finance leader.
Ethical Intelligence for Artificial Intelligence (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Organizations and individuals enticed by the siren song of artificial intelligence cannot ignore ethical considerations. Professionals must consider accuracy of information, data privacy, independence, source citations, organizational policies, security, data retention, and other ethical matters. This course discusses ethical issues associated with the utilization of AI in a professional setting and provides suggested best practices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.