Self-Study Video
(SSTE413/26) Surgent’s Data Analytics Readiness Series: Data Modeling
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...
Read More
Self-Study Video
(SSTE447/26) Surgent’s Power Query Series: Append Queries
Append queries combine two or more queries into one output query that is a combination of the originals. This course discusses best practices for creating append 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...
Read More
Self-Study Text
(SSAA597/26) Surgent’s Technology Trends and Hot Topics Impacting the Accounting Profession
The benefits, and related risks, of utilizing new technology have never 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
(SSTE416/26) Surgent’s Data Analytics Readiness Series: Artificial Intelligence- Basic Concepts in Excel
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,...
Read More
Self-Study Video
(SSTE406/26) Surgent’s The Risks and Benefits of ChatGPT and Artificial Intelligence
We see multiple stories about the rapid growth of artificial intelligence (AI) and its entry into our lives in the form of AI tools, including ChatGPT. They seem to be everywhere. It is difficult to overstate how much things will change with the rise of these new technologies, or how important it is that companies...
Read More
Self-Study Video
(SSTE418/26) Surgent’s Excel: The Data Tools for Analysis – Power Query and Power Pivot
With the Power BI ecosystem, a complete business intelligence solution, your company can begin the data analytics journey with Excel. Excel contains two data tools of the Power BI ecosystem to begin developing data skills: Power Query and Power Pivot. Beginning your data journey with an application your business users are already familiar with will...
Read More
Self-Study Text
(SSTE428/26) Surgent’s Max the Tax: Metaverse
Your client, Multi-Mega Markets Corporation (MMM), a global conglomerate with businesses in entertainment, fashion, retail, software, technology and other industries, is looking for advice on the state of the metaverse. They are considering starting a new subsidiary in the metaverse called The MegaVerse (TMV). Your help is needed to share accurate information about the metaverse,...
Read More
Self-Study Video
(SSTE445/26) 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
(SSTE443/26) Surgent’s Power Query Series: Editor – The User Interface of Power Query
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...
Read More
Self-Study Video
(SSTE438/26) Surgent’s Power Query Series: Use Cases
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...
Read More