CPE Catalog & Events
Surgent's Data Analytics Readiness Series: Advanced Formulas- Array Formulas and DAX Formulas
Available Until Apr. 30, 2026
Online
1.00 Credits
Member Price: $59
This one-hour data analytics course will introduce formula arrays and DAX formulas to users in Power BI and Excel. Users will learn the skills to create and evaluate array formulas and DAX formulas. An understanding of implicit or explicit intersections and measures within the formulas will be developed. Users will apply the understanding to data and work alongside the instructor to create calculated columns in Power Pivot using DAX formulas and array formulas. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ. Delivery Method: On-Demand WebcastCPE Credit: Information technologyProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Data Analytics Readiness Series: Artificial Intelligence- Basic Concepts in Excel
Available Until Apr. 30, 2026
Online
1.00 Credits
Member Price: $59
This one-hour course will serve as an introduction to artificial intelligence and how artificial intelligence is utilized in Excel. Users will be introduced to correlation and trend functions in Excel. The basics of linear regression and its application in Excel will be discussed. Specific attention will be given to artificial intelligence functions in Excel, including, but not limited to, forecasting, trend analysis, regression analysis, and predictive modeling. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ. Delivery Method: On-Demand WebcastCPE Credit: Information technologyProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Data Analytics Readiness Series: Calculated Columns and Dimensions
Available Until Apr. 30, 2026
Online
1.00 Credits
Member Price: $59
This one-hour course will focus on the use of Excel with Power BI and Power Query to organize and analyze data. Users will primarily work with calculated columns generated from existing data. They will walk through hands-on exercises to create calculated columns, add dimensions to existing data tables, and create hierarchies within the data tables. Special attention will be paid to Star Schema analytical modelling. To explore practical applications, users will apply the skills to journal entry testing. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ. Delivery Method: On-Demand WebcastCPE Credit: Information technologyProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Data Analytics Readiness Series: Data Extraction and Data Sources
Available Until Apr. 30, 2026
Online
1.00 Credits
Member Price: $59
This one-hour course serves as the introductory module to data analytics. Users of the course will learn the basic terminology used in performing data analytic-based tasks or working with data analytics. An understanding of the sources of data and importance in combining multiples sources will be developed. Users will be introduced to and will practice the basics of Microsoft's Power Query. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ. Delivery Method: On-Demand WebcastCPE Credit: Information technologyProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Data Analytics Readiness Series: Data Modeling
Available Until Apr. 30, 2026
Online
1.00 Credits
Member Price: $59
This one-hour course will focus primarily on Power Query, Power Pivot, and VLOOKUP skills. Users will learn how to join tables using various techniques and add-ons in Excel. Users will understand how to utilize the tools while maintaining data integrity. The majority of the course will focus on hands-on data exercises. Users will apply skills to create relationships and analyze the data using Power Query. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ. Delivery Method: On-Demand WebcastCPE Credit: Information technologyProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Data Analytics Readiness Series: Data Preparation Using Get and Transform
Available Until Apr. 30, 2026
Online
1.00 Credits
Member Price: $59
In this one-hour course, users will learn to apply Power Query to extract, transform, and load data for analysis. Users will learn how to manipulate data once it is loaded into the platform and will practice the manipulation during the course. Using the same data as the instructor, users will perform an exercise to clean and transform a basic general ledger with an emphasis on preparing the data for analysis. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ. Delivery Method: On-Demand WebcastCPE Credit: Information technologyProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Data Analytics Readiness Series: Excel Tables
Available Until Apr. 30, 2026
Online
1.00 Credits
Member Price: $59
In this one-hour course, users will apply Excel and Power BI tools and skills directly to tables in Excel. Users will work alongside the instructor to create named tables, create structured references, enter formulas, and prepare the tables for input into Power Query. Users will be introduced to the preparation of the first level of statistics - descriptive statistics. Emphasis will be placed on mean, median, and standard errors. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ. Delivery Method: On-Demand WebcastCPE Credit: Information technologyProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Data Analytics Readiness Series: Formulas, Named Ranges, and Formula Auditing
Available Until Apr. 30, 2026
Online
1.00 Credits
Member Price: $59
This one-hour course will introduce users to table functions in Excel and Power BI. Users will demonstrate an ability to apply and utilize named ranges and naming conventions to data. Specific focus will be given to common formulas and functions within Excel. Common pitfalls in formula implementation will be discussed. Users will utilize exercises alongside an instructor to practice formula and function skills. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.Delivery Method: On-Demand WebcastCPE Credit: Information technologyProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Data Analytics Readiness Series: PivotTables
Available Until Apr. 30, 2026
Online
1.00 Credits
Member Price: $59
This one-hour course will provide users with hands-on practice using PivotTables and Excel. Users will learn and apply skills to create, structure, and analyze data using PivotTables. The benefits and limitations of PivotTables will be discussed. Users will be introduced to Power Pivot and Online Analytics Processing within it. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ. Delivery Method: On-Demand WebcastCPE Credit: Information technologyProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Data Analytics Readiness Series: Visualizations and Reporting
Available Until Apr. 30, 2026
Online
1.00 Credits
Member Price: $59
This one-hour course will serve as an introduction to data visualization and reporting using Power BI and Excel. Users will understand the benefits of using Power BI to create data visualizations and how Power BI differs from previous functions in Excel for visualizations. A hands-on exercise will be applied where the user will work alongside the instructor to create dashboarding for journal entry testing. Specific focus will be on the relation among various tools for data analytics: Power Query, Power Pivot, PivotTables, DAX formulas, and storyboarding. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ. Delivery Method: On-Demand WebcastCPE Credit: Information technologyProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Data Analytics Toolkit - Tools and Applications
Available Until Apr. 30, 2026
Online
2.00 Credits
Member Price: $89
There is no shortage of data, but relatively few organizations have an environment and process to isolate, capture, analyze, and convert data into actionable information. Too often, we collect as much data as possible, continue to use historic measurements, and communicate data using traditional vehicles. Good decisions are not the result of the amount of data gathered, but of the quality and understanding of the information. The goal of this program is to explore a number of analytical tools and techniques and identify applications for them within an organization. Analytical techniques will be introduced throughout the discussion, and a significant amount of time will be spent addressing the steps needed to establish a data-driven environment and identifying and discussing potential/specific applications. In this way, participants get experience they can begin to use in their organizations. An expanded list of reference books and next level software is also provided.Delivery Method: On-Demand WebcastCPE Credit: Accounting, Management servicesProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Data Security: Best Practices to Protect Your Business and Yourself
Available Until Apr. 30, 2026
Online
1.00 Credits
Member Price: $49
Data security is a front-of-mind topic for most businesses because the risk and cost statistics are sobering. Each of us is in the crosshairs because a typical internet-connected computer faces a cyberattack every 39 seconds. Businesses of all sizes should be cognizant of the ethical issues that must be considered when planning their approach to privacy and data security. In this webinar, we will explore both the risks we have traditionally faced in the workplace personally, as well as the novel set of data privacy threats and compliance challenge issues employers face with a remote and mobile workforce.Delivery Method: On-Demand WebcastCPE Credit: Information technologyProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Depreciation Rules for Bonus and Section 179 Expensing
Available Until Apr. 30, 2026
Online
2.00 Credits
Member Price: $89
The Tax Cuts and Jobs Act of 2017 has had a tremendous impact on commercial real estate, including liberalizing the depreciation provisions. The Coronavirus Aid, Relief, and Economic Security Act (CARES Act) included several provisions that allow taxpayers to revisit projects completed in earlier, more profitable years, and generate even more value. In this course, we will explore the impact of these important laws on commercial real estate owners and delve into what Accounting and Financial Professionals need to know. We'll also examine these opportunities to "turn back the clock," including the retroactive correction of QIP's recovery period and the option to revoke electing-out of the business interest limitation. Finally, we will review other strategies that are crucial parts of a comprehensive tax plan this year and will discuss a strategic hierarchy for employing those strategies most successfully. Relevant Rev. Procs. and multiple real-life case studies will be reviewed.Delivery Method: On-Demand WebcastCPE Credit: TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Did I Pick the Right Major? Selecting Major Programs in a Single Audit
Available Until Apr. 30, 2026
Online
2.00 Credits
Member Price: $89
Even after we complete our work at an institution, the question sometimes lingers: "Did I pick the right major?" Major program determination is difficult in a single audit and sometimes we feel ill prepared to make the best decision. This course will give you the counseling and assistance you need to feel confident in your major program selection under the Uniform Guidance for Federal Awards requirements.Delivery Method: On-Demand WebcastCPE Credit: Auditing (governmental)Program Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Disclosure Requirements for SEC Form 8-K
Available Until Apr. 30, 2026
Online
2.00 Credits
Member Price: $49
This course provides an overview of the disclosure requirements for SEC Form 8-K, the broad form used to notify investors in U.S. publicly traded companies of certain events that may be important . This course provides an overview of the key disclosure requirements for several of the triggering events requiring the filing of a Form 8-K with the SEC. This course also provides information about how the Form 8-K requirements have evolved over time.Delivery Method: DownloadCPE Credit: AccountingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Disclosures of Risks and Uncertainties
Available Until Apr. 30, 2026
Online
1.00 Credits
Member Price: $29
This course provides an overview of the disclosure requirements regarding risks and uncertainties. The disclosure requirements related to risks and uncertainties are prescribed by the Financial Accounting Standards Board (FASB) in ASC Topic 275. For public business entities that file their annual and interim reports with the U.S. Securities & Exchange Commission (SEC), there are also additional disclosure requirements required by Regulation S-K. This course focuses on general disclosure requirements outlined in U.S. GAAP. This course also provides illustrative examples from both the GAAP implementation guidance as well as actual SEC filings from public business entities.Delivery Method: DownloadCPE Credit: AccountingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Effective Communications with Management and Those Charged with Governance
Available Until Apr. 30, 2026
Online
2.00 Credits
Member Price: $49
As a byproduct of the audit, the auditor has a responsibility to communicate certain information to management and those charged with governance, primarily related to risk and internal control deficiencies. In some cases the auditor may be required to report outside the entity, for example, when fraud is identified. Some of these communications to management and those charged with governance occur at the beginning of the audit, others during the audit and at the end of the audit. Two-way communication is very important to meet professional responsibilities and also as a client service. This module will discuss the most significant of the required communications and explore how to make them more effective. (Please Note: This module is part of Surgent's Audit Skills Training: Level 5.)Delivery Method: DownloadCPE Credit: AuditingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Effective Communications with Management and Those Charged with Governance
Available Until Apr. 30, 2026
Online
2.00 Credits
Member Price: $89
As a byproduct of the audit, the auditor has a responsibility to communicate certain information to management and those charged with governance, primarily related to risk and internal control deficiencies. In some cases the auditor may be required to report outside the entity, for example, when fraud is identified. Some of these communications to management and those charged with governance occur at the beginning of the audit, others during the audit and at the end of the audit. Two-way communication is very important to meet professional responsibilities and also as a client service. This module will discuss the most significant of the required communications and explore how to make them more effective. (Please Note: This module is part of Surgent's Audit Skills Training: Level 5.)Delivery Method: On-Demand WebcastCPE Credit: AuditingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Effective Techniques for Auditing Contingencies and Going Concern
Available Until Apr. 30, 2026
Online
2.00 Credits
Member Price: $89
In these rapidly changing times, an entity may experience significant uncertainties. This is especially true at this time due to issues entities have experienced as a result of the pandemic declared in March 2020 which are still ongoing for many. New accounting principles issued by the FASB are requiring more estimates which could give rise to significant uncertainties. A primary focus right now for management is the requirement to evaluate entity's ability to remain a going concern. In addition, new audit standards, effective for calendar year end 2021 audits. This module provides tips and techniques for obtaining the audit evidence needed to support conclusions on contingencies and going concern. These issues require disclosure and may result in accruals. (Please Note: This module is part of Surgent's Audit Skills Training: Level 3.)Delivery Method: On-Demand WebcastCPE Credit: AuditingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Employee Stock Options: What Financial Professionals Should Know When Advising Their Clients
Available Until Apr. 30, 2026
Online
2.00 Credits
Member Price: $89
Companies often offer stock options as an additional form of compensation to attract and retain the best talent. Used appropriately, stock options can generate significant wealth, yet many employees are unfamiliar with how stock options work and why options serve as a valuable opportunity for employees to establish and grow their wealth. Unfortunately, employees who receive stock options are often unaware of their inherent risks. Research has shown that over 76% of employees have never exercised their stock options. Almost half of these individuals (48%), say they held off on selling their options due to fear of making a mistake. This course provides accounting and finance professionals with a broad overview of employee stock options. The webinar is designed to help participants better understand the fundamentals behind these investments and, in turn, better advise their clients.Delivery Method: On-Demand WebcastCPE Credit: Specialized knowledge, TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.