CPE Catalog & Events
Surgent's Power Query Series: Data Modeling and Next Steps
Available Until Apr. 30, 2027
Online
1.00 Credits
Member Price: $59
This final course in the series covers advanced features in Power Query (Excel version), including functions and parameters and basics of data modeling in Power BI and Power Pivot. Multiple hands-on examples help to reinforce these concepts. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the last in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.Delivery Method: On-Demand WebcastCPE Credit: Information Technology (1)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Power Query Series: Data Transformations
Available Until Apr. 30, 2027
Online
1.00 Credits
Member Price: $59
This course teaches the user how to perform data transformations in Power Query, using a hands-on approach. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the fourth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.Delivery Method: On-Demand WebcastCPE Credit: Information Technology (1)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Power Query Series: Editor – The User Interface of Power Query
Available Until Apr. 30, 2027
Online
1.00 Credits
Member Price: $59
This course introduces users to the Power Query Editor, using the Excel version of Power Query, and includes a hands-on transformation exercise using the editor. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the third in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.Delivery Method: On-Demand WebcastCPE Credit: Information Technology (1)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Power Query Series: Formulas, M Language, and Error Handling
Available Until Apr. 30, 2027
Online
1.00 Credits
Member Price: $59
Even for experienced Excel users, there is a learning curve to using formulas in Power Query (Excel version). This course presents the fundamentals of this concept. In addition, this webinar introduces users to the "M" language in Power Query, as well as types of errors that users may encounter. Hands-on examples reinforce all of these concepts. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the eleventh in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.Delivery Method: On-Demand WebcastCPE Credit: Information Technology (1)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Power Query Series: Introduction and First Connection
Available Until Apr. 30, 2027
Online
1.00 Credits
Member Price: $59
This course is designed for the Excel user to begin their data analytics journey with an introduction to a product created for their skill set: Power Query, using the Excel version. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the first in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. Delivery Method: On-Demand WebcastCPE Credit: Information Technology (1)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Power Query Series: Making a Connection
Available Until Apr. 30, 2027
Online
1.00 Credits
Member Price: $59
This course explores the workflow of making connections to various data sources using the Excel version of Power Query. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the second in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.Delivery Method: On-Demand WebcastCPE Credit: Information Technology (1)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Power Query Series: Merge Queries
Available Until Apr. 30, 2027
Online
1.00 Credits
Member Price: $59
A merge query combines two queries that have a common column or columns. This course discusses best practices for creating merge queries using Power Query (Excel version) and includes hands-on exercises to enable the user to demonstrate what they have learned. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the eighth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.Delivery Method: On-Demand WebcastCPE Credit: Information Technology (1)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Power Query Series: More Transformations and Load Options
Available Until Apr. 30, 2027
Online
1.00 Credits
Member Price: $59
Power Query (Excel version) offers a wide range of transformation options. This course uses hands-on exercises to explore the data transformation process, focusing on data cleaning and data enrichment. In addition, this course explains query loading options and processes. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the sixth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.Delivery Method: On-Demand WebcastCPE Credit: Information Technology (1)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Power Query Series: Use Cases
Available Until Apr. 30, 2027
Online
1.00 Credits
Member Price: $59
This course presents five use cases for specific data issues a user may encounter in Power Query (Excel version). Through hands-on examples, users are guided through the process of overcoming each of these issues. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the tenth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.Delivery Method: On-Demand WebcastCPE Credit: Information Technology (1)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Power Query Series: Useful Transformations
Available Until Apr. 30, 2027
Online
1.00 Credits
Member Price: $59
This course covers a number of useful transformations using Power Query (Excel version) to clean, enrich, and shape data. Coverage includes pivoting and unpivoting, filtering and grouping, fuzzy matching, and more, with hands-on exercises for users to practice these skills. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the ninth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.Delivery Method: On-Demand WebcastCPE Credit: Information Technology (1)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Preparation and Compilation Engagements Under the SSARS
Available Until Apr. 30, 2027
Online
4.00 Credits
Member Price: $79
Be the go-to person on financial statement compilation and preparation engagements. Specifically designed for those performing preparation and compilation engagements, this course will provide you with a hands-on application for performing preparation and compilation engagements under AR-C Section 70 and 80, respectively. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-24 and SSARS Nos. 26-27 by the ARSC. In addition to SSARS No. 26, the entire suite of quality management standards is discussed. Most importantly, you will be provided with practical examples and illustrations to help you effectively and efficiently perform those engagements, including a detailed discussion of the reporting requirements under AR-C 80 related to compilation engagement. Lastly, the course will review recent peer review feedback on these types of engagements, highlighting areas where you can improve engagement quality.Delivery Method: DownloadCPE Credit: Auditing (4)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Preparation and Compilation Engagements Under the SSARS
Available Until Apr. 30, 2027
Online
4.00 Credits
Member Price: $129
Be the go-to person on financial statement compilation and preparation engagements. Specifically designed for those performing preparation and compilation engagements, this course will provide you with a hands-on application for performing preparation and compilation engagements under AR-C Section 70 and 80, respectively. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-24 and SSARS Nos. 26-27 by the ARSC. In addition to SSARS No. 26, the entire suite of quality management standards is discussed. Most importantly, you will be provided with practical examples and illustrations to help you effectively and efficiently perform those engagements, including a detailed discussion of the reporting requirements under AR-C 80 related to compilation engagement. Lastly, the course will review recent peer review feedback on these types of engagements, highlighting areas where you can improve engagement quality.Delivery Method: On-Demand WebcastCPE Credit: Auditing (4)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Preparing and Reviewing Client Prepared Financial Statements
Available Until Apr. 30, 2027
Online
2.00 Credits
Member Price: $89
The ultimate objective of a financial statement audit is to issue the independent auditor's report. This module discusses the process, introduces key elements of financial statements, and provides best practices for auditors who either prepare or review the client's financial statements. (Please Note: This module is part of Surgent's Audit Skills Training: Level 2.)Delivery Method: On-Demand WebcastCPE Credit: Auditing (2)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Preparing C Corporation Tax Returns for New Staff and Paraprofessionals
Available Until Apr. 30, 2027
Online
10.00 Credits
Member Price: $189
This course is a great foundation to introduce new preparers to tax rules related to business returns. The course covers tax areas affecting all business entities, providing a solid basis for staff to handle business entity returns. Such business tax topics include the sale of assets used in a trade or business (Form 4797), depreciation (Form 4562), deductible and nondeductible items, and the basics of uniform capitalization. The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare complicated federal corporate income tax returns. It is a hands-on and practical course, with extra emphasis on changes to forms under new tax law.Delivery Method: DownloadCPE Credit: Taxes (10)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Preparing C Corporation Tax Returns for New Staff and Paraprofessionals
Available Until Apr. 30, 2027
Online
8.00 Credits
Member Price: $199
This course is a great foundation to introduce new preparers to tax rules related to business returns. The course covers tax areas affecting all business entities, providing a solid basis for staff to handle business entity returns. Such business tax topics include the sale of assets used in a trade or business (Form 4797), depreciation (Form 4562), deductible and nondeductible items, and the basics of uniform capitalization. The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare complicated federal corporate income tax returns. It is a hands-on and practical course, with extra emphasis on changes to forms under new tax law.Delivery Method: On-Demand WebcastCPE Credit: Taxes (8)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Preparing Individual Tax Returns for New Staff and Paraprofessionals
Available Until Apr. 30, 2027
Online
8.00 Credits
Member Price: $159
The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare a moderately complex federal individual income tax return (Form 1040). Over the years, thousands of new staff have received practical, hands-on experience to become familiar with tax forms. This course covers the latest tax law changes, making it essential for your new staff.Delivery Method: DownloadCPE Credit: Taxes (8)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Preparing Individual Tax Returns for New Staff and Paraprofessionals
Available Until Apr. 30, 2027
Online
8.00 Credits
Member Price: $199
The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare a moderately complex federal individual income tax return (Form 1040). Over the years, thousands of new staff have received practical, hands-on experience to become familiar with tax forms. This course covers the latest tax law changes, making it essential for your new staff.Delivery Method: On-Demand WebcastCPE Credit: Taxes (8)Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Preparing Not-for-Profit Financial Statements
Available Until Apr. 30, 2027
Online
8.00 Credits
Member Price: $199
In order to prepare accurate and effective not-for-profit financial statements, professionals must have a strong working knowledge of the reporting requirements. Now is the time to obtain that knowledge! This course explains the requirements, illustrates how the requirements manifest in the financial statements, and clarifies options available to not-for-profits in applying the requirements. The course covers key accounting areas that affect not-for-profits, including net assets, contributions, and functional expense reporting. The course materials utilize a highly illustrative and innovative format, including 30 focused exercises to provide an enhanced working knowledge of not-for-profit accounting and reporting.Delivery Method: On-Demand WebcastCPE Credit: Accounting (Governmental) (8)Program Level: IntermediateThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Preparing Not-for-Profit Financial Statements
Available Until Apr. 30, 2027
Online
8.00 Credits
Member Price: $159
Accurate and effective financial reporting is essential for every not-for-profit organization, and it requires a solid understanding of today's reporting requirements. This course equips professionals with the knowledge and tools to confidently navigate not-for-profit accounting standards. You'll learn how requirements are applied in financial statements, explore available reporting options, and gain clarity on key areas such as net assets, contributions, and functional expense reporting. Through a highly illustrative format and over 30 targeted exercises, this course provides a practical, hands-on approach to building expertise in not-for-profit accounting and reporting.Delivery Method: DownloadCPE Credit: Accounting (Governmental) (8)Program Level: IntermediateThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Principles of Financial Statement Presentation
Available Until Apr. 30, 2027
Online
3.00 Credits
Member Price: $59
This course provides an overview of the key presentation requirements with respect to an entity's financial statements. This includes a discussion of key principles related to an entity's overall presentation as well as specific topics with respect to its balance sheet, income statement, comprehensive income, statement of cash flows, as well as notes to the financial statements. The course also addresses the considerations around changes in accounting principles. The information related to this course is primarily sourced from the Financial Standards Accounting Board's (FASB) Accounting Standards Codification (ASC).Delivery Method: DownloadCPE Credit: Accounting (3)Program Level: OverviewThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.