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 wit...
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,...
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...
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 ha...
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 ...
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...
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 s...
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 calcul...
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 Ex...
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 ...
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 ...
Power BI Desktop is the authoring tool for the Power BI Ecosystem and is an essential component of the Power BI ecosystem. Power BI Desktop is a free application that is available for download.This one-hour course will demonstrate the capabilities of...
Accounting and finance professionals have used different forms of automation over the years to improve the efficiency and accuracy of their work. So far, technology has not been able to replace the knowledge, experience, and decision-making of seaso...
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 inpu...
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...
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 integr...
It is no secret that accounting firms, like many other organizations, have begun launching operations in the metaverse. For those unsure, the metaverse is a digital or virtual space where participants simulate a host of activities ranging from shoppi...
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 wel...
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. Use...
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 im...
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 th...
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 E...
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 enabl...
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 Que...
As the rewards from data continue to grow, companies must recognize the value of data to remain competitive in the current digital economy. Companies that use data in their business processes are outperforming those that do not. Data skills will beco...
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 d...
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 ch...
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...
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 intersect...
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 ...