Self-Study Video
(SSTE412/26) Surgent’s Data Analytics Readiness Series: PivotTables
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...
Read More
Self-Study Video
(SSTE439/26) Surgent’s Power Query Series: Formulas, M Language, and Error Handling
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...
Read More
Self-Study Video
(SSTE420/26) 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
(SSTE130/25) Surgent’s Power Query Series: Merge Queries
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...
Read More
Self-Study Text
(SSTE119/25) 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
(SSTE114/25) 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
(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