Self-Study Text
(SSAA283/25) Surgent’s Technology Trends and Hot Topics Impacting the Accounting Profession
Never have the benefits, and related risks, of utilizing new technology been greater for those in the accounting profession. From Artificial Intelligence (AI), Robotic Process Automation (RPA), and Audit Data Analytics (ADA) to cloud-based software solutions, our clients' technology landscape is rapidly changing. Accordingly, we, as accounting professionals, need to be on the forefront of...
Read More
Self-Study Video
(SSTE127/25) Surgent’s Power Query Series: Adding Columns for Data Enrichment
Using a variety of hands-on exercises, this course enables users to learn how to add columns using Power Query (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...
Read More
Self-Study Video
(SSTE105/25) Surgent’s Data Analytics Readiness Series: Data Preparation Using Get and Transform
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...
Read More
Self-Study Video
(SSTE104/25) Surgent’s Data Analytics Readiness Series: Data Extraction and Data Sources
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...
Read More
Self-Study Text
(SSTE132/25) Surgent’s UiPath: Step into RPA
Surgent has partnered with UiPath(TM), the world's leading robotic process automation (RPA) software company, to provide this CPE course that gives learners practical application in RPA. Participants in this course receive an engaging introduction to RPA through an experiential, use-case approach. They learn how general, real-world problems can be solved in a non-RPA environment. The...
Read More
Self-Study Video
(SSTE124/25) Surgent’s Power Query Series: Making a Connection
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...
Read More
Self-Study Video
(SSTE101/25) Surgent’s Anatomy of a Ransomware Event and Incident Response
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...
Read More
Self-Study Video
(SSTE116/25) Surgent’s Power BI.com: Empowering Collaborative Data Analytics in Your Organization
A data-driven culture can only occur when there is collaboration, communication, and cooperation between everyone in your organization.Collaboration can only occur in the Power BI ecosystem when your organization works in the cloud with Power BI.com, also known as the Power BI Service, a software as a service available on the Power Platform.This one-hour course...
Read More
Self-Study Video
(SSTE126/25) Surgent’s Power Query Series: Data Transformations
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...
Read More
Self-Study Video
(SSTE122/25) Surgent’s Power Query Series: Data Modeling and Next Steps
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...
Read More